Bug 226279 - net-mgmt/zabbix34-proxy: missing support for sqlite
Summary: net-mgmt/zabbix34-proxy: missing support for sqlite
Status: Closed Not A Bug
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: Kubilay Kocak
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-01 13:30 UTC by Thore Bödecker
Modified: 2018-12-15 11:13 UTC (History)
2 users (show)

See Also:
bugzilla: maintainer-feedback? (pg)


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thore Bödecker 2018-03-01 13:30:23 UTC
The zabbix_proxy binary from "net-mgmt/zabbix34-proxy" is built against libmysqlclient.so only, i.e. sqlite support is set to "off".

It is my understanding that the zabbix_proxy binary is able to provide support for mysql and sqlite databases at the same time, at least the zabbix_proxy.conf states that. (DBName should be set to a full path to use sqlite over mysql)

So it would be really great to have sqlite support in the zabbix-proxy package as this allows running zabbix proxies with just a little sqlite database instead of spinning up a full blown mysql server.
Comment 1 Kubilay Kocak freebsd_committer freebsd_triage 2018-12-15 11:13:59 UTC
This port contains the following options that allows for customising which backend database should be used and depended on:

  MYSQL=on: MySQL database support
  PGSQL=off: PostgreSQL database support
  SQLITE=off: SQLite database support
  ORACLE=off: Oracle database support

It appears this is also the case for:

  net-mgmt/zabbix22-proxy
  net-mgmt/zabbix3-proxy
  net-mgmt/zabbix32-proxy
  net-mgmt/zabbix4-proxy

If you are strictly using packages, I would suggest using poudriere [1] to create a custom package repository, allowing you to customise port OPTIONS while continuing to use packages.

[1] https://www.freebsd.org/doc/handbook/ports-poudriere.html