My FOG 1.1.0 broken - Please help

[Tom Elliott]

when signing in are you type literally ‘fog’ or fog?

I know it seems silly to ask, but one never really knows.

[Achieve94]

Lol…I was typing in fog (without the single quotation marks).

Just to clarify the second line of the command looked like this:

UPDATE fog.users SET uPass = MD5(‘mypassword’) WHERE users.uName=‘fog’;

Thanks.

[Tom Elliott]

So is it working for you now?

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