Problem updating fog: Backing up Database ... failed
-
I know there was a post similar to this but I believe his problem had to do with the fact he had a proxy, I do not.
-
Where you cloned the fog repo, can you look inside of
bin/error_logthere will be some files in there, with version numbers on them. Get the latest one and upload it here please. The file contains all the redirected output from the installer, and it’s how we will know what is going wrong. -
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.
-
@K.Hays Does your DB have a password? Are you running the installer as root? If so, how do you become root exactly?
-
@Wayne-Workman I believe so
-
@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 assnmysqluserandsnmysqlpassandsnmysqlhost -
@Wayne-Workman so should the mysql name and password be the same as my database name and password?
-
@Wayne-Workman Also i am running as root, by “sudo -i” or running the command with just “sudo” in front
-
@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! -
@K-Hays What do you see in the last 20 lines of the install logs (/path/to/checked/out/fogproject/bin/error_log/…)??
-
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.
-
@Sebastian-Roth Im currently on Version 7084, and was trying to upgrade to 1.3.0-RC-8.
-
@K.Hays Could you post your /opt/fog/.fogsettings file here?
-
This post is deleted! -
This post is deleted! -
@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/fogand/var/www/fog… -
@Sebastian-Roth That got me further! But when i got to the Updating database schema there is no update option on the web page.
-
@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-pandfoggyis intentional.The
snmysqlhostbeing set tofogis suspicious… normally this is left blank, is set tolocalhostor127.0.0.1for the main server. -
@Wayne-Workman it said unknown host
-
@K.Hays Now try
mysql -u fog -pfoggy -D fog
