Fog 1.2 under Ubuntu 14.04 LTS install/upgrade DB schema error
I am a newbie to fog server so please bear with me as I am not that familar with unix/linux commands. I was able to install FOG 1.2.0 under Ubuntu 14.04 LTS through some tutorials you guys posted. I was able to upload and download images as well without any problems. Since I was running out of space, I tried to increase the virtual disk space (thru vmware). But when I tried to go to my fog web console, I received the notification saying my database schema is not updated. I tried to click on the Install/Upgrade but got multiple errors. (Update ID reached all the way to 113 with errors.
How do I try to fix this without re-installing the whole thing since I already uploaded multiple images to fog? When I try to run the command to backup the database from the ubuntu’s terminal, I get error 2002: can’t connect to local MySQL server through socket ‘var/run/mysqld/mysqld.sock’ (111) when trying to connect. My default MySQL password was blank. I tried to locate the said file on /var/run/mysqld and I can see it inside.
Any help would be greatly appreciated.
@greenfog @dylan This has been in our Wiki for quite a while: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL
You are a lifesaver and this just made my day. Thank you very much for pointing me to that forum.
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.
would it be possible to simply re-install MySQL without affecting the images I was able to successfully upload the first time?
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% /boot
Mod edited to use code box.
@greenfog is the file system full?
I used the same command as what you typed in and it kept on saying failed after a few seconds
@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
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)
Also make sure the password for mysql is correct.