[slurm-users] Re: mariadb refusing access

5 Mar 2025


      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....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...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
--
slurm-users mailing list -- slurm-users@lists.schedmd.com
To unsubscribe send an email to slurm-users-leave@lists.schedmd.com

2025

2024

[slurm-users] Re: mariadb refusing access

MariaDB [(none)]>