Hi everyone,
I installed the 1.1.0 version of fog,
I can access the fog via [url]http://ip/fog/management[/url].
He then asked me to update, here is what appears:
"Database Schema Installer / Updater
Your FOG database schema is not up to date, Either Because You-have updated or FOG FOG this is a new installation. If this is a upgrade, we highly recommend you backup your FOG That before updating the database schema (This Will allow you to return the previous installed version.)
If You Would like to backup your database FOG you can do so using my MySql Administrator or by running the command in a terminal Following window (Applications -> System Tools -> Terminal), This Will save sqldump in your home directory.cd ~; mysqldump - allow-keywords-x-v fog> fogbackup.sql
Are you sure you wish to install / update the FOG database?
install / upgrade now> I click on the next page and it gives me a bunch of error messages:
"Database Schema Installer / Updater
Update / Install Failed!The following errors occured
Update ID: 1-0
Database Error:
SQL Database:
CREATE DATABASE fog
Update ID: 1-1
Database Error:
SQL Database:
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 Update ID: 1-2 Database Error: SQL Database: 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 Update ID: 1-3 Database Error: SQL Database: 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 Update ID: 1-4 Database Error: SQL Database: CREATE TABLE `fog`. `Hosts` (HostID int (11) NOT NULL auto_increment,Hostname varchar (16) NOT NULL,HostDesc longtext NOT NULL, Hostip varchar (25) NOT NULL,HostImage int (11) NOT NULL,HostBuilding int (11) NOT NULL,HostCreateDate datetime NOT NULL, HostCreateBy varchar (50) NOT NULL,HostMAC varchar (20) NOT NULL,Hostos int (10) unsigned NOT NULL,PRIMARY KEY ( hostID)KEY `new_index` (`hostname`)KEY `new_index1` ( hostip)KEY new_index2 ( hostMAC)KEY `new_index3` ( Hostos)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1
Have you an idea of the problem? apparently this is related to the database, but should he do?
Best regards