Broken after last update

Just doing the latest update (the framework to xxxxxx.41)

and I am getting the following on my web console.

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

/var/www/html/admin/bootstrap.php:91 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:99 include_once()
[0]: /etc/freepbx.conf

Huh? How do I fix this…

Looks like mysql crashed. Try to restart it

Done, but now I am stuck at a “White Screen” via the web interface. Asterisk seems to be running underneath, but can’t get to the GUI.

I am seeing the same - getting a blank (empty page) on what should normally be the landing page for Freepbx. I have tried changing the permissions of /etc/freepbx.conf, but to no avail.

Asterisk seems to be working in the background.

Please provide some logs: http://wiki.freepbx.org/display/GHWF/Providing+Great+Debug

amportal a dbug

Please wait…

trying to run as user asterisk:

[FPBXDBUGDISABLE] changed from previous value: [1] to new value: [0]

==> /var/log/asterisk/freepbx_dbug <==

2015-Mar-04 00:25:18 /var/www/html/admin/libraries/BMO/GPG.class.php:510
[DEPRECATION_WARNING]: Comments starting with ‘#’ are deprecated in Unknown on line 20

2015-Mar-04 05:38:49 /var/www/html/admin/libraries/view.functions.php:57
[NOTICE]: Undefined variable: amp_conf

2015-Mar-04 05:46:40 /var/www/html/admin/libraries/view.functions.php:57
[NOTICE]: Undefined variable: amp_conf

Up to here is where it started up - from here on is when I opened a browser at ipaddress/admin/

==> /var/log/asterisk/freepbx.log <==

==> /var/log/asterisk/freepbx_dbug <==
2015-Mar-04 11:20:09 /var/www/html/admin/libraries/view.functions.php:41
[NOTICE]: Undefined variable: amp_conf

2015-Mar-04 11:20:09 /var/www/html/admin/libraries/view.functions.php:57
[NOTICE]: Undefined variable: amp_conf

2015-Mar-04 11:20:40 /var/www/html/admin/libraries/view.functions.php:41
[NOTICE]: Undefined variable: amp_conf

2015-Mar-04 11:20:40 /var/www/html/admin/libraries/view.functions.php:57
[NOTICE]: Undefined variable: amp_conf

Thoughts? Actions? Reinstall from the ground up for the 7th time?

Ok. You shouldn’t have to do that. How about you tail the http error log:

tail -f /var/log/httpd/error_log

Refresh the page and post the output.

It’s best for things like this to just jump on IRC and ask there…

1 Like

Answered on irc (by someone called x-rob - :smile:

For later reference for anyone that encounters this… (white screen of death, after a failed update of a module), was to get to a console and type

amportal a ma updateall

which I am assuming to be shorthand for something like amportal admin moduleadmin updateall

That, and a reboot and all is ticketyboo.

Well… I’ve run into the same problem and none of the various ‘solutions’ that I’ve seen have helped.

Stop mysql, delete .sock file (already gone following stop), restart…
amportal a ma update all just responds with “Fetching FreePBX settings with gen_amp_conf.php…” and then exits.

the SQL daemon is running, the specifics in the boot log are:

                                                       [FAILED]

[FATAL] DB Error: connect failed

Trace Back:

/var/www/html/admin/libraries/db_connect.php:71 die_freepbx()
[0]: DB Error: connect failed

/var/www/html/admin/bootstrap.php:91 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/modules/vqplus/queue-callback.php:8 include_once()
[0]: /etc/freepbx.conf

Though I do note that these errors are being displayed immediately BEFORE the “Starting mysqld” entry in the boot.log file…

amportal a dbug returns the following (and a page refresh was done while this was running)

Fetching FreePBX settings with gen_amp_conf.php…

trying to run as user asterisk:

[FPBXDBUGDISABLE] already set to [0]

==> /var/log/asterisk/freepbx_dbug <==

==> /var/log/httpd/error_log <==
[Tue May 26 12:24:20 2015] [notice] Digest: done
[Tue May 26 12:24:20 2015] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.28 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured – resuming normal operations
[Tue May 26 12:25:50 2015] [notice] caught SIGTERM, shutting down
[Tue May 26 12:27:12 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue May 26 12:27:12 2015] [notice] Digest: generating secret for digest authentication …
[Tue May 26 12:27:12 2015] [notice] Digest: done
[Tue May 26 12:27:13 2015] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.28 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured – resuming normal operations
[Tue May 26 14:41:20 2015] [error] [client 192.168.50.42] File does not exist: /var/www/html/favicon.ico, referer: http://192.168.142.20/admin/config.php
[Tue May 26 14:41:54 2015] [error] [client 192.168.50.42] File does not exist: /var/www/html/favicon.ico, referer: http://192.168.142.20/admin/config.php
[Tue May 26 14:47:22 2015] [error] [client 192.168.50.42] File does not exist: /var/www/html/favicon.ico, referer: http://192.168.142.20/admin/config.php

==> /var/log/asterisk/freepbx.log <==
[2015-May-26 14:47:55] [INFO] (bin/freepbx_setting:42) - trying to run as user asterisk:
[2015-May-26 14:47:55] [INFO] (bin/freepbx_setting:43) -
[2015-May-26 14:47:55] [INFO] (bin/freepbx_setting:64) - [FPBXDBUGDISABLE] already set to [0]
[2015-May-26 14:47:55] [INFO] (bin/freepbx_setting:65) -
[2015-May-26 14:52:10] [WARNING] (libraries/modulefunctions.legacy.php:7) - Depreciated Function module_getinfo detected in /var/www/html/admin/modules/bria/functions.inc/userman_hooks.php on line 15
[2015-May-26 14:52:10] [PHP-WARNING] (/var/www/html/admin/modules/cxpanel/brand.php:3) - file_get_contents(/etc/schmooze/operator-panel-brand): failed to open stream: No such file or directory
[2015-May-26 14:55:27] [INFO] (bin/freepbx_setting:42) - trying to run as user asterisk:
[2015-May-26 14:55:27] [INFO] (bin/freepbx_setting:43) -
[2015-May-26 14:55:28] [INFO] (bin/freepbx_setting:64) - [FPBXDBUGDISABLE] already set to [0]
[2015-May-26 14:55:28] [INFO] (bin/freepbx_setting:65) -
[2015-May-26 14:55:50] [WARNING] (libraries/modulefunctions.legacy.php:7) - Depreciated Function module_getinfo detected in /var/www/html/admin/modules/bria/functions.inc/userman_hooks.php on line 15
[2015-May-26 14:55:50] [PHP-WARNING] (/var/www/html/admin/modules/cxpanel/brand.php:3) - file_get_contents(/etc/schmooze/operator-panel-brand): failed to open stream: No such file or directory

Thoughts and suggestions most welcome! If there is something else in the way of logs required, please let me know. Looked in the httpd error_log file as well, not thing there of note…

I tried this command /usr/bin/change-passwords and it worked without a problem, found it in the following link:
vivaolinux.com.br/topico/MySQL/DB-Error-connect-failed-Elastix
Thank you all!