Access denied for root@localhost
-
@Quazz said:
Still getting the same issues
Which issues/errors exactly? The mysql 5.7 stuff or what?
-
* 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 BTWProcessor usage is pegged at 100 for all four cores as well as many many httpd processes
-
@Hanz I cannot see how this is related to the topic of Ubuntu 16.04 mysql issues!?! Please help me.
-
@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)
-
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
-
you should dump Ubuntu for this:
https://www.turnkeylinux.org/lampstackinstall is SO easy and the features of the stack are good too.
-
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…)
-
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
-
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 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. -
@Sebastian-Roth Is there any way to address this in the installer so that it works out of the box for Ubuntu 16?
-
@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