Lost All Users information after power outage

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Lost All Users information after power outage

Postby zubz94 » Sun May 12, 2024 12:20 pm

Fairly new to using this, Recently after a power outage, server seems to have lost all user data including admin(6666) no users are able to log in on web interface but we can access via cli on server, all tables have been repaired but now not sure how to proceed to resolve this issue
zubz94
 
Posts: 3
Joined: Sat May 11, 2024 7:11 am

Re: Lost All Users information after power outage

Postby mflorell » Sun May 12, 2024 2:14 pm

You probably have crashed database tables, you should check for crashed tables with your mysql command-line interface.
mflorell
Site Admin
 
Posts: 18386
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Lost All Users information after power outage

Postby zubz94 » Sun May 12, 2024 5:47 pm

I have checked and repaired all mysql tables which were corrupt but still cannot log in any users,
All tables are upto date/ Ok

Please advise on any data that i need to provide here that can assist with further investigation
zubz94
 
Posts: 3
Joined: Sat May 11, 2024 7:11 am

Re: Lost All Users information after power outage

Postby zubz94 » Mon May 13, 2024 8:27 am

when checking
MariaDB [asterisk]> select * from vicidial_users where user="Admin";
Empty set (0.001 sec)

the same for users
zubz94
 
Posts: 3
Joined: Sat May 11, 2024 7:11 am

Re: Lost All Users information after power outage

Postby carpenox » Wed May 29, 2024 7:18 am

does "select * from vicidial_users;" show anything?
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2423
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to Support

Who is online

Users browsing this forum: No registered users and 53 guests