[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
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.org%2F&data=05%7C02%7Csteven.jones%40vuw.ac.nz%7C007dc22ebe914e990c0108dd5bbfe1a7%7Ccfe63e236951427e8683bb84dcf1d20c%7C0%7C0%7C638767601906202750%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=ithr%2FHxdN5w0npKMhJQNEvCG8di%2BNsQH%2BrPRm1M3t0w%3D&reserved=0
: 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