Problem after update

[Pascal Gazaille]

Hi,
I’ve update from 1.1.0 to 1.1.2, I seem to have a problem with the installation.

If I reboot my ubuntu, I have to do the reinstall because I can’t go in the web interface.
I have this :

[SIZE=6][B]Database Schema Installer / Updater[/B][/SIZE]

Your FOG database schema is not up to date, either because you have updated FOG or this is a new FOG installation. If this is a upgrade, we highly recommend that you backup your FOG database before updating the schema (this will allow you to return the previous installed version).
If you would like to backup your FOG database you can do so my using MySql Administrator or by running the following command in a terminal window (Applications -> System Tools -> Terminal), this will save sqldump in your home directory.
cd ~;mysqldump --allow-keywords -x -v fog > fogbackup.sql
Are you sure you wish to install/update the FOG database?

This seems to come back after a ubuntu reboot.

Any Idea?

[Fhajad]

If you update does it go away just for that time while it’s up then require an update again after a reboot?

[braindead]

I was able to resolve this problem by following Tom’s suggestion [URL=‘http://fogproject.org/forum/threads/fog-1-1-2-released.10938/’]here[/URL].

It’s basically edit this setting to be blank:

[CODE]snmysqlpass=“”[/CODE]

in /opt/fog/.fogsettings

Modify that setting, then reinstall the update.

[Pascal Gazaille]

I’ve rebooted, I had a message asking to check the disk.
I’ve let it done it’s job and once up my web interface seems ok.

rebooted another time, seems ok now…
Going to check if it comes back!

[Pascal Gazaille]

ok problem as come back…

[SIZE=6][B]Database Schema Installer / Updater again…[/B][/SIZE]

[Pascal Gazaille]

When I try to do the installation, I have the error in the txt file.

I’ve updated the my information in the /opt/fog/.fogsettings

[url=“/_imported_xf_attachments/1/1084_Database_Error.txt?:”]Database_Error.txt[/url]

[braindead]

[quote=“Pascal Gazaille, post: 31675, member: 21659”]When I try to do the installation, I have the error in the txt file.

I’ve updated the my information in the /opt/fog/.fogsettings[/quote]

I had the same errors, but modified the [CODE]snmysqlpass=“”[/CODE] to blank, then reinstalled.

Did you run the FOG install script after that?

Also, there’s a point during the install script to update the DB, then you hit enter afterwards. Try that.

[drenj19]

I have the same issue listed above… but I cannot find /opt/fog/.fogsettings in order to apply the suggested fix above.
I’m new to Ubuntu, I cannont find the “.fogsettings” under /opt/fog. what am I missing?

AM.

[Tom Elliott]

[quote=“drenj19, post: 31784, member: 24855”]I have the same issue listed above… but I cannot find /opt/fog/.fogsettings in order to apply the suggested fix above.
I’m new to Ubuntu, I cannont find the “.fogsettings” under /opt/fog. what am I missing?

AM.[/quote]

Your system sounds like it hasn’t properly installed FOG. Can you provide the /var/log/foginstall.log file?

[drenj19]

Here you go…

thank you!

[url=“/_imported_xf_attachments/1/1088_foginstall.zip?:”]foginstall.zip[/url]

[Tom Elliott]

It looks like this isn’t the complete log. It’s stopped at the installing htmldoc and there isn’t any more information.

Was/is there an error if you try to re-run the installer?

[drenj19]

no, the install appears to run without a glitch. I’ve done this several times, even going as far as reloading Ubuntu.
any other suggestions?

[drenj19]

Here is the installation log file after a re-install.

[url=“/_imported_xf_attachments/1/1090_foginstall.zip?:”]foginstall.zip[/url]

[drenj19]

After doing more testing I find that restarting the MySQL daemon temporarily fixes the issue until the next reboot.
sudo service mysql stop
sudo service mysql start

[drenj19]

so… my issue is definitely related to MySQL and not the password in the ./fogsettings file.
after a Ubuntu restart, the for website will run for a minute or so before displaying the [SIZE=6][B]Database Schema Installer / Updater again…[/B][/SIZE] .

manually restarting MySQL temporarily fixes the issue until the next reboot… any suggestions?

[Fhajad]

Sounds like MySQL isn’t waiting to connect and just fails on startup. Ubuntu does weird things in the sake of “speeding up startup”.

Check in your my.cnf for MySQL what “[FONT=Helvetica][COLOR=#000000][SIZE=14px]–service-startup-timeout” is set to.[/SIZE][/COLOR][/FONT]

[Jaymes Driver]

Add the start condition in /etc/init/mysql.conf to"start on (net-device-up IFACE=ethX)", where “X” is the interface you have mysql bound to, e.g. ETH0, usually the same port FOG is using.

We used this similar command to help with start up problems in Ubuntu 12.04 for tftpd-hpa service, it might help here as well.

This of course doesn’t solve the issue but may help alleviate the need to type the command on each reboot.

[drenj19]

I don’t see "[FONT=Helvetica][COLOR=#000000][SIZE=14px]–service-startup-timeout inside the my.cnf file… again, just to reiterate, it does appear that MySQL starts and then crashes. after that restarting MySQL allows me use the fog management website.[/SIZE][/COLOR][/FONT]

[FONT=Helvetica][COLOR=#000000][SIZE=14px]is there a way to script the restart of the mysql service after 120 secs after boot?[/SIZE][/COLOR][/FONT]

[drenj19]

I also do no see the line (net-device-up IFACE=ethX)", inside the mysql.conf

[Fhajad]

I’d ass in my.cnf --service-startup-timeout=900 to see if that helps you out.