Fog issue with new Dell optiplex 7040

[Sebastian Roth]

@inafog9 Well then I guess what going on is that queries to external DNS servers is NOT allowed! You need to use your internal DNS servers. Most probably those had some kind of issue (when you had trouble at first) which is now solved. Ask your colleges…

[inafog9]

@Tom-Elliott I started the trunk install and it failed at the end.

[Wayne Workman]

@inafog9 I suppose an address with two forward slashes won’t work. @Tom-Elliott

/var/www/html/fog//management/reports/*

[inafog9]

@Wayne-Workman that happens when I run ./installfog/sh Is this something with the install file?

[Tom Elliott]

@inafog9 The slashes aren’t the problem at all.

My guess is it thinks the data is in /var/www/html, which isn’t present on that system at the moment.

That all said, there shouldn’t be any problem with that in trunk. What’s the output of

svnversion from within the svn/trunk folder?

[inafog9]

@Tom-Elliott 5113

[Tom Elliott]

@inafog9 can you try to run sudo using sudo -i and try again? My guess is some of the commands aren’t available with full permissions because (and again I’m just guessing) you’re sudoed to root using simply sudo su.

[inafog9]

@Tom-Elliott I’m logged in as the root user. I tried the sudo -i then the install and it still fails on the backing up user reports.

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