All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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
by 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
-
by 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
by 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
by carpenox » Wed May 29, 2024 7:18 am
does "select * from vicidial_users;" show anything?
Alma Linux 9.4 | SVN Version: 3890 | 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: 2426
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
-
Return to Support
Who is online
Users browsing this forum: Majestic-12 [Bot] and 77 guests