Page 1 of 1
Lost All Users information after power outage
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
Wed May 29, 2024 7:18 am
by carpenox
does "select * from vicidial_users;" show anything?