Broken after last update

General Help
1

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ā€¦

2

Looks like mysql crashed. Try to restart it

3

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.

5

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.

6

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

7

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

8

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

9

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.

10

Itā€™s best for things like this to just jump on IRC and ask thereā€¦

1 Like
11

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.

12

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ā€¦

13

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!