Page 1 of 1

Getting error "DBD::mysql::db do failed: No database select"

PostPosted: Tue Sep 19, 2023 3:00 pm
by rdipen
I am using ViciBox v 10.0 on Dell 1350 i5 processor and it's been running for almost 6 months up until now this morning.

I have been trying to troubleshoot this problem since this morning and I couldn't find any luck... As of now we don't have access to GUI interface, we have tried rebooting server, run mysql check command to auto repair any corruption and couldn't resolve this error.
-It gives me this error "localhost vicidial[2533]: No /start_asterisk_boot.pl found! ViciDial installed?
" when I tried running " systemctl status vicidial" I don't know if it's related or not.

-I have tried accessing GUI interface it says "MySQL connect ERROR" anyone ever faced this similar problem and know how to fix it?

-I thought it might be the IP address so I've tried using "/usr/share/astguiclient/ADMIN_update_server_ip.pl" command to change the IP address and that's when I get
"Updating servers table: active_twin_server_ip...
DBD::mysql::db do failed: No database selected at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 410, <STDIN> line 4." error
We are okay paying for it if you think you could fix it... Shoot me an email dbsdipen@gmail.com if you can fix it.

Re: Getting error "DBD::mysql::db do failed: No database sel

PostPosted: Tue Sep 19, 2023 3:46 pm
by carpenox
I can fix it

Re: Getting error "DBD::mysql::db do failed: No database sel

PostPosted: Tue Sep 19, 2023 6:18 pm
by carpenox
Just to update:

Turned out all his settings in the install.pl script were erased and needed to be readded. Once I did that and ran the script, everything synced back up.

Hopefully this helps someone else..

Chris