[ZBX-17297] Zabbix Proxy sqllite3 config not working Created: 2020 Feb 11  Updated: 2023 Feb 04  Resolved: 2020 Feb 12

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Scott Nursten Assignee: Edgar Akhmetshin
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS Linux release 7.7.1908 (Core)
zabbix-proxy-mysql-4.4.5-2.el7.x86_64


 Description   

Steps to reproduce:

  1. Install zabbix proxy
  2. Start zabbix proxy

Result:

2237:20200211:122153.931 [Z3001] connection to database 'zabbix_proxy' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 2237:20200211:122153.931 database is down: reconnecting in 10 seconds

Expected:

From what I understand, zabbix_proxy creates it's own sqllite3 db that doesn't require any config.

 Comments   
Comment by Edgar Akhmetshin [ 2020 Feb 12 ]

Hello Scott,

You need to use zabbix-proxy-sqlite3 package (documentation):

  • zabbix-proxy-mysql.x86_64 : Zabbix proxy for MySQL or MariaDB database
  • zabbix-proxy-pgsql.x86_64 : Zabbix proxy for PostgreSQL database
  • zabbix-proxy-sqlite3.x86_64 : Zabbix proxy for SQLite3 database

Use Zabbix Proxy configuration option DBName= to set path to the file (replace <path/to/the/file>):

DBName=<path/to/the/file>

Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support or consultancy services. Alternatively, you can also use our IRC channel or community forum (https://www.zabbix.com/forum) for assistance. With that said, we are closing this ticket. Thank you for understanding.

Regards,
Edgar

Comment by LivreAcesso.Pro [ 2023 Feb 04 ]

The problems persists:

  2613:20230204:181622.567 Starting Zabbix Proxy (active) [zabbix6proxy]. Zabbix 6.0.13 (revision fdfa8cef9ce).
  2613:20230204:181622.567 **** Enabled features ****
  2613:20230204:181622.567 SNMP monitoring:       YES
  2613:20230204:181622.567 IPMI monitoring:       YES
  2613:20230204:181622.567 Web monitoring:        YES
  2613:20230204:181622.567 VMware monitoring:     YES
  2613:20230204:181622.567 ODBC:                  YES
  2613:20230204:181622.567 SSH support:           YES
  2613:20230204:181622.567 IPv6 support:          YES
  2613:20230204:181622.567 TLS support:           YES
  2613:20230204:181622.567 **************************
  2613:20230204:181622.568 using configuration file: /etc/zabbix/zabbix_proxy.conf
  2613:20230204:181622.568 cannot open database file "zabbix_proxy": [2] No such file or directory
  2613:20230204:181622.568 creating database ...
  2613:20230204:181622.569 [Z3002] cannot create database 'zabbix_proxy': [0] unable to open database file
  2613:20230204:181622.569 cannot initialize database: cannot open database

Please, provide a working default config.

Generated at Thu Jun 05 22:09:43 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.