My FOG 1.1.0 broken - Please help

[Tom Elliott]

Did you set a password on the root account?

It sounds like your FOG user’s password was changed and this is why you’re getting the Login Invalid message.

You can reset the password, somewhere on the forums I’m sure there’s a tagging to on how to reset the fog user password through mysql prompts. I’m pretty sure the password is just md5 hashed in the table.

[Achieve94]

Hi Tom,

Thanks for your response.

No I hadn’t set a password on my root account; certainly not since the upgrade was done on Wednesday.

[Tom Elliott]

Okay

So the code to get into the database would be:
[code]mysql -u root fog[/code]

Then to reset the password should be:
[code]UPDATE fog.users SET uPass = MD5(‘PASSWORDFORFOGWEBGUIUSER’) WHERE users.uName=‘fog’;[/code]

[Tom Elliott]

Of course change the name to the user you’re unable to login as, and change the password to what you want it to be.

[Achieve94]

OK, will try that now and let you know straightaway.

Thanks.

[Achieve94]

Hi Tom,

I’ve tried that now and I’m afraid it hasn’t fixed the issue.

Just in case, I’ve typed the command in within Terminal and changed the ‘PASSWORDFORFOGWEBGUIUSER’ to my desired password. Correct?

The user I wanted to login with was ‘fog’.

Thanks.

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