Fog/ SQL problem
I rescently retried setting up another fog server using ubuntu 10.10. After the installation and the installation of fog I could not go to the management console x.x.x.x/fog/management. It was giving me a password error. I did not set up a password for mysql when I installed this so I am not sure where this came from. Anyways I decided to reset the password using this technique.
1.Stop the MySQL Server.
sudo /etc/init.d/mysql stop
2.Start the mysqld configuration.
sudo mysqld --skip-grant-tables &
3.Login to MySQL as root.
mysql -u root mysql
4.Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
After doing this I can now get into the management console where it prompts me for the update. When I click to update it, I get an error Database error (ID# 15-0)
Database Error
Duplicate column name 'taskBPM'
Anyone have any idea? I have seen other people with this issue also but there is no answer.
|