Ad Widget

Collapse

mysql errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bisbell
    Junior Member
    • May 2008
    • 14

    #1

    mysql errors

    When I try to start zabbix server I get the following to my zabbix_server.log file.
    10551:20080509:123406 Starting zabbix_server. ZABBIX 1.4.4.
    10551:20080509:123406 **** Enabled features ****
    10551:20080509:123406 SNMP monitoring: YES
    10551:20080509:123406 WEB monitoring: YES
    10551:20080509:123406 Jabber notifications: NO
    10551:20080509:123406 IPv6 support: NO
    10551:20080509:123406 **************************
    10551:20080509:123406 Failed to connect to database: Error: Can't connect to local MySQL server through socket '/opt/csw/mysql4/var/mysql.sock' (13) [2002]


    But if I try to connect to my database just using the command line it seems to work just fine.
    # mysql -uroot -pTEST -S/opt/csw/mysql4/var/mysql.sock zabbix


    And I have all of these same parameters in my zabbix_server.conf file:
    # Database name
    # SQLite3 note: path to database file must be provided. DBUser and DBPassword are ignored.
    DBName=zabbix

    # Database user
    DBUser=root

    # Database password
    # Comment this line if no password used
    DBPassword=TEST

    # Connect to MySQL using Unix socket?
    DBSocket=/opt/csw/mysql4/var/mysql.sock

    Any ideas of what I'm doing wrong?
  • bisbell
    Junior Member
    • May 2008
    • 14

    #2
    It was just a permissions problem. The mysql user owns the /opt/csw/mysql4/var directory and had 700 permissions on it keeping the zabbix user from getting to the socket file. Changing the permissions on the dir to 755 fixed the problem.

    It's always an easy answer- sometime..

    Comment

    Working...