Problem after running upgrade script - please help

Distro Discussion & Help
1

Went through the upgrades, didn’t miss one, here is what my GUI displays after running the 5.211.65-2 script.

FATAL ERROR
DB Error: connect failed
Trace Back
/var/www/html/admin/libraries/db_connect.php:63 die_freepbx()
[0]: DB Error: connect failed

/var/www/html/admin/bootstrap.php:98 require_once()
[0]: /var/www/html/admin/libraries/db_connect.php

/etc/freepbx.conf:9 require_once()
[0]: /var/www/html/admin/bootstrap.php

/var/www/html/admin/config.php:109 include_once()
[0]: /etc/freepbx.conf

2

You didn’t tell us much about what you were doing or how it went wrong. Log files would help.

The bottom line is the credentials in /etc/freepbx.conf much match the mysql account.

3

I ran the update scripts individually from 4.211.64-8
rebooted after each upgrade script and checked GUI
I did not check the GUI after upgrading to 5.211.65-1 but did reboot
ran the 5.211.65-2 script, but could see errors, rebooted, GUI listed as in first post.

Upgrade script logs look ok, until 5.211.65-2 whick looks incomplete it ends like this

Fri Feb 21 12:24:44 PST 2014 STAGE 4 STARTING - Clean Up
Fri Feb 21 12:24:44 PST 2014 updatedb for locate command

What additional info can I provide to be of assistance?

Thanks for the help!

4

Sounds like your DB crashed.

5

We just went through the same thing last week. My post is still on page 2.

Upon CentOS 6.5 shutdown, the MYSQL socket file is not cleaned up in some cases and remains on reboot (e.g. system did not shutdown gracefully). This causes a DB Error: connect failed and when you stop and restart MYSQL it gives the error “MySQL daemon already running with the same unix socket”.

Solution is to stop mysql, cleanup the file /var/lib/mysql/mysql.sock and start sql again. As per Tony this was corrected in 5.211.65-4.

6

Thank you DCI, that did the trick!