OK, installed the mariadb-devel package on the build host, and rebuilt the packages. I also had to change the rpm spec directive as follows:
%slurm_without_opt mysql --to-> %slurm_with_opt mysql The resulting "slurm-sql" package now has the "accounting_storage_mysql.so" file (as well as "jobcomp_mysql.so") that gets installed into /usr/lib64/slurm And once updated with the new package, the slurmdbd service now starts on the DB server. Thanks Giovanni! Will -----Original Message----- From: Torres, Giovanni [mailto:giovanni.tor...@nih.gov] Sent: Friday, December 23, 2016 1:52 PM To: slurm-dev Subject: [slurm-dev] RE: Cannot get SlurmDBD service running (missing mysql plugin) 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
