@george1421 George thanks for your support now I access the gui when I have root password for mysql but there is another problem now Database schema cant get updated successfully.
Database Schema Installer / Updater
Install / Update Failed!
The following errors occurred
Update ID: 16
Database Error:
Failed to query: Error: SQLSTATE[HY000]: General error: 1819 Your password does not satisfy the current policy requirements Error Message: Error Code: “HY000”, Error Message: [“HY000”,1819,“Your password does not satisfy the current policy requirements”], Debug: SQL: [70] GRANT ALL ON fog.* TO ‘fogstorage’@‘%’ IDENTIFIED BY ‘fs69872702752’
Params: 0
Variable contains:
Array
( [0] => ALTER TABLE tasks ADD COLUMN taskBPM varchar(250) NOT NULL AFTER taskPCT, ADD COLUMN taskTimeElapsed varchar(250) NOT NULL AFTER taskBPM, ADD COLUMN taskTimeRemaining varchar(250) NOT NULL AFTER taskTimeElapsed, ADD COLUMN taskDataCopied varchar(250) NOT NULL AFTER taskTimeRemaining, ADD COLUMN taskPercentText varchar(250) NOT NULL AFTER taskDataCopied, ADD COLUMN taskDataTotal VARCHAR(250) NOT NULL AFTER taskPercentText [1] => CREATE TABLE nfsGroups (ngID integer NOT NULL AUTO_INCREMENT,ngName varchar(250) NOT NULL,ngDesc longtext NOT NULL,PRIMARY KEY (ngID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [2] => CREATE TABLE nfsGroupMembers (ngmID integer NOT NULL AUTO_INCREMENT,ngmMemberName varchar(250) NOT NULL,ngmMemberDescription longtext NOT NULL,ngmIsMasterNode char NOT NULL,ngmGroupID integer NOT NULL,ngmRootPath longtext NOT NULL,ngmIsEnabled char NOT NULL,ngmHostname varchar(250) NOT NULL,ngmMaxClients integer NOT NULL,ngmUser varchar(250) NOT NULL,ngmPass varchar(250) NOT NULL,ngmKey varchar(250) NOT NULL, PRIMARY KEY (ngmID),INDEX new_index(ngmMemberName),INDEX new_index2(ngmIsMasterNode),INDEX new_index3(ngmGroupID),INDEX new_index4(ngmIsEnabled)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [3] => ALTER TABLE images ADD COLUMN imageNFSGroupID integer NOT NULL AFTER imageDD,ADD INDEX new_index3(imageNFSGroupID) [4] => ALTER TABLE tasks ADD COLUMN taskNFSGroupID integer NOT NULL AFTER taskDataTotal,ADD COLUMN taskNFSMemberID integer NOT NULL AFTER taskNFSGroupID,ADD COLUMN taskNFSFailures char NOT NULL AFTER taskNFSMemberID,ADD COLUMN taskLastMemberID integer NOT NULL AFTER taskNFSFailures,ADD INDEX new_index5(taskNFSGroupID),ADD INDEX new_index6(taskNFSMemberID),ADD INDEX new_index7(taskNFSFailures),ADD INDEX new_index8(taskLastMemberID) [5] => CREATE TABLE nfsFailures (nfID integer NOT NULL AUTO_INCREMENT,nfNodeID integer NOT NULL,nfTaskID integer NOT NULL,nfHostID integer NOT NULL,nfGroupID integer NOT NULL,nfDateTime integer NOT NULL,PRIMARY KEY (nfID),INDEX new_index(nfNodeID),INDEX new_index1(nfTaskID),INDEX new_index2(nfHostID),INDEX new_index3(nfGroupID)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [6] => ALTER TABLE nfsFailures MODIFY COLUMN nfDateTime datetime NOT NULL,ADD INDEX new_index4(nfDateTime) [7] => ALTER TABLE multicastSessions CHANGE msAnon2 msNFSGroupID integer NOT NULL, ADD INDEX new_index(msNFSGroupID) [8] => INSERT IGNORE INTO nfsGroups (ngName,ngDesc) VALUES (‘default’,‘Auto generated fog nfs group’) [9] => INSERT IGNORE INTO nfsGroupMembers (ngmMemberName,ngmMemberDescription,ngmIsMasterNode,ngmGroupID,ngmRootPath,ngmIsEnabled,ngmHostname,ngmMaxClients,ngmUser,ngmPass) VALUES (‘DefaultMember’,‘Auto generated fog nfs group member’,‘1’,‘1’,‘/images/’,‘1’,‘10.0.105.87’,‘10’,‘fog’,‘FG5Jdw+JorQZiWDy0oyeLAX8O3TaKwGSvNF3A5lNOcE=’) [10] => UPDATE images set imageNFSGroupID = ‘1’ [11] => DELETE FROM globalSettings WHERE settingKey IN (‘FOG_NFS_HOST’,‘FOG_NFS_FTP_USERNAME’,‘FOG_NFS_FTP_PASSWORD’,‘FOG_NFS_DATADIR’,‘FOG_NFS_DATADIR_CAPTURE’) [12] => INSERT IGNORE INTO globalSettings (settingKey,settingDesc,settingValue,settingCategory) VALUES (‘FOG_STORAGENODE_MYSQLUSER’,‘This setting defines the username the storage nodes should use to connect to the fog server.’,‘fogstorage’,‘FOG Storage Nodes’),(‘FOG_STORAGENODE_MYSQLPASS’,‘This setting defines the password the storage nodes should use to connect to the fog server.’,‘fs69872702752’,‘FOG Storage Nodes’) [13] => GRANT ALL ON fog.* TO ‘fogstorage’@‘%’ IDENTIFIED BY ‘fs69872702752’ [14] => UPDATE schemaVersion set vValue=‘16’
)
Database SQL:
GRANT ALL ON fog.* TO ‘fogstorage’@‘%’ IDENTIFIED BY ‘fs69872702752’
