search

kloczek / zabbix-templates

Zabbix templates
113 stars 65 forks source link

documentation on how to configure mysql template #21

Open OrwinLopes opened 5 years ago

OrwinLopes commented 5 years ago

can you please share documentation on how to configure mysql template

kloczek commented 5 years ago

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 :)

OrwinLopes commented 5 years ago

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

OrwinLopes commented 5 years ago

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)