[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Nancy Kritkausky
ectly, Nancy -Original Message- From: Charles Johnson [mailto:charles.john...@accre.vanderbilt.edu] Sent: Friday, October 31, 2014 11:02 To: slurm-dev Subject: [slurm-dev] Re: Database incompletely configured On 10/31/2014 12:49 PM, David Bigagli wrote: > The database is created by the

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Charles Johnson
On 10/31/2014 01:25 PM, Nancy Kritkausky wrote: sacctmgr add cluster snowflake sacctmgr add account none,test Cluster=snowflake \ Description="none" Organization="none" sacctmgr add user da DefaultAccount=test With a change in names to "protect the innocent", that was done. Thank you. Ch

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Nancy Kritkausky
[mailto:charles.john...@accre.vanderbilt.edu] Sent: Friday, October 31, 2014 11:19 To: slurm-dev Subject: [slurm-dev] Re: Database incompletely configured On 10/31/2014 01:11 PM, David Bigagli wrote: > If you want Slurm to create the database itself, and any future > databases, you have to ch

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Nancy Kritkausky
Yes, it should... always has for me anyway. : ) -Original Message- From: Charles Johnson [mailto:charles.john...@accre.vanderbilt.edu] Sent: Friday, October 31, 2014 11:19 To: slurm-dev Subject: [slurm-dev] Re: Database incompletely configured On 10/31/2014 01:11 PM, David Bigagli

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Charles Johnson
On 10/31/2014 01:11 PM, David Bigagli wrote: If you want Slurm to create the database itself, and any future databases, you have to change your grant line to be *.* instead of slurm_acct_db.*. Otherwise you have to create the database as root. mysql> create database slurm_acct_db; I am so

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread David Bigagli
If you want Slurm to create the database itself, and any future databases, you have to change your grant line to be *.* instead of slurm_acct_db.*. Otherwise you have to create the database as root. mysql> create database slurm_acct_db; On 10/31/2014 11:01 AM, Charles Johnson wrote: On 1

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread Charles Johnson
On 10/31/2014 12:49 PM, David Bigagli wrote: The database is created by the slurmdbd daemon. Have you granted access to the database to the slurm user? Yes, I did a grant all on slurm_acct_db.* TO 'slurm'@'localhost'; -- Charles Johnson, Vanderbilt University Advanced Computing Center for R

[slurm-dev] Re: Database incompletely configured

2014-10-31 Thread David Bigagli
The database is created by the slurmdbd daemon. Have you granted access to the database to the slurm user? Here is the relevant documentation how to set the db up: http://slurm.schedmd.com/accounting.html On 10/31/2014 10:41 AM, Charles Johnson wrote: Slurm Version: 14.03.9 MariaDB Versio