• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. SteveL
    3. Posts
    S
    • Profile
    • Following 0
    • Followers 0
    • Topics 4
    • Posts 27
    • Best 0
    • Controversial 0
    • Groups 0

    Posts made by SteveL

    • RE: Database Schema Installer / Updater Update/Install Failed!

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

      posted in FOG Problems
      S
      SteveL
    • RE: Database Schema Installer / Updater Update/Install Failed!

      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?

      posted in FOG Problems
      S
      SteveL
    • Database Schema Installer / Updater Update/Install Failed!

      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.

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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?

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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.

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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.

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

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

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      -> 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>

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      Incase this helps

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

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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>

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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>

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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.

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

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

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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]

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

      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?

      posted in FOG Problems
      S
      SteveL
    • RE: Boot Loop issue

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

      posted in FOG Problems
      S
      SteveL
    • Boot Loop issue

      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

      posted in FOG Problems
      S
      SteveL
    • RE: Fog Tray IP Question

      Thanks!

      posted in General
      S
      SteveL
    • RE: Fog Tray IP Question

      Anyone?

      posted in General
      S
      SteveL
    • Fog Tray IP Question

      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?

      posted in General
      S
      SteveL
    • 1 / 1