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 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]



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


 

599
Online

41.9k
Users

12.4k
Topics

116.8k
Posts