Selasa, 30 Oktober 2018

How to configure mysql plugins check mk agent

  1 komentar
Before you read the following section, make sure you have install check mk agent and work properly, if yet, you can find the tutorial how to install check mk agent here

Create check_mk user on mysql with select only permission
[email protected]:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 289
Server version: 5.5.60-0+deb7u1 (Debian)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT SELECT ON *.* to check_mk@'localhost' IDENTIFIED BY '[email protected]';
Query OK, 0 rows affected (0.29 sec)

mysql> exit
Bye
[email protected]:~$

Execute check mk agent and read the text result, find out where is the agent directory and plugins directory
[email protected]:~$ nc -v localhost 6556
Connection to localhost 6556 port [tcp/*] succeeded!
<<<check_mk>>>
Version: 1.5.0p4
AgentOS: linux
Hostname: vta-cloud
AgentDirectory: /etc/check_mk
DataDirectory: /var/lib/check_mk_agent
SpoolDirectory: /var/lib/check_mk_agent/spool
PluginsDirectory: /usr/lib/check_mk_agent/plugins
LocalDirectory: /usr/lib/check_mk_agent/local
<<<df>>>
udev           devtmpfs     4059644        0   4059644       0% /dev
tmpfs          tmpfs         815768    50488    765280       7% /run
/dev/sda4      ext4       495251272 85974012 384096896      19% /
tmpfs          tmpfs        4078820       80   4078740       1% /dev/shm
tmpfs          tmpfs           5120        0      5120       0% /run/lock

Create mysq.cfg new file on check mk agent directory with following content, use mysql user and password that created before
[email protected]:~$ sudo vi /etc/check_mk/mysql.cfg
[sudo] password for sysop:
[email protected]:~$
[email protected]:~$ sudo cat /etc/check_mk/mysql.cfg
[client]
user=check_mk
[email protected]
[email protected]:~$
Create mysq.cfg new file on check mk agent directory with following content, use mysql user and password that created before
[email protected]:~$ sudo vi /etc/check_mk/mysql.cfg
[sudo] password for sysop:
[email protected]:~$
[email protected]:~$ sudo cat /etc/check_mk/mysql.cfg
[client]
user=check_mk
[email protected]
[email protected]:~$
Change working directory to check mk agent plugins and download the check mk mysql plugins
[email protected]:~$ cd /usr/lib/check_mk_agent/plugins/
[email protected]:/usr/lib/check_mk_agent/plugins$ ls
[email protected]:/usr/lib/check_mk_agent/plugins$ 
[email protected]:/usr/lib/check_mk_agent/plugins$ sudo wget https://monitoring.wachid.web.id/monitoring/check_mk/agents/plugins/mk_mysql
--2018-10-30 18:21:49--  https://monitoring-wachid.web.id/monitoring/check_mk/agents/plugins/mk_mysql
Connecting to 192.168.71.17:9898... connected.
Proxy request sent, awaiting response... 200 OK
Length: 3518 (3.4K) [text/plain]
Saving to: ‘mk_mysql’

mk_mysql                          100%[===========================================================>]   3.44K  --.-KB/s    in 0s

2018-10-30 18:21:50 (23.6 MB/s) - ‘mk_mysql’ saved [3518/3518]

[email protected]:/usr/lib/check_mk_agent/plugins$ ls
mk_mysql
[email protected]:/usr/lib/check_mk_agent/plugins$
Add execution privileges to the mysql plugins file
[email protected]:/usr/lib/check_mk_agent/plugins$ sudo chmod 775 mk_mysql
[email protected]:/usr/lib/check_mk_agent/plugins$
[email protected]:/usr/lib/check_mk_agent/plugins$ ls -l
total 4
-rwxrwxr-x 1 root root 3518 Sep 11 00:27 mk_mysql
[email protected]:/usr/lib/check_mk_agent/plugins$
Execute the check mk agent by telnet localhost on port 6556 and read out the result, you fill find mysql under the local result text, it's mean the check mk mysql plugins work properly
...
...
<<<local>>>
<<<<>>>>
<<<local>>>
<<<mysql_ping>>>
[[mysql]]
mysqld is alive
<<<mysql>>>
[[mysql]]
Aborted_clients 3
Aborted_connects        16
Binlog_cache_disk_use   0
Binlog_cache_use        0
Binlog_stmt_cache_disk_use      0
Binlog_stmt_cache_use   0
Bytes_received  29721010161
Bytes_sent      186671796
Com_admin_commands      58
Com_assign_to_keycache  0
Com_alter_db    0
Com_alter_db_upgrade    0
Com_alter_event 0
Com_alter_function      0


1 komentar :