Problem after update
-
ok problem as come back…
[SIZE=6][B]Database Schema Installer / Updater again…[/B][/SIZE]
-
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]
-
[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.
-
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=“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?
-
Here you go…
thank you!
[url=“/_imported_xf_attachments/1/1088_foginstall.zip?:”]foginstall.zip[/url]
-
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?
-
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? -
Here is the installation log file after a re-install.
[url=“/_imported_xf_attachments/1/1090_foginstall.zip?:”]foginstall.zip[/url]
-
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 -
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?
-
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]
-
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.
-
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]
-
I also do no see the line (net-device-up IFACE=ethX)", inside the mysql.conf
-
I’d ass in my.cnf --service-startup-timeout=900 to see if that helps you out.
-
just at the bottom of the config file?
-
[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.
-
to the bottom of the my.cnf file?
-
[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 007pre-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 scriptexec /usr/sbin/mysqld
post-start script
for i inseq 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]
