Fog - Can't access database after install of 12.04
-
I installed the update to 12.04 and after the install completes successfully I get a message “Unable to connect to database”. I was not prompted to install or update the database.
-
I have the same issue on Ubuntu 11.10.
-
That is the error that one usually sees when fog is trying to use the wrong mysql password.
Try opening a terminal window and logging in to the mysql db manually:
[code] sudo mysql -u root -p [/code]
If you get in, check to make sure fog has the correct password in /var/www/fog/commons/config.php. It is the ‘DATABASE_PASSWORD’ variable.–astrouga
-
[quote=“jester805, post: 3575, member: 1167”]I have the same issue on Ubuntu 11.10.[/quote]
It was a problem with the password I had set up for MySQL on the install. I went into /var/www/fog/commons/config.php and set the password for DATABASE_PASSWORD . You need to do it with root credentials - [FONT=Consolas]sudo mysql -u root -p. [/FONT]After changing the password I was able to access fog via [URL=‘http://fog/fog/management’]http://“IP address of server”/fog/management[/URL] -
This post is deleted! -
[quote=“Jay, post: 3580, member: 1085”]It was a problem with the password I had set up for MySQL on the install. I went into /var/www/fog/commons/config.php and set the password for DATABASE_PASSWORD . You need to do it with root credentials - [FONT=Consolas]sudo mysql -u root -p. [/FONT]After changing the password I was able to access fog via [URL=‘http://fog/fog/management’]http://“IP address of server”/fog/management[/URL][/quote]
I think you were correct. I got that issue fixed, but now I’m getting this error message:
[FONT=Ubuntu][COLOR=#333333][B]Database error: (ID# 15-0)[/B][/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#333333][B]Database Error: [/B][/COLOR][/FONT]
[COLOR=#333333][B]Duplicate column name ‘taskBPM’[/B][/COLOR]
[COLOR=#333333] [/COLOR]
[COLOR=#333333] [/COLOR] -
This post is deleted! -
Got a follow-up e-mail message about a post here, but the post is not showing. Odd. Anyway, some asked:
[quote]
This sounds stupid, but I am new…
How or what commands do i use to get to “/var/www/fog/commons/config.php” once i go here: sudo mysql -u root -p?
[/quote]Sorry, I should have been more clear. You don’t need to use the “sudo mysql -u root -p”. I just added that because it is an easy way to verify that you know the mysql password. If you get in, then you can just exit mysql. You need to put that password in /var/www/fog/commons/config.php. It is the ‘DATABASE_PASSWORD’ variable, if I recall correctly.
Just type “sudo vi /var/www/fog/commons/config.php” to edit the file and insert your mysql password. Some people hate vi, so you could substitute vi in the command above with ‘gedit’. That will give you a graphical editor in a new window. Just insert the mysql password and save the file. Then try to open the WEBUI again.
Let us know if that works.
-
Thanks for this thread guys! I think I mistakenly set my MySQL password during install of FOG 0.32 to an Ubuntu 12.4 LTS build, which was causing this error for me. After changing the MYSQL_PASSWORD line in the config.php file to what I set, I was able to log into my install.
