proxy zabbix and agent

[Spirou]

Hi,

i just install a zabbix proxy and i cant see my zabbix agent on my zabbix server, here my config :

zabbix server : 192.168.1.13
zabbix proxy : 192.168.1.50 (i see active in zabbix server GUI)
zabbix agent : 192.168.1.60 (it work w/o proxy)

config for the zabbix agent :
Server=192.168.1.50
ServerActive=192.168.1.50
Hostname=agentzabbix (name of my server in zabbix server GUI)

I have no availability in GUI interface !? (proxyzab: agentzabbix)

0.0.0.0:10051 0.0.0.0:* LISTEN 106 194453 1906/zabbix_proxy
192.168.1.50:10051 192.168.1.60:35892 TIME_WAIT 0 0 -

i have another problem in zabbix_proxy.log :

failed to update local proxy configuration copy: invalid field name "hosts.tls_connect"

i need help please !

ty
regards.

[Spirou]

Bump !!

[Atsushi]

What version using Zabbix server and proxy?
You must use same version with server and proxy.

ex.
Zabbix Server 3.0.3 <-> Zabbix Proxy 3.0.3
Zabbix Server 2.2.13 <-> Zabbix Proxy 2.2.13

[Spirou]

What version using Zabbix server and proxy?
You must use same version with server and proxy.

ex.
Zabbix Server 3.0.3 <-> Zabbix Proxy 3.0.3
Zabbix Server 2.2.13 <-> Zabbix Proxy 2.2.13

Hi,

zabbix server :
ii zabbix-frontend-php 1:3.0.1-1+trusty
ii zabbix-release 3.0-1+trusty
ii zabbix-sender 1:3.0.1-1+trusty
ii zabbix-server-mysql 1:3.0.1-1+trusty

and proxy :

zabbix-proxy-mysql 1:3.0.3-1+trusty

does it work ?

[Atsushi]

Please try to restart the Zabbix proxy daemon.
Do you output the same error?

[Spirou]

Please try to restart the Zabbix proxy daemon.
Do you output the same error?

yes same error :

1356:20160704:191348.952 housekeeper [deleted 1 records in 0.004693 sec, idle 3600 sec]
1341:20160704:191348.952 Received configuration data from server. Datalen 3195
1365:20160704:191348.953 proxy #19 started [history syncer #1]
1366:20160704:191348.953 proxy #20 started [history syncer #2]
1370:20160704:191348.954 proxy #23 started [snmp trapper #1]
1367:20160704:191348.953 proxy #21 started [history syncer #3]
1369:20160704:191348.954 proxy #22 started [history syncer #4]
1371:20160704:191348.954 proxy #24 started [self-monitoring #1]
1341:20160704:191348.956 failed to update local proxy configuration copy: invalid field name "hosts.tls_connect"
1364:20160704:191348.956 proxy #18 started [discoverer #1]

I have this error too :

1354:20160704:192131.893 cannot send list of active checks to [192.168.1.60]: host [agentzabbix] not found

[Spirou]

Hi,

I have this on my server zabbix (attachment)

interface is the proxy (192.168.1.50:10051) , is it right ?

regards.

[Spirou]

Proxy configuration 192.168.1.50 (zabbix_proxy.conf) :


ProxyMode=0
Server=192.168.1.13 (zabbix server)
Hostname=proxyzab (proxy name in zabbix server)
LogFile=/var/log/zabbix-proxy/zabbix_proxy.log
DebugLevel=3
PidFile=/var/run/zabbix/zabbix_proxy.pid
DBName=zabbixproxy
DBUser=zabbixproxy
DBPassword=zabbixproxy
DBSocket=/var/run/mysqld/mysqld.sock
SNMPTrapperFile=/var/log/snmptt/snmptt.log
StartSNMPTrapper=1

[Spirou]

Agent configuration 192.168.1.60 (zabbix_agentd.conf) :

PidFile=/var/run/zabbix/zabbix_agentd.pid
LogFile=/var/log/zabbix-agent/zabbix_agentd.log
LogFileSize=0
Server=192.168.1.50
ServerActive=192.168.1.50
Hostname=agentzabbix
Include=/etc/zabbix/zabbix_agentd.conf.d/

[DmitryL]

Hello Spirou,

Could you please post output of this SQL queries executed on Proxy and server?

select * from dbversion;

I know that u said that both ( proxy and server are 3.0 )
But it looks like DBversion of proxy is < 3.0

Error you are getting
1341:20160704:191348.956 failed to update local proxy configuration copy: invalid field name "hosts.tls_connect"

Is caused by configuration file from server 3.0 which contains TLS related columns in hosts table. One of them are tls_connect.
Databases before 3.0 didnt have this collumns.

All configuration that was stored before this issue is and will work further. but proxy cant update/create new hosts.

You can check with query from proxy db

 select * from hosts limit 1 \G

Best regards,
Dmitry

[Spirou]

Hi Dmitryb,

Result for proxy :

mysql> select * from dbversion;
+-----------+----------+
| mandatory | optional |
+-----------+----------+
| 2020000 | 2020000 |
+-----------+----------+
1 row in set (0.00 sec)

Result for server :

mysql> select * from dbversion;
+-----------+----------+
| mandatory | optional |
+-----------+----------+
| 3000000 | 3000000 |
+-----------+----------+
1 row in set (0.00 sec)

[Spirou]

On proxy :

mysql> select * from hosts limit 1 \G
Empty set (0.00 sec)

On server :

mysql> select * from hosts limit 1 \G
*************************** 1. row ***************************
hostid: 10001
proxy_hostid: NULL
host: Template OS Linux
status: 3
disable_until: 0
error:
available: 0
errors_from: 0
lastaccess: 0
ipmi_authtype: 0
ipmi_privilege: 2
ipmi_username:
ipmi_password:
ipmi_disable_until: 0
ipmi_available: 0
snmp_disable_until: 0
snmp_available: 0
maintenanceid: NULL
maintenance_status: 0
maintenance_type: 0
maintenance_from: 0
ipmi_errors_from: 0
snmp_errors_from: 0
ipmi_error:
snmp_error:
jmx_disable_until: 0
jmx_available: 0
jmx_errors_from: 0
jmx_error:
name: Template OS Linux
flags: 0
templateid: NULL
description:
tls_connect: 1
tls_accept: 1
tls_issuer:
tls_subject:
tls_psk_identity:
tls_psk:
1 row in set (0.00 sec)




regards.

[Atsushi]

Database for Zabbix proxy is the old version.
It does not work in this state.

This Zabbix proxy environment is newly installed?
Or, upgrading from a previous version?

When the proxy of Zabbix 3.0.3 is started, it has certainly come to check the version of the database.
Please check the version that is output to the log at the start of Zabbix proxy.
# "Starting Zabbix Proxy" line.

[Spirou]

Database for Zabbix proxy is the old version.
It does not work in this state.

This Zabbix proxy environment is newly installed?
Or, upgrading from a previous version?

When the proxy of Zabbix 3.0.3 is started, it has certainly come to check the version of the database.
Please check the version that is output to the log at the start of Zabbix proxy.
# "Starting Zabbix Proxy" line.

Its newly installed yes and not an upgrade. I will check the version.
So if i resume i need the exactly same version for proxy and server ?

regards.

[Atsushi]

It is best to exactly match versions.
I have not been verified by a combination of that version, but it should work if the major version(3.0) match.