Bug #12131
closed
zabbix-proxy54 database is down
Added by Mario A over 3 years ago.
Updated over 3 years ago.
Affected Architecture:
amd64
Description
Hi, after upgrading zabbix proxy to the new 5.4 version I get this error:
42052:20210715:165612.288 [Z3001] connection to database '/var/db/zabbix-proxy/proxy.db' failed: [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
42052:20210715:165612.288 database is down: reconnecting in 10 seconds
I also tried to do this thing (without success):
cd /var/db/zabbix-proxy
sqlite3 proxy.db < /usr/local/share/zabbix54/proxy/database/sqlite3/schema.sql
chown zabbix proxy.db
Zabbix Proxy 5.4 package doesn't create /var/db/zabbix-proxy/proxy.db file
from https://www.zabbix.com/documentation/current/manual/appendix/install/db_scripts:
"If using SQLite with Zabbix proxy, database will be automatically created if it does not exist."
but zabbix54-proxy SQLITE=off:
# pkg info zabbix54-proxy
zabbix54-proxy-5.4.1
Name : zabbix54-proxy
Version : 5.4.1
Installed on : Fri Jul 16 10:08:50 2021 MSK
Origin : net-mgmt/zabbix54-proxy
Architecture : FreeBSD:12:amd64
Prefix : /usr/local
Categories : net-mgmt
Licenses : GPLv2+
Maintainer : otis@FreeBSD.org
WWW : https://www.zabbix.com/
Comment : Enterprise-class open source distributed monitoring (proxy)
Options :
CURL : on
FPING : on
GNUTLS : off
IPMI : off
IPV6 : on
LDAP : off
LIBXML2 : off
MYSQL : on
NMAP : off
OPENSSL : on
ORACLE : off
PGSQL : off
SQLITE : off
SSH : off
UNIXODBC : on
Shared Libs required:
libcurl.so.4
libpcre.so.1
libodbc.so.2
libmysqlclient.so.20
libnetsnmp.so.40
libevent-2.1.so.7
proxy 5.2:
# pkg info zabbix52-proxy
zabbix52-proxy-5.2.6
Name : zabbix52-proxy
Version : 5.2.6
Installed on : Fri Jul 16 10:00:29 2021 MSK
Origin : net-mgmt/zabbix52-proxy
Architecture : FreeBSD:12:amd64
Prefix : /usr/local
Categories : net-mgmt
Licenses : GPLv2+
Maintainer : pg@pakhom.spb.ru
WWW : https://www.zabbix.com/
Comment : Enterprise-class open source distributed monitoring (proxy)
Options :
CURL : on
FPING : on
GNUTLS : off
IPMI : on
IPV6 : on
LDAP : off
LIBXML2 : on
MYSQL : off
NMAP : off
OPENSSL : on
ORACLE : off
PGSQL : off
SQLITE : on
SSH : on
UNIXODBC : on
Shared Libs required:
libcurl.so.4
libpcre.so.1
libodbc.so.2
libnetsnmp.so.40
libevent-2.1.so.7
libsqlite3.so.0
libOpenIPMIposix.so.0
libOpenIPMI.so.0
libxml2.so.2
libssh2.so.1
- Status changed from New to Feedback
- Assignee set to Renato Botelho
Commit that defines zabbix-proxy 5.4 options was missing on stable branches. Fixed on version 1.0.4_9
Renato Botelho wrote:
Commit that defines zabbix-proxy 5.4 options was missing on stable branches. Fixed on version 1.0.4_9
I was experiencing this issue, and it now seems to be fixed. Thank you!
- Status changed from Feedback to Resolved
Also available in: Atom
PDF