Backing up database... failed!

  • Server
    • 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: for my initial problem, but that hasn’t helped.

    I have both commented out the two lines referred here: and tried making the snmysqlhost blank, but that has not worked.

    Another forum thread ( 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 ‘’ throws “Operation ALTER USER failed for ‘root’@‘’”

    UPDATE: Configured /etc/wgetrc with:

    https_proxy =
    http_proxy =
    ftp_proxy =
    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, Username: fogstorage

  • Moderator

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

    UPDATE: Configured /etc/wgetrc with:
    https_proxy =
    http_proxy =
    ftp_proxy =

    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=,<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:

    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.