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.


Log in to reply
 

363
Online

38984
Users

10712
Topics

101689
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.