PDA

View Full Version : Zabbix Proxy


nelsonab
15-04-2008, 00:29
I've been digging around trying to find out more information about the new proxy function but haven't come up with much so far.

My main question is how is it intended to be deployed? Is it intended to be deployed near the SQL server and act as a direct feed into the SQL database, or is it meant to sit somewhere aggregating data from agents into one stream which is then sent to the zabbix_server process? Where does it fit in the agent/server/database interaction?

nelsonab
16-04-2008, 20:27
Bump!

Alexei, other devs, would ya'll mind giving us a little more information please?

NOB
17-04-2008, 07:19
Hi

last time I checked the sources it'll use ODBC (under Windows and UNIX/Linux)
to connect to the DB.
So you need an ODBC driver for it.
The Windows version won't be ready in 1.6 (http://www.zabbix.com/forum/showthread.php?t=9164)

That's all I know.

Regards

Norbert.

jahlewis
17-04-2008, 15:05
my understanding (and hope) is that it will act as a proxy collector in networks behind firewalls or slow wan links, so that the actual zabbix server talks only to the proxy, which then communicates to the internal hosts.

internal hosts -> zabbix proxy -> firewall -> WAN -> firewall -> zabbix server

is this a correct assumption? I'm hoping it is, as this is a major feature I've been waiting for, and once available, will allow me to monitor multiple remote sites across the internet.

Alexei
20-04-2008, 12:24
my understanding (and hope) is that it will act as a proxy collector in networks behind firewalls or slow wan links, so that the actual zabbix server talks only to the proxy, which then communicates to the internal hosts.

internal hosts -> zabbix proxy -> firewall -> WAN -> firewall -> zabbix server

is this a correct assumption? I'm hoping it is, as this is a major feature I've been waiting for, and once available, will allow me to monitor multiple remote sites across the internet.
ZABBIX Proxy will work exactly as you described. It will collect performance and availability data, also perform auto-discovery on ZABBIX Server behalf. There are several cool things about the proxy:

1. It is immune to communication problems. Data is locally stored.
2. It requires one-way (Proxy to Server) TCP connections only.
3. Almost zero maintenance. For example, if a local Proxy database does not exist, the proxy will create one automatically. So, basically a binary and small configuration file is required to setup a proxy.
4. Configuration is stored and fully managed on Server side from the normal WEB GUI.
5. I am sure I forgot many other interesting things.... :)

BusteR81
21-04-2008, 05:44
ZABBIX Proxy will work exactly as you described. It will collect performance and availability data, also perform auto-discovery on ZABBIX Server behalf. There are several cool things about the proxy:

1. It is immune to communication problems. Data is locally stored.
2. It requires one-way (Proxy to Server) TCP connections only.
3. Almost zero maintenance. For example, if a local Proxy database does not exist, the proxy will create one automatically. So, basically a binary and small configuration file is required to setup a proxy.
4. Configuration is stored and fully managed on Server side from the normal WEB GUI.
5. I am sure I forgot many other interesting things.... :)

This feature is awesome. However I couldn't find any help topics (even from zabbix manual v1.4) on the usage of proxy server. Can someone enlighten mi, please ??

Cheers

Alexei
21-04-2008, 07:34
This feature is awesome. However I couldn't find any help topics (even from zabbix manual v1.4) on the usage of proxy server. Can someone enlighten mi, please ??

Cheers
Take a look at the manual included into 1.5.1. The proxy is covered there.

BusteR81
21-04-2008, 07:48
Take a look at the manual included into 1.5.1. The proxy is covered there.

THanks Alexei. i do have a suggestion that you insert/update the v1.4 manual on zabbix website. it took mi abt 10 minutes to seach for the v1.6 manual download link as it is not updated in certain places.

BusteR81
21-04-2008, 10:17
3. Almost zero maintenance. For example, if a local Proxy database does not exist, the proxy will create one automatically. So, basically a binary and small configuration file is required to setup a proxy.

Can you explain what you meant? do i no longer have to create database zabbix and cat data.sql | mysql DB, etc. for a zabbix proxy server ???

Alexei
21-04-2008, 10:30
Can you explain what you meant? do i no longer have to create database zabbix and cat data.sql | mysql DB, etc. for a zabbix proxy server ???
Yes, the database will be created automatically provided the proxy user has permissions to do it.

BusteR81
21-04-2008, 10:58
Yes, the database will be created automatically provided the proxy user has permissions to do it.

I don't think it is able to do it.

[root@ALPHA6U02 zabbix]# /usr/local/sbin/zabbix_proxy

/tmp/zabbix_proxy.log :
22177:20080421:165205 Failed to connect to database: Error: Unknown database 'proxy' [1049]

zabbix_proxy.conf :
# Database host name
# Default is localhost

#DBHost=localhost

# Database name
# SQLite3 note: path to database file must be provided. DBUser and DBPassword are ignored.
DBName=proxy

# Database user

DBUser=root

# Database password
# Comment this line if no password used

#DBPassword=<password>

# Connect to MySQL using Unix socket?

#DBSocket=/tmp/mysql.sock

------------------manually create just database ----------------
[zabbix@ALPHA6U02 ~]$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 298 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database proxy;
Query OK, 1 row affected (0.00 sec)

/tmp/zabbix_proxy.log :
22281:20080421:165642 Query failed:Table 'proxy.items' doesn't exist [1146]

Alexei
21-04-2008, 11:02
It is currently implemented for SQLite only, more to come (including MySQL) in 1.6.

NL_Daan
29-04-2008, 15:12
Hi,
did someone notice that the Availability in the hosts overviews doesn't work anymore after implementing the proxy?

Alexei
12-06-2008, 22:21
Hi,
did someone notice that the Availability in the hosts overviews doesn't work anymore after implementing the proxy?
The availability column will be removed in 1.6. This is a major source of confusion for many ZABBIX users....

Emir Imamagic
03-10-2008, 01:23
It is currently implemented for SQLite only, more to come (including MySQL) in 1.6.

Could you confirm that auto creation for MySQL is implemented in 1.6? I installed proxy today and it was complaining that DB is missing. Only after I manually created the DB and executed SQL scripts, proxy started working.

Cheers,
emir

tekknokrat
16-10-2008, 17:38
I get this error message within proxy:

2351:20081016:164108 Query failed [19]:columns hostid, key_ are not unique

tekknokrat
16-10-2008, 18:27
hm, seems to be resolved after recreating database.
I have also seen this in some other post :confused:

tekknokrat
17-10-2008, 00:38
was only one short.

insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,del
ay,status,value_type,trapper_hosts,units,multiplie r,delta,snmpv3_securityname,sn
mpv3_securitylevel,snmpv3_authpassphrase,snmpv3_pr ivpassphrase,formula,logtimefm
t,templateid,valuemapid,delay_flex,params,ipmi_sen sor) values (24914,0,'','',161
,10078,'net.if.out[vlan101,bytes]',20,0,0,'','Bps',0,1,'',0,'','','0','',23496,0
,'','','');
insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,del
ay,status,value_type,trapper_hosts,units,multiplie r,delta,snmpv3_securityname,sn
mpv3_securitylevel,snmpv3_authpassphrase,snmpv3_pr ivpassphrase,formula,logtimefm
t,templateid,valuemapid,delay_flex,params,ipmi_sen sor) values (24915,0,'','',161
,10078,'net.if.in[vlan102,bytes]',20,0,0,'','Bps',0,1,'',0,'','','0','',23495,0,
'','','');
insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,del
ay,status,value_type,trapper_hosts,units,multiplie r,delta,snmpv3_securityname,sn
mpv3_securitylevel,snmpv3_authpassphrase,snmpv3_pr ivpassphrase,formula,logtimefm
t,templateid,valuemapid,delay_flex,params,ipmi_sen sor) values (24916,0,'','',161
,10078,'net.if.out[vlan102,bytes]',20,0,0,'','Bps',0,1,'',0,'','','0','',23497,0
,'','','');

2777:20081016:234237 Query failed [19]:columns hostid, key_ are not unique


I am wondering if key_ is really an existing column.

Cray
25-04-2009, 20:31
Hello tekknokrat ! :)

I'm facing the exact same problem you had a few months ago with the proxy (see my thread (http://www.zabbix.com/forum/showthread.php?t=12355))

Did you manage to solve this problem ?

I'm actually struggling with this issue and I don't understand why it is happening :(