Support sqLite db for proxies

[jrg72]

Hello, and thank you for this Puppet module, it's quite excellent. I have run into an issue with proxy configuration, however. Proxies support use of sqLite for the dbtype in Zabbix, and it looks like there is mention of this in your docs also:

https://github.com/dj-wasabi/puppet-zabbix/blob/master/manifests/proxy.pp#L11

[dbtype]

Type of database. Can use the following 3 databases:

- postgresql

- mysql

- sqlite

However, setting the dbtype to `sqlite' seems to fail with the following error:

Error: Unrecognized database type for proxy: sqlite at /etc/puppet/modules/zabbix/manifests/proxy.pp:295

Farther down in the proxy manifest, it looks like there is no case switch to set `sqlite' as an option for the dbtype:

https://github.com/dj-wasabi/puppet-zabbix/blob/master/manifests/proxy.pp#L286

Use the correct db.

case $dbtype {
'postgresql': {
$db = 'pgsql'
}
'mysql': {
$db = 'mysql'
}
default: {
fail("Unrecognized database type for proxy: ${dbtype}")
}
}

Is this an option that can be fully implemented at some point? Thank you.

[dj-wasabi]

Hi jrg72,

Thanks for making time for creating an issue. At the beginning, the plan was to create support for this type of database with the proxy and server classes. But lateron I thought that sqlite3 wasn't an popular choice as backend, so I didn't implemented it.

At this moment, I'm busy with some zabbixapi stuff and when this is done, I'll take a look at it. I can't say when this will happen tough. Why would you use sqlite3 for this if I may ask? I'm not an database engineer, but using MySQL or Postgresql isn't that hard.

Kind regards,
Werner

[jrg72]

Hello again Werner,

Thanks for the response! We ended up just switching to MySQL - I think sqLite was being used for simplicity's sake, but it's no big deal to just use MySQL instead.

Thanks again,

Joe