On 08/01/2014 03:44 PM, Bogdan-Stefan Rotariu wrote: > >> On Aug 1, 2014, at 15:27, Adrian Sevcenco <[email protected]> >> wrote: >> >> in zabbix.conf.php am serverul de mysql pus cu 127.0.0.1 > > 127.0.0.1 si localhost nu sunt acelasi lucru, localhost se conecteaza > pe socket, 127.0.0.1 pe tcp, pune localhost si in config sau adauga > allow si de la 127.0.0.1 ok... 1. am facut grant si pentru 127.0.0.1 (sa fie) grant all privileges on zabbix.* to 'zabbix'@'localhost' with grant option; grant all privileges on zabbix.* to 'zabbix'@'127.0.0.1' with grant option;
2. am comentat portul si am lasat socketul enabled, parola e reverificata (pot sa intru cu mysql -u zabbix zabbix -p) 3. [root@monitor zabbix]# tail -n1 zabbix_server.log 19963:20140801:161330.100 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES) 4. [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 5. [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'] = 'ACEIASI_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; ?> multumesc de sfaturi si pareri! Adrian
_______________________________________________ RLUG mailing list [email protected] http://lists.lug.ro/mailman/listinfo/rlug
