In the logs I am seeing, root@vuwunicoslurmd3 mariadb]# tail -f mariadb.log 2025-03-04 19:01:32 12565 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES) 2025-03-04 19:06:19 12566 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES) However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd Any ideas please? regards Steven
On 3/4/25 5:23 pm, Steven Jones via slurm-users wrote:
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
Try: mysql -h 127.0.0.1 -u slurm -p IIRC without that it'll try a UNIX domain socket and not try and connect via TCP/IP. -- Chris Samuel : http://www.csamuel.org/ : Berkeley, CA, USA
I had already tried that but here it is, looks OK to me. ====== [root@vuwunicoslurmd3 slurm]# mysql -h 127.0.0.1 -u slurm -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 12583 Server version: 10.11.10-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | slurm_acct_db | +--------------------+ 2 rows in set (0.000 sec) MariaDB [(none)]> ======== regards Steven ________________________________ From: Christopher Samuel via slurm-users <slurm-users@lists.schedmd.com> Sent: Wednesday, 5 March 2025 2:51 pm To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com> Subject: [slurm-users] Re: mariadb refusing access On 3/4/25 5:23 pm, Steven Jones via slurm-users wrote:
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
Try: mysql -h 127.0.0.1 -u slurm -p IIRC without that it'll try a UNIX domain socket and not try and connect via TCP/IP. -- Chris Samuel : https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.csamuel.org%2F&data=05%7C02%7Csteven.jones%40vuw.ac.nz%7C9e6208744a254ba3d31008dd5b898069%7Ccfe63e236951427e8683bb84dcf1d20c%7C0%7C0%7C638767368335219563%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=zi7ay%2B%2FO85t1MKA%2BB6e463Nku1aa0auoTkkdRHLBNJo%3D&reserved=0<http://www.csamuel.org/> : Berkeley, CA, USA -- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
Hi, Check your /etc/hosts file for localhost definition. I would guess it is not only 127.0.0.1. I think you have IPv6 ::1 address too. If so, try connect using 172.0.0.1 and add a GRANT with the same password for 'slurm'@'::1'; That will allow connections using IPv4 and IPv6 loopback address. Cordialement / Best regards, Sébastien VIGNERON CRIANN, Ingénieur / Engineer Technopôle du Madrillet 745, avenue de l'Université 76800 Saint-Etienne du Rouvray - France tél.☎️ +33 2 32 91 42 91 fax. +33 2 32 91 42 92 http://www.criann.fr mailto:sebastien.vigneron@criann.fr support: support@criann.fr
Le 5 mars 2025 à 03:04, Steven Jones via slurm-users <slurm-users@lists.schedmd.com> a écrit :
I had already tried that but here it is, looks OK to me.
====== [root@vuwunicoslurmd3 slurm]# mysql -h 127.0.0.1 -u slurm -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 12583 Server version: 10.11.10-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | slurm_acct_db | +--------------------+ 2 rows in set (0.000 sec)
MariaDB [(none)]> ========
regards Steven From: Christopher Samuel via slurm-users <slurm-users@lists.schedmd.com> Sent: Wednesday, 5 March 2025 2:51 pm To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com> Subject: [slurm-users] Re: mariadb refusing access On 3/4/25 5:23 pm, Steven Jones via slurm-users wrote:
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
Try:
mysql -h 127.0.0.1 -u slurm -p
IIRC without that it'll try a UNIX domain socket and not try and connect via TCP/IP.
-- Chris Samuel : https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.csamuel... : Berkeley, CA, USA
-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
Hi, [root@vuwunicoslurmd3 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 130.195.19.159 vuwunicoslurmd3.ods.vuw.ac.nz vuwunicoslurmd3 [root@vuwunicoslurmd3 ~]# regards Steven ________________________________ From: Sébastien VIGNERON <sebastien.vigneron@criann.fr> Sent: Wednesday, 5 March 2025 9:29 pm To: Steven Jones <steven.jones@vuw.ac.nz> Cc: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com>; Christopher Samuel <chris@csamuel.org> Subject: Re: [slurm-users] mariadb refusing access [You don't often get email from sebastien.vigneron@criann.fr. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] Hi, Check your /etc/hosts file for localhost definition. I would guess it is not only 127.0.0.1. I think you have IPv6 ::1 address too. If so, try connect using 172.0.0.1 and add a GRANT with the same password for 'slurm'@'::1'; That will allow connections using IPv4 and IPv6 loopback address. Cordialement / Best regards, Sébastien VIGNERON CRIANN, Ingénieur / Engineer Technopôle du Madrillet 745, avenue de l'Université 76800 Saint-Etienne du Rouvray - France tél.☎️ +33 2 32 91 42 91 fax. +33 2 32 91 42 92 https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.criann.fr%2F&data=05%7C02%7Csteven.jones%40vuw.ac.nz%7C007dc22ebe914e990c0108dd5bbfe1a7%7Ccfe63e236951427e8683bb84dcf1d20c%7C0%7C0%7C638767601906179159%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=ftjvWgl31qZshJG0jrIp4Knc%2FsHzUfvDSRzeJomJ9bI%3D&reserved=0<http://www.criann.fr/> mailto:sebastien.vigneron@criann.fr support: support@criann.fr
Le 5 mars 2025 à 03:04, Steven Jones via slurm-users <slurm-users@lists.schedmd.com> a écrit :
I had already tried that but here it is, looks OK to me.
====== [root@vuwunicoslurmd3 slurm]# mysql -h 127.0.0.1 -u slurm -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 12583 Server version: 10.11.10-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | slurm_acct_db | +--------------------+ 2 rows in set (0.000 sec)
MariaDB [(none)]> ========
regards Steven From: Christopher Samuel via slurm-users <slurm-users@lists.schedmd.com> Sent: Wednesday, 5 March 2025 2:51 pm To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com> Subject: [slurm-users] Re: mariadb refusing access On 3/4/25 5:23 pm, Steven Jones via slurm-users wrote:
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
Try:
mysql -h 127.0.0.1 -u slurm -p
IIRC without that it'll try a UNIX domain socket and not try and connect via TCP/IP.
-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
On 3/5/25 02:23, Steven Jones via slurm-users wrote:
In the logs I am seeing,
root@vuwunicoslurmd3 mariadb]# tail -f mariadb.log 2025-03-04 19:01:32 12565 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES) 2025-03-04 19:06:19 12566 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES)
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
It seems that you didn't select a suitable slurm user’s database password, see https://wiki.fysik.dtu.dk/Niflheim_system/Slurm_database/#set-up-mariadb-dat... IHTH, Ole
Sorry, I dont follow you, Pass word works fine and grant looks OK. [root@vuwunicoslurmd3 ~]# mysql -u slurm -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 208 Server version: 10.11.10-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show grants; +--------------------------------------------------------------------------------------------------------------+ | Grants for slurm@localhost | +--------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `slurm`@`localhost` IDENTIFIED BY PASSWORD '*2F4EEC707189D8B5E329829B9303058EF7585569' | | GRANT ALL PRIVILEGES ON `slurm_acct_db`.* TO `slurm`@`localhost` | +--------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.000 sec) MariaDB [(none)]> Isnt there something about password encryption / password hash? regards Steven ________________________________ From: Ole Holm Nielsen via slurm-users <slurm-users@lists.schedmd.com> Sent: Wednesday, 5 March 2025 9:25 pm To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com> Subject: [slurm-users] Re: mariadb refusing access On 3/5/25 02:23, Steven Jones via slurm-users wrote:
In the logs I am seeing,
root@vuwunicoslurmd3 mariadb]# tail -f mariadb.log 2025-03-04 19:01:32 12565 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES) 2025-03-04 19:06:19 12566 [Warning] Access denied for user 'slurm'@'localhost' (using password: YES)
However mysql -u slurm -p works just fine so it seems to be a config error for slurmdbd
It seems that you didn't select a suitable slurm user’s database password, see https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.fysik... IHTH, Ole -- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com
participants (4)
-
Christopher Samuel -
Ole Holm Nielsen -
Steven Jones -
Sébastien VIGNERON