Problem after update

[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.

[drenj19]

just at the bottom of the config file?

[Jaymes Driver]

[quote=“drenj19, post: 31859, member: 24855”]I also do no see the line (net-device-up IFACE=ethX)", inside the mysql.conf[/quote]

You won’t you add it.

[drenj19]

to the bottom of the my.cnf file?

[Jaymes Driver]

[quote=“drenj19, post: 31880, member: 24855”]to the bottom of the my.cnf file?[/quote]

What version of Ubuntu did you install FOG on if you don’t mind my asking?

No it should be at the top. The start on section:

example
[code]

MySQL Service

description “MySQL Server”
author “Mario Limonciello superm1@ubuntu.com”

start on (net-device-up
and local-filesystems
and runlevel [2345])
stop on runlevel [016]

respawn

env HOME=/etc/mysql
umask 007

pre-start script
#Sanity checks
[ -r $HOME/my.cnf ]
[ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d /var/run/mysqld
# Load AppArmor profile
if aa-status --enabled 2>/dev/null; then
apparmor_parser -r /etc/apparmor.d/usr.sbin.mysqld || true
fi
LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1 | awk ‘{ exit ($4<4096) }’
end script

exec /usr/sbin/mysqld

post-start script
for i in seq 1 30 ; do
/usr/bin/mysqladmin --defaults-file=“${HOME}”/debian.cnf ping && {
exec “${HOME}”/debian-start
# should not reach this line
exit 2
}
sleep 1
done
exit 1
end script[/code]

edit the line
[code]
start on (net-device-up
and local-filesystems
and runlevel [2345])[/code]

to look like

[code]
start on (net-device-up IFACE=eth0
and local-filesystems
and runlevel [2345])[/code]

[drenj19]

James,
Running Ubuntu 14.04.
[I][B][COLOR=#ff0000]Adding the code mentioned above did fix my issue!![/COLOR][/B][/I]
THANK YOU!!!

One last question, in what appears to be my last issue, it looks like I have a chain link issue with my new Dell 9020’s. I’m able to boot to the fog menu but it does not properly boot to the HDD after the timer on the FOG menu expires.

I saw some chain link fixes posted for previous versions of FOG (0.32) do you have any suggestions for a fix on the current 1.1.2 version?

once again thank you for all of your help!!