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(
gmIDint(11) NOT NULL auto_increment,
gmHostIDint(11) NOT NULL,
gmGroupIDint(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(
groupIDint(11) NOT NULL auto_increment,
groupNamevarchar(50) NOT NULL,
groupDesclongtext NOT NULL,
groupDateTimedatetime NOT NULL,
groupCreateByvarchar(50) NOT NULL,
groupBuildingint(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(
hIDint(11) NOT NULL auto_increment,
hTextlongtext NOT NULL,
hUservarchar(200) NOT NULL,
hTimedatetime NOT NULL,
hIPvarchar(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(
gmIDint(11) NOT NULL auto_increment,
gmHostIDint(11) NOT NULL,
gmGroupIDint(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(
groupIDint(11) NOT NULL auto_increment,
groupNamevarchar(50) NOT NULL,
groupDesclongtext NOT NULL,
groupDateTimedatetime NOT NULL,
groupCreateByvarchar(50) NOT NULL,
groupBuildingint(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(
hIDint(11) NOT NULL auto_increment,
hTextlongtext NOT NULL,
hUservarchar(200) NOT NULL,
hTimedatetime NOT NULL,
hIPvarchar(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.