After upgrading to 1.2.0 one of my FOG servers is not completing the upgrade.
I get a lot oferrors when I click the Install/Upgrade Now button. I would think it is a SQL password issue. I cannot find the config.php files in order to change that on for 1.2.0. Here is a sample of the errors I get.
[QUOTE]
Update/Install Failed!
[SIZE=5][B]The following errors occured[/B][/SIZE]
[B]Update ID:[/B] 1 - 0
[B]Database Error:[/B]
[B]Database SQL:[/B]
CREATE DATABASE fog
[B]Update ID:[/B] 1 - 1
[B]Database Error:[/B]
[B]Database SQL:[/B]
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
[B]Update ID:[/B] 1 - 2
[B]Database Error:[/B]
[B]Database SQL:[/B]
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
[B]Update ID:[/B] 1 - 3
[B]Database Error:[/B]
[B]Database SQL:[/B]
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[/QUOTE]
and the apache error log files has:
[QUOTE]
Update/Install Failed!
[SIZE=5][B]The following errors occured[/B][/SIZE]
[B]Update ID:[/B] 1 - 0
[B]Database Error:[/B]
[B]Database SQL:[/B]
CREATE DATABASE fog
[B]Update ID:[/B] 1 - 1
[B]Database Error:[/B]
[B]Database SQL:[/B]
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
[B]Update ID:[/B] 1 - 2
[B]Database Error:[/B]
[B]Database SQL:[/B]
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
[B]Update ID:[/B] 1 - 3
[B]Database Error:[/B]
[B]Database SQL:[/B]
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[/QUOTE]