Database Schema Installer / Updater

[Danny R]

Reinstalled FOG yesterday was working fine. I shut the machine down last night. Put it into our rack and booted it backup. Tried to get into it this morning and I’m getting

Database Schema Installer / Updater

If I click Install / Upgrade now it just gives tons of SQL errors. The list goes on and on here is one error for example.

Update ID: 1 - 1

Database Error:

Database SQL:

CREATE TABLE fog.groupMembers (
gmID int(11) NOT NULL auto_increment,
gmHostID int(11) NOT NULL,
gmGroupID int(11) NOT NULL,
PRIMARY KEY (gmID),
KEY new_index (gmHostID),
KEY new_index1 (gmGroupID)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

It ends at Update ID: 113-0

[ch3i]

@Danny-R Which FOG version ?

[Wayne Workman]

Sounds like MySQL (or MariaDB) didn’t start up…

What OS version?

[Danny R]

@ch3i said:

@Danny-R Wich FOG version ?

FOG 1.2.0

[Danny R]

@Wayne-Workman Ubuntu 14.04

[ch3i]

@Danny-R Try on your Ubuntu :

service mysql status | grep "Uptime"

And post the result please.

[Tom Elliott]

This issue is well known about particularly on Ubuntu. It isn’t so much the service failed to start, but rather the service crashed later on down the road.

[Wayne Workman]

@Danny-R So, in this situation, you should just be able to restart MySQL…

service mysql restart

[Danny R]

@ch3i That command did not work however a SQL restart resolved the issue.

Thanks,

[Danny R]

@Wayne-Workman

That did it thanks!

[Tom Elliott]

@Danny-R

To prevent this from happening down the road, you could try following these instructions:
https://github.com/fogproject/fogproject/issues/1