Problem updating fog: Backing up Database ... failed



  • Currently on Fog trunk, but a very outdated version. Cant remember exactly what it was, maybe 7084 or something similar. Also I cant access the web gui to see it. I’m also on Ubuntu 14.04. The problem occurred when I tried to update to the newest version of fog, everything seemed to be going alright until this point, the one other thing that it said whilst installing was “server subnet mask: error: c is not recognized”. I checked .fogsettings and the subnet is correct. I’m not very skilled with commands so bare with me.



  • @Wayne-Workman Ok ill be sure to look for that in the future. Thanks to everyone who helped! Ill be sure too update frequently now haha


  • Moderator

    @K.Hays said in Problem updating fog: Backing up Database ... failed:

    Any idea to what caused this whole thing?

    Somebody messed with the .fogsettings file and put in the wrong information. If things in there are wrong and you update - things in fog will be wrong.

    For you and future readers, information on the .fogsettings file and passwords are in these two articles:
    https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
    https://wiki.fogproject.org/wiki/index.php?title=Password_Central



  • @Wayne-Workman That worked! Any idea to what caused this whole thing? Im going to have to update my other servers, and obviously this one in the future and would like to avoid this whole ordeal again haha


  • Moderator

    @K.Hays Ok. then inside of /opt/fog/.fogsettings set snmysqluser to root, and blank out snmysqlpass and snmysqlhost, re-run the installer, and you should be good to go.



  • @Wayne-Workman that worked, as in it let me in mysql


  • Moderator

    @K.Hays Ok, now try mysql -u root -D fog



  • @Wayne-Workman Access denied for user ‘fog’@‘localhost’ (using password: YES)
    d430@


  • Moderator

    @K.Hays Now try mysql -u fog -pfoggy -D fog



  • @Wayne-Workman it said unknown host


  • Moderator

    @K.Hays I suspect db issues. Try to connect to the DB, use the credentials in your .fogsettings file.

    mysql -u fog -h fog -pfoggy -D fog
    Note that no space between -p and foggy is intentional.

    The snmysqlhost being set to fog is suspicious… normally this is left blank, is set to localhost or 127.0.0.1 for the main server.



  • @Sebastian-Roth That got me further! But when i got to the Updating database schema there is no update option on the web page.


  • Developer

    @K-Hays Sorry for the delay. I am preparing to move house these days and don’t get much time for FOG stuff…

    Sorry didn’t see that you already posted this:

    ln: failed to create symbolic link ‘/var/www/fog/fog’: File exists
    ...
    --2016-08-12 14:22:17--  http://10.40.0.7//fog//maintenance/backup_db.php
    Connecting to 10.40.0.7:80... connected.
    HTTP request sent, awaiting response... 500 Internal Server Error
    2016-08-12 14:22:17 ERROR 500: Internal Server Error.
    

    Maybe something went wrong with those links. If you don’t have any modifications (kernels, initrds or whatever) within /var/www/ then I’d ask you to completely delete those and re-run the installer. See what you have in that directory, possibly there is /var/www/html/fog and /var/www/fog



  • This post is deleted!


  • This post is deleted!

  • Moderator

    @K.Hays Could you post your /opt/fog/.fogsettings file here?



  • @Sebastian-Roth Im currently on Version 7084, and was trying to upgrade to 1.3.0-RC-8.



  • @Sebastian-Roth

    The script you are attempting to invoke has been converted to an Upstart
    job, but lsb-header is not supported for Upstart jobs.
    insserv: warning: script 'friendly-recovery' missing LSB tags and overrides
    insserv: Default-Start undefined, assuming empty start runlevel(s) for script `friendly-recovery'
    insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `friendly-recovery'
    The script you are attempting to invoke has been converted to an Upstart
    job, but lsb-header is not supported for Upstart jobs.
    insserv: warning: script 'cron' missing LSB tags and overrides
    insserv: Default-Start undefined, assuming empty start runlevel(s) for script `cron'
    insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `cron'
     * Starting FOG Computer Imaging Solution: FOGMulticastManager
       ...fail!
     * Starting FOG Computer Imaging Solution: FOGImageReplicator
       ...fail!
     * Starting FOG Computer Imaging Solution: FOGSnapinReplicator
       ...fail!
     * Starting FOG Computer Imaging Solution: FOGScheduler
       ...fail!
     * Starting FOG Computer Imaging Solution: FOGPingHosts
       ...fail!
     * Stopping NFS kernel daemon
       ...done.
     * Unexporting directories for NFS kernel daemon...
       ...done.
     * Exporting directories for NFS kernel daemon...
       ...done.
     * Starting NFS kernel daemon
       ...done.
    

    This is the other error log. There is two, one for the new version which i posted below, and one for the old version which is posted here.


  • Developer

    @K-Hays What do you see in the last 20 lines of the install logs (/path/to/checked/out/fogproject/bin/error_log/…)??



  • @Wayne-Workman This is what the actual install says

     * Here are the settings FOG will use:
     * Base Linux: Debian
     * Detected Linux Distribution: Ubuntu
     * Server IP Address: 10.40.0.7
     * Server Subnet Mask: Error: c is not recognized
     * Interface: eth0
     * Installation Type: Normal Server
     * Donate: 0
     * Internationalization: 0
     * Image Storage Location: /images
     * Using FOG DHCP: No
     * DHCP will NOT be setup but you must setup your
     | current DHCP server to use FOG for PXE services.
    
     * On a Linux DHCP server you must set: next-server and filename
    
     * On a Windows DHCP server you must set options 066 and 067
    
     * Option 066/next-server is the IP of the FOG Server: (e.g. 10.40.0.7)
     * Option 067/filename is the bootfile: (e.g. undionly.kpxe)
    
    
     * Are you sure you wish to continue (Y/N) 
     * Installation Started
    
     * Installing required packages, if this fails
     | make sure you have an active internet connection.
    
     * Adding needed repository....................................OK
     * Preparing Package Manager...................................OK
     * Packages to be installed:
    
    	apache2 build-essential cpp curl g++ gcc gzip htmldoc lftp libapache2-mod-php5 libc6 libcurl3 m4 mysql-client mysql-server net-tools nfs-kernel-server openssh-server php5 php5-bcmath php5-cli php5-curl php5-fpm php5-gd php5-json php5-mcrypt php5-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa vsftpd wget xinetd zlib1g 
    
    
     * Skipping package: apache2...................................(Already Installed)
     * Skipping package: build-essential...........................(Already Installed)
     * Skipping package: cpp.......................................(Already Installed)
     * Skipping package: curl......................................(Already Installed)
     * Skipping package: g++.......................................(Already Installed)
     * Skipping package: gcc.......................................(Already Installed)
     * Skipping package: gzip......................................(Already Installed)
     * Skipping package: htmldoc...................................(Already Installed)
     * Skipping package: lftp......................................(Already Installed)
     * Skipping package: libapache2-mod-php5.......................(Already Installed)
     * Skipping package: libc6.....................................(Already Installed)
     * Skipping package: libcurl3..................................(Already Installed)
     * Skipping package: m4........................................(Already Installed)
     * Skipping package: mysql-client..............................(Already Installed)
     * Skipping package: mysql-server..............................(Already Installed)
     * Skipping package: net-tools.................................(Already Installed)
     * Skipping package: nfs-kernel-server.........................(Already Installed)
     * Skipping package: openssh-server............................(Already Installed)
     * Skipping package: php5......................................(Already Installed)
     * Skipping package: php5-bcmath...............................(Does not exist)
     * Skipping package: php5-cli..................................(Already Installed)
     * Skipping package: php5-curl.................................(Already Installed)
     * Skipping package: php5-fpm..................................(Already Installed)
     * Skipping package: php5-gd...................................(Already Installed)
     * Skipping package: php5-json.................................(Already Installed)
     * Skipping package: php5-mcrypt...............................(Already Installed)
     * Skipping package: php5-mysqlnd..............................(Already Installed)
     * Skipping package: php-gettext...............................(Already Installed)
     * Skipping package: sysv-rc-conf..............................(Already Installed)
     * Skipping package: tar.......................................(Already Installed)
     * Skipping package: tftpd-hpa.................................(Already Installed)
     * Skipping package: tftp-hpa..................................(Already Installed)
     * Skipping package: vsftpd....................................(Already Installed)
     * Skipping package: wget......................................(Already Installed)
     * Skipping package: xinetd....................................(Already Installed)
     * Skipping package: zlib1g....................................(Already Installed)
     * Updating packages as needed.................................OK
    
     * Confirming package installation
    
     * Checking package: apache2...................................OK
     * Checking package: build-essential...........................OK
     * Checking package: cpp.......................................OK
     * Checking package: curl......................................OK
     * Checking package: g++.......................................OK
     * Checking package: gcc.......................................OK
     * Checking package: gzip......................................OK
     * Checking package: htmldoc...................................OK
     * Checking package: lftp......................................OK
     * Checking package: libapache2-mod-php5.......................OK
     * Checking package: libc6.....................................OK
     * Checking package: libcurl3..................................OK
     * Checking package: m4........................................OK
     * Checking package: mysql-client..............................OK
     * Checking package: mysql-server..............................OK
     * Checking package: net-tools.................................OK
     * Checking package: nfs-kernel-server.........................OK
     * Checking package: openssh-server............................OK
     * Checking package: php5......................................OK
     * Checking package: php5-cli..................................OK
     * Checking package: php5-curl.................................OK
     * Checking package: php5-fpm..................................OK
     * Checking package: php5-gd...................................OK
     * Checking package: php5-json.................................OK
     * Checking package: php5-mcrypt...............................OK
     * Checking package: php5-mysqlnd..............................OK
     * Checking package: php-gettext...............................OK
     * Checking package: sysv-rc-conf..............................OK
     * Checking package: tar.......................................OK
     * Checking package: tftpd-hpa.................................OK
     * Checking package: tftp-hpa..................................OK
     * Checking package: vsftpd....................................OK
     * Checking package: wget......................................OK
     * Checking package: xinetd....................................OK
     * Checking package: zlib1g....................................OK
    
     * Configuring services
    
     * Setting up fog user.........................................Already setup
     * Setting up fog password.....................................OK
     * Stopping FOGMulticastManager Service........................OK
     * Stopping FOGImageReplicator Service.........................OK
     * Stopping FOGSnapinReplicator Service........................OK
     * Stopping FOGScheduler Service...............................OK
     * Stopping FOGPingHosts Service...............................OK
     * Setting up and starting MySQL...............................OK
     * Backing up user reports.....................................Done
     * Stopping web service........................................OK
     * Removing vhost file.........................................OK
     * Is the MySQL password blank? (Y/n)  * Enter the MySQL password: 
     * Re-enter the MySQL password: 
    mysql  Ver 14.14 Distrib 5.5.50, for debian-linux-gnu (i686) using readline 6.3
    Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Usage: mysql [OPTIONS] [database]
      -?, --help          Display this help and exit.
      -I, --help          Synonym for -?
      --auto-rehash       Enable automatic rehashing. One doesn't need to use
                          'rehash' to get table and field completion, but startup
                          and reconnecting may take a longer time. Disable with
                          --disable-auto-rehash.
                          (Defaults to on; use --skip-auto-rehash to disable.)
      -A, --no-auto-rehash 
                          No automatic rehashing. One has to use 'rehash' to get
                          table and field completion. This gives a quicker start of
                          mysql and disables rehashing on reconnect.
      --auto-vertical-output 
                          Automatically switch to vertical output mode if the
                          result is wider than the terminal width.
      -B, --batch         Don't use history file. Disable interactive behavior.
                          (Enables --silent.)
      --character-sets-dir=name 
                          Directory for character set files.
      --column-type-info  Display column type information.
      -c, --comments      Preserve comments. Send comments to the server. The
                          default is --skip-comments (discard comments), enable
                          with --comments.
      -C, --compress      Use compression in server/client protocol.
      -#, --debug[=#]     This is a non-debug version. Catch this and exit.
      --debug-check       Check memory and open file usage at exit.
      -T, --debug-info    Print some debug info at exit.
      -D, --database=name Database to use.
      --default-character-set=name 
                          Set the default character set.
      --delimiter=name    Delimiter to be used.
      --enable-cleartext-plugin 
                          Enable/disable the clear text authentication plugin.
      -e, --execute=name  Execute command and quit. (Disables --force and history
                          file.)
      -E, --vertical      Print the output of a query (rows) vertically.
      -f, --force         Continue even if we get an SQL error.
      -G, --named-commands 
                          Enable named commands. Named commands mean this program's
                          internal commands; see mysql> help . When enabled, the
                          named commands can be used from any line of the query,
                          otherwise only from the first line, before an enter.
                          Disable with --disable-named-commands. This option is
                          disabled by default.
      -i, --ignore-spaces Ignore space after function names.
      --init-command=name SQL Command to execute when connecting to MySQL server.
                          Will automatically be re-executed when reconnecting.
      --local-infile      Enable/disable LOAD DATA LOCAL INFILE.
      -b, --no-beep       Turn off beep on error.
      -h, --host=name     Connect to host.
      -H, --html          Produce HTML output.
      -X, --xml           Produce XML output.
      --line-numbers      Write line numbers for errors.
                          (Defaults to on; use --skip-line-numbers to disable.)
      -L, --skip-line-numbers 
                          Don't write line number for errors.
      -n, --unbuffered    Flush buffer after each query.
      --column-names      Write column names in results.
                          (Defaults to on; use --skip-column-names to disable.)
      -N, --skip-column-names 
                          Don't write column names in results.
      --sigint-ignore     Ignore SIGINT (CTRL-C).
      -o, --one-database  Ignore statements except those that occur while the
                          default database is the one named at the command line.
      --pager[=name]      Pager to use to display results. If you don't supply an
                          option, the default pager is taken from your ENV variable
                          PAGER. Valid pagers are less, more, cat [> filename],
                          etc. See interactive help (\h) also. This option does not
                          work in batch mode. Disable with --disable-pager. This
                          option is disabled by default.
      -p, --password[=name] 
                          Password to use when connecting to server. If password is
                          not given it's asked from the tty.
      -P, --port=#        Port number to use for connection or 0 for default to, in
                          order of preference, my.cnf, $MYSQL_TCP_PORT,
                          /etc/services, built-in default (3306).
      --prompt=name       Set the mysql prompt to this value.
      --protocol=name     The protocol to use for connection (tcp, socket, pipe,
                          memory).
      -q, --quick         Don't cache result, print it row by row. This may slow
                          down the server if the output is suspended. Doesn't use
                          history file.
      -r, --raw           Write fields without conversion. Used with --batch.
      --reconnect         Reconnect if the connection is lost. Disable with
                          --disable-reconnect. This option is enabled by default.
                          (Defaults to on; use --skip-reconnect to disable.)
      -s, --silent        Be more silent. Print results with a tab as separator,
                          each row on new line.
      -S, --socket=name   The socket file to use for connection.
      --ssl               Enable SSL for connection (automatically enabled with
                          other flags).
      --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies
                          --ssl).
      --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl).
      --ssl-cert=name     X509 cert in PEM format (implies --ssl).
      --ssl-cipher=name   SSL cipher to use (implies --ssl).
      --ssl-key=name      X509 key in PEM format (implies --ssl).
      --ssl-verify-server-cert 
                          Verify server's "Common Name" in its cert against
                          hostname used when connecting. This option is disabled by
                          default.
      --ssl-mode=name     SSL connection mode.
      -t, --table         Output in table format.
      --tee=name          Append everything into outfile. See interactive help (\h)
                          also. Does not work in batch mode. Disable with
                          --disable-tee. This option is disabled by default.
      -u, --user=name     User for login if not current user.
      -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
      -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.
      -v, --verbose       Write more. (-v -v -v gives the table output format).
      -V, --version       Output version information and exit.
      -w, --wait          Wait and retry if connection is down.
      --connect-timeout=# Number of seconds before connection timeout.
      --max-allowed-packet=# 
                          The maximum packet length to send to or receive from
                          server.
      --net-buffer-length=# 
                          The buffer size for TCP/IP and socket communication.
      --select-limit=#    Automatic limit for SELECT when using --safe-updates.
      --max-join-size=#   Automatic limit for rows in a join when using
                          --safe-updates.
      --secure-auth       Refuse client connecting to server if it uses old
                          (pre-4.1.1) protocol.
      --server-arg=name   Send embedded server this as a parameter.
      --show-warnings     Show warnings after every statement.
      --plugin-dir=name   Directory for client-side plugins.
      --default-auth=name Default authentication client-side plugin to use.
    
    Default options are read from the following files in the given order:
    /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf 
    The following groups are read: mysql client
    The following options may be given as the first argument:
    --print-defaults        Print the program argument list and exit.
    --no-defaults           Don't read default options from any option file.
    --defaults-file=#       Only read default options from the given file #.
    --defaults-extra-file=# Read this file after the global files are read.
    
    Variables (--variable-name=value)
    and boolean options {FALSE|TRUE}  Value (after reading options)
    --------------------------------- ----------------------------------------
    auto-rehash                       TRUE
    auto-vertical-output              FALSE
    character-sets-dir                (No default value)
    column-type-info                  FALSE
    comments                          FALSE
    compress                          FALSE
    debug-check                       FALSE
    debug-info                        FALSE
    database                          (No default value)
    default-character-set             auto
    delimiter                         ;
    enable-cleartext-plugin           FALSE
    vertical                          FALSE
    force                             FALSE
    named-commands                    FALSE
    ignore-spaces                     FALSE
    init-command                      (No default value)
    local-infile                      FALSE
    no-beep                           FALSE
    host                              fog
    html                              FALSE
    xml                               FALSE
    line-numbers                      TRUE
    unbuffered                        FALSE
    column-names                      FALSE
    sigint-ignore                     FALSE
    port                              3306
    prompt                            mysql> 
    quick                             FALSE
    raw                               FALSE
    reconnect                         FALSE
    socket                            /var/run/mysqld/mysqld.sock
    ssl                               FALSE
    ssl-ca                            (No default value)
    ssl-capath                        (No default value)
    ssl-cert                          (No default value)
    ssl-cipher                        (No default value)
    ssl-key                           (No default value)
    ssl-verify-server-cert            FALSE
    table                             FALSE
    user                              fog
    safe-updates                      FALSE
    i-am-a-dummy                      FALSE
    connect-timeout                   0
    max-allowed-packet                16777216
    net-buffer-length                 16384
    select-limit                      1000
    max-join-size                     1000000
    secure-auth                       FALSE
    show-warnings                     FALSE
    plugin-dir                        (No default value)
    default-auth                      (No default value)
     * Setting up Apache and PHP files.............................OK
     * Testing and removing symbolic links if found................OK
     * Backing up old data.........................................OK
     * Copying back old web folder as is...........................OK
     * Ensuring all classes are lowercased.........................OK
     * Copying new files to web folder.............................OK
     * Creating config file........................................OK
     * Getting checksum files for kernels and inits................OK
     * Downloading inits, kernels, and the fog client..............OK
     * Comparing checksums of kernels and inits....................Done
     * Enabling apache and fpm services on boot....................OK
     * Creating SSL Certificate....................................OK
     * Creating auth pub key and cert..............................OK
     * Resetting SSL Permissions...................................OK
     * Setting up SSL FOG Server...................................OK
     * Restarting Apache2 for fog vhost............................OK
     * Changing permissions on apache log files....................OK
     * Backing up database.........................................Failed!
    

Log in to reply
 

343
Online

38751
Users

10577
Topics

100136
Posts

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