Problem with DB backup



  • 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



  • Hi,

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

    Thanks !
    Matthieu



  • @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
    

  • Developer

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



  • @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"
    


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


Log in to reply
 

957
Online

40.3k
Users

11.4k
Topics

108.3k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.