Troble with MySQL after Upgrading from .32 to 1.2.0
-
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 TABLEfog
.groupMembers
(
gmID
int(11) NOT NULL auto_increment,
gmHostID
int(11) NOT NULL,
gmGroupID
int(11) NOT NULL,
PRIMARY KEY (gmID
),
KEYnew_index
(gmHostID
),
KEYnew_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 TABLEfog
.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
),
KEYnew_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 TABLEfog
.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 TABLEfog
.groupMembers
(
gmID
int(11) NOT NULL auto_increment,
gmHostID
int(11) NOT NULL,
gmGroupID
int(11) NOT NULL,
PRIMARY KEY (gmID
),
KEYnew_index
(gmHostID
),
KEYnew_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 TABLEfog
.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
),
KEYnew_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 TABLEfog
.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] -
Found the answers while looking through the release thread. The config.php has become /var/www/fog/lib/fog/Config.class.php. Added my SQL password in and it all worked.