Access denied for root@localhost

[Quazz]

@Tom-Elliott Tried to update to 7334.

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

[Sebastian Roth]

@Quazz said:

Still getting the same issues

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

[Hanz]

@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

[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