I need to restore my fog server, but I don't know the web gui password

[kyletmanel]

I need to recover a fog server that is being used to build several machines. The past operator however has left without leaving passwords to the web ui. I have recovered into the CLI, and have attempted to run ‘mysql -p fog’ but I receive ‘ERROR 1045’ Access denied for user ‘root’@‘localhost’ (using password: YES)
as well as ‘mysql -p fog’ with similar results (except a NO).

[Wayne Workman]

if you have root access to the server AND you’re on fog trunk, you can follow steps here:
https://wiki.fogproject.org/wiki/index.php?title=Password_Central

And, if you’re not on FOG Trunk, that’ll at least point you in the right direction.

[kyletmanel]

fog@fogserv:/$ mysql
ERROR 1045 (28000): Access denied for user ‘fog’@‘localhost’ (using password: NO)

[Wayne Workman]

@kyletmanel You need to become root first. sudo -i

And, if there’s a db password set, you might find it in the file /opt/fog/.fogsettings but this would only be there for newer fog versions. you could look inside of config.class.php for a db pass as well. You can search for that file with find /var/www | grep config.class.php

[kyletmanel]

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
There is a password located in the /opt/fog/.fogsettings file, though I am unclear how to use this to access the database.

[Wayne Workman]

@kyletmanel the db password is labeled as snmysqlpass=
you would use it like:
mysql -u root -p then hit enter, and supply the password.

[kyletmanel]

root@fogserv:/# mysql
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

[kyletmanel]

Sorry, that was after the first command in the link that was provided ‘mysql’

[Wayne Workman]

@kyletmanel So… back in business now?

[kyletmanel]

@Wayne-Workman
Not as yet. I can’t access the mysql utility as it provides error 1045 when I attempt to access the application.

[Wayne Workman]

@kyletmanel The error you posted says you’re not using a password. You should be providing a password if one is set. The command to access MySQL when a password is set is mysql -u root -p, so any instructions you see that say to enter into mysql via the command mysql, you would instead use mysql -u root -p