• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    build 7102 'Backing up database ... failed'

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    23
    5.4k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • sudburrS
      sudburr
      last edited by

      So far I’ve tried updating to 7102, 7104 and 7106 on this server and it continues to fail at Backing up database.

      My fresh iron build using the same source files and installed identically, works. yargen.

      A little help? What has broken on this naughty server?

      [ Standing in between extinction in the cold and explosive radiating growth ]

      1 Reply Last reply Reply Quote 0
      • george1421G
        george1421 Moderator
        last edited by

        Is your FOG server behind a proxy server? I have seen where the fog server is behind a proxy server and you either use the environ variables or update wgetrc with proxy settings. This will cause the backup script to fail.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

        1 Reply Last reply Reply Quote 0
        • sudburrS
          sudburr
          last edited by

          No proxy server. Again, 4/5 worked, but number 5 is not alive.

          [ Standing in between extinction in the cold and explosive radiating growth ]

          1 Reply Last reply Reply Quote 0
          • george1421G
            george1421 Moderator
            last edited by george1421

            Hmmm…

            I think what I would do on this is look into the /opt/fog/.fogsettings file. That will have the parameters saved by the installer and the password selected for the mysql database. Then try to login to mysql using the FOG SQL password.

            with mysql -u fog fog -p
            That reads use user fog to connect to the fog database and prompt me for the password.

            See if you can get logged into the mysql database. If you get logged in then do something like show tables; to list all of the fog related tables.

            [edit] wait this doesn’t work on my fog server. I can’t test it right now I have to run [/edit]

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

            1 Reply Last reply Reply Quote 0
            • sudburrS
              sudburr
              last edited by

              Command results:

              mysql -u root fog -p
              show tables;
              
              +------------------------+
              | Tables_in_fog          |
              +------------------------+
              | aloLog                 |
              | clientUpdates          |
              | dirCleaner             |
              | globalSettings         |
              | greenFog               |
              | groupMembers           |
              | groups                 |
              | history                |
              | hostAutoLogOut         |
              | hostMAC                |
              | hostScreenSettings     |
              | hosts                  |
              | imageGroupAssoc        |
              | imagePartitionTypes    |
              | imageTypes             |
              | images                 |
              | imagingLog             |
              | inventory              |
              | ipxeTable              |
              | keySequence            |
              | moduleStatusByHost     |
              | modules                |
              | multicastSessions      |
              | multicastSessionsAssoc |
              | nfsFailures            |
              | nfsGroupMembers        |
              | nfsGroups              |
              | os                     |
              | oui                    |
              | plugins                |
              | printerAssoc           |
              | printers               |
              | pxeMenu                |
              | scheduledTasks         |
              | schemaVersion          |
              | snapinAssoc            |
              | snapinGroupAssoc       |
              | snapinJobs             |
              | snapinTasks            |
              | snapins                |
              | supportedOS            |
              | taskLog                |
              | taskStates             |
              | taskTypes              |
              | tasks                  |
              | userCleanup            |
              | userTracking           |
              | users                  |
              | virus                  |
              +------------------------+
              49 rows in set (0.00 sec)
              
              

              [ Standing in between extinction in the cold and explosive radiating growth ]

              Wayne WorkmanW 1 Reply Last reply Reply Quote 0
              • Wayne WorkmanW
                Wayne Workman @sudburr
                last edited by

                @sudburr I’ve been watching this thread and I’ve not had any ideas. The database backups go into /home maybe make sure you have space there. df -h

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                Daily Clean Installation Results:
                https://fogtesting.fogproject.us/
                FOG Reporting:
                https://fog-external-reporting-results.fogproject.us/

                george1421G 1 Reply Last reply Reply Quote 0
                • sudburrS
                  sudburr
                  last edited by

                  Gigs worth of space.

                  [ Standing in between extinction in the cold and explosive radiating growth ]

                  Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                  • Wayne WorkmanW
                    Wayne Workman @sudburr
                    last edited by

                    @sudburr partitions, man. partitions… check anyways.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                    Daily Clean Installation Results:
                    https://fogtesting.fogproject.us/
                    FOG Reporting:
                    https://fog-external-reporting-results.fogproject.us/

                    1 Reply Last reply Reply Quote 0
                    • sudburrS
                      sudburr
                      last edited by

                      Filesystem      Size  Used Avail Use% Mounted on
                      /dev/sda2       115G  3.3G  106G   4% /
                      devtmpfs        919M     0  919M   0% /dev
                      tmpfs           928M     0  928M   0% /dev/shm
                      tmpfs           928M  8.5M  920M   1% /run
                      tmpfs           928M     0  928M   0% /sys/fs/cgroup
                      /dev/sdb1       932G  249G  684G  27% /images
                      /dev/sda1       477M  172M  276M  39% /boot
                      tmpfs           186M     0  186M   0% /run/user/1000
                      

                      [ Standing in between extinction in the cold and explosive radiating growth ]

                      1 Reply Last reply Reply Quote 0
                      • george1421G
                        george1421 Moderator @Wayne Workman
                        last edited by

                        @Wayne-Workman what happens if the destination location does not exist?

                        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                        • Wayne WorkmanW
                          Wayne Workman @george1421
                          last edited by

                          @george1421 Not sure… I’m sure it exists though.

                          ls /home

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

                          1 Reply Last reply Reply Quote 0
                          • Wayne WorkmanW
                            Wayne Workman
                            last edited by

                            r7116 on Fedora 21 fully updated, I’m getting a db failed message as well.

                            * Backing up database.........................................Failed!
                            

                            Here’s what’s in the error log:

                            /usr/bin/lsb_release
                            /usr/bin/systemctl
                            ln: failed to create symbolic link ‘/usr/lib/systemd/system/mysql.service’: File exists
                            ln: failed to create symbolic link ‘/usr/lib/systemd/system/mysqld.service’: File exists
                            ln: failed to create symbolic link ‘/etc/systemd/system/mysql.service’: File exists
                            ln: failed to create symbolic link ‘/etc/systemd/system/mysqld.service’: File exists
                            /opt/fog/.fogsettings
                            Loaded plugins: langpacks
                            http://remi.kazukioishi.net/fedora/21/remi/x86_64/repodata/repomd.xml: [Errno 12] Timeout on http://remi.kazukioishi.net/fedora/21/remi/x86_64/repodata/repomd.xml: (28, 'Connection timed out after 30001 milliseconds')
                            Trying other mirror.
                            No package epel-release available.
                            Error: Nothing to do
                            remi-release-21-3.fc21.remi.noarch
                            Loaded plugins: langpacks
                            ================================== repo: remi ==================================
                            [remi]
                            async = True
                            bandwidth = 0
                            base_persistdir = /var/lib/yum/repos/x86_64/21
                            baseurl =
                            cache = 0
                            cachedir = /var/cache/yum/x86_64/21/remi
                            check_config_file_age = True
                            cost = 1000
                            deltarpm_metadata_percentage = 100
                            deltarpm_percentage =
                            enabled = True
                            enablegroups = True
                            exclude =
                            failovermethod = roundrobin
                            gpgcadir = /var/lib/yum/repos/x86_64/21/remi/gpgcadir
                            gpgcakey =
                            gpgcheck = True
                            gpgdir = /var/lib/yum/repos/x86_64/21/remi/gpgdir
                            gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
                            hdrdir = /var/cache/yum/x86_64/21/remi/headers
                            http_caching = all
                            includepkgs =
                            ip_resolve =
                            keepalive = True
                            keepcache = False
                            mddownloadpolicy = sqlite
                            mdpolicy = group:small
                            mediaid =
                            metadata_expire = 21600
                            metadata_expire_filter = read-only:present
                            metalink =
                            minrate = 0
                            mirrorlist = http://rpms.remirepo.net/fedora/21/remi/mirror
                            mirrorlist_expire = 86400
                            name = Remi's RPM repository - Fedora 21 - x86_64
                            old_base_cache_dir =
                            password =
                            persistdir = /var/lib/yum/repos/x86_64/21/remi
                            pkgdir = /var/cache/yum/x86_64/21/remi/packages
                            proxy = False
                            proxy_dict =
                            proxy_password =
                            proxy_username =
                            repo_gpgcheck = False
                            retries = 10
                            skip_if_unavailable = False
                            ssl_check_cert_permissions = True
                            sslcacert =
                            sslclientcert =
                            sslclientkey =
                            sslverify = True
                            throttle = 0
                            timeout = 30.0
                            ui_id = remi/21
                            ui_repoid_vars = releasever,
                               basearch
                            username =
                            
                            Loaded plugins: langpacks
                            httpd-2.4.16-1.fc21.x86_64
                            php-5.6.20-1.fc21.remi.x86_64
                            php-cli-5.6.20-1.fc21.remi.x86_64
                            php-common-5.6.20-1.fc21.remi.x86_64
                            php-gd-5.6.20-1.fc21.remi.x86_64
                            mariadb-10.0.21-1.fc21.x86_64
                            mariadb-server-10.0.21-1.fc21.x86_64
                            tftp-server-5.2-15.fc21.x86_64
                            nfs-utils-1.3.1-6.4.fc21.x86_64
                            vsftpd-3.0.2-12.fc21.x86_64
                            net-tools-2.0-0.31.20141124git.fc21.x86_64
                            wget-1.16.3-1.fc21.x86_64
                            xinetd-2.3.15-15.fc21.x86_64
                            tar-1.27.1-8.fc21.x86_64
                            gzip-1.6-8.fc21.x86_64
                            make-4.0-3.fc21.x86_64
                            m4-1.4.17-6.fc21.x86_64
                            gcc-4.9.2-6.fc21.x86_64
                            gcc-c++-4.9.2-6.fc21.x86_64
                            lftp-4.5.4-4.fc21.x86_64
                            Loaded plugins: langpacks
                            Installed Packages
                            php-mysqlnd.x86_64                  5.6.20-1.fc21.remi                   @remi
                            Available Packages
                            php-mysqlnd.i686                    5.6.15-1.fc21                        updates
                            php-mysqlnd-5.6.20-1.fc21.remi.x86_64
                            curl-7.37.0-14.fc21.x86_64
                            php-mcrypt-5.6.20-1.fc21.remi.x86_64
                            php-mbstring-5.6.20-1.fc21.remi.x86_64
                            mod_ssl-2.4.16-1.fc21.x86_64
                            php-fpm-5.6.20-1.fc21.remi.x86_64
                            php-process-5.6.20-1.fc21.remi.x86_64
                            Loaded plugins: langpacks
                            No packages marked for update
                            httpd-2.4.16-1.fc21.x86_64
                            php-5.6.20-1.fc21.remi.x86_64
                            php-cli-5.6.20-1.fc21.remi.x86_64
                            php-common-5.6.20-1.fc21.remi.x86_64
                            php-gd-5.6.20-1.fc21.remi.x86_64
                            mariadb-10.0.21-1.fc21.x86_64
                            mariadb-server-10.0.21-1.fc21.x86_64
                            tftp-server-5.2-15.fc21.x86_64
                            nfs-utils-1.3.1-6.4.fc21.x86_64
                            vsftpd-3.0.2-12.fc21.x86_64
                            net-tools-2.0-0.31.20141124git.fc21.x86_64
                            wget-1.16.3-1.fc21.x86_64
                            xinetd-2.3.15-15.fc21.x86_64
                            tar-1.27.1-8.fc21.x86_64
                            gzip-1.6-8.fc21.x86_64
                            make-4.0-3.fc21.x86_64
                            m4-1.4.17-6.fc21.x86_64
                            gcc-4.9.2-6.fc21.x86_64
                            gcc-c++-4.9.2-6.fc21.x86_64
                            lftp-4.5.4-4.fc21.x86_64
                            php-mysqlnd-5.6.20-1.fc21.remi.x86_64
                            php-mysqlnd-5.6.20-1.fc21.remi.x86_64
                            curl-7.37.0-14.fc21.x86_64
                            php-mcrypt-5.6.20-1.fc21.remi.x86_64
                            php-mbstring-5.6.20-1.fc21.remi.x86_64
                            mod_ssl-2.4.16-1.fc21.x86_64
                            php-fpm-5.6.20-1.fc21.remi.x86_64
                            php-process-5.6.20-1.fc21.remi.x86_64
                            New password: Retype new password: Changing password for user fog.
                            passwd: all authentication tokens updated successfully.
                            Failed to execute operation: No such file or directory
                            ● mariadb.service - MariaDB 10.0 database server
                               Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
                              Drop-In: /usr/lib/systemd/system/mariadb.service.d
                                       └─mysql-compat.conf
                               Active: active (running) since Fri 2016-04-08 12:56:04 CDT; 2s ago
                              Process: 47341 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
                              Process: 47189 ExecStartPost=/usr/libexec/mysql-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
                              Process: 47153 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
                              Process: 47129 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
                             Main PID: 47188 (mysqld_safe)
                               CGroup: /system.slice/mariadb.service
                                       ├─47188 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
                                       └─47304 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
                            
                            Apr 08 12:56:03 localhost.localdomain mysqld_safe[47188]: 160408 12:56:03 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
                            Apr 08 12:56:03 localhost.localdomain mysqld_safe[47188]: 160408 12:56:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
                            Signature ok
                            subject=/CN=10.2.1.11
                            Getting CA Private Key
                            ln: failed to create symbolic link ‘/var/www/html/fog/fog’: File exists
                            ● httpd.service - The Apache HTTP Server
                               Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled)
                               Active: active (running) since Fri 2016-04-08 13:05:04 CDT; 2s ago
                             Main PID: 47564 (httpd)
                               Status: "Processing requests..."
                               CGroup: /system.slice/httpd.service
                                       ├─47564 /usr/sbin/httpd -DFOREGROUND
                                       ├─47572 /usr/sbin/httpd -DFOREGROUND
                                       ├─47573 /usr/sbin/httpd -DFOREGROUND
                                       ├─47574 /usr/sbin/httpd -DFOREGROUND
                                       ├─47575 /usr/sbin/httpd -DFOREGROUND
                                       ├─47576 /usr/sbin/httpd -DFOREGROUND
                                       ├─47582 /usr/sbin/httpd -DFOREGROUND
                                       └─47585 /usr/sbin/httpd -DFOREGROUND
                            
                            Apr 08 13:05:04 localhost.localdomain httpd[47564]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message
                            
                            ● php-fpm.service - The PHP FastCGI Process Manager
                               Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; enabled)
                               Active: active (running) since Fri 2016-04-08 13:05:04 CDT; 3s ago
                             Main PID: 47565 (php-fpm)
                               Status: "Ready to handle connections"
                               CGroup: /system.slice/php-fpm.service
                                       ├─47565 php-fpm: master process (/etc/php-fpm.conf
                                       ├─47566 php-fpm: pool www
                                       ├─47567 php-fpm: pool www
                                       ├─47568 php-fpm: pool www
                                       ├─47569 php-fpm: pool www
                                       └─47570 php-fpm: pool www
                            --2016-04-08 13:05:08--  http://10.2.1.11/fog//management/export.php?type=sql
                            Connecting to 10.2.1.11:80... connected.
                            HTTP request sent, awaiting response... 500 Internal Server Error
                            2016-04-08 13:05:09 ERROR 500: Internal Server Error.
                            

                            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                            Daily Clean Installation Results:
                            https://fogtesting.fogproject.us/
                            FOG Reporting:
                            https://fog-external-reporting-results.fogproject.us/

                            1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott
                              last edited by

                              try updating.

                              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                              1 Reply Last reply Reply Quote 0
                              • Wayne WorkmanW
                                Wayne Workman
                                last edited by

                                Whatever the issue was, it’s fixed in r7118.

                                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                                Daily Clean Installation Results:
                                https://fogtesting.fogproject.us/
                                FOG Reporting:
                                https://fog-external-reporting-results.fogproject.us/

                                Tom ElliottT 1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  Tom Elliott @Wayne Workman
                                  last edited by

                                  @Wayne-Workman it was a switch from self to static. In the case of the base class everything needs to be self.

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                  1 Reply Last reply Reply Quote 0
                                  • sudburrS
                                    sudburr
                                    last edited by

                                    Still no love for my original problem on this particular naughty server.

                                    [ Standing in between extinction in the cold and explosive radiating growth ]

                                    1 Reply Last reply Reply Quote 0
                                    • sudburrS
                                      sudburr
                                      last edited by

                                      So I :

                                      mysql -u root -p
                                      DROP DATABASE fog;
                                      mv /opt/fog /opt/fog.old
                                      

                                      Then launched the installer and I’m your uncle.

                                      [ Standing in between extinction in the cold and explosive radiating growth ]

                                      1 Reply Last reply Reply Quote 1
                                      • sudburrS
                                        sudburr
                                        last edited by sudburr

                                        I’m wondering now if the database backup failure was caused by the bloating of the history table like I experienced on another server? hmm …

                                        Too bad I didn’t check for that.

                                        [ Standing in between extinction in the cold and explosive radiating growth ]

                                        1 Reply Last reply Reply Quote 0
                                        • 1
                                        • 2
                                        • 1 / 2
                                        • First post
                                          Last post

                                        173

                                        Online

                                        12.0k

                                        Users

                                        17.3k

                                        Topics

                                        155.2k

                                        Posts
                                        Copyright © 2012-2024 FOG Project