Web page wont update during install

[tom.langenfeld]

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

[Tom Elliott]

What OS are you running?

[tom.langenfeld]

kubuntu 16.10

[george1421]

@tom.langenfeld

1. Can you log into the mysql database user interface?
2. Can you also confirm that the mysql database server is running on your system? ps aux|grep mysql should return the process number of the mysql service.
3. Did you change/set root’s password for mysql (not related to root’s linux password)?

[tom.langenfeld]

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

[george1421]

@tom.langenfeld said in Web page wont update during install:

/usr/sbin/mysqld

Ths should indicate that the mysqld server is running.

From the command prompt key in mysql -u root see if it lets you in directly.

Just to be clear “however this is an attempted update to fog” does this imply you are updating from a previous release of FOG, what was the previous release?

[tom.langenfeld]

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