[slurm-users] problems building slurm with MariaDB 10.4

[Rodrigo Santibáñez]

Hello Jeffrey,

I installed slurm 17.02.11 a week ago for centOS7 and I followed the
instructions here https://wiki.fysik.dtu.dk/niflheim/Slurm_installation

You could install MariaDB (I installed v10.4) with their repo and gpgkey
with instructions here https://mariadb.com/kb/en/yum/

Then, you could build the slurm rpms with (change the version to match
yours):

export VER=20.02.2-1
rpmbuild -ta slurm-$VER.tar.bz2 --with mysql      # Includes accounting
support with the slurm-slurmdbd package

To create the database, I followed the instructions here
https://github.com/mknoxnv/ubuntu-slurm:

$ systemctl enable mysql
$ systemctl start mysql
$ mysql -u root
create database slurm_acct_db;
create user 'slurm'@'localhost';
set password for 'slurm'@'localhost' = password('slurmdbpass');
grant usage on *.* to 'slurm'@'localhost';
grant all privileges on slurm_acct_db.* to 'slurm'@'localhost';
flush privileges;
exit

Feel free to ask for more information,
Best regards


El mar., 2 jun. 2020 a las 11:47, Jeffrey McDonald (<jmcdonal at umn.edu>)
escribió:
>
> Hi,
> I'm trying to build the slurm rpms on a Centos 7.8  system with the
> mariadb 10.4 RPMs,
> # rpm -qa | grep -i mariadb:
>
> MariaDB-common-10.4.13-1.el7.centos.x86_64
> MariaDB-server-10.4.13-1.el7.centos.x86_64
> MariaDB-compat-10.4.13-1.el7.centos.x86_64
> MariaDB-client-10.4.13-1.el7.centos.x86_64
> MariaDB-devel-10.4.13-1.el7.centos.x86_64
> MariaDB-backup-10.4.13-1.el7.centos.x86_64
>
>
> When I try to build the rpms, I see the following build errors:
> $ rpmbuild -ta slurm-20.02.3.tar.bz2
> Processing files: slurm-slurmdbd-20.02.3-1.el7.x86_64
> error: File not found:
>
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
>
>
> RPM build errors:
>     File not found:
>
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
>     File not found:
>
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
> --------------------------------------
> There are errors in the config run:
> --------------------------------------
> checking for mysql_config... /usr/bin/mysql_config
> configure: WARNING: *** MySQL test program execution failed. A
> thread-safe MySQL library is required.
>
>
> In the build config.log,
> configure: WARNING: *** MySQL test program execution failed. A
> thread-safe MySQL library is required.
>
> -----------------------------------------------
> It seems that there are some missing dependencies and changes with
> MariaDB 10.4, namely, there is no /usr/lib64/libmariadb.a (its been
> replaced by /usr/lib/libmariadbclient.a) but a soft link from the
> latter to the former doesn't fix the issue:
> ------------------------------------------------
> In the config.log, it seems that the system libs are missing from the
> mariadb_config interaction:
>
> configure:4953: result: /usr/bin/mysql_config
> configure:5054: gcc -o conftest -I/usr/include/mysql
> -I/usr/include/mysql/mysql -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE
> =2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4
> -grecord-gcc-switches -Wl,-z,lazy  -m64 -mtune=generi
> c  -Wl,-z,relro -Wl,-z,lazy conftest.c -L/usr/lib64/ -lmariadb  >&5
> /usr/lib64//libmariadb.a(mariadb_lib.c.o): In function
`mysql_server_init':
> (.text+0x1ba4): undefined reference to `pthread_once'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_double.isra.2':
> (.text+0x17bc): undefined reference to `floor'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_double.isra.2':
> (.text+0x180d): undefined reference to `floor'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_float.isra.3':
> (.text+0x1b9a): undefined reference to `floorf'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_float.isra.3':
> (.text+0x1be4): undefined reference to `floorf'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_long.isra.4':
> (.text+0x20e0): undefined reference to `ceilf'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_long.isra.4':
> (.text+0x215d): undefined reference to `ceil'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_long.isra.4':
> (.text+0x225b): undefined reference to `ceil'
> /usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
> `convert_from_long.isra.4':
> (.text+0x229e): undefined reference to `ceilf'
> /usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
> `mysql_client_plugin_deinit':
> (.text+0x20b): undefined reference to `dlclose'
> /usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
> `mysql_load_plugin_v':
> (.text+0x5d9): undefined reference to `dlopen'
> /usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
> `mysql_load_plugin_v':
>
> ---------------------------------------------
>
> I built the slurm system successfully with version mariadb 5.5. from
> centOS, is this a known issue with MariaDB 10.4 ?    Does slurm build
> with other versions of MariaDB?
>
> Thanks in advance,
> Jeff
>
>
> --
> Jeffrey McDonald, PhD
> Director of Information Technology
> The Hormel Institute
> 801 16th Ave NE            email: jmcdonal at umn.edu
> Austin, MN 55912           phone: +1 507.437.9654
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20200602/1a4dcfdd/attachment.htm>