Ad Widget

Collapse

MySQL App Template

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nmz
    Member
    • Jan 2016
    • 69

    #1

    MySQL App Template

    I get mysql connection error when I use MySQL App Template.

    Thais is error what I got :
    11940:20160126:164832.709 zbx_popen(): executing script
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    and this is my userparameter_mysql.conf
    Code:
     11940:20160126:164832.709 zbx_popen(): executing script
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    and that is piece of zabbix_agentd.conf
    Code:
    ### Option: Include
    #	You may include individual files or all files in a directory in the configuration file.
    #	Installing Zabbix will create include directory in /usr/local/etc, unless modified during the compile time.
    #
    # Mandatory: no
    # Default:
    # Include=
    
    #Include=/etc/zabbix/zabbix_agentd.d
    Include=/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
    #Include=/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
    # Include=/usr/local/etc/zabbix_agentd.userparams.conf
    # Include=/usr/local/etc/zabbix_agentd.conf.d/
    One more file which I was setup in /var/lib/zabbix/ is .my.cnf
    Code:
    [mysql]
    user=root
    password=password
    [mysqladmin]
    user=root
    password=password
    [PS : I used root as mysql user. I can't login in mysql with zabbix user from other host. Willing to get any help also about mysql privileges.]
Working...