Azure / cyclecloud-slurm

Azure CycleCloud project to enable users to create, configure, and use Slurm HPC clusters.
MIT License
54 stars 40 forks source link

install libmysqlclient-dev on ubuntu 20.04 #221

Closed xpillons closed 1 month ago

xpillons commented 3 months ago

with the need to move to mySQL add libmysqlclient-dev in the ubuntu installation script of the scheduler

xpillons commented 3 months ago

@aditigaur4 for reference

xpillons commented 2 months ago

the mariadb client works to connect to mySQL Flexible server, so closing it

xpillons commented 2 months ago

Reopening this. When using image canonical:0001-com-ubuntu-server-focal:20_04-lts-gen2:latest for the scheduler then I'm getting an error in /var/log/slurmctld/slurmdbd.log

[2024-04-17T16:20:16.609] error: plugin_load_from_file: dlopen(/usr/lib64/slurm/accounting_storage_mysql.so): libmysqlclient.so.21: cannot open shared object file: No such file or directory
[2024-04-17T16:20:16.609] error: Couldn't load specified plugin name for accounting_storage/mysql: Dlopen of plugin file failed
[2024-04-17T16:20:16.609] error: cannot create accounting_storage context for accounting_storage/mysql
[2024-04-17T16:20:16.609] fatal: Unable to initialize accounting_storage/mysql accounting storage plugin

this can be fixed by installing libmysqlclient-dev

aditigaur4 commented 2 months ago

I have included this in this PR: https://github.com/Azure/cyclecloud-slurm/pull/223