Database update Fails

[Wayne Workman]

The errors are non-impacting.

Go ahead and try it out. It’s most likely fine.

[the_duke]

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

[Wayne Workman]

@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…

[Wayne Workman]

Oh and what distro are you running?

[the_duke]

Ran “sudo service mysql stop” then ran “sudo service mysql start” and still the same page

[Wayne Workman]

@Wayne-Workman said:

Oh and what distro are you running?

[the_duke]

ubuntu 12.04

[Wayne Workman]

Can you update your OS to the latest patches and then try to re-install FOG?

[the_duke]

@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

[Wayne Workman]

@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]

[the_duke]

@Wayne-Workman Ok it is now back to working just like it should. Thanks Wayne

[the_duke]

@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?

[ch3i]

@the_duke For Windows 7, choose Windows 7

[the_duke]

@ch3i Ok thanks

[Wayne Workman]

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.

[the_duke]

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

[Clifford Raymond]

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.

[ch3i]

@Clifford-Raymond Hi, please create a new topic (The “Database update Fails” is solved) with your problem and your FOG configuration (OS, FOG version, …)