Hi Jeff, Hmmm... I don't have a "slurm-lua" package built in the RPMS directory, but I do have the "lua-devel" package installed on the build host... But I did not pass the "--with lua" flag to rpmbuild, perhaps that's why?
Will -----Original Message----- From: Jeff White [mailto:jeff.wh...@wsu.edu] Sent: Friday, December 23, 2016 4:10 PM To: slurm-dev Subject: [slurm-dev] RE: Cannot get SlurmDBD service running (missing mysql plugin) 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