• 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

      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

                                170

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project