documentation on how to configure mysql template about zabbix-templates HOT 3 OPEN

Just committed changes on devel branch with details what needs to be don to monitor MySQL.
If you think that it is enough clear please close that ticket :)

from zabbix-templates.

Thanks alot but i get this error. can you please help :-

[root@zabbixdb bin]# su - zabbix -s /bin/bash -c "mysql_config_editor set --login-path=monitoring --user monitoring --password"
su: warning: cannot change directory to /usr/lib/zabbix: No such file or directory
mysql_config_editor: Can't create/write to file '/usr/lib/zabbix/.mylogin.cnf' (OS errno 2 - No such file or directory)
couldn't create the login file : No such file or directory
mysql_config_editor: Error on close of 'UNKNOWN' (OS errno 9 - Bad file descriptor)
operation failed. : Bad file descriptor

from zabbix-templates.

i can see the direcotry should be /usr/lib/zabbix ? i might be wrong...can u confirm

mkdir -p /var/lib/zabbix (should be /usr/lib/zabbix)
chwon zabbix:zabbix /var/lib/zabbix
chmod 700 /var/lib/zabbix
su - zabbix -s /bin/bash -c "mysql_config_editor set --login-path=monitoring --user monitoring --password"

after changing it gives this below error :-
su - zabbix -s /bin/bash -c "mysql_config_editor set --login-path=monitoring --user monitoring --password"
su: warning: cannot change directory to /usr/lib/zabbix: Permission denied
-bash: /usr/lib/zabbix/.bash_profile: Permission denied
mysql_config_editor: Can't create/write to file '/usr/lib/zabbix/.mylogin.cnf' (OS errno 13 - Permission denied)
couldn't create the login file : Permission denied
mysql_config_editor: Error on close of 'UNKNOWN' (OS errno 9 - Bad file descriptor)

from zabbix-templates.