Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-8821

zabbix_proxy can't connect to sqlite database

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 2.2.6
    • Proxy (P)
    • None
    • * Ubuntu Trusty (14.04)
      * self-compiled zabbix_proxy

      I compiled zabbix_proxy with following command

      ./configure --enable-proxy --with-sqlite3 --with-libcurl --with-libxml2 --with-net-snmp --with-openipmi --with-ssh2 --with-ldap --enable-ipv6 && make install

      I configured following zabbix_proxy.conf 

      ProxyMode=0
Server=SERVER
Hostname=PROXY
LogFile=/tmp/zabbix_proxy.log
PidFile=/tmp/zabbix_proxy.pid
DBName=/tmp/proxy.db
ProxyLocalBuffer=16
StartPollers=10
StartTrappers=10
StartPingers=10
StartDiscoverers=5
JavaGateway=127.0.0.1
JavaGatewayPort=10052
StartJavaPollers=5
Timeout=30
FpingLocation=/usr/bin/fping
Fping6Location=/usr/bin/fping6

      If i try to start the proxy i get the following in log file:

       16665:20140925:083846.283 Starting Zabbix Proxy (active) [ca-monitor-1-proxy-prod-01]. Zabbix 2.2.6 (revision 48483).
 16665:20140925:083846.283 **** Enabled features ****
 16665:20140925:083846.283 SNMP monitoring:       YES
 16665:20140925:083846.283 IPMI monitoring:       YES
 16665:20140925:083846.283 WEB monitoring:        YES
 16665:20140925:083846.283 VMware monitoring:     YES
 16665:20140925:083846.283 ODBC:                   NO
 16665:20140925:083846.283 SSH2 support:          YES
 16665:20140925:083846.284 IPv6 support:          YES
 16665:20140925:083846.284 **************************
 16665:20140925:083846.284 using configuration file: /opt/zabbix-proxy/etc/zabbix_proxy.conf
 16665:20140925:083846.284 In load_modules()
 16665:20140925:083846.284 End of load_modules():SUCCEED
 16665:20140925:083846.284 In init_database_cache()
 16665:20140925:083846.284 In zbx_mem_required_size() size:0 chunks_num:4 descr:'history cache' param:'HistoryCacheSize'
 16665:20140925:083846.284 End of zbx_mem_required_size() size:543
 16665:20140925:083846.284 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:8388575
 16665:20140925:083846.284 zbx_shmget() removing existing shm_id:3080203
 16665:20140925:083846.284 valid user addresses: [0x7f3eae2ba170, 0x7f3eaeab9fd0] total size: 8388192
 16665:20140925:083846.284 End of zbx_mem_create()
 16665:20140925:083846.284 In zbx_mem_required_size() size:0 chunks_num:1 descr:'history text cache' param:'HistoryTextCacheSize'
 16665:20140925:083846.284 End of zbx_mem_required_size() size:435
 16665:20140925:083846.284 In zbx_mem_create() descr:'history text cache' param:'HistoryTextCacheSize' size:16777216
 16665:20140925:083846.284 zbx_shmget() removing existing shm_id:3112972
 16665:20140925:083846.284 valid user addresses: [0x7f3ead2ba178, 0x7f3eae2b9ff0] total size: 16776824
 16665:20140925:083846.284 End of zbx_mem_create()
 16665:20140925:083846.285 End of init_database_cache()
 16665:20140925:083846.285 In init_configuration_cache() size:8388608
 16665:20140925:083846.285 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:7130317
 16665:20140925:083846.285 zbx_shmget() removing existing shm_id:3145741
 16665:20140925:083846.285 valid user addresses: [0x7f3eacbed170, 0x7f3ead2b9cc0] total size: 7129936
 16665:20140925:083846.285 End of zbx_mem_create()
 16665:20140925:083846.286 In zbx_strpool_create()
 16665:20140925:083846.286 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:1258291
 16665:20140925:083846.286 zbx_shmget() removing existing shm_id:3178510
 16665:20140925:083846.287 valid user addresses: [0x7f3eb6143168, 0x7f3eb6276328] total size: 1257920
 16665:20140925:083846.287 End of zbx_mem_create()
 16665:20140925:083846.288 End of zbx_strpool_create()
 16665:20140925:083846.288 End of init_configuration_cache()
 16665:20140925:083846.288 In init_selfmon_collector()
 16665:20140925:083846.288 init_selfmon_collector() size:13656
 16665:20140925:083846.288 zbx_shmget() removing existing shm_id:3211279
 16665:20140925:083846.288 End of init_selfmon_collector() collector:0x7f3eb628d000
 16665:20140925:083846.288 In DBcheck_version()
 16665:20140925:083846.288 In DBconnect() flag:0
 16665:20140925:083846.291 [Z3001] connection to database '/tmp/proxy.db' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 16665:20140925:083846.291 Database is down. Reconnecting in 10 seconds.

      What goes wrong with sqlite.

      I try to create database before proxy starts and without existing database. Some result. Proxy try to connect to mysql.

      zabbix_proxy ist linked to the following libs:

      # ldd zabbix_proxy 
	linux-vdso.so.1 =>  (0x00007fff657fe000)
	libmysqlclient.so.18 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007fcfa8a20000)
	libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007fcfa86ba000)
	libnetsnmp.so.30 => /usr/lib/x86_64-linux-gnu/libnetsnmp.so.30 (0x00007fcfa83df000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fcfa80d9000)
	libssh2.so.1 => /usr/lib/x86_64-linux-gnu/libssh2.so.1 (0x00007fcfa7eb1000)
	libOpenIPMI.so.0 => /usr/lib/libOpenIPMI.so.0 (0x00007fcfa7ba9000)
	libOpenIPMIposix.so.0 => /usr/lib/libOpenIPMIposix.so.0 (0x00007fcfa79a3000)
	libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007fcfa7752000)
	liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007fcfa7542000)
	libcurl.so.4 => /usr/lib/x86_64-linux-gnu/libcurl.so.4 (0x00007fcfa72db000)
	libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fcfa70d7000)
	libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fcfa6ebb000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fcfa6af5000)
	libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fcfa68dc000)
	libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fcfa66bd000)
	liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007fcfa649b000)
	libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007fcfa60c1000)
	libgcrypt.so.11 => /lib/x86_64-linux-gnu/libgcrypt.so.11 (0x00007fcfa5e41000)
	libOpenIPMIutils.so.0 => /usr/lib/libOpenIPMIutils.so.0 (0x00007fcfa5c38000)
	libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007fcfa5a1d000)
	libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007fcfa57de000)
	libgnutls.so.26 => /usr/lib/x86_64-linux-gnu/libgnutls.so.26 (0x00007fcfa5520000)
	libidn.so.11 => /usr/lib/x86_64-linux-gnu/libidn.so.11 (0x00007fcfa52ed000)
	librtmp.so.0 => /usr/lib/x86_64-linux-gnu/librtmp.so.0 (0x00007fcfa50d2000)
	libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007fcfa4e74000)
	libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007fcfa4c2e000)
	/lib64/ld-linux-x86-64.so.2 (0x00007fcfa8f5e000)
	libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0 (0x00007fcfa4a28000)
	libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007fcfa481f000)
	libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007fcfa4596000)
	libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8 (0x00007fcfa42f5000)
	libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007fcfa40f1000)
	libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007fcfa3ebd000)
	libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18 (0x00007fcfa3ca8000)
	libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007fcfa3a94000)
	libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007fcfa3851000)
	libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007fcfa3586000)
	libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007fcfa3357000)
	libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007fcfa314b000)
	libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0 (0x00007fcfa2f22000)
	libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007fcfa2d14000)
	libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5 (0x00007fcfa2aca000)
	libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007fcfa2811000)
	libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007fcfa25d8000)
	libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007fcfa23cf000)
	libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007fcfa21cb000)

      Links to both "libsqlite3.so.0" and "libmysqlclient.so.18" are present.

            Unassigned Unassigned
            cmeissner Christian Meissner
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: