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]