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

Reply via email to