Ad Widget

Collapse

Zabbix not listening and no mysql connection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AdrianSevcenco
    Junior Member
    • Aug 2014
    • 4

    #1

    Zabbix not listening and no mysql connection

    Hi! I m trying to install zabix on a centos 6.5 server
    the problem si that the zabbix_server do no listen
    and cannot create mysql connection...

    but: i can connect by doing mysql -u zabbix zabbix -p and the show tables;
    looks ok

    my settings are:

    [root@monitor zabbix]# grep ^[0-9,A-F,a-f] /etc/zabbix/zabbix_server.conf
    DebugLevel=2
    DBHost=localhost
    DBName=zabbix
    DBUser=zabbix
    DBPassword='PAROLA_SECRETA'
    DBSocket=/var/lib/mysql/mysql.sock
    AlertScriptsPath=/usr/lib/zabbix/alertscripts
    ExternalScripts=/usr/lib/zabbix/externalscripts
    FpingLocation=/usr/sbin/fping
    Fping6Location=/usr/sbin/fping6
    AllowRoot=0

    [root@monitor web]# cat zabbix.conf.php
    <?php
    // Zabbix GUI configuration file
    global $DB;

    $DB['TYPE'] = 'MYSQL';
    $DB['SERVER'] = 'localhost';
    $DB['PORT'] = '3306';
    $DB['DATABASE'] = 'zabbix';
    $DB['USER'] = 'zabbix';
    $DB['PASSWORD'] = 'PAROLA_SECRETA';

    // SCHEMA is relevant only for IBM_DB2 database
    $DB['SCHEMA'] = '';

    $ZBX_SERVER = 'localhost';
    $ZBX_SERVER_PORT = '10051';
    $ZBX_SERVER_NAME = '';

    $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
    ?>

    does anyone have any idea why this is not working?
    i found no information in any installation turorial...

    Thanks a lot!!
    Adrian
  • Odilhao
    Junior Member
    • Jun 2013
    • 8

    #2
    Can you post the zabbix_server.log , maybe you need to grant access for zabbix user on localhost socket.

    Try this

    grant all privileges on zabbix.* to zabbix@localhost identified by ‘password’

    Comment

    • AdrianSevcenco
      Junior Member
      • Aug 2014
      • 4

      #3
      sorry for not replying earlier... i found the problem : i escaped the password in zabbix_server.conf. it seems that the password is read as all characters after DBPassword=
      i removed the '' and now it is working. maybe is worth mentionined in help somewhere..
      Thanks!
      Adrian

      Comment

      Working...