Fog issue with new Dell optiplex 7040

[Tom Elliott]

@inafog9 Check your /opt/fog/.fogsettings file. Look for the snmysqlpass= field.

If you don’t have a mysql password set, delete the contents of that line so it reads as snmysqlpass=''

[inafog9]

@Tom-Elliott I removed the password from the file but i’m still prompted to update the database and I get the same errors. I’m not sure if there was a password used.

[Sebastian Roth]

@inafog9 Can you connect to the database using the mysql command line client? mysql --user=root -p (for empty password just hit enter on password prompt)

Don’t empty all the mysql settings in .fogsettings!!!

...
snmysqluser='root'
snmysqlpass=''
snmysqlhost='127.0.0.1'
...

[inafog9]

@Sebastian-Roth I had to use my root password to access.

[inafog9]

@Tom-Elliott I was looking for an answer and I noticed I do not have /var/www/fog/lib/fog/Config.class.php. Could that be my issue?

[Sebastian Roth]

@inafog9 Please show us what you see from those two commands: ls -al /var/www and ls /var/www/fog/lib/fog

In FOG trunk all the filenames are lower case so it might be: /var/www/fog/lib/fog/config.class.php

[inafog9]

@Sebastian-Roth

[Sebastian Roth]

Well there is old and new installation mixed up now… ls -al /var/www/html/fog/lib/fog/config.class.php

And better change the ownership of the new www files: chown -R www-data:www-data /var/www/html

[inafog9]

@Sebastian-Roth I ran both commands but I’m still not able to get past the Database Schema Installer / Updater.

[Sebastian Roth]

Check the credentials in /var/www/html/fog/lib/fog/config.class.php

[inafog9]

@Sebastian-Roth What should I be looking for?

[Tom Elliott]

@inafog9 in the Config file remove the password from the database_password line

[inafog9]

@Tom-Elliott I removed the password from config.class.php but that did not work. Should I also remove the password from .fogsettings?

[Sebastian Roth]

So I guess there was a password set in your database from FOG 1.0.1… too bad that the “old” Config.class.php (upper case ‘C’) file is not where it should be.

You need to somehow find out your DB credentials. Try connecting using the command line client:

mysql --user=root -p
Enter password:
...
mysql --user=fog -p
Enter password:
...

Try different passwords (as well empty by just hitting ENTER on the password prompt) till you find the correct login credentials! As well try the password from your last screenshot (maybe with user ‘fog’).

[inafog9]

@Sebastian-Roth I know the password. I have tried to enter it into the .fogsettings several times and I still get the same error when logging into fog

[Tom Elliott]

We were able to get the stuff figured out. YAY!

The connection is now operational. FOG Interface displays properly.