Fog Show me Blank Page on Fresh install /Ubuntu 16.04

[george1421]

If you get just a blank white page that means that php (the language behind the FOG server threw an exception). If you review the last few lines in the apache error log that should give you an idea what happened.
tail /var/log/apache/error.log It may be error_log I don’t remember between distributions.

If you see sql errors in the apache log I might start with this document to fix it: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

[selcukkubur]

@george1421 said in Fog Show me Blank Page on Fresh install /Ubuntu 16.04:

tail /var/log/apache/error.log

Firstly thanks for your reply.

Here is apache2 log cant understhood errors.

[Wed Jan 31 05:53:43.781260 2018] [mpm_event:notice] [pid 23279:tid 140416774641536] AH00489: Apache/2.4.29 (Ubuntu) configured – resuming normal operations
[Wed Jan 31 05:53:43.781458 2018] [core:notice] [pid 23279:tid 140416774641536] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 31 05:54:10.854319 2018] [mpm_event:notice] [pid 23279:tid 140416774641536] AH00491: caught SIGTERM, shutting down
[Wed Jan 31 05:54:10.936267 2018] [mpm_prefork:notice] [pid 29569] AH00163: Apache/2.4.29 (Ubuntu) configured – resuming normal operations
[Wed Jan 31 05:54:10.936435 2018] [core:notice] [pid 29569] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 31 05:54:11.429643 2018] [mpm_prefork:notice] [pid 29569] AH00169: caught SIGTERM, shutting down
[Wed Jan 31 05:54:11.582229 2018] [mpm_prefork:notice] [pid 29641] AH00163: Apache/2.4.29 (Ubuntu) configured – resuming normal operations
[Wed Jan 31 05:54:11.582329 2018] [core:notice] [pid 29641] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 31 05:55:49.549584 2018] [mpm_prefork:notice] [pid 29641] AH00169: caught SIGTERM, shutting down
[Wed Jan 31 05:58:44.430614 2018] [mpm_prefork:notice] [pid 6785] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured – resuming normal operations
[Wed Jan 31 05:58:44.430719 2018] [core:notice] [pid 6785] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 31 05:58:46.619725 2018] [php7:error] [pid 6790] [client 10.0.105.87:53140] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/reportmaker.class.php(75): HookManager->processEvent(‘REPORT_TYPES’, Array)\n#3 [internal function]: ReportMaker->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/maintenance/backup_db.php(23): FOGBase::getClass(‘ReportMaker’)\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443

[george1421]

@selcukkubur said in Fog Show me Blank Page on Fresh install /Ubuntu 16.04:

Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1

Indicates a database issue. Please follow the guidance in the link I posted. Its a quick fix for what ubuntu does to the sql server settings.

[selcukkubur]

@george1421 thanks for your support but when I try to run command
after sudo - i in terminal window “mysql -u root” I got this error.

sudo -i
[sudo] password for fogadmin:
root@DSK-FOG:~# mysql -u root
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

[george1421]

@selcukkubur Ok this is going to take some research. Since root is locked out and can’t access. I would suggest doing the second part about removing the unattended upgrades, while I look how to force root’s password reset.

[george1421]

@george1421 Here is a good source on forcing root password reset: https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password

[selcukkubur]

@george1421 I removed unattented upgrades with
apt-get -y remove unattended-upgrades command line.

[selcukkubur]

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

[selcukkubur]

@selcukkubur I fixed problem with disabling mysql Valide password plugin

[george1421]

@selcukkubur said in Fog Show me Blank Page on Fresh install /Ubuntu 16.04:

I fixed problem with disabling mysql Valide password plugin

Sorry I was on the commute into the office. Can you explain this statment?

[selcukkubur]

@george1421 Hello George as you seen on the Database schema error log

"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”], "

because of mysql root password policy requirements I coulndt get update or install database schema to new one.

so I searched about error for mysql server then I understhand I dısableit Password validation on mysql

[https://dev.mysql.com/doc/refman/5.7/en/validate-password.html]