Fog 1.2 under Ubuntu 14.04 LTS install/upgrade DB schema error
-
@greenfog https://github.com/FOGProject/fogproject/issues/1
Also make sure the password for mysql is correct.
-
thanks for the tip. MySQL password was left blank when I installed it initially and haven’t changed it so I’m not sure how to make the password for mysql correct or synchronized. When I tried to restart Mysql service, I got a failure in service start. I was able to backup and copy the ib_logfiles but when I tried to restart mysql, (unknown job/instance)
-
@greenfog how did you restart MySQL? I notice this on Ubuntu occasionally and the fix for that is to use:
service mysql stop service mysql start -
I used the same command as what you typed in and it kept on saying failed after a few seconds
-
@greenfog is the file system full?
df -h -
still some space left
Filesystem Size Used Avail Use% Mounted on /dev/mapper/ubuntu--vg-root 98G 81G 13G 87% / none 4.0K 0 4.0k 0% /sys/fs/cgroup udev 486M 4.0K 486M 1% /dev tmpfs 100M 1.2M 99M 2% /run none 5.0M 0 5.0M 0% /run/lock none 497M 152K 497M 1% /run/shm none 100M 44K 100M 1% /run/user /dev/sda1 236M 38M 186M 17% /bootMod edited to use code box.
-
would it be possible to simply re-install MySQL without affecting the images I was able to successfully upload the first time?
-
Think I had a similar issue with this the other day on my first restart.
I followed this thread - https://community.spiceworks.com/topic/564935-fog-database-error - the 3rd post by the user “aboushard” fixed the issue I was having.
Assuming you’ve probably found a way around this by now/given up on it though, but the above worked for me if you’re still having issues with that.
-
You are a lifesaver and this just made my day. Thank you very much for pointing me to that forum.
@dylan -
@greenfog @dylan This has been in our Wiki for quite a while: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL
