My FOG 1.1.0 broken - Please help

[Achieve94]

No, I’m afraid.

I tried doing a re-install - with a view of correcting the problem but when I try to upgrade via the web UI; I get the following error on the web browser.

The error was very long, abt 87 pages on a Word doc. I’ve only shown some here.

Any ideas please?

Thanks.
[SIZE=6][B]Database Schema Installer / Updater[/B][/SIZE]

Update/Install Failed!
[SIZE=5][B]The following errors occured[/B][/SIZE]

[B]Update ID:[/B] 1 - 0
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE DATABASE fog

[B]Update ID:[/B] 1 - 1
[B]Database Error:[/B]

[B]Database SQL:[/B]
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

[B]Update ID:[/B] 1 - 2
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE TABLE fog.groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(50) NOT NULL,
groupDesc longtext NOT NULL,
groupDateTime datetime NOT NULL,
groupCreateBy varchar(50) NOT NULL,
groupBuilding int(11) NOT NULL,
PRIMARY KEY (groupID),
KEY new_index (groupName)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

[Tom Elliott]

Sounds like the database is not running to me?

Try:
[code]service mysql restart[/code]
or
[code]sudo service mysql restart[/code]

[Achieve94]

I’ve restarted the database; still not working.

Just in case, I’ve now set a password to MySQL during re-install - which I previously left blank. Is there any way I can make FOG use this new password?

Thanks.

[Tom Elliott]

Edit the /var/www/fog/commons/config.php and set the PASSWORD in db_settings.

[Achieve94]

Just checked, the password has already being set there by the installer but can’t perform the schema upgrade via the web UI still.

Thanks.

[Tom Elliott]

so in your /var/www/fog/commons/config.php file, the password is already set? Is the host set correctly as well?

[Achieve94]

Yes the password was set by the installer after I ran the re-install. The host is set as ‘localhost’.

Thanks.

[Tom Elliott]

I’m going to guess, then that everything is correct and you could actually login to the mysql instance. What happens if you change localhost to the actual FOG Server’s IP address?

[Achieve94]

I’ve changed the ‘localhost’ to the server’s IP address and restarted MySQL but still didn’t resolve the issue.

Is there a way I can test MySQL login via Terminal to see if it prompts me for the credentials?

Thanks.

[Tom Elliott]

[code]mysql -u root fog[/code]

Does it let you into the database?

[Achieve94]

Typed that in and it took me straight to MySQL> prompt. There was no prompt for credentials.

Thanks.

[Tom Elliott]

So remove the password from the db_settings field.

[Achieve94]

Yes.

[Achieve94]

Password removed.

Thanks.

[Tom Elliott]

Are things working now?

[Achieve94]

No I’m afraid, still not working.
Seems a strange problem.

[Achieve94]

This is the prompt I got with or without MySQL password in Config.php when I typed “MySQL -u root fog” command at the Terminal…

[url=“/_imported_xf_attachments/0/996_FOG2.jpg?:”]FOG2.jpg[/url]

[Achieve94]

And this is the issue as reported in web UI…

[url=“/_imported_xf_attachments/0/997_FOGISSUE.jpg?:”]FOGISSUE.jpg[/url]

[Tom Elliott]

What that means is you don’t have a root password set for mysql.
If you had a password set to the mysql server and typed in the mysql -u root fog, the terminal would’ve spit out:
[code]ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)[/code]

Mysql doesn’t run because of the /var/www/fog/commons/config.php file. It runs on it’s own.

You can set a password for mysql but I would recommend against it. When the installer is asking you if you left the mysql password blank either hit enter your type Y and press enter.

[Achieve94]

OK, I can re-run the installer again; then this time leaving MySQL password blank.

Thanks