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

Access denied for root@localhost

Scheduled Pinned Locked Moved
Linux Problems
8
30
22.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.
  • T
    Tom Elliott @Quazz
    last edited by Apr 27, 2016, 12:04 PM

    @Quazz Sounds, to me, that you may need to install php7.0-mbstring?

    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

    Q 2 Replies Last reply Apr 27, 2016, 12:58 PM Reply Quote 1
    • Q
      Quazz Moderator @Tom Elliott
      last edited by Apr 27, 2016, 12:58 PM

      @Tom-Elliott It was indeed not installed! Installation now completes!

      Still getting the same issues as before on the webui however, which I’m guessing has a lot to do with php7 and less with anything else?

      1 Reply Last reply Reply Quote 0
      • Q
        Quazz Moderator @Tom Elliott
        last edited by Apr 27, 2016, 1:05 PM

        @Tom-Elliott Tried to update to 7334.

        Installer fails to update the database. No errors to be found in the installer error logs.

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Apr 27, 2016, 1:34 PM

          @Quazz said:

          Still getting the same issues

          Which issues/errors exactly? The mysql 5.7 stuff or what?

          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

          H Q 2 Replies Last reply Apr 27, 2016, 1:37 PM Reply Quote 0
          • H
            Hanz @Sebastian Roth
            last edited by Hanz Apr 27, 2016, 7:47 AM Apr 27, 2016, 1:37 PM

            @Sebastian-Roth

             * Backing up database.........................................OK
             * Updating Database...........................................Failed!
            [bcs@fog-server bin]$ 
            

            Updating consistently fails
            and web ui is not working.

            The 10.72.3.50 page isn’t working
            
            10.72.3.50 is currently unable to handle this request.
            500
            
            bcs@fog-server ~]$ sudo mysqlcheck -r fog
            [sudo] password for bcs: 
            mysqlcheck: Got error: 1040: Too many connections when trying to connect
            [bcs@fog-server ~]$ 
            

            max_connections set to 2500 in /etc/my.cnf
            Possibly connections not closing correctly ?
            Updates on nodes worked flawlessly BTW

            Processor usage is pegged at 100 for all four cores as well as many many httpd processes

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Apr 27, 2016, 1:45 PM

              @Hanz I cannot see how this is related to the topic of Ubuntu 16.04 mysql issues!?! Please help me.

              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

              1 Reply Last reply Reply Quote 0
              • Q
                Quazz Moderator @Sebastian Roth
                last edited by Apr 27, 2016, 1:48 PM

                @Sebastian-Roth Unable to create tasks, no fog settings being displayed, the php error spam.

                Mysql seems to work fine now (assuming it’s not causing the other issues that is)

                1 Reply Last reply Reply Quote 0
                • Q
                  Quazz Moderator
                  last edited by Quazz Apr 27, 2016, 9:08 AM Apr 27, 2016, 3:06 PM

                  Images are unable to deploy (input/output error).

                  
                  [Wed Apr 27 17:02:54.713022 2016] [:error] [pid 9551] [client 192.168.1.73:55204] PHP Fatal error:  Uncaught Error: Call to a member function get() on null in /var/www/fog/lib/fog/bootmenu.class.php:380\nStack trace:\n#0 /var/www/fog/lib/fog/bootmenu.class.php(565): BootMenu->falseTasking('', Object(Image))\n#1 /var/www/fog/lib/fog/bootmenu.class.php(538): BootMenu->setTasking('12')\n#2 /var/www/fog/lib/fog/bootmenu.class.php(128): BootMenu->verifyCreds()\n#3 [internal function]: BootMenu->__construct(Object(Host))\n#4 /var/www/fog/lib/fog/fogbase.class.php(89): ReflectionClass->newInstance(Object(Host))\n#5 /var/www/fog/service/ipxe/boot.php(14): FOGBase::getClass('BootMenu', Object(Host))\n#6 {main}\n  thrown in /var/www/fog/lib/fog/bootmenu.class.php on line 380
                  [Wed Apr 27 17:05:12.363397 2016] [:error] [pid 6003] [client 192.168.1.73:43795] PHP Fatal error:  Uncaught Error: Call to a member function get() on null in /var/www/fog/lib/fog/bootmenu.class.php:380\nStack trace:\n#0 /var/www/fog/lib/fog/bootmenu.class.php(565): BootMenu->falseTasking('', Object(Image))\n#1 /var/www/fog/lib/fog/bootmenu.class.php(538): BootMenu->setTasking('12')\n#2 /var/www/fog/lib/fog/bootmenu.class.php(128): BootMenu->verifyCreds()\n#3 [internal function]: BootMenu->__construct(Object(Host))\n#4 /var/www/fog/lib/fog/fogbase.class.php(89): ReflectionClass->newInstance(Object(Host))\n#5 /var/www/fog/service/ipxe/boot.php(14): FOGBase::getClass('BootMenu', Object(Host))\n#6 {main}\n  thrown in /var/www/fog/lib/fog/bootmenu.class.php on line 380
                  [Wed Apr 27 17:06:28.521520 2016] [:error] [pid 8828] [client 192.168.1.73:6592] PHP Fatal error:  Uncaught Error: Call to a member function get() on null in /var/www/fog/lib/fog/bootmenu.class.php:380\nStack trace:\n#0 /var/www/fog/lib/fog/bootmenu.class.php(565): BootMenu->falseTasking('', Object(Image))\n#1 /var/www/fog/lib/fog/bootmenu.class.php(538): BootMenu->setTasking('12')\n#2 /var/www/fog/lib/fog/bootmenu.class.php(128): BootMenu->verifyCreds()\n#3 [internal function]: BootMenu->__construct(Object(Host))\n#4 /var/www/fog/lib/fog/fogbase.class.php(89): ReflectionClass->newInstance(Object(Host))\n#5 /var/www/fog/service/ipxe/boot.php(14): FOGBase::getClass('BootMenu', Object(Host))\n#6 {main}\n  thrown in /var/www/fog/lib/fog/bootmenu.class.php on line 380
                  

                  The other php errors have no longer showed up since Tom’s tomfoolery

                  1 Reply Last reply Reply Quote 0
                  • I
                    ITCC
                    last edited by Apr 28, 2016, 6:50 AM

                    you should dump Ubuntu for this:
                    https://www.turnkeylinux.org/lampstack

                    install is SO easy and the features of the stack are good too.

                    1 Reply Last reply Reply Quote 0
                    • Q
                      Quazz Moderator
                      last edited by Quazz Apr 28, 2016, 3:56 AM Apr 28, 2016, 9:26 AM

                      Added subnet to evasive mod whitelist to get rid off a bunch of stupid errors (it kept on blocking getfiles.php)

                      Perhaps worth noting that both php7.0-mbstring and php-mbstring exist and are in fact different packages. (why…)

                      1 Reply Last reply Reply Quote 0
                      • S
                        Sebastian Roth Moderator
                        last edited by Apr 30, 2016, 4:20 PM

                        I think we need to face 16.04 at some point to I am trying to get a wiki article together: https://wiki.fogproject.org/wiki/index.php?title=Ubuntu_16.04

                        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

                        1 Reply Last reply Reply Quote 0
                        • N
                          NSmith @Quazz
                          last edited by May 13, 2016, 3:32 PM

                          I found the solution for me in this article: https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/

                          basically comes down to the following as the fix :

                          sudo mysql -u root
                          ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
                          exit

                          W 1 Reply Last reply May 13, 2016, 6:17 PM Reply Quote 0
                          • W
                            Wayne Workman @NSmith
                            last edited by May 13, 2016, 6:17 PM

                            @NSmith that’s in our wiki. https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#MySQL_credentials_for_FOG_Main_and_Storage_Nodes

                            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!
                            Daily Clean Installation Results:
                            https://fogtesting.fogproject.us/
                            FOG Reporting:
                            https://fog-external-reporting-results.fogproject.us/

                            1 Reply Last reply Reply Quote 0
                            • S
                              Sebastian Roth Moderator
                              last edited by Sebastian Roth May 13, 2016, 3:54 PM May 13, 2016, 9:54 PM

                              @Wayne-Workman Sorry, but that’s a bit of a different story as Ubuntu 16.04 comes with MySQL 5.7 which defaults to something called auth_socket in contrast to normal tcp localhost socket connection.

                              Issue and solution are known and documented here and here.

                              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

                              W 1 Reply Last reply May 13, 2016, 10:00 PM Reply Quote 0
                              • W
                                Wayne Workman @Sebastian Roth
                                last edited by May 13, 2016, 10:00 PM

                                @Sebastian-Roth Is there any way to address this in the installer so that it works out of the box for Ubuntu 16?

                                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!
                                Daily Clean Installation Results:
                                https://fogtesting.fogproject.us/
                                FOG Reporting:
                                https://fog-external-reporting-results.fogproject.us/

                                S 1 Reply Last reply May 13, 2016, 10:04 PM Reply Quote 0
                                • S
                                  Sebastian Roth Moderator @Wayne Workman
                                  last edited by May 13, 2016, 10:04 PM

                                  @Wayne-Workman Yes, force people to set a MySQL root password when installing. But it would still fail if people have MySQL server pre-installed (with empty password)… Other than that I don’t think we have any chance to hook into the auth_socket thing. See if you can find anything related to php and auth_socket

                                  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

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

                                  222

                                  Online

                                  12.2k

                                  Users

                                  17.3k

                                  Topics

                                  155.5k

                                  Posts
                                  Copyright © 2012-2024 FOG Project