I am able to check the log and see that the client installer is in fact communicating with the server, so I put PXE as 1st in the client’s boot order and create a task to reboot and make an image from the fog server GUI. The machine restarts and boots to PXE, but eventually times out. The host in fog has the correct MAC, so I don’t know why it won’t upload.
C
Latest posts made by cschwab
-
PXE Not Uploading
-
RE: FOG prompts me to update the database...
@Sebastian-Roth
I am pretty new to Linux/FOG, so I didn’t realize I should have included this:
0_1463517858582_error.log -
RE: FOG prompts me to update the database...
@Wayne-Workman It is password protected, but it was all correctly included in the installation process.
-
FOG prompts me to update the database...
FOG prompts me to update the database when I attempt to access the server from another windows computer. It is running on Ubuntu 14.04 and works fine from that machine. I am able to log in and do what I need to do from the linux server. However, I am now unable to download the client prep files from other machines. I click the update button, and I get this:
The following errors occured Update ID: 1 - 0 Database Error: Database SQL: CREATE DATABASE fog Update ID: 1 - 1 Database Error: Database SQL: 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: Database SQL: 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: Database SQL: 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: Database SQL: 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 Update ID: 1 - 5 Database Error: Database SQL: CREATE TABLE `fog`.`images` ( `imageID` int(11) NOT NULL auto_increment, `imageName` varchar(40) NOT NULL, `imageDesc` longtext NOT NULL, `imagePath` longtext NOT NULL, `imageDateTime` datetime NOT NULL, `imageCreateBy` varchar(50) NOT NULL, `imageBuilding` int(11) NOT NULL, `imageSize` varchar(200) NOT NULL, PRIMARY KEY (`imageID`), KEY `new_index` (`imageName`), KEY `new_index1` (`imageBuilding`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 Update ID: 1 - 6 Database Error: Database SQL: CREATE TABLE `fog`.`schemaVersion` ( `vID` int(11) NOT NULL auto_increment, `vValue` int(11) NOT NULL, PRIMARY KEY (`vID`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC Update ID: 1 - 7 Database Error: Database SQL: CREATE TABLE `fog`.`supportedOS` ( `osID` int(10) unsigned NOT NULL auto_increment, `osName` varchar(150) NOT NULL, `osValue` int(10) unsigned NOT NULL, PRIMARY KEY (`osID`), KEY `new_index` (`osValue`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 Update ID: 1 - 8 Database Error: Database SQL: CREATE TABLE `fog`.`tasks` ( `taskID` int(11) NOT NULL auto_increment, `taskName` varchar(250) NOT NULL, `taskCreateTime` datetime NOT NULL, `taskCheckIn` datetime NOT NULL, `taskHostID` int(11) NOT NULL, `taskState` int(11) NOT NULL, `taskCreateBy` varchar(200) NOT NULL, `taskForce` varchar(1) NOT NULL, `taskScheduledStartTime` datetime NOT NULL, `taskType` varchar(1) NOT NULL, `taskPCT` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`taskID`), KEY `new_index` (`taskHostID`), KEY `new_index1` (`taskCheckIn`), KEY `new_index2` (`taskState`), KEY `new_index3` (`taskForce`), KEY `new_index4` (`taskType`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
And this goes on for many more errors, pages worth. Any ideas? thanks.
Mod edited to use code box.