Problem with mysql by agent2

[LenR]

I can't get it to work :-(

Version 6.4.2. I attached the template and set host macros for {$MYSQL.DSN}, {$MYSQL.USER} and {$MYSQL.PASSWORD}. Agent log gets error:

[Mysql] Cannot fetch data: Error 1045: Access denied for user 'root'@'localhost' (using password: NO).

But f I use zabbix_get with the values from the macro, it returns data:

zabbix_get -s 127.0.0.1 -k mysql.get_status_variables["unix:/var/lib/mysql/mysql.sock",zbx_monitor,zsecret]
{"Aborted_clients":"1","Aborted_connects":"69","Ab orted_connects_preauth":"0","Access_denied_errors" :"69","Acl_column_grants":"0", <truncated>

I increased logging level on the agent but didn't see any useful information.

Any ideas? Thanks

[LenR]

Found it.... I somehow had blanks in the macro values but the values in the description fields. It "looks" right, but it isn't.

[LenR]

Found it.... I somehow had blanks in the macro values but the values in the description fields. It "looks" right, but it isn't.