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

All installation and configuration problems and questions

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

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

Postby rdipen » Tue Sep 19, 2023 3:00 pm

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.
rdipen
 
Posts: 17
Joined: Tue May 09, 2023 3:18 pm

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

Postby carpenox » Tue Sep 19, 2023 3:46 pm

I can fix it
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2250
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

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

Postby carpenox » Tue Sep 19, 2023 6:18 pm

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
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2250
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 271 guests