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

Now the local subnet is also 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.

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

1.I will look into this one

2. 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:~$

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

kubuntu 16.10

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

When trying to run the first command I get this message.

Running the ./install -Xy yielded the same results

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