Thank you Junkhacker. That took care of that problem. Now to fix the issue of my PXE timeouts…argh.

I found where the mysql pw is…if it isn’t correct, is there a way to recover the pw from mysql, or to create another?

While updating from 1.1.1 to 1.2.0, I got the error. This isn’t the entire list…it actually goes to line 113.
Please help!?!?

 
[SIZE=6][B][FONT=Ubuntu][CENTER][SIZE=32px][COLOR=#666666]Database Schema Installer / Updater[/COLOR][/SIZE][/CENTER][/FONT][/B][/SIZE]

[FONT=Ubuntu][COLOR=#555555]Update/Install Failed!
 
 
[SIZE=5][B][CENTER][SIZE=18px][COLOR=#4c68a0]The following errors occured[/COLOR][/SIZE][/CENTER][/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
 
[B]Update ID:[/B] 1 - 4
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
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
 
[B]Update ID:[/B] 1 - 5
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
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
 
[B]Update ID:[/B] 1 - 6
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
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
 
[B]Update ID:[/B] 1 - 7
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
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
 
[B]Update ID:[/B] 1 - 8
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
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
 
[B]Update ID:[/B] 1 - 9
[B]Database Error:[/B]
 
 
[B]Database SQL:[/B]
CREATE TABLE  `fog`.`users` (
      `uId` int(11) NOT NULL auto_increment,
      `uName` varchar(40) NOT NULL,
      `uPass` varchar(50) NOT NULL,
      `uCreateDate` datetime NOT NULL,
      `uCreateBy` varchar(40) NOT NULL,
      PRIMARY KEY  (`uId`),
      KEY `new_index` (`uName`),
      KEY `new_index1` (`uPass`)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1[/COLOR][/FONT]

Mod edited to use code box.

So, it turns out when portfast is turned on, all works well…but, my net admin is hesitant to do this because Cisco advises against it. Is there a way to increase the PXE timeout?

Sorry for the delay, I got sidetracked with another project.

After some testing…I’m just scratching my head on this one. Please help.

My environment.
Fog 1.1.1 hosted on Dell 3010 / Ubuntu 14.04
Cisco 2950 Switches In my cold room
85 Dell 3010’s
5 Dell 3020’s

Here is what is confusing me.
When I boot a 3010 on the floor, it reaches the fog server, downloads the config, and then times out.
The video above shows what is happening. At the very end of the video, it throws an error
“Error 0x040ee109 [url]Http://ipxe.org/040ee119[/url]”

Now, when I plug a work station into the Linksys 10/100 8-Port Workgroup switch in my office, it boots into the FOG menu every time without a problem.

I’ve tried every combination I can think of plugging in the FOG server, and workstation into the same switch, changing switches…and still, it only works when I plug the workstation into the Linksys switch in my office.

I’m at a complete loss.
Any suggestions are greatly appreciated.

Sorry for the delay, I got sidetracked with another project.

After some testing…I’m just scratching my head on this one. Please help.

My environment.
Fog 1.1.1 hosted on Dell 3010 / Ubuntu 14.04
Cisco 2950 Switches In my cold room
85 Dell 3010’s
5 Dell 3020’s

Here is what is confusing me.
When I boot a 3010 on the floor, it reaches the fog server, downloads the config, and then times out.
The video above shows what is happening. At the very end of the video, it throws an error
“Error 0x040ee109 [url]Http://ipxe.org/040ee119[/url]”

Now, when I plug a work station into the Linksys 10/100 8-Port Workgroup switch in my office, it boots into the FOG menu every time without a problem.

I’ve tried every combination I can think of plugging in the FOG server, and workstation into the same switch, changing switches…and still, it only works when I plug the workstation into the Linksys switch in my office.

I’m at a complete loss.
Any suggestions are greatly appreciated.

SO…how do I fix it? And remember…it works just fine for my 3020’s

-> use fog;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘the manual that corresponds to your MySQL server version for the right syntax to’ at line 1
mysql> select * from hosts where hostID=‘0’;
ERROR 1046 (3D000): No database selected
mysql> use fog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from hosts where hostID=‘0’;
Empty set (0.01 sec)
mysql>

Incase this helps

[media=youtube]4SaO4gY-sZo[/media]

I’m not sure this is right…I copied and pasted and got this…did you want me to change something?

-> mysql>
-> select * from hosts WHERE hostID='0';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘.
Your MySQL connection id is 2750
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubun’ at line 1
mysql>