[slurm-users] slurmctld and slurmdbd on the server, mysql on remote

[Gérard Henry (AMU)]

oups, i found my error, i forgot to remove JobCompHost, found it after 
reading this:
https://bugs.schedmd.com/show_bug.cgi?id=2322#c5

sorry for the noise

On 19/07/2023 14:51, Gérard Henry (AMU) wrote:
> Hello all,
> is it possible to have this configuration? i installed slurm on ubuntu 
> 20 LTS, but slurmctld refuses to start with messages:
> 
> [2023-07-19T14:37:59.563] Job completion MYSQL plugin loaded
> [2023-07-19T14:37:59.563] debug:  /var/log/slurm/jobcomp doesn't look 
> like a database name using slurm_jobcomp_db
> [2023-07-19T14:37:59.563] debug2: mysql_connect() called for db 
> slurm_jobcomp_db
> [2023-07-19T14:37:59.571] debug2: Attempting to connect to localhost:3306
> [2023-07-19T14:37:59.571] error: mysql_real_connect failed: 2002 Can't 
> connect to local MySQL server through socket 
> '/var/run/mysqld/mysqld.sock' (2)
> [2023-07-19T14:37:59.572] fatal: You haven't inited this storage yet.
> 
> slurmdbd is running, and some stuff seems to be written in db:
> # sacctmgr show cluster
>     Cluster     ControlHost  ControlPort   RPC     Share GrpJobs GrpTRES 
> GrpSubmit MaxJobs       MaxTRES MaxSubmit     MaxWall
>            QOS   Def QOS
> ---------- --------------- ------------ ----- --------- ------- 
> ------------- --------- ------- ------------- --------- ----------- -------
> ------------- ---------
>     cathena                            0     0         1
>         normal
> 
> i don't understand why slurmctld needs to connect to mysql, since it 
> connects to slurmdbd.
> 
> slurm is # slurmctld -V
> slurm-wlm 19.05.5
> 
> Thanks in advance for help,
> 
> 

-- 
Gérard HENRY
Institut Fresnel - UMR 7249
+33 413945457
Aix-Marseille Université - Campus Etoile, BATIMENT FRESNEL, Avenue 
Escadrille Normandie Niemen, 13013 Marseille
Site : https://fresnel.fr/
Afin de respecter l'environnement, merci de n'imprimer cet email que si 
nécessaire.