search

ULHPC / puppet-slurm

A Puppet module designed to configure and manage SLURM(see https://slurm.schedmd.com/), an open source, fault-tolerant, and highly scalable cluster management and job scheduling system for large and small Linux clusters
Apache License 2.0
19 stars 25 forks source link

when using external DB, we enable outside connections to local DB #74

Open jorhett opened 1 month ago

jorhett commented 1 month ago

If you configure an external database for Slurm, Puppet is changing the local (totally unrelated!) mysql instance to allow external connections:

Notice: /Stage[main]/Mysql::Server::Config/File[mysql-config-file]/content:
--- /etc/my.cnf.d/server.cnf    2024-08-15 20:22:05.110172179 +0000
+++ /tmp/puppet-file20240815-170215-gwhbun  2024-08-15 20:41:20.534894953 +0000
@@ -11,7 +11,7 @@

 [mysqld]
 basedir = /usr
-bind-address = 127.0.0.1
+bind-address = 0.0.0.0
 datadir = /var/lib/mysql
 innodb_buffer_pool_size = 256M
 innodb_lock_wait_timeout = 500

Resolved configuration looks like this:

# grep Storage /etc/slurm/slurmdbd.conf
StorageType=accounting_storage/mysql
StorageHost=10.10.10.10
StoragePort=3306
StorageLoc=slurm   # Name of the database
StorageUser=slurm-user
StoragePass=*************