Problem updating fog: Backing up Database ... failed
-
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 -
@Wayne-Workman Access denied for user ‘fog’@‘localhost’ (using password: YES)
d430@ -
@K.Hays Ok, now try
mysql -u root -D fog
