• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Troble with MySQL after Upgrading from .32 to 1.2.0

    Scheduled Pinned Locked Moved
    FOG Problems
    1
    2
    1.8k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      TJ333
      last edited by

      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]

      1 Reply Last reply Reply Quote 0
      • T
        TJ333
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        240

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project