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

    Cant access management portal

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    34
    7.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.
    • S
      Sebastian Roth Moderator
      last edited by

      @CoxM Yes mysql should definitely be running. What version of FOG and which Linux do you use? Please post the errors here and we sure can help.

      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 Here is what I am getting
        1_1517934440848_fog2.JPG 0_1517934440847_fog1.JPG image url)

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

          @coxm What’s 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
          • C
            CoxM @Tom Elliott
            last edited by

            @tom-elliott 0_1517937586714_fog3.JPG

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

              What’s output of systemctl status -l mysql

              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
              • C
                CoxM @Tom Elliott
                last edited by

                @tom-elliott 0_1518002804739_fog4.JPG

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

                  @Tom-Elliott I have ow had some progress, turns out MySQL wouldn’t start due to the local nic being disabled and therefore couldn’t bind. This is now resolved but still I get an empty white screen from the fog management url.

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

                    @CoxM Check the apache logs. See my signature on where to find those.

                    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
                      thanks for the help, I was out the office for a few days but back now and really need to get this sorted… Apache2 error…
                      0_1518606827689_fog5.JPG

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

                        @CoxM Check out this article in our wiki: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

                        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 2 Replies Last reply Reply Quote 0
                        • C
                          CoxM @Sebastian Roth
                          last edited by

                          @sebastian-roth Thanks, any pointers what to look for, there is alot of info on that link.

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

                            @sebastian-roth That doesn’t seem to have resolved it.
                            Do you think its still a mysql issue? The MySQL error appears to have gone away and the service has started. I ran the repair sql command but all came back with status of ok.

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

                              @CoxM But from the apache error look it seems like the mysql connection information (username, password) do not match. Check /opt/fog/.fogsettings plus /var/www/fog/lib/fog/config.class.php for mysql connection info. Then try to connect to the database using the command line tool as described in the wiki page to see if the credentials are correct.

                              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 ok cool, that makes sense. Where can I take the correct sql credentials from? .fogsettings?

                                Thanks,

                                Matt

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

                                  @CoxM Those all need to match up! .fogsettings is what the installer uses, config.class.php is used by the web UI… (and should be generated by the installer).

                                  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 3 Replies Last reply Reply Quote 0
                                  • C
                                    CoxM @Sebastian Roth
                                    last edited by

                                    @sebastian-roth Thanks. I did have some issues with username and password matching when configuring a new storage node but it still worked after that.

                                    I can see in .fogsettings I have the username and password field which appears to be what I use to login to the fog web ui. then there is snmysqluser, snmysqlpass and snmysqlhost. currently thats “root”, blank and “localhost”. Is that correct?

                                    Any further guidance this would be amazing.

                                    Thanks,

                                    Matt

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

                                      @sebastian-roth
                                      This is what happens when using the username “root” and the same password as I would use to log into the fog web ui
                                      0_1518622322448_fog6.JPG

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

                                        @sebastian-roth this is what I get, still in the mysql prompt use the fog database and get status
                                        0_1518622903325_fog7.JPG

                                        1 Reply Last reply Reply Quote 0
                                        • 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
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            249

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project