Backing up database... failed!



  • 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: http://i.imgur.com/dx2Lanw.png
    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


  • Moderator

    @Benjamin_D said in Backing up database... failed!:

    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”

    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.


  • Moderator

    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.


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.