Building MySQL support within RPMs

Discussion:

Brian B

11 years ago

Greetings,

I am trying to setup my slurm setup to use MySQL. I installed via pre-compiled RPMs but I am having trouble actually loading the plugin as it isn’t being installed from he RPMs I currently have. I see documentation on how to include MySQL support when doing a source compile but not with making RPMs. Thank you for your help.

Regards,
Brian

Kilian Cavalotti

11 years ago

Permalink

Hi Brian,

Post by Brian B
I am trying to setup my slurm setup to use MySQL. I installed via pre-compiled RPMs but I am having trouble actually loading the plugin as it isn’t being installed from he RPMs I currently have. I see documentation on how to include MySQL support when doing a source compile but not with making RPMs. Thank you for your help.

I think that as long as the MySQL headers are installed on the node
you're compiling Slurm on, the configure script should pick them up
automatically.

# yum install mysql-devel
# rpmbuild -ta slurm-14.03.7.tar.bz2
[...]
Wrote: /root/rpmbuild/RPMS/x86_64/slurm-sql-14.03.7-1.el6.x86_64.rpm
[...]
# rpm -qlp /root/rpmbuild/RPMS/x86_64/slurm-sql-14.03.7-1.el6.x86_64.rpm
/usr/lib64/slurm
/usr/lib64/slurm/accounting_storage_mysql.so
/usr/lib64/slurm/jobcomp_mysql.so

Cheers,

--
Kilian

Brian B

11 years ago

Permalink

Hello Killian,

Thank you for the info. That seems to have worked. I was confused as the “slurm-sql” package was built.

Regards,
Brian

...

Trey Dockendorf

11 years ago

Permalink

Brian,

If it's at all helpful, below are some of the options I use to build SLURM on CentOS 6.5 using mock.

$ mock/epel-6-x86_64.cfg
config_opts['root'] = 'slurm'
config_opts['target_arch'] = 'x86_64'
config_opts['legal_host_arches'] = ('x86_64',)
config_opts['chroot_setup_cmd'] = 'install @buildsys-build blcr blcr-devel hwloc-devel numactl-devel libibmad-devel freeipmi-devel rrdtool-devel glib2-devel gtk2-devel man'
config_opts['dist'] = 'el6' # only useful for --resultdir variable subst
config_opts['cleanup_on_success'] = 0
config_opts['cleanup_on_failure'] = 0

config_opts['yum.conf'] = """
# the usual lines plus an internal repo containing BLCR RPMs

"""

I haven't gotten around to cleaning up my build process so it's useful to others than myself, but see this gist https://gist.github.com/treydock/ed5cd81978cbb838cf88.

It assumes you've copied /etc/mock (particularly default.cfg, logging.ini and site-defaults.cfg) into same directory as the script, and modified the one I mentioned above to build slurm.

I typically do something like

$ ./build.sh --extract-spec 14.03.6
# modify spec - typically just Release number if I changed something (like add BLCR support)
$ ./build.sh --mock 14.03.6

- Trey

=============================

Trey Dockendorf
Systems Analyst I
Texas A&M University
Academy for Advanced Telecommunications and Learning Technologies
Phone: (979)458-2396
Email: treydock-mRW4Vj+***@public.gmane.org
Jabber: treydock-mRW4Vj+***@public.gmane.org

----- Original Message -----

...