Access denied for root@localhost

Sebastian Roth

Still getting the same issues

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

Hanz

 * 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

Sebastian Roth

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

Quazz

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

Quazz

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

ITCC

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

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

Quazz

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

Sebastian Roth

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

NSmith

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

Wayne Workman

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

Sebastian Roth

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

Wayne Workman

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

Sebastian Roth

@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

Access denied for root@localhost

293

11.6k

17.1k

154.6k