Hi Richard,
The database is created when the slurmdbd is started. However, you need
to go through the step described in the documentation for mysql to add
permissions to your the userid that will connect to the database in order
for the creation to work. This is documented in the accounting.html and
man pages. You normally have to be root do this step. The example shows
grant all on slurm_acct_db.* to 'slurm'@'localhost';
where slurm_acct_db is the name of your database, slurm is the userid that
will connect to the database and localhost is the ip address of the node
that is running the database.
You also need a slurmdbd.conf file and the cluster name, ports, etc
defined in your slurm.conf. But, I believe the tables are built when the
slurmdbd is started.
Hope this helps,
Nancy
From: Richard Casey <[email protected]>
To: "slurm-dev" <[email protected]>,
Date: 01/17/2013 11:09 AM
Subject: [slurm-dev] When is database created?
Hi,
We installed slurm 2.5.1 with
rpmbuild -ta slurm*.tar.bz2
rpm --install <the rpm files>
All the rpm's are installed and we have slurmctld and slurmd running. We
installed munge and it works. The regression tests work. We installed
MySQL
and it's running. Now we're trying to add accounting. On the page
http://www.schedmd.com/slurmdocs/accounting.html
it says
"While SLURM will create the database automatically..."
However, we don't see at what step it creates the database? In MySQL show
databases doesn't list slurm_acct_db (we're just using defaults) so it's
not
clear how it's creating the database and of course tables.
