My FOG 1.1.0 broken - Please help
-
Sounds like the database is not running to me?
Try:
[code]service mysql restart[/code]
or
[code]sudo service mysql restart[/code] -
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.
-
Edit the /var/www/fog/commons/config.php and set the PASSWORD in db_settings.
-
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.
-
so in your /var/www/fog/commons/config.php file, the password is already set? Is the host set correctly as well?
-
Yes the password was set by the installer after I ran the re-install. The host is set as ‘localhost’.
Thanks.
-
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?
-
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.
-
[code]mysql -u root fog[/code]
Does it let you into the database?
-
Typed that in and it took me straight to MySQL> prompt. There was no prompt for credentials.
Thanks.
-
So remove the password from the db_settings field.
-
Yes.
-
Password removed.
Thanks.
-
Are things working now?
-
No I’m afraid, still not working.
Seems a strange problem. -
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]
-
And this is the issue as reported in web UI…
[url=“/_imported_xf_attachments/0/997_FOGISSUE.jpg?:”]FOGISSUE.jpg[/url]
-
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.
-
OK, I can re-run the installer again; then this time leaving MySQL password blank.
Thanks
-
Hello,
I’ve now ran the installer again this time leaving the MySQL password blank. However, I can’t still login to the FOG web UI with the default login “fog” and “password” that I’ve always used.
This is happening when I try to login to the web UI on the FOG server itself and from a client PC.
Any ideas?
Thanks.
