Backing up database ... Failed - working-RC-11

[Wayne Workman]

Server

• Version: 1.3.0 working-RC-11
• OS: Fedora 24 server

PHP version:

PHP 7.0.11 (cli) (built: Sep 14 2016 08:01:31) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies

MySQL verison:

mysql  Ver 15.1 Distrib 10.1.16-MariaDB, for Linux (x86_64) using  EditLine wrapper

Description

the installer fails at backing up the database. I’ve done some debugging, this is the command that is ran when it tries to back up:

wget --no-check-certificate -O /home//fogDBbackups/fog_sql_25_"20160914_095730".sql "http://10.0.0.4//fog//maintenance/backup_db.php" --post-data="type=sql&fogajaxonly=1"

I’ve ran this manually, and I get this error at CLI:

[root@fog-server bin]# wget --no-check-certificate -O /home//fogDBbackups/fog_sql_25_"20160914_095730".sql "http://10.0.0.4//fog//maintenance/backup_db.php" --post-data="type=sql&fogajaxonly=1"
--2016-09-14 09:57:45--  http://10.0.0.4//fog//maintenance/backup_db.php
Connecting to 10.0.0.4:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2016-09-14 09:57:45 ERROR 500: Internal Server Error.

[root@fog-server bin]#

And this error appear in the apache error log:

[Wed Sep 14 09:57:30.596441 2016] [:error] [pid 5925] [client 10.0.0.4:60374] PHP Fatal error:  Uncaught Error: Call to a member function debug() on null in /var/www/html/fog/lib/db/pdodb.class.php:208\nStack trace:\n#0 /var/www/html/fog/lib/db/pdodb.class.php(153): PDODB::currentDb(Object(PDODB))\n#1 /var/www/html/fog/lib/db/pdodb.class.php(161): PDODB->_connect(false)\n#2 /var/www/html/fog/lib/db/pdodb.class.php(87): PDODB->_connect()\n#3 /var/www/html/fog/lib/db/databasemanager.class.php(36): PDODB->__construct()\n#4 /var/www/html/fog/commons/init.php(283): DatabaseManager->establish()\n#5 /var/www/html/fog/commons/base.inc.php(19): require('/var/www/html/f...')\n#6 /var/www/html/fog/maintenance/backup_db.php(2): require('/var/www/html/f...')\n#7 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 208
[Wed Sep 14 09:57:45.454079 2016] [:error] [pid 5926] [client 10.0.0.4:60376] PHP Fatal error:  Uncaught Error: Call to a member function debug() on null in /var/www/html/fog/lib/db/pdodb.class.php:208\nStack trace:\n#0 /var/www/html/fog/lib/db/pdodb.class.php(153): PDODB::currentDb(Object(PDODB))\n#1 /var/www/html/fog/lib/db/pdodb.class.php(161): PDODB->_connect(false)\n#2 /var/www/html/fog/lib/db/pdodb.class.php(87): PDODB->_connect()\n#3 /var/www/html/fog/lib/db/databasemanager.class.php(36): PDODB->__construct()\n#4 /var/www/html/fog/commons/init.php(283): DatabaseManager->establish()\n#5 /var/www/html/fog/commons/base.inc.php(19): require('/var/www/html/f...')\n#6 /var/www/html/fog/maintenance/backup_db.php(2): require('/var/www/html/f...')\n#7 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 208

[Wayne Workman]

This is because the fog database is not being created. Still looking into it.

[Wayne Workman]

The installer succeeds when I run it as:
snmysqlhost='127.0.0.1' ./installfog.sh -y

[Tom Elliott]

@Wayne-Workman so solved by using 127.0.0.1?

[Wayne Workman]

@Tom-Elliott sort-of. Even with that it seems hit and miss, but that argument is the only one that has had success so far.

[Tom Elliott]

@Wayne-Workman Should be fixed now. I removed all the “debug” calls in the db class.

[Wayne Workman]

@Tom-Elliott I will test. I was actually getting ready to post here about issues… the db connection keeps dropping on the version I’m on. I’ll update and try again.

[Tom Elliott]

@Wayne-Workman What do you mean “dropping?”

I’m, currently, not using persistent connection.

[Wayne Workman]

@Tom-Elliott Earlier, the installer completed and the web interface was functional. Now it’s saying the db connection is invalid when I try to use the web interface.

[Wayne Workman]

@Tom-Elliott I’m now on working-RC-11 version 28, I re-ran the installer on the main and node, and it’s working at the moment.

[Wayne Workman]

Version 51 and it’s installing fine still.

[Tom Elliott]

@Wayne-Workman mind upping to version 53?

[Wayne Workman]

@Tom-Elliott 53 and 54 were fine.