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

    Cant access management portal

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    34
    5.8k
    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.
    • K
      kwisher @CoxM
      last edited by kwisher

      I am also having the same issue only this occurred after I pulled from git and installed the current version.

      Last few lines of apace2.error.log

      [Wed Feb 14 08:33:00.550232 2018] [mpm_prefork:notice] [pid 10247] AH00169: caught SIGTERM, shutting down
[Wed Feb 14 08:36:12.661760 2018] [mpm_prefork:notice] [pid 1502] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured -- resuming normal operations
[Wed Feb 14 08:36:12.678333 2018] [core:notice] [pid 1502] AH00094: Command line: '/usr/sbin/apache2'
[Wed Feb 14 08:56:08.148967 2018] [php7:error] [pid 1503] [client 10.2.1.104:55546] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:447\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(460): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(63): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpage.class.php(219): HookManager->processEvent('PAGES_WITH_OBJE...', Array)\n#3 /var/www/html/fog/lib/pages/schemaupdaterpage.class.php(39): FOGPage->__construct('')\n#4 /var/www/html/fog/lib/fog/fogpagemanager.class.php(381): SchemaUpdaterPage->__construct()\n#5 [internal function]: FOGPageManager->{closure}('/var/www/html/f...')\n#6 /var/www/html/fog/lib/fog/fogpagemanager.class.php(386): array_map(Object(Closure), Array)\n#7 /var/www/html/fog/lib/fog/fogpagemanager.class.php(79): FOGPageManager->loadPageClasses()\n#8 [internal function]: FOGPageManager->__construct()\n#9 /var/www/html/fog/lib/fog/fogbase.class.php(481): ReflectionClass->newInstanceArgs(Array)\n#10 /var/www/html/fog/management/index.php(2 in /var/www/html/fog/lib/db/pdodb.class.php on line 447, referer: http://10.1.0.54/fog/management/index.php?node=service
[Wed Feb 14 08:56:48.476628 2018] [php7:error] [pid 1506] [client 10.2.10.151:52335] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:447\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(460): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(63): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpage.class.php(219): HookManager->processEvent('PAGES_WITH_OBJE...', Array)\n#3 /var/www/html/fog/lib/pages/schemaupdaterpage.class.php(39): FOGPage->__construct('')\n#4 /var/www/html/fog/lib/fog/fogpagemanager.class.php(381): SchemaUpdaterPage->__construct()\n#5 [internal function]: FOGPageManager->{closure}('/var/www/html/f...')\n#6 /var/www/html/fog/lib/fog/fogpagemanager.class.php(386): array_map(Object(Closure), Array)\n#7 /var/www/html/fog/lib/fog/fogpagemanager.class.php(79): FOGPageManager->loadPageClasses()\n#8 [internal function]: FOGPageManager->__construct()\n#9 /var/www/html/fog/lib/fog/fogbase.class.php(481): ReflectionClass->newInstanceArgs(Array)\n#10 /var/www/html/fog/management/index.php(2 in /var/www/html/fog/lib/db/pdodb.class.php on line 447
[Wed Feb 14 09:04:34.614871 2018] [php7:error] [pid 3522] [client 10.2.1.104:55764] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:447\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(460): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(63): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpage.class.php(219): HookManager->processEvent('PAGES_WITH_OBJE...', Array)\n#3 /var/www/html/fog/lib/pages/schemaupdaterpage.class.php(39): FOGPage->__construct('')\n#4 /var/www/html/fog/lib/fog/fogpagemanager.class.php(381): SchemaUpdaterPage->__construct()\n#5 [internal function]: FOGPageManager->{closure}('/var/www/html/f...')\n#6 /var/www/html/fog/lib/fog/fogpagemanager.class.php(386): array_map(Object(Closure), Array)\n#7 /var/www/html/fog/lib/fog/fogpagemanager.class.php(79): FOGPageManager->loadPageClasses()\n#8 [internal function]: FOGPageManager->__construct()\n#9 /var/www/html/fog/lib/fog/fogbase.class.php(481): ReflectionClass->newInstanceArgs(Array)\n#10 /var/www/html/fog/management/index.php(2 in /var/www/html/fog/lib/db/pdodb.class.php on line 447

      Ubuntu 16.04 server

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        I’m guessing both of you are running Ubuntu?

        Please run through the commands listed here:
        (changing the password field to whatever your mysql password is if you have one set)

        https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

        If you have set a mysql password:
        Change the ALTER statements to: (Changing the password between the quotes to whatever your password is)

        ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        K 1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott @CoxM
          last edited by

          @coxm The /var/www/fog/lib/fog/config.class.php DATABASE_PASSWORD line should look like:

          define('DATABASE_PASSWORD', '<whateveryourfogguipasswordishere>');

          You may also need to edit the /opt/fog/.fogsettings line with snmysqlpass='' to:

          snmysqlpass='<whateveryourfogguipasswordishere>'

          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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          C K 2 Replies Last reply Reply Quote 1
          • C
            CoxM @Tom Elliott
            last edited by

            @tom-elliott No luck 😞

            is it going to be easier to backup what I have and reinstall? I even have a working snapshot of the server, if I could ensure it using the newer up to date Db then I could roll back?

            1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott
              last edited by

              You could aire. Though I’d first see what the problem is. What’s the output of df -h

              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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              C 1 Reply Last reply Reply Quote 0
              • K
                kwisher @Tom Elliott
                last edited by

                @tom-elliott That did not work for me. I even ran the installer after doing the mysql commands.

                1 Reply Last reply Reply Quote 0
                • K
                  kwisher @Tom Elliott
                  last edited by

                  @tom-elliott said in Cant access management portal:

                  /var/www/fog/lib/fog/config.class.php

                  Thank you, that was the solution to my problem 🙂

                  1 Reply Last reply Reply Quote 0
                  • C
                    CoxM @Tom Elliott
                    last edited by

                    @tom-elliott
                    Hi,
                    Have run df -h and have space on all partitions.

                    Getting desperate now, need to image some machine for our new users. Any other ideas? What about exporting the Db and reinstalling?

                    Just need to find a way back to a working Fog install with my existing Db.
                    Thanks,

                    1 Reply Last reply Reply Quote 0
                    • C
                      CoxM
                      last edited by

                      This is my current apache2 log
                      0_1518694579851_fog8.JPG

                      1 Reply Last reply Reply Quote 0
                      • S
                        Sebastian Roth Moderator
                        last edited by Sebastian Roth

                        @CoxM The message ... Uncaught Error: Call to a member function lastInsertId() ... in the logs most certainly means that the database connection information set in /var/www/fog/lib/fog/config.class.php is not correct and therefore the PHP web UI cannot connect to the database!

                        Did you follow Tom’s suggestions on altering/resetting the database passwords (... mysql_native_password ...) as well as comparing the username/password in the mentioned files? Your answer to that was “No luck”. But what did you do and what happened. We can’t really help if we don’t know what exactly you tried and why it did not work from your point of view.

                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                        C 1 Reply Last reply Reply Quote 0
                        • C
                          CoxM @Sebastian Roth
                          last edited by

                          @sebastian-roth
                          Hi,
                          Sorry for the lack of useful feedback!
                          Here are the shots of both files, its worth noting that originally the mysql password in the class.php file was blank. I have since edited.
                          1_1518701676498_fog10.JPG 0_1518701676497_fog9.JPG

                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by

                            @CoxM Check the line snmysqlpass=... in .fogsettings. That’s the mysql database password. If it is blank leave it like that and change it back to blank in the config.class.php as well.

                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                            C 1 Reply Last reply Reply Quote 0
                            • C
                              CoxM @Sebastian Roth
                              last edited by

                              @sebastian-roth @Tom-Elliott
                              Thank you both so much, through a combination of things I have it working. you guys ROCK!

                              Thanks again!

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

                              134

                              Online

                              11.7k

                              Users

                              17.2k

                              Topics

                              154.7k

                              Posts
                              Copyright © 2012-2024 FOG Project