Page 1 of 1

Lost All Users information after power outage

PostPosted: Sun May 12, 2024 12:20 pm
by zubz94
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

Re: Lost All Users information after power outage

PostPosted: Sun May 12, 2024 2:14 pm
by mflorell
You probably have crashed database tables, you should check for crashed tables with your mysql command-line interface.

Re: Lost All Users information after power outage

PostPosted: Sun May 12, 2024 5:47 pm
by zubz94
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

Re: Lost All Users information after power outage

PostPosted: Mon May 13, 2024 8:27 am
by zubz94
when checking
MariaDB [asterisk]> select * from vicidial_users where user="Admin";
Empty set (0.001 sec)

the same for users

Re: Lost All Users information after power outage

PostPosted: Wed May 29, 2024 7:18 am
by carpenox
does "select * from vicidial_users;" show anything?