Server
- FOG Version: 1.4.3
- OS: Ubuntu 16.04.2 LTS
Description
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.
UPDATE: Tried 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