Problem updating fog: Backing up Database ... failed

[K.Hays]

Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully
 * Stopping FOG Computer Imaging Solution: FOGMulticastManager
start-stop-daemon: warning: failed to kill 7822: No such process
   ...done.
 * Stopping FOG Computer Imaging Solution: FOGImageReplicator
start-stop-daemon: warning: failed to kill 7862: No such process
   ...done.
 * Stopping FOG Computer Imaging Solution: FOGSnapinReplicator
   ...done.
 * Stopping FOG Computer Imaging Solution: FOGScheduler
   ...done.
 * Stopping FOG Computer Imaging Solution: FOGPingHosts
   ...done.
mysql stop/waiting
mysql start/running, process 9015
 * Stopping web server apache2
 * 
php5-fpm stop/waiting
Site 001-fog disabled.
To activate the new configuration, you need to run:
  service apache2 reload
mysqlnd
mcrypt
Signature ok
subject=/CN=10.40.0.7
Getting CA Private Key
ln: failed to create symbolic link ‘/var/www/fog/fog’: File exists
Module php5 already enabled
Module rewrite already enabled
Considering dependency setenvif for ssl:
Module setenvif already enabled
Considering dependency mime for ssl:
Module mime already enabled
Considering dependency socache_shmcb for ssl:
Module socache_shmcb already enabled
Module ssl already enabled
Enabling site 001-fog.
To activate the new configuration, you need to run:
  service apache2 reload
 * Stopping web server apache2
 * 
 * Starting web server apache2
 * 
stop: Unknown instance: 
php5-fpm start/running, process 9461
 * apache2 is running
php5-fpm start/running, process 9461
--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.

Mod edited to use code box.

[Wayne Workman]

@K.Hays Does your DB have a password? Are you running the installer as root? If so, how do you become root exactly?

[K.Hays]

@Wayne-Workman I believe so

[Wayne Workman]

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

@Wayne-Workman I believe so

Doublecheck that this username/password is correct inside /opt/fog/.fogsettings
They are listed as snmysqluser and snmysqlpass and snmysqlhost

[K.Hays]

@Wayne-Workman so should the mysql name and password be the same as my database name and password?

[K.Hays]

@Wayne-Workman Also i am running as root, by “sudo -i” or running the command with just “sudo” in front

[K.Hays]

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

[Sebastian Roth]

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

[K.Hays]

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

[K.Hays]

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

[Quazz]

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

[K.Hays]

This post is deleted!

[K.Hays]

This post is deleted!

[Sebastian Roth]

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

[K.Hays]

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

[Wayne Workman]

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

[K.Hays]

@Wayne-Workman it said unknown host

[Wayne Workman]

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

[K.Hays]

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

[Wayne Workman]

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