problem adding local agent to zabbix proxy

[echoranger]

Hello,

I'm trying to get a zabbix proxy setup and I'm having a devil of a time. I've installed the zabbix_proxy software on my proxy system, imported the schema.sql DB ONLY (I'm using MySQL as the backend), added the proxy as an Active proxy to the Zabbix Server via the Administration, DM option in the web interface, no problems with any of that. I've verified that the zabbix proxy is communicating with the server every 60 seconds.

Now I added a zabbix agent to the zabbix proxy host and then told my zabbix server that this particular agent should be monitored via the proxy under its Configuration, Hosts entry. Almost immediately after doing that I see the following in my zabbix_proxy.log file:

30465:20130703:211219.453 Received configuration data from server. Datalen 9792
30465:20130703:211219.458 [Z3005] query failed: [1364] Field 'description' doesn't have a default value [insert into items (itemid,type,snmp_community,snmp_oid,hostid,key_,d elay,status,value_type,trapper_hosts,snmpv3_securi tyname,snmpv3_securitylevel,snmpv3_authpassphrase, snmpv3_privpassphrase,formula,logtimefmt,delay_fle x,params,ipmi_sensor,data_type,authtype,username,p assword,publickey,privatekey,flags,filter,interfac eid,port) values (36258,0,'','',10346,'agent.ping',60,0,3,'','',0,' ','','1','','','','',0,0,'','','','',0,'',31038,'' );
insert into items (itemid,type,snmp_community,snmp_oid,hostid,key_,d elay,status,value_type,trapper_hosts,snmpv3_securi tyname,snmpv3_securitylevel,snmpv3_authpassphrase, snmpv3_privpassphrase,formula,logtimefmt,delay_fle x,params,ipmi_sensor,data_type,authtype,username,p assword,publickey,privatekey,flags,filter,interfac eid,port) values (36259,0,'','',10346,'net.if.in[eth0,bytes]',60,0,0,'','',0,'','','0','','','','',0,0,'','',' ','',0,'',31038,'');
...
30465:20130703:211219.459 failed to update local proxy cofiguration copy: database error


I'm not sure what to do here. This error reappears in the log every time the proxy queries the server for its configuration. I've tried dropping and recreating the zabbix_proxy database I created for use with this proxy (which is also referenced in the DBName param in the zabbix_proxy.conf file), still getting the same error.


One other side question: as this agent lives on the zabbix proxy itself, when I configure the agent via the Hosts view of the web interface, should I use 127.0.0.1 as the agent's IP as well as the Server entry in the zabbix_agent.conf file? The way I interpret the documentation all hosts that are monitored via the proxy should be configured to talk to the proxy and not the zabbix server.


Thanks!

[werneck.costa]

Hello echoranger,
What is the version of agent/server/proxy?
Can you put here your zabbix_proxy.conf and zabbix_agentd.conf?

[echoranger]

The server, agent, and proxy are all version 2.0.1.

zabbix_agentd.conf (1.2.3.4 is the IP address of this host, the proxy):

# This is a config file for Zabbix Agent (Unix)
# To get more information about Zabbix, visit http://www.zabbix.com
#
############ GENERAL PARAMETERS #################

### Option: PidFile
#       Name of PID file.
#
# Mandatory: no
# Default:
# PidFile=/tmp/zabbix_agentd.pid

### Option: LogFile
#       Name of log file.
#       If not set, syslog is used.
#
# Mandatory: no
# Default:
# LogFile=
LogFile=/var/log/zabbix/zabbix_agentd.log

### Option: LogFileSize
#       Maximum size of log file in MB.
#       0 - disable automatic log rotation.
#
# Mandatory: no
# Range: 0-1024
# Default:
# LogFileSize=1
LogFileSize=10

### Option: DebugLevel
#       Specifies debug level
#       0 - no debug
#       1 - critical information
#       2 - error information
#       3 - warnings
#       4 - for debugging (produces lots of information)
#
# Mandatory: no
# Range: 0-4
# Default:
# DebugLevel=3

### Option: SourceIP
#       Source IP address for outgoing connections.
#
# Mandatory: no
# Default:
# SourceIP=

### Option: EnableRemoteCommands
#       Whether remote commands from Zabbix server are allowed.
#       0 - not allowed
#       1 - allowed
#
# Mandatory: no
# Default:
# EnableRemoteCommands=0
EnableRemoteCommands=1

### Option: LogRemoteCommands
#       Enable logging of executed shell commands as warnings.
#       0 - disabled
#       1 - enabled
#
# Mandatory: no
# Default:
# LogRemoteCommands=0
LogRemoteCommands=1

##### Passive checks related

### Option: Server
#       List of comma delimited IP addresses (or hostnames) of Zabbix servers.
#       Incoming connections will be accepted only from the hosts listed here.
#       No spaces allowed.
#       If IPv6 support is enabled then '127.0.0.1', '::127.0.0.1', '::ffff:127.                                                                                                                                                                                                0.0.1' are treated equally.
#
# Mandatory: no
# Default:
# Server=

Server=1.2.3.4

### Option: ListenPort
#       Agent will listen on this port for connections from the server.
#
# Mandatory: no
# Range: 1024-32767
# Default:
# ListenPort=10050

### Option: ListenIP
#       List of comma delimited IP addresses that the agent should listen on.
#       First IP address is sent to Zabbix server if connecting to it to retriev                                                                                                                                                                                                e list of active checks.
#
# Mandatory: no
# Default:
# ListenIP=0.0.0.0

### Option: StartAgents
#       Number of pre-forked instances of zabbix_agentd that process passive che                                                                                                                                                                                                cks.
#       If set to 0, disables passive checks and the agent will not listen on an                                                                                                                                                                                                y TCP port.
#
# Mandatory: no
# Range: 0-100
# Default:
# StartAgents=3

##### Active checks related
#
### Option: ServerActive
#       List of comma delimited IP:port (or hostname:port) pairs of Zabbix serve                                                                                                                                                                                                rs for active checks.
#       If port is not specified, default port is used.
#       IPv6 addresses must be enclosed in square brackets if port for that host                                                                                                                                                                                                 is specified.
#       If port is not specified, square brackets for IPv6 addresses are optiona                                                                                                                                                                                                l.
#       If this parameter is not specified, active checks are disabled.
#       Example: ServerActive=127.0.0.1:20051,zabbix.domain,[::1]:30051,::1,[12f                                                                                                                                                                                                c::1]
#
# Mandatory: no
# Default:
# ServerActive=

ServerActive=1.2.3.4

### Option: Hostname
#       Unique, case sensitive hostname.
#       Required for active checks and must match hostname as configured on the                                                                                                                                                                                                 server.
#       Value is acquired from HostnameItem if undefined.
#
# Mandatory: no
# Default:
# Hostname=
Hostname=zabbix101.core.domain.tld

### Option: HostnameItem
#       Item used for generating Hostname if it is undefined.
#       Ignored if Hostname is defined.
#
# Mandatory: no
# Default:
# HostnameItem=system.hostname

### Option: RefreshActiveChecks
#       How often list of active checks is refreshed, in seconds.
#
# Mandatory: no
# Range: 60-3600
# Default:
# RefreshActiveChecks=120

### Option: BufferSend
#       Do not keep data longer than N seconds in buffer.
#
# Mandatory: no
# Range: 1-3600
# Default:
# BufferSend=5

### Option: BufferSize
#       Maximum number of values in a memory buffer. The agent will send
#       all collected data to Zabbix Server or Proxy if the buffer is full.
#
# Mandatory: no
# Range: 2-65535
# Default:
# BufferSize=100

### Option: MaxLinesPerSecond
#       Maximum number of new lines the agent will send per second to Zabbix Ser                                                                                                                                                                                                ver
#       or Proxy processing 'log' and 'logrt' active checks.
#       The provided value will be overridden by the parameter 'maxlines',
#       provided in 'log' or 'logrt' item keys.
#
# Mandatory: no
# Range: 1-1000
# Default:
# MaxLinesPerSecond=100

### Option: AllowRoot
#       Allow the agent to run as 'root'. If disabled and the agent is started b                                                                                                                                                                                                y 'root', the agent
#       will try to switch to user 'zabbix' instead. Has no effect if started un                                                                                                                                                                                                der a regular user.
#       0 - do not allow
#       1 - allow
#
# Mandatory: no
# Default:
# AllowRoot=0

############ ADVANCED PARAMETERS #################

### Option: Alias
#       Sets an alias for parameter. It can be useful to substitute long and com                                                                                                                                                                                                plex parameter name with a smaller and simpler one.
#
# Mandatory: no
# Range:
# Default:

### Option: Timeout
#       Spend no more than Timeout seconds on processing
#
# Mandatory: no
# Range: 1-30
# Default:
# Timeout=3

### Option: Include
#       You may include individual files or all files in a directory in the conf                                                                                                                                                                                                iguration file.
#       Installing Zabbix will create include directory in /usr/local/etc, unles                                                                                                                                                                                                s modified during the compile time.
#
# Mandatory: no
# Default:
# Include=

# Include=/usr/local/etc/zabbix_agentd.userparams.conf
# Include=/usr/local/etc/zabbix_agentd.conf.d/

####### USER-DEFINED MONITORED PARAMETERS #######

### Option: UnsafeUserParameters
#       Allow all characters to be passed in arguments to user-defined parameter                                                                                                                                                                                                s.
#       0 - do not allow
#       1 - allow
#
# Mandatory: no
# Range: 0-1
# Default:
# UnsafeUserParameters=0

### Option: UserParameter
#       User-defined parameter to monitor. There can be several user-defined par                                                                                                                                                                                                ameters.
#       Format: UserParameter=<key>,<shell command>
#       See 'zabbix_agentd' directory for examples.
#
# Mandatory: no
# Default:
# UserParameter=

### MySQL parameters
UserParameter=mysql.uptime,mysqladmin -uzabbix -pxxxxxx status|cut -f2 -d":
"|cut -f1 -d"T"
UserParameter=mysql.threads,mysqladmin -uzabbix -pxxxxxx status|cut -f3 -d"
:"|cut -f1 -d"Q"
UserParameter=mysql.questions,mysqladmin -uzabbix -pxxxxxx status|cut -f4 -
d":"|cut -f1 -d"S"
UserParameter=mysql.slowqueries,mysqladmin -uzabbix -pxxxxxx status|cut -f5
 -d":"|cut -f1 -d"O"

zabbix_proxy.conf (2.3.4.5 is the IP of the zabbix server it is proxying to):

# This is a configuration file for Zabbix Proxy process
# To get more information about Zabbix,
# visit http://www.zabbix.com

############ GENERAL PARAMETERS #################

### Option: ProxyMode
#       Proxy operating mode
#       0 - proxy in the active mode
#       1 - proxy in the passive mode
#
# Mandatory: no
# Default:
# ProxyMode=0

### Option: Server
#       IP address (or hostname) of Zabbix server.
#       Active proxy will get configuration data from the server.
#       For a proxy in the passive mode this parameter will be ignored.
#
# Mandatory: yes (if ProxyMode is set to 0)
# Default:
# Server=

Server=2.3.4.5

### Option: ServerPort
#       Port of Zabbix trapper on Zabbix server.
#       For a proxy in the passive mode this parameter will be ignored.
#
# Mandatory: no
# Range: 1024-32767
# Default:
# ServerPort=10051

### Option: Hostname
#       Unique, case sensitive Proxy name. Make sure the Proxy name is known to                                                                                                                                                                                                 the server!
#       Value is acquired from HostnameItem if undefined.
#
# Mandatory: no
# Default:
# Hostname=

Hostname=zabbix101.core.domain.tld

### Option: HostnameItem
#       Item used for generating Hostname if it is undefined.
#       Ignored if Hostname is defined.
#
# Mandatory: no
# Default:
# HostnameItem=system.hostname

### Option: ListenPort
#       Listen port for trapper.
#
# Mandatory: no
# Range: 1024-32767
# Default:
# ListenPort=10051

### Option: SourceIP
#       Source IP address for outgoing connections.
#
# Mandatory: no
# Default:
# SourceIP=

### Option: LogFile
#       Name of log file.
#       If not set, syslog is used.
#
# Mandatory: no
# Default:
# LogFile=

LogFile=/var/log/zabbix/zabbix_proxy.log

### Option: LogFileSize
#       Maximum size of log file in MB.
#       0 - disable automatic log rotation.
#
# Mandatory: no
# Range: 0-1024
# Default:
# LogFileSize=1

### Option: DebugLevel
#       Specifies debug level
#       0 - no debug
#       1 - critical information
#       2 - error information
#       3 - warnings
#       4 - for debugging (produces lots of information)
#
# Mandatory: no
# Range: 0-4
# Default:
# DebugLevel=3

### Option: PidFile
#       Name of PID file.
#
# Mandatory: no
# Default:
# PidFile=/tmp/zabbix_proxy.pid

### Option: DBHost
#       Database host name.
#       If set to localhost, socket is used for MySQL.
#       If set to empty string, socket is used for PostgreSQL.
#
# Mandatory: no
# Default:
# DBHost=localhost

### Option: DBName
#       Database name.
#       For SQLite3 path to database file must be provided. DBUser and DBPasswor                                                                                                                                                                                                d are ignored.
#
# Mandatory: yes
# Default:
# DBName=

DBName=zabbix_proxy

### Option: DBSchema
#       Schema name. Used for IBM DB2.
#
# Mandatory: no
# Default:
# DBSchema=

### Option: DBUser
#       Database user. Ignored for SQLite.
#
# Default:
# DBUser=

DBUser=zabbix

### Option: DBPassword
#       Database password. Ignored for SQLite.
#       Comment this line if no password is used.
#
# Mandatory: no
# Default:
# DBPassword=

DBPassword=xxxxxxx

### Option: DBSocket
#       Path to MySQL socket.
#
# Mandatory: no
# Default:
# DBSocket=/tmp/mysql.sock

DBSocket=/opt/mysql/mysql.sock

# Option: DBPort
#       Database port when not using local socket. Ignored for SQLite.
#
# Mandatory: no
# Default (for MySQL):
# DBPort=3306

######### PROXY SPECIFIC PARAMETERS #############

### Option: ProxyLocalBuffer
#       Proxy will keep data locally for N hours.
#       This parameter may be used if local data will be used by third party app                                                                                                                                                                                                lications.
#
# Mandatory: no
# Range: 0-720
# Default:
# ProxyLocalBuffer=0

ProxyLocalBuffer=4

### Option: ProxyOfflineBuffer
#       Proxy will keep data for N hours in case if no connectivity with Zabbix                                                                                                                                                                                                 Server.
#       Older data will be lost.
#
# Mandatory: no
# Range: 1-720
# Default:
# ProxyOfflineBuffer=1

ProxyOfflineBuffer=4

### Option: HeartbeatFrequency
#       Frequency of heartbeat messages in seconds.
#       Used for monitoring availability of Proxy on server side.
#       0 - heartbeat messages disabled.
#       For a proxy in the passive mode this parameter will be ignored.
#
# Mandatory: no
# Range: 0-3600
# Default:
# HeartbeatFrequency=60

### Option: ConfigFrequency
#       How often proxy retrieves configuration data from Zabbix Server in secon                                                                                                                                                                                                ds.
#       For a proxy in the passive mode this parameter will be ignored.
#
# Mandatory: no
# Range: 1-3600*24*7
# Default:
# ConfigFrequency=3600

ConfigFrequency=60

### Option: DataSenderFrequency
#       Proxy will send collected data to the Server every N seconds.
#       For a proxy in the passive mode this parameter will be ignored.
#
# Mandatory: no
# Range: 1-3600
# Default:
# DataSenderFrequency=1

############ ADVANCED PARAMETERS ################

### Option: StartPollers
#       Number of pre-forked instances of pollers.
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartPollers=5

StartPollers=15

### Option: StartIPMIPollers
#       Number of pre-forked instances of IPMI pollers.
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartIPMIPollers=0

### Option: StartPollersUnreachable
#       Number of pre-forked instances of pollers for unreachable hosts (includi                                                                                                                                                                                                ng IPMI).
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartPollersUnreachable=1

StartPollersUnreachable=5

### Option: StartTrappers
#       Number of pre-forked instances of trappers.
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartTrappers=5

### Option: StartPingers
#       Number of pre-forked instances of ICMP pingers.
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartPingers=1

### Option: StartDiscoverers
#       Number of pre-forked instances of discoverers.
#
# Mandatory: no
# Range: 0-250
# Default:
# StartDiscoverers=1

### Option: JavaGateway
#       IP address (or hostname) of Zabbix Java gateway.
#       Only required if Java pollers are started.
#
# Mandatory: no
# Default:
# JavaGateway=

### Option: JavaGatewayPort
#       Port that Zabbix Java gateway listens on.
#
# Mandatory: no
# Range: 1024-32767
# Default:
# JavaGatewayPort=10052

### Option: StartJavaPollers
#       Number of pre-forked instances of Java pollers.
#
# Mandatory: no
# Range: 0-1000
# Default:
# StartJavaPollers=0

### Option: SNMPTrapperFile
#       Temporary file used for passing data from SNMP trap daemon to the proxy.
#       Must be the same as in zabbix_trap_receiver.pl or SNMPTT configuration f                                                                                                                                                                                                ile.
#
# Mandatory: no
# Default:
# SNMPTrapperFile=/tmp/zabbix_traps.tmp

### Option: StartSNMPTrapper
#       If 1, SNMP trapper process is started.
#
# Mandatory: no
# Range: 0-1
# Default:
# StartSNMPTrapper=0

### Option: ListenIP
#       List of comma delimited IP addresses that the trapper should listen on.
#       Trapper will listen on all network interfaces if this parameter is missi                                                                                                                                                                                                ng.
#
# Mandatory: no
# Default:
# ListenIP=0.0.0.0

### Option: HousekeepingFrequency
#       How often Zabbix will perform housekeeping procedure (in hours).
#       Housekeeping is removing unnecessary information from history, alert, an                                                                                                                                                                                                d alarms tables.
#
# Mandatory: no
# Range: 1-24
# Default:
# HousekeepingFrequency=1

### Option: CacheSize
#       Size of configuration cache, in bytes.
#       Shared memory size, for storing hosts and items data.
#
# Mandatory: no
# Range: 128K-1G
# Default:
# CacheSize=8M

CacheSize=10M

### Option: StartDBSyncers
#       Number of pre-forked instances of DB Syncers
#
# Mandatory: no
# Range: 1-100
# Default:
# StartDBSyncers=4

### Option: HistoryCacheSize
#       Size of history cache, in bytes.
#       Shared memory size for storing history data.
#
# Mandatory: no
# Range: 128K-1G
# Default:
# HistoryCacheSize=8M

HistoryCacheSize=10M

### Option: HistoryTextCacheSize
#       Size of text history cache, in bytes.
#       Shared memory size for storing character, text or log history data.
#
# Mandatory: no
# Range: 128K-1G
# Default:
# HistoryTextCacheSize=16M

### Option: Timeout
#       Specifies how long we wait for agent, SNMP device or external check (in                                                                                                                                                                                                 seconds).
#
# Mandatory: no
# Range: 1-30
# Default:
# Timeout=3

Timeout=29

### Option: TrapperTimeout
#       Specifies how many seconds trapper may spend processing new data.
#
# Mandatory: no
# Range: 1-300
# Default:
# TrapperTimeout=300

### Option: UnreachablePeriod
#       After how many seconds of unreachability treat a host as unavailable.
#
# Mandatory: no
# Range: 1-3600
# Default:
# UnreachablePeriod=45

### Option: UnavailableDelay
#       How often host is checked for availability during the unavailability per                                                                                                                                                                                                iod, in seconds.
#
# Mandatory: no
# Range: 1-3600
# Default:
# UnavailableDelay=60

### Option: UnreachableDelay
#       How often host is checked for availability during the unreachability per                                                                                                                                                                                                iod, in seconds.
#
# Mandatory: no
# Range: 1-3600
# Default:
# UnreachableDelay=15

### Option: ExternalScripts
#       Full path to location of external scripts.
#       Default depends on compilation options.
#
# Mandatory: no
# Default:
# ExternalScripts=${datadir}/zabbix/externalscripts

ExternalScripts=/etc/zabbix/scripts/

### Option: FpingLocation
#       Location of fping.
#       Make sure that fping binary has root ownership and SUID flag set.
#
# Mandatory: no
# Default:
# FpingLocation=/usr/sbin/fping

### Option: Fping6Location
#       Location of fping6.
#       Make sure that fping6 binary has root ownership and SUID flag set.
#       Make empty if your fping utility is capable to process IPv6 addresses.
#
# Mandatory: no
# Default:
# Fping6Location=/usr/sbin/fping6

### Option: SSHKeyLocation
#       Location of public and private keys for SSH checks and actions
#
# Mandatory: no
# Default:
# SSHKeyLocation=

### Option: LogSlowQueries
#       How long a database query may take before being logged (in milliseconds)                                                                                                                                                                                                .
#       0 - don't log slow queries.
#
# Mandatory: no
# Range: 1-3600000
# Default:
# LogSlowQueries=0

### Option: TmpDir
#       Temporary directory.
#
# Mandatory: no
# Default:
# TmpDir=/tmp

### Option: Include
#       You may include individual files or all files in a directory in the conf                                                                                                                                                                                                iguration file.
#       Installing Zabbix will create include directory in /usr/local/etc, unles                                                                                                                                                                                                s modified during the compile time.
#
# Mandatory: no
# Default:
# Include=

# Include=/usr/local/etc/zabbix_proxy.general.conf
# Include=/usr/local/etc/zabbix_proxy.conf.d/

[heaje]

I ran into this exact same issue. The problem is the db schema that is created. This exact same problem exists in one of the regex tables as well. I got around it by modifying the schema to allow null values in the items.description column and the other one that you'll run into after fixing the description column.

[echoranger]

Thanks for that update heaje, I was thinking along the lines of needing to tweak the schema. For the time being I was able to get around the issue by building another zabbix-proxy package that uses SQLite as the backend over MySQL (not an issue here as there's only a handful of devices monitored through this proxy), which doesn't have this same issue. If/when I have time I'll revisit the MySQL backend and see if I can tweak the schema into a working edition, but for now I'll focus on "don't fix what ain't broke"

Thanks again!

[werneck.costa]

Ok.
Good Luck!