voxpupuli / puppet-icingadb

Puppet module to manage IcingaDB.
Apache License 2.0
3 stars 6 forks source link

Add support for DB options #35

Closed trauta closed 1 month ago

trauta commented 1 month ago

Hi,

unfortunately, it is currently not possible to configure custom db options with this module. In my setup I need to set the wsrep_sync_wait parameter to 0 because both Icinga master nodes only connect to their local MariaDB daemon.

Could you please add the database options parameters?

Regards, Alex

lbetz commented 1 month ago

Right, thx, will be added shortly.

trauta commented 1 month ago

Sorry to bother again, but is there any specific reason why the wsrep_sync_wait parameter is set to Integer[1] which prevents using 0?

The IcingaDB documentation says that for Galera setups where the Icinga master nodes only connects to a single DB node the setting should be set to 0, however the current implementation with the Integer[1] datatype does not allow this.

Error 500 on SERVER: Server Error: Evaluation Error: Error while evaluating a Function Call, Class[Icingadb]: parameter 'db_options' entry 'wsrep_sync_wait' expects an Integer[1] value, got Integer[0, 0]
lbetz commented 1 month ago

I think the reason is that I wasn't paying attention.