[slurm-users] problems building slurm with MariaDB 10.4

[Jeffrey McDonald]

Thanks, one of your links to the  MariaDB installs pointed out the
issue, with version 10.4 you must install the MariaDB-shared rpm.
My build completes successfully.
Thanks,
Jeff

On Tue, Jun 2, 2020 at 11:20 AM Rodrigo Santibáñez
<rsantibanez.uchile at gmail.com> wrote:
>
> 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
> >



-- 

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