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

[jorhett]

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=*************