Posts made by SteveL

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>

I didn’t set a PW…so just typing in mysql -u root here is the output

it@ET11FogServer:~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2750
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

If I can provide any logs or anything…just let me know…and explain how to find them. If you want to showmypc or something similar to take a look…I’m more than willing to accommodate.

Yes…it connects to the fog server…goes through its dance…and then where it would normally show the Fog menu…it just restarts.

Thanks Robbie…that was easy, but unfortauntly, it didn’t work. Same result. 3020’s boot to PXE menu no prob…3010’s go into a boot loop.
Here is what I installed.

[FONT=Ubuntu][COLOR=#555555]Unofficial Published Kernels[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#555555]Kernel - 3.15.1 TomElliott
Date : June 17, 2014
Version: 3.15.1
FOG Type: TomElliott
Arch Type: (x86)[/COLOR][/FONT]

No idea…whatever was in the standard installation.

Is that something that is easy to change/fix?

Care to point me in the right direction?

It connects with the fog server… and everything seems to go as planned…but instead of showing the menu, it immediately reboots.

Hello.
On my fresh install of Ubuntu 14.04 and FOG 1.1.1, I’m having a problem with DELL 3010’s in a constant boot loop after the PXE connection…this is NOT happening with my DELL 3020’s

Also, I believe there is an issue with GREEN FOG causing PC’s to shutdown without much warning and no way to opt out. I’ve turned off GREEN FOG checkbox and that seemed to clear that issue up.
These 2 issues caused yesterday to be quite stressful.

If there is any information or help that I can provide, please don’t hesitate to ask. But just to let you know, I’m not really a linux guy. Google and I have struggled through.

Please advise?

Thanks

Steve

Thanks!

Anyone?

Hello,
I recently changed the IP of my fog server. So my client PC’s fog tray can find the server, do I just change the ip in
\c$\Program Files (x86)\FOG\etc config.ini? Or do I have to make any other changes?