Solved Database update Fails
-
I just upgraded my fog version from .32 to 1.2.0 and I got to the point where I needed to update my database schema so when I went to the link in the terminal and pressed the link to update I received the error that the install/update failed with lots of errors. What can I do from here? I did not back up my database…yes I know stupid on me. Am I just going to have to do a full reinstall of fog and start over on everything?
-
The errors are non-impacting.
Go ahead and try it out. It’s most likely fine.
-
Ok I did press enter and finished in the terminal and went to try logging back into fog and still get the “Database schema installer/updater” page
-
@the_duke said:
installer/updater” page
Try restarting the mysql service.
On RHEL/Fedora/CentOS it’s something like
[CODE]systemctl restart mysqld.service[/CODE]Don’t remember what it is for Ubuntu…
-
Oh and what distro are you running?
Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
Daily Clean Installation Results:
https://fogtesting.fogproject.us/
FOG Reporting:
https://fog-external-reporting-results.fogproject.us/ -
Ran “sudo service mysql stop” then ran “sudo service mysql start” and still the same page
-
@Wayne-Workman said:
Oh and what distro are you running?
-
ubuntu 12.04
-
Can you update your OS to the latest patches and then try to re-install FOG?
-
@Wayne-Workman I uninstalled mysql and reinstalled it like you originally said. Now when i try to reinstall fog it gets to the checking package php5-mysql…failed
-
@the_duke then just uninstall that and re-install…
Should be something like this:
[CODE]apt-get remove php5-mysql
apt-get install php5-mysql[/CODE] -
@Wayne-Workman Ok it is now back to working just like it should. Thanks Wayne
-
@Wayne-Workman One other thing, I know in version .32 when you had to chose the operating system for the image we had to chose xp for any windows 7 system. Has this issue been corrected in the latest version?
-
@the_duke For Windows 7, choose Windows 7
-
@ch3i Ok thanks
-
Glad to see you got it working. Glad reinstalling that worked!
I love it when the “first-instincts” work…
Because when they don’t, then the troubleshooting fiasco starts and who knows where that will go and if I have the expertise to keep up lol.
-
@Wayne-Workman Ok when I try to upload a new image, I go to preform full registration and it goes to a black screen with a blinking cursor. Also when I am on the host management page, I can only access the delete link from the host menu. I can’t search for a specific host, it just comes up with a “searching error, please try again”, so I have to list all host and find it there. I tried to upload another image to a currently registered host and I had to hit the upload arrow in the host search screen. After booting to network it would boot to ipxe and acted like it was connecting then loop back to the computers boot menu. Any ideas.
-
Hey Duke, I am in a school district like you and came across the same problem. I tried all your steps and was not able to get FOG to work. At the moment every time I try to log on to FOG it asks to install the database, then I get 113 errors. If you could shed some light on anything else you may have done it would be greatly appreciated.
-
@Clifford-Raymond Hi, please create a new topic (The “Database update Fails” is solved) with your problem and your FOG configuration (OS, FOG version, …)
