Problem with DB backup

Matthieu Jacquart · Jan 30, 2018, 1:05 AM

Hi,

I’ve got this problem since long time, so it’s not related to RC11 or RC10 : So each time I upgrade fog, FogDBBackup folder in /home only contains 1Kb files, whereas few months ago file size was the same that when I export database (between 2MB and 5MB).

And new problem since I move my older fog server (Debian 8 ) to new Debian 9, in Web UI “Fog configuration” - “Configuration save”, when I export database (user and passwor dare ok), there is blank screen (http://fog/fog/management/export.php?type=sql) and nothning happens…

Thanks
Matthieu

Wayne Workman · Jan 29, 2018, 5:03 PM

@matthieu-jacquart Check the apache error logs just after you try this. Show us what you find.

Matthieu Jacquart · Jan 30, 2018, 7:18 AM

@Wayne-Workman Hi, Just after trying to export database, apache2 error.log :

[Mon Jan 29 06:25:05.343782 2018] [mpm_prefork:notice] [pid 668] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2l configured -- resuming normal operations
[Mon Jan 29 06:25:05.343849 2018] [core:notice] [pid 668] AH00094: Command line: '/usr/sbin/apache2'
[Mon Jan 29 17:07:28.647006 2018] [:error] [pid 27308] [client 192.168.10.100:64228] PHP Warning:  fopen(/tmp/fog_backup_tmp.sql): failed to open stream: No such file or directory in /var/www/fog/lib/db/mysqldump.class.php on line 1080, referer: http://fog/fog/management/index.php?node=about&sub=config
[Mon Jan 29 17:07:28.647137 2018] [:error] [pid 27308] [client 192.168.10.100:64228] PHP Fatal error:  Uncaught Exception: Output file is not writable in /var/www/fog/lib/db/mysqldump.class.php:1082\nStack trace:\n#0 /var/www/fog/lib/db/mysqldump.class.php(309): CompressNone->open('/tmp/fog_backup...')\n#1 /var/www/fog/lib/fog/schema.class.php(200): Mysqldump->start('/tmp/fog_backup...')\n#2 /var/www/fog/lib/fog/reportmaker.class.php(269): Schema->exportdb('fog_backup_2018...')\n#3 /var/www/fog/management/export.php(40): ReportMaker->outputReport()\n#4 {main}\n  thrown in /var/www/fog/lib/db/mysqldump.class.php on line 1082, referer: http://fog/fog/management/index.php?node=about&sub=config
[Mon Jan 29 17:11:10.144748 2018] [:error] [pid 17023] [client 192.168.10.100:64324] PHP Warning:  fopen(/tmp/fog_backup_tmp.sql): failed to open stream: No such file or directory in /var/www/fog/lib/db/mysqldump.class.php on line 1080, referer: http://fog/fog/management/index.php?node=about&sub=config
[Mon Jan 29 17:11:10.144845 2018] [:error] [pid 17023] [client 192.168.10.100:64324] PHP Fatal error:  Uncaught Exception: Output file is not writable in /var/www/fog/lib/db/mysqldump.class.php:1082\nStack trace:\n#0 /var/www/fog/lib/db/mysqldump.class.php(309): CompressNone->open('/tmp/fog_backup...')\n#1 /var/www/fog/lib/fog/schema.class.php(200): Mysqldump->start('/tmp/fog_backup...')\n#2 /var/www/fog/lib/fog/reportmaker.class.php(269): Schema->exportdb('fog_backup_2018...')\n#3 /var/www/fog/management/export.php(40): ReportMaker->outputReport()\n#4 {main}\n  thrown in /var/www/fog/lib/db/mysqldump.class.php on line 1082, referer: http://fog/fog/management/index.php?node=about&sub=config
[Tue Jan 30 08:07:13.756950 2018] [:error] [pid 9627] [client 192.168.10.100:61894] PHP Warning:  fopen(/tmp/fog_backup_tmp.sql): failed to open stream: No such file or directory in /var/www/fog/lib/db/mysqldump.class.php on line 1080, referer: http://fog/fog/management/index.php?node=about&sub=config
[Tue Jan 30 08:07:13.757056 2018] [:error] [pid 9627] [client 192.168.10.100:61894] PHP Fatal error:  Uncaught Exception: Output file is not writable in /var/www/fog/lib/db/mysqldump.class.php:1082\nStack trace:\n#0 /var/www/fog/lib/db/mysqldump.class.php(309): CompressNone->open('/tmp/fog_backup...')\n#1 /var/www/fog/lib/fog/schema.class.php(200): Mysqldump->start('/tmp/fog_backup...')\n#2 /var/www/fog/lib/fog/reportmaker.class.php(269): Schema->exportdb('fog_backup_2018...')\n#3 /var/www/fog/management/export.php(40): ReportMaker->outputReport()\n#4 {main}\n  thrown in /var/www/fog/lib/db/mysqldump.class.php on line 1082, referer: http://fog/fog/management/index.php?node=about&sub=config

and access.log

192.168.10.100 - - [30/Jan/2018:08:06:59 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 690 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:06:59 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=74:27:EA:6C:AA:0D&newService&json HTTP/1.1" 200 491 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:07:00 +0100] "GET /fog/management/other/ssl/srvpublic.crt HTTP/1.1" 200 1926 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:07:00 +0100] "POST /fog/management/index.php?sub=requestClientInfo&authorize&newService HTTP/1.1" 200 527 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:07:00 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 493 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:07:00 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 498 "-" "-"
192.168.10.100 - - [30/Jan/2018:08:07:10 +0100] "GET /fog/management/index.php?node=about&sub=config HTTP/1.1" 200 2970 "http://fog/fog/management/index.php?node=about" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0"
192.168.10.100 - - [30/Jan/2018:08:07:10 +0100] "POST /fog/status/getservertime.php HTTP/1.1" 200 672 "http://fog/fog/management/index.php?node=about&sub=config" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0"
192.168.10.100 - - [30/Jan/2018:08:07:10 +0100] "GET /fog/status/mainversion.php HTTP/1.1" 200 704 "http://fog/fog/management/index.php?node=about&sub=config" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0"
192.168.10.100 - - [30/Jan/2018:08:07:13 +0100] "POST /fog/management/export.php?type=sql HTTP/1.1" 200 677 "http://fog/fog/management/index.php?node=about&sub=config" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0"
192.168.10.100 - - [30/Jan/2018:08:07:13 +0100] "POST /fog/management/export.php?type=sql HTTP/1.1" 500 634 "http://fog/fog/management/index.php?node=about&sub=config" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0"

Sebastian Roth · Jan 30, 2018, 7:29 AM

@Matthieu-Jacquart Please run ls -al /tmp | head -5 and ls -al /tmp/fog_backup_tmp.sql and post here.

Matthieu Jacquart · Jan 30, 2018, 8:02 AM

@sebastian-roth Hi,

I rebooted fog server and now I can save and export database, but it’s not the first time I had to do this on the new server to backup DB

root@FOG:~$ ls -al /tmp | head -5
total 68
drwxrwxrwt 17 root root 4096 janv. 30 08:55 .
drwxr-xr-x 25 root root 4096 janv. 30 08:12 ..
drwxrwxrwt  2 root root 4096 janv. 30 08:15 .font-unix
drwxrwxrwt  2 root root 4096 janv. 30 08:15 .ICE-unix

root@FOG:~$ ls -al /tmp/fog_backup_tmp.sql
ls: impossible d'accéder à '/tmp/fog_backup_tmp.sql': Aucun fichier ou dossier de ce type

and I launched install script before rebooting but once again sql file in /home/fogDBbackups is only 1KB

root@FOG:/home/fogDBbackups$ ls -l
total 12
drwxr-xr-x 2 root root 4096 janv. 30 08:12 .
drwxr-xr-x 6 root root 4096 janv. 30 08:12 ..
-rw-r--r-- 1 root root   25 janv. 30 08:12 fog_sql_1.5.0-RC-11_20180130_081251.sql

Matthieu Jacquart · Feb 8, 2018, 8:35 AM

Hi,

Everything is now fine with RC-12, thread can be closed

Thanks !
Matthieu

Problem with DB backup

165

12.0k

17.3k

155.2k