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?
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.dtu.dk%2FNiflheim_system%2FSlurm_database%2F%23set-up-mariadb-database&data=05%7C02%7Csteven.jones%40vuw.ac.nz%7C56b95182b57d4019d31708dd5bc24a33%7Ccfe63e236951427e8683bb84dcf1d20c%7C0%7C0%7C638767612299485227%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=HxKEeO4mU%2BSJwPX%2Bi72TWfV0bMIya9DN2uX802eO%2BAQ%3D&reserved=0
IHTH,
Ole
--
slurm-users mailing list -- slurm-users@lists.schedmd.com
To unsubscribe send an email to slurm-users-leave@lists.schedmd.com