• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. tom.langenfeld
    T
    • Profile
    • Following 0
    • Followers 0
    • Topics 5
    • Posts 35
    • Best 0
    • Controversial 0
    • Groups 0

    tom.langenfeld

    @tom.langenfeld

    0
    Reputation
    541
    Profile views
    35
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    tom.langenfeld Unfollow Follow

    Latest posts made by tom.langenfeld

    • RE: FOG Server TFTP timing out

      a restart of the server has restored access to the local subnet but not the other subnets.

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: FOG Server TFTP timing out

      Now the local subnet is also timing out.

      posted in FOG Problems
      T
      tom.langenfeld
    • FOG Server TFTP timing out

      Hey guys I am having an issue on the boot with the tftp timing out on the boot for my machines. This only happens when trying to boot from a different sub net, the local subnet works everytime.

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web page wont update during install

      as a root user I can get in but I need to enter root before the command

      also from 1.3.0 to 1.3.5

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web page wont update during install

      1.I will look into this one

      1. Here is the response from running the konsole command.

      it 3874 0.0 0.0 14232 920 pts/2 S+ 16:18 0:00 grep --color=auto mysql
      mysql 24389 1.5 4.4 2033524 179932 ? Ssl 13:15 2:45 /usr/sbin/mysqld
      it@it-PowerEdge-2950:~$

      1. I did not change the password during the installation. There was a prompt asking if I left it blank and I said that I did, however this is an attempted update to fog
      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web page wont update during install

      kubuntu 16.10

      posted in FOG Problems
      T
      tom.langenfeld
    • Web page wont update during install

      I am trying to update to 1.3.5 and the install goes normal until the point in the installer where you go to the web page to do an upgrade and after that hit enter to finish installation.

      After getting to the page and clicking the install/upgrade button I get the following error code

      Database Schema Installer / Updater

      Install / Update Failed!
      The following errors occurred

      Update ID: 1

      Database Error:

      Failed to query: Error: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘root’@‘172.25.96.10’ to database ‘fog’ Error Message: Error Code: “42000”, Error Message: [“42000”,1044,“Access denied for user ‘root’@‘172.25.96.10’ to database ‘fog’”], Debug: SQL: [35] CREATE DATABASE IF NOT EXISTSfog
      Params: 0

      Variable contains:

      Array
      ( [0] => CREATE DATABASE IF NOT EXISTSfog [1] => USE fog [2] => CREATE TABLE groupMembers (gmID INT(11) NOT NULL AUTO_INCREMENT,gmHostID INT(11) NOT NULL,gmGroupID INT(11) NOT NULL,PRIMARY KEY (gmID),UNIQUE KEY gmHostID (gmHostID,gmGroupID),UNIQUE KEY gmGroupID (gmHostID,gmGroupID),KEY new_index (gmHostID),KEY new_index1 (gmGroupID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [3] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [4] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [5] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [6] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [7] => CREATE TABLE schemaVersion (vID INT(11) NOT NULL AUTO_INCREMENT,vValue INT(11) NOT NULL,PRIMARY KEY (vID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [8] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [9] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [10] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [11] => INSERT IGNORE INTO users VALUES (‘’,‘fog’, MD5(‘password’), NOW(), ‘’) [12] => INSERT IGNORE INTO supportedOS VALUES (‘’, ‘Windows XP’, ‘1’) [13] => INSERT IGNORE INTO schemaVersion VALUES (‘’, ‘1’)
      )

      Database SQL:

      CREATE DATABASE IF NOT EXISTSfog##### Server

      • FOG Version:
      • OS:
      Client
      • Service Version:
      • OS:
      Description

      I am trying to update to 1.3.5 and the install goes normal until the point in the installer where you go to the web page to do an upgrade and after that hit enter to finish installation.

      After getting to the page and clicking the install/upgrade button I get the following error code

      Database Schema Installer / Updater

      Install / Update Failed!
      The following errors occurred

      Update ID: 1

      Database Error:

      Failed to query: Error: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘root’@‘172.25.96.10’ to database ‘fog’ Error Message: Error Code: “42000”, Error Message: [“42000”,1044,“Access denied for user ‘root’@‘172.25.96.10’ to database ‘fog’”], Debug: SQL: [35] CREATE DATABASE IF NOT EXISTSfog
      Params: 0

      Variable contains:

      Array
      ( [0] => CREATE DATABASE IF NOT EXISTSfog [1] => USE fog [2] => CREATE TABLE groupMembers (gmID INT(11) NOT NULL AUTO_INCREMENT,gmHostID INT(11) NOT NULL,gmGroupID INT(11) NOT NULL,PRIMARY KEY (gmID),UNIQUE KEY gmHostID (gmHostID,gmGroupID),UNIQUE KEY gmGroupID (gmHostID,gmGroupID),KEY new_index (gmHostID),KEY new_index1 (gmGroupID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [3] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [4] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [5] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [6] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [7] => CREATE TABLE schemaVersion (vID INT(11) NOT NULL AUTO_INCREMENT,vValue INT(11) NOT NULL,PRIMARY KEY (vID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [8] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [9] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [10] => CREATE TABLE 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=utf8 ROW_FORMAT=DYNAMIC [11] => INSERT IGNORE INTO users VALUES (‘’,‘fog’, MD5(‘password’), NOW(), ‘’) [12] => INSERT IGNORE INTO supportedOS VALUES (‘’, ‘Windows XP’, ‘1’) [13] => INSERT IGNORE INTO schemaVersion VALUES (‘’, ‘1’)
      )

      Database SQL:

      CREATE DATABASE IF NOT EXISTSfog

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web Service Can't Stop The Web Service

      When trying to run the first command I get this message.
      0_1483022793418_12-28.png

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web Service Can't Stop The Web Service

      Running the ./install -Xy yielded the same results

      posted in FOG Problems
      T
      tom.langenfeld
    • RE: Web Service Can't Stop The Web Service

      Sounds good just chat me with a time that works for you and I am flexible

      posted in FOG Problems
      T
      tom.langenfeld