Slurm's build system skips building whatever optional pieces it doesn't
find packages for. You might want to check the output of the
./configure stage to see what else it skipped. As another example to
what you have seen, I'll bet your rpmuild didn't give you a slurm-lua
RPM unless you happen to have installed lua-devel already.
--
Jeff White
HPC Systems Engineer
Information Technology Services - WSU
On 12/23/2016 10:50 AM, Torres, Giovanni wrote:
Yup. Install the devel package and rebuild and you should have that
accounting_storage_mysql.so file.
Here is the relevant bit from the spec file:
%define use_mysql_devel %(perl -e '`rpm -q mariadb-devel`; print $?;')
%if %{slurm_with mysql}
%if %{use_mysql_devel}
BuildRequires: mysql-devel >= 5.0.0
%else
BuildRequires: mariadb-devel >= 5.0.0
%endif
%endif
So, without mysql-devel or mariadb-devel, slurm will not be built with the
mysql option.
Hope that helps.
- Giovanni
________________________
From: Will Dennis [wden...@nec-labs.com]
Sent: Friday, December 23, 2016 1:43 PM
To: slurm-dev
Subject: [slurm-dev] RE: Cannot get SlurmDBD service running (missing mysql
plugin)
Just checked, and no... just "mariadb-libs" is installed on the build host...
Install mariadb-devel & rebuild/repackage?
-----Original Message-----
From: Torres, Giovanni [mailto:giovanni.tor...@nih.gov]
Sent: Friday, December 23, 2016 1:35 PM
To: slurm-dev
Subject: [slurm-dev] RE: Cannot get SlurmDBD service running (missing mysql
plugin)
Hi Will,
Did you have the mariadb-devel package installed when you built the RPMs?
- Giovanni
________________________________________
From: Will Dennis [wden...@nec-labs.com]
Sent: Friday, December 23, 2016 1:21 PM
To: slurm-dev
Subject: [slurm-dev] Cannot get SlurmDBD service running (missing mysql plugin)
Hi all,
New Slurm user here, trying to get a Slurm 16.05.4 installation up and running
for a compute cluster I admin… We have a basic Slurm/Munge installation up and
running (one head node and a few compute nodes), and trying to configure it as
we desire.
My current task is to get slurmdbd running on a host, so I can utilize the
fair-share factor in the multifactor priority plugin. This host only runs MySQL
(MariaDB) and SlurmDBD, and is not otherwise associated with the compute
cluster. It is running CentOS 7.3.1611, and has the following RPMs installed
(which I built from sources via ‘rpmbuild’):
slurm-16.05.4-1.el7.centos.x86_64
slurm-munge-16.05.4-1.el7.centos.x86_64
slurm-plugins-16.05.4-1.el7.centos.x86_64
slurm-slurmdbd-16.05.4-1.el7.centos.x86_64
slurm-sql-16.05.4-1.el7.centos.x86_64
My slurmdbd.conf file has the following directives:
AuthType=auth/munge
AuthInfo=/var/run/munge/munge.socket.2
DbdAddr=localhost
DbdHost=localhost
SlurmUser=slurm
DebugLevel=4
LogFile=/var/log/slurm/slurmdbd.log
PidFile=/var/run/slurmdbd.pid
StorageType=accounting_storage/mysql
StorageHost=localhost
StoragePass=XXXXXXXX
StorageUser=slurm
StorageLoc=slurm_acctg_db
The “slurm_acctg_db” has been created, the “slurm” db user created with
appropriate grants, and the DB server is up and running.
However, when I try to start up the slurmdbd service, it fails to start, and I
see the following sort of output in the slurmdbd.log:
[2016-12-23T12:30:00.446] error: Couldn't find the specified plugin name for
accounting_storage/mysql looking at all files [2016-12-23T12:30:00.446] error:
cannot find accounting_storage plugin for accounting_storage/mysql
[2016-12-23T12:30:00.446] error: cannot create accounting_storage context for
accounting_storage/mysql [2016-12-23T12:30:00.446] fatal: Unable to initialize
accounting_storage/mysql accounting storage plugin
The files in the "slurm-plugins” RPM package are as follows:
/usr/lib64/slurm/accounting_storage_filetxt.so
/usr/lib64/slurm/accounting_storage_none.so
/usr/lib64/slurm/accounting_storage_slurmdbd.so
/usr/lib64/slurm/acct_gather_energy_cray.so
/usr/lib64/slurm/acct_gather_energy_ibmaem.so
/usr/lib64/slurm/acct_gather_energy_none.so
/usr/lib64/slurm/acct_gather_energy_rapl.so
/usr/lib64/slurm/acct_gather_filesystem_lustre.so
/usr/lib64/slurm/acct_gather_filesystem_none.so
/usr/lib64/slurm/acct_gather_infiniband_none.so
/usr/lib64/slurm/acct_gather_profile_none.so
/usr/lib64/slurm/burst_buffer_generic.so
/usr/lib64/slurm/checkpoint_none.so
/usr/lib64/slurm/checkpoint_ompi.so
/usr/lib64/slurm/core_spec_cray.so
/usr/lib64/slurm/core_spec_none.so
/usr/lib64/slurm/crypto_openssl.so
/usr/lib64/slurm/ext_sensors_none.so
/usr/lib64/slurm/ext_sensors_rrd.so
/usr/lib64/slurm/gres_gpu.so
/usr/lib64/slurm/gres_mic.so
/usr/lib64/slurm/gres_nic.so
/usr/lib64/slurm/job_container_cncu.so
/usr/lib64/slurm/job_container_none.so
/usr/lib64/slurm/job_submit_all_partitions.so
/usr/lib64/slurm/job_submit_cray.so
/usr/lib64/slurm/job_submit_require_timelimit.so
/usr/lib64/slurm/job_submit_throttle.so
/usr/lib64/slurm/jobacct_gather_aix.so
/usr/lib64/slurm/jobacct_gather_cgroup.so
/usr/lib64/slurm/jobacct_gather_linux.so
/usr/lib64/slurm/jobacct_gather_none.so
/usr/lib64/slurm/jobcomp_filetxt.so
/usr/lib64/slurm/jobcomp_none.so
/usr/lib64/slurm/jobcomp_script.so
/usr/lib64/slurm/launch_slurm.so
/usr/lib64/slurm/layouts_power_cpufreq.so
/usr/lib64/slurm/layouts_power_default.so
/usr/lib64/slurm/layouts_unit_default.so
/usr/lib64/slurm/mcs_group.so
/usr/lib64/slurm/mcs_none.so
/usr/lib64/slurm/mcs_user.so
/usr/lib64/slurm/mpi_lam.so
/usr/lib64/slurm/mpi_mpich1_p4.so
/usr/lib64/slurm/mpi_mpich1_shmem.so
/usr/lib64/slurm/mpi_mpichgm.so
/usr/lib64/slurm/mpi_mpichmx.so
/usr/lib64/slurm/mpi_mvapich.so
/usr/lib64/slurm/mpi_none.so
/usr/lib64/slurm/mpi_openmpi.so
/usr/lib64/slurm/mpi_pmi2.so
/usr/lib64/slurm/power_none.so
/usr/lib64/slurm/preempt_job_prio.so
/usr/lib64/slurm/preempt_none.so
/usr/lib64/slurm/preempt_partition_prio.so
/usr/lib64/slurm/preempt_qos.so
/usr/lib64/slurm/priority_basic.so
/usr/lib64/slurm/priority_multifactor.so
/usr/lib64/slurm/proctrack_cgroup.so
/usr/lib64/slurm/proctrack_linuxproc.so
/usr/lib64/slurm/proctrack_pgid.so
/usr/lib64/slurm/route_default.so
/usr/lib64/slurm/route_topology.so
/usr/lib64/slurm/sched_backfill.so
/usr/lib64/slurm/sched_builtin.so
/usr/lib64/slurm/sched_hold.so
/usr/lib64/slurm/sched_wiki.so
/usr/lib64/slurm/sched_wiki2.so
/usr/lib64/slurm/select_alps.so
/usr/lib64/slurm/select_bluegene.so
/usr/lib64/slurm/select_cons_res.so
/usr/lib64/slurm/select_cray.so
/usr/lib64/slurm/select_linear.so
/usr/lib64/slurm/select_serial.so
/usr/lib64/slurm/slurmctld_nonstop.so
/usr/lib64/slurm/switch_cray.so
/usr/lib64/slurm/switch_generic.so
/usr/lib64/slurm/switch_none.so
/usr/lib64/slurm/task_affinity.so
/usr/lib64/slurm/task_cgroup.so
/usr/lib64/slurm/task_cray.so
/usr/lib64/slurm/task_none.so
/usr/lib64/slurm/topology_3d_torus.so
/usr/lib64/slurm/topology_hypercube.so
/usr/lib64/slurm/topology_node_rank.so
/usr/lib64/slurm/topology_none.so
/usr/lib64/slurm/topology_tree.so
I see there is not a "/usr/lib64/slurm/accounting_storage_mysql.so” file
(guessing at the name here) in the list; how can I go about getting (building) the
missing plugin?
Thanks all!
Will
