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 (<[email protected]>) 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: [email protected] > Austin, MN 55912 phone: +1 507.437.9654 >
