[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-31 Thread Benjamin Smith via slurm-users
It could be systemd doing that. Since slurmdbd is being started with -D, I would verify that slurmdbd.service has Type=simple and not Type=forking. The systemctl status output later in the thread shows systemd starting slurmdbd with -D. If that's the slurmdbd package from Ubuntu you might f

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
I also run both commands using sudo so I am assuming permission should not be the issue ? my cluster user is root (i know not good, but im testing things out) On Fri, May 31, 2024 at 12:03 AM Radhouane Aniba wrote: > Yes when I run it manually it says something like this > > [2024-05-31T00:20:0

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
Yes when I run it manually it says something like this [2024-05-31T00:20:01.142] Accounting storage MYSQL plugin loaded [2024-05-31T00:20:01.146] slurmdbd version 19.05.5 started But when I try to do it through systemctl [2024-05-31T00:21:30.953] Terminate signal (SIGINT or SIGTERM) received [20

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Ryan Novosielski via slurm-users
Are you looking at the log/what appears on the screen, and do you know for a fact that it is all the way up (should say "version started” at the end)? If that’s not it, you could have a permissions thing or something. I do not expect you’d need to extend the timeout for a normal run. I suspect

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
manually running it through sudo slurmdbd -D /path/to/conf is very quick on my fresh install trying to start the slurmdbd through systemctl take 3 minutes and then crashes and fail Is there an alternative to systemctl to start the slurmdbd in the background ? But most importantly I wanted to kno

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
Ok I made some progress here. I removed and purged slurmdbd mysql mariadb etc .. and started from scratch. I added the recommended mysqld requirements Started slurmdbd manually : sudo slurmdbd -D /path/to/conf and everything worked well When I tried to start the service sudo systemctl start slur

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
Thank you Ahmet and Brian, Ahmet, which conf in particular slurmdbd is readiugn from, I parsed all the cnf files for mysql and I cannot find the data it is displaying here slurmdbd: debug2: Attempting to connect to localhost:3306 slurmdbd: debug2: innodb_buffer_pool_size: 134217728 slurmdbd: debu

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Brian Andrus via slurm-users
That SIGTERM message means something is telling slurmdbd to quit. Check your cron jobs, maintenance scripts, etc. Slurmdbd is being told to shutdown. If you are running in the foreground, a ^C does that. If you run a kill or killall on it, you will get that same message. Brian Andrus On 5/30

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread mercan via slurm-users
You should fix this error, this not a warning. It is an error: "slurmdbd: error: Database settings not recommended values: innodb_buffer_pool_size innodb_lock_wait_timeout" error. You can find info at slurm documentation: https://slurm.schedmd.com/accounting.html#slurm-accounting-configuratio

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
Yes I can connect to my database using mysql --user=slurm --password=slurmdbpass slurm_acct_db and there is no firewall blocking mysql after checking the firewall question ALso here is the output of slurmdbd -D -vvv (note I can only run this as sudo ) sudo slurmdbd -D -vvv slurmdbd: debug: Log f

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread mercan via slurm-users
Did you try to connect database using mysql command? mysql --user=slurm --password=slurmdbpass  slurm_acct_db C. Ahmet Mercan On 30.05.2024 14:48, Radhouane Aniba via slurm-users wrote: Thank you Ahmet, I dont have a firewall active. And because slurmdbd cannot connect to the database I am no

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-30 Thread Radhouane Aniba via slurm-users
Thank you Ahmet, I dont have a firewall active. And because slurmdbd cannot connect to the database I am not able to getting it to be activated through systemctl I will share the output for slurmdbd -D -vvv shortly but overall it is always saying trying to connect to the db and then retries a coupl

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-29 Thread mercan via slurm-users
Hi; Did you check can you connect db with your conf parameters from head-node: mysql --user=slurm --password=slurmdbpass  slurm_acct_db Also, check and stop firewall and selinux, if they are running. Last, you can stop slurmdbd, then run run terminal with: slurmdbd -D -vvv Regards; C. Ahmet

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-29 Thread Ole Holm Nielsen via slurm-users
This might be the firewall blocking communication to slurmdbd? You may perhaps find some useful information in this Wiki page: https://wiki.fysik.dtu.dk/Niflheim_system/Slurm_installation/ /Ole On 29-05-2024 23:05, Radhouane Aniba via slurm-users wrote: Hi everyone I am trying to get slurmdbd

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-29 Thread aradwen--- via slurm-users
Yes mysql database is running I can update and check, but I guess the update will break a couple of config , I need to check if this is something safe to do even though it is for my homelab but still :) -- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email t

[slurm-users] Re: slurmdbd not connecting to mysql (mariadb)

2024-05-29 Thread James Lam via slurm-users
1. is your mysql database running? 2. slurm 19.x is far obselete and you should at least use 21.x On 30/5/2024 5:05 am, Radhouane Aniba via slurm-users wrote: Hi everyone I am trying to get slurmdbd to run on my local home server but I am really struggling. Note : am a novice slurm user my slu