New subject: mariadb refusing access

5 Mar 2025


      Yes that is set, and my settings are,
# slurmDBD info
DbdAddr=localhost
DbdHost=vuwunicoslurmd3.ods.vuw.ac.nz
#DbdHost=localhost
DbdPort=6819
SlurmUser=slurm
#MessageTimeout=300
DebugLevel=verbose
#DefaultQOS=normal,standby
LogFile=/var/log/slurm/slurmdbd.log
PidFile=/var/run/slurmdbd/slurmdbd.pid
#PluginDir=/usr/lib/slurm
#PrivateData=accounts,users,usage,jobs
#TrackWCKey=yes
#
# Database info
StorageType=accounting_storage/mysql
#StorageHost=localhost
StorageHost=localhost
#StoragePort=1234
#StoragePort=3306
StoragePass=xxxxxxxx
StorageUser=slurm
StorageLoc=slurm_acct_db
#ssj
regards
Steven
________________________________
From: Sarlo, Jeffrey S JSarlo@Central.UH.EDU
Sent: Thursday, 6 March 2025 7:42 am
To: Steven Jones steven.jones@vuw.ac.nz
Subject: RE: [slurm-users] Re: mariadb refusing access
You don't often get email from jsarlo@central.uh.edu. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification
Do you have the correct password listed in the slurmdbd.conf file?  That was toward the bottom of the Wiki that Ole sent.
Jeff
From: Steven Jones via slurm-users slurm-users@lists.schedmd.com
Sent: Wednesday, March 5, 2025 12:39 PM
To: slurm-users@lists.schedmd.com; Ole Holm Nielsen Ole.H.Nielsen@fysik.dtu.dk
Subject: [slurm-users] Re: mariadb refusing access
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.commailto:slurm-users@lists.schedmd.com>
Sent: Wednesday, 5 March 2025 9:25 pm
To: slurm-users@lists.schedmd.commailto:slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.commailto: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...https://urldefense.com/v3/__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__;JSUlJSUlJSUlJSUlJSUlJSUlJSUlJSUlJSUl!!LkSTlj0I!Gxp9Yh3QmkllJPNtRmlEmVWti3Me866Nvmrk23HCyYI8ctqFXvRmVLXVyjN-pvkm3AK1bBuef1c5pmZJzoZ3Vg_ujX37dg$
IHTH,
Ole
--
slurm-users mailing list -- slurm-users@lists.schedmd.commailto:slurm-users@lists.schedmd.com
To unsubscribe send an email to slurm-users-leave@lists.schedmd.commailto:slurm-users-leave@lists.schedmd.com