Fog issue with new Dell optiplex 7040

[Tom Elliott]

@inafog9 Does the /var/www/html/fog/management/reports/ directory exist on your system?

[inafog9]

@Tom-Elliott yes

[Tom Elliott]

@inafog9 In the trunk folder, what’s it show for the backupReports() function in the file trunk/lib/common/functions.sh around lines 85 through 94?

[inafog9]

@Tom-Elliott

[Tom Elliott]

@inafog9 Can you update again and try again? I am not going to force this part to fail any more. I’m also writing the info to the error logs so we can get more info for this later on.

[inafog9]

Sure, Do you want me to run the entire trunk upgrade again? Starting with downloading the svn?

[Tom Elliott]

@inafog9 No, you should be able to just run svn up from the root of the trunk folder: /opt/fog/trunk (or wherever it’s located).

Running svn up in the bin won’t update all the other folders below it.

[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