Fog issue with new Dell optiplex 7040

[inafog9]

@Tom-Elliott I was able to get past the report section. Once it got to the database portion it said successful but lots of errors. I was not prompted to enter root password.

pdate ID: 1 - 0

Database Error:

Access denied for user 'root'@'localhost' (using password: YES), Message: Check that database is running
Database SQL:

CREATE DATABASE fog
Update ID: 1 - 1

Database Error:

Access denied for user 'root'@'localhost' (using password: YES), Message: Check that database is running
Database SQL:

CREATE TABLE `fog`.`groupMembers` ( `gmID` int(11) NOT NULL auto_increment, `gmHostID` int(11) NOT NULL, `gmGroupID` int(11) NOT NULL, PRIMARY KEY (`gmID`),
KEY `new_index` (`gmHostID`),
KEY `new_index1` (`gmGroupID`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
Update ID: 1 - 2

Database Error:

Access denied for user 'root'@'localhost' (using password: YES), Message: Check that database is running
Database SQL:

CREATE TABLE `fog`.`groups` ( `groupID` int(11) NOT NULL auto_increment, `groupName` varchar(50) NOT NULL, `groupDesc` longtext NOT NULL, `groupDateTime` datetime NOT NULL, `groupCreateBy` varchar(50) NOT NULL, `groupBuilding` int(11) NOT NULL, PRIMARY KEY (`groupID`),
KEY `new_index` (`groupName`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
Update ID: 1 - 3

Database Error:

Access denied for user 'root'@'localhost' (using password: YES), Message: Check that database is running
Database SQL:

CREATE TABLE `fog`.`history` ( `hID` int(11) NOT NULL auto_increment, `hText` longtext NOT NULL, `hUser` varchar(200) NOT NULL, `hTime` datetime NOT NULL, `hIP` varchar(50) NOT NULL, PRIMARY KEY (`hID`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

[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.