Backing up database... failed!
- FOG Version: 1.4.3
- OS: Ubuntu 16.04.2 LTS
I am trying to setup a FOG server in an AWS EC2 instance. I got to the point in the install where it was “ensuring that node username and passwords match”, and it just hung there.
I then decided to restart the installer, and ever since then I get to “Backing up database” which fails after a long period of time.
I followed this: https://forums.fogproject.org/topic/10126/ensuring-node-username-and-passwords-match for my initial problem, but that hasn’t helped.
I have both commented out the two lines referred here: https://forums.fogproject.org/topic/8358/problem-updating-fog-backing-up-database-failed/26 and tried making the snmysqlhost blank, but that has not worked.
Another forum thread (https://forums.fogproject.org/topic/6097/backing-up-database-failed) said that the “backing up database” issue may be due to the existence of a proxy server. I use an elastic IP on the EC2 instance, which may be a proxy server, but I’m not sure what syntax to use in the configurations mentioned in the thread.
Other than than FOG works perfectly fine. I successfully imaged a machine at my workplace to a storage node at the work place using tasks issued by the EC2 server. It’s just a matter of getting the database working properly. I was even able to register the host machine via FOG’s Full Host Registration, so it seems as though that part of the database updating is done successfully.
UPDATE: Ran installer for 1.4.4, still did not work.
UPDATE: Apache error log appears to throw this error every time I run the installer:
I have no idea what the “client” IP in that error is referring to, nor do I recognize the IP address.
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;but that didn’t work. Replacing ‘localhost’ with ‘127.0.0.1’ throws “Operation ALTER USER failed for ‘root’@‘127.0.0.1’”
UPDATE: Configured /etc/wgetrc with:
https_proxy = https://172.31.45.41 http_proxy = https://172.31.45.41 ftp_proxy = https://172.31.45.41 use_proxy = on no_proxy = "localhost"
Got to point in install where I had to go to FOG_SERVER_IP/fog/management to update database schema. The prompt didn’t show up to update the schema, so I continued with the install. The install finished, however it still fails to update the database during imaging, throwing the error:
Error returned: Type: 8, File: /var/www/fog/lib/fog/fogcontroller.class.php, Line: 1046, Message: Undefined offset: 3, Host 192.168.10.100, Username: fogstorage
use_proxy = on
no_proxy = “localhost”
You could update your bashrc or what ever the linux profile script is on your OS with
export http_proxy=http://<proxy_ip>:<proxy_port> export https_proxy=http://<proxy_ip>:<proxy_port> export ftp_proxy=http://<proxy_ip>:<proxy_port> export no_proxy=127.0.0.1,<fog_server_ip>
Log out and back in to have these profile settings stick.
I also noted in your example you use https for your proxy, is this a requirement of your proxy server. This is not a standard for proxy servers.
I would recommend deleting that instance, and starting over. This time, follow an installation guide: https://wiki.fogproject.org/wiki/index.php?title=Installation#Installation_manuals
I would recommend CentOS 7 or Debian 8, but use whatever you want.