Ad Widget

Collapse

Can't connect to local MySQL server through socket

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • clubbing80s
    Senior Member
    • Sep 2005
    • 109

    #1

    Can't connect to local MySQL server through socket

    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
  • elkor
    Senior Member
    • Jul 2005
    • 299

    #2
    you probably have selinux configured and running.

    try disabling this.

    Comment

    Working...