• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Fog Show me Blank Page on Fresh install /Ubuntu 16.04

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    2
    12
    1.7k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      selcukkubur
      last edited by selcukkubur

      Hi there ,

      Im new here in fog community I just newly installed FOG v1.4.4 successfully on ubuntu 16 but fog want me to go

      http://10.0.105.87/fog/management I just saw white blank page is there a solution for that? because fog successfully installed, what is causing to that problem. How can I fix it ? Could someone help me.

      Cant see Gui 😞 http://10.0.105.87/fog/management/?node=schema

      1 Reply Last reply Reply Quote 0
      • george1421G
        george1421 Moderator
        last edited by

        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

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

        1 Reply Last reply Reply Quote 0
        • S
          selcukkubur
          last edited by

          @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

          george1421G 1 Reply Last reply Reply Quote 0
          • george1421G
            george1421 Moderator @selcukkubur
            last edited by

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

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

            S 1 Reply Last reply Reply Quote 0
            • S
              selcukkubur @george1421
              last edited by

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

              george1421G 1 Reply Last reply Reply Quote 0
              • george1421G
                george1421 Moderator @selcukkubur
                last edited by

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

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                george1421G S 2 Replies Last reply Reply Quote 0
                • george1421G
                  george1421 Moderator @george1421
                  last edited by

                  @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

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                  S 1 Reply Last reply Reply Quote 0
                  • S
                    selcukkubur @george1421
                    last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • S
                      selcukkubur @george1421
                      last edited by

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

                      S 1 Reply Last reply Reply Quote 0
                      • S
                        selcukkubur @selcukkubur
                        last edited by

                        @selcukkubur I fixed problem with disabling mysql Valide password plugin

                        george1421G 1 Reply Last reply Reply Quote 0
                        • george1421G
                          george1421 Moderator @selcukkubur
                          last edited by

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

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                          S 1 Reply Last reply Reply Quote 0
                          • S
                            selcukkubur @george1421
                            last edited by 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]

                            1 Reply Last reply Reply Quote 1
                            • 1 / 1
                            • First post
                              Last post

                            149

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project