Please advise....
stats
Fedora Core 4
Mysql 4.1.11
zabbix-1.0-2.rhfc4.at
i'm getting the error below when i try to launch zabbix_suckerd
and suckerd dies .. I have read the other postings on similar errors and still not winning the total zabbix database database folder is less than a meg ... ???
008267:20051005:124032 Query::insert into history (clock,itemid,value) values (1128508832,17434,1.000000)
008267:20051005:124032 Query failed:Lost connection to MySQL server during query [2013]
008267:20051005:124032 In add_trend()
008267:20051005:124032 SQL [select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400]
008267:20051005:124032 Executing query:select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400
008267:20051005:124032 Query::select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400
008267:20051005:124032 Query failed:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [2002]
008261:20051005:124032 One child process died. Exiting ...
008263:20051005:124032 Got QUIT or INT or TERM or PIPE signal. Exiting...
008265:20051005:124032 Got QUIT or INT or TERM or PIPE signal. Exiting...
this is my suckerd config
# This is config file for zabbix_suckerd
# To get more information about Zabbix,
# go http://zabbix.sourceforge.net
############ GENERAL PARAMETERS #################
# Number of pre-forked instances of zabbix_suckerd
# Default value is 5
# This parameter must be between 5 and 255
StartSuckers=5
# How often Zabbix will perform housekeeping procedure
# (in hours)
# Default value is 1 hour
# Housekeeping is removing unnecessary information from
# tables history, laert, and alarms
# This parameter must be between 1 and 24
HousekeepingFrequency=12
# How often Zabbix will try to send unsent alerts
# (in seconds)
# Default value is 30 seconds
SenderFrequency=30
# Uncomment this line to disable housekeeping procedure
#DisableHousekeeping=1
# Specifies debug level
# 0 - debug is not created
# 1 - critical information
# 2 - error information
# 3 - warnings (default)
# 4 - for debugging (produces lots of information)
DebugLevel=4
# Specifies how long we wait for agent (in sec)
# Must be between 1 and 30
Timeout=30
# Name of PID file
PidFile=/var/run/zabbix/zabbix_suckerd.pid
# Name of log file
# If not set, syslog is used
LogFile=/var/log/zabbix/zabbix_suckerd.log
#Location for custom alert scripts
AlertScriptsPath=/home/zabbix/bin/
#Location of 'fping. Default is /usr/sbin/fping
FpingLocation=/usr/sbin/fping
# Frequency of ICMP pings. Defauls is 30 second.
#PingerFrequency=30
# Database host name
# Default is localhost
DBHost=localhost
# Database name
DBName=zabbix
# Database user
DBUser=root
# Database password
# Comment this line if no password used
#DBPassword=turbo
# Connect to MySQL using Unix socket?
DBSocket=/var/lib/mysql/mysql.sock
# Experimental options. Use with care !
# Get rid of sockets in TIME_WAIT state
# This will set socket option SO_LINGER
NoTimeWait=1
this is my mysql config
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#port=3306
log=/var/log/mysql.log
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
stats
Fedora Core 4
Mysql 4.1.11
zabbix-1.0-2.rhfc4.at
i'm getting the error below when i try to launch zabbix_suckerd
and suckerd dies .. I have read the other postings on similar errors and still not winning the total zabbix database database folder is less than a meg ... ???
008267:20051005:124032 Query::insert into history (clock,itemid,value) values (1128508832,17434,1.000000)
008267:20051005:124032 Query failed:Lost connection to MySQL server during query [2013]
008267:20051005:124032 In add_trend()
008267:20051005:124032 SQL [select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400]
008267:20051005:124032 Executing query:select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400
008267:20051005:124032 Query::select num,value_min,value_avg,value_max from trends where itemid=17434 and clock=1128506400
008267:20051005:124032 Query failed:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [2002]
008261:20051005:124032 One child process died. Exiting ...
008263:20051005:124032 Got QUIT or INT or TERM or PIPE signal. Exiting...
008265:20051005:124032 Got QUIT or INT or TERM or PIPE signal. Exiting...
this is my suckerd config
# This is config file for zabbix_suckerd
# To get more information about Zabbix,
# go http://zabbix.sourceforge.net
############ GENERAL PARAMETERS #################
# Number of pre-forked instances of zabbix_suckerd
# Default value is 5
# This parameter must be between 5 and 255
StartSuckers=5
# How often Zabbix will perform housekeeping procedure
# (in hours)
# Default value is 1 hour
# Housekeeping is removing unnecessary information from
# tables history, laert, and alarms
# This parameter must be between 1 and 24
HousekeepingFrequency=12
# How often Zabbix will try to send unsent alerts
# (in seconds)
# Default value is 30 seconds
SenderFrequency=30
# Uncomment this line to disable housekeeping procedure
#DisableHousekeeping=1
# Specifies debug level
# 0 - debug is not created
# 1 - critical information
# 2 - error information
# 3 - warnings (default)
# 4 - for debugging (produces lots of information)
DebugLevel=4
# Specifies how long we wait for agent (in sec)
# Must be between 1 and 30
Timeout=30
# Name of PID file
PidFile=/var/run/zabbix/zabbix_suckerd.pid
# Name of log file
# If not set, syslog is used
LogFile=/var/log/zabbix/zabbix_suckerd.log
#Location for custom alert scripts
AlertScriptsPath=/home/zabbix/bin/
#Location of 'fping. Default is /usr/sbin/fping
FpingLocation=/usr/sbin/fping
# Frequency of ICMP pings. Defauls is 30 second.
#PingerFrequency=30
# Database host name
# Default is localhost
DBHost=localhost
# Database name
DBName=zabbix
# Database user
DBUser=root
# Database password
# Comment this line if no password used
#DBPassword=turbo
# Connect to MySQL using Unix socket?
DBSocket=/var/lib/mysql/mysql.sock
# Experimental options. Use with care !
# Get rid of sockets in TIME_WAIT state
# This will set socket option SO_LINGER
NoTimeWait=1
this is my mysql config
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#port=3306
log=/var/log/mysql.log
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Comment