Project

General

Profile

Actions

Bug #12131

closed

zabbix-proxy54 database is down

Added by Mario A 2 months ago. Updated 2 months ago.

Status:
Resolved
Priority:
Urgent
Category:
Zabbix
Target version:
-
Start date:
07/15/2021
Due date:
% Done:

0%

Estimated time:
Plus Target Version:
Affected Version:
2.5.2
Affected Plus Version:
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
Actions #1

Updated by Viktor Gurov 2 months ago

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

Actions #2

Updated by Viktor Gurov 2 months ago

at the same time:
https://github.com/pfsense/pfsense/blob/master/tools/conf/pfPorts/make.conf#L119:

net-mgmt_zabbix54-proxy_SET_FORCE=IPMI IPV6 LIBXML2 SQLITE SSH
net-mgmt_zabbix54-proxy_UNSET_FORCE=MYSQL

it looks like build options are being ignored

Actions #3

Updated by Renato Botelho 2 months ago

  • 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

Actions #4

Updated by Jeff Dairiki 2 months ago

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!

Actions #5

Updated by Renato Botelho 2 months ago

  • Status changed from Feedback to Resolved
Actions

Also available in: Atom PDF