#.
# name to disable plugin
# # name to disable plugin

khan-plugin-apache
khan-plugin-nginx
khan-plugin-docker
khan-plugin-crio
khan-plugin-containerd
khan-plugin-cubrid
khan-plugin-mysql

#.
# name to disable plugin
# # name to disable plugin

#khan-plugin-apache
khan-plugin-nginx
#khan-plugin-docker
khan-plugin-crio
khan-plugin-containerd
khan-plugin-cubrid
khan-plugin-mysql

instance=apache
host=localhost
port=80
username=
password=
infoUrlPath=/server-info?server
statusUrlPath=/status?auto
jkStatusUrlPath=/jkstatus
modClusterManagerUrlPath=/mod_cluster_manager

maxConnections=1
maxConnectionsPerHost=1
maxConnectionsPerRoute=1
waitIdleCheck=60000
waitIdleClose=120
requestTimeout=1000
sessionTimeout=1000

## "key":"log directory path":"http status code index" - split with whitespaces, ex) homepage:/data/logs/homepage:8
#http.status.code.log.dir=homepage:/data/logs/homepage:8,admin:/data/logs/admin:8
#http.status.code.log.exclude.url.patterns=\\*/,/status,/server-info,/jkstatus,/mod_cluster_manager
#http.status.code.log.exclude.file.patterns=^httpd.log$,.*mod_jk.*,.*modjk.*,.*error_log.*,.*modcluster.*

#
# ExtendedStatus controls whether Apache will generate "full" status
# information (ExtendedStatus On) or just basic information (ExtendedStatus
# Off) when the "server-status" handler is called. The default is Off.
#
ExtendedStatus On

#
# Allow server status reports generated by mod_status,
# with the URL of http://servername/server-status
# Change the ".example.com" to match your domain to enable.
#
<Location /status>
  SetHandler server-status
  Order deny,allow
  Deny from all
  Allow from localhost
</Location>

#
# Allow remote server configuration reports, with the URL of
# http://servername/server-info (requires that mod_info.c be loaded).
# Change the ".example.com" to match your domain to enable.
#
<Location /server-info>
  SetHandler server-info
  Order deny,allow
  Deny from all
  Allow from localhost
</Location>

#.
# Nginx status monitoring
# # Nginx status monitoring

instance=nginx
host=localhost
port=80
username=
password=
statusUrlPath=/nginx_status

maxConnections=1
maxConnectionsPerHost=1
maxConnectionsPerRoute=1
waitIdleCheck=60000
waitIdleClose=120
requestTimeout=1000
sessionTimeout=1000

    location /nginx_status {
    stub_status;
    allow 127.0.0.1;
    deny all;
}

#.
# Cubrid status monitoring
# # Cubrid status monitoring

# cubrid server home directory
# if cubridHome is empty then check environment variable 'CUBRID'
cubridHome=

# comma separated broker names to exclude gather stats
excludedBrokers=query_editor

~
# support monitoring statistic (YES/NO), default NO
# If you want to use the advanced monitoring feature on CUBRID Manager,
# you should set this value to YES.

support_mon_statistic=YES
~

#
# Docker status monitoring
#

# Add docker remote api options in /etc/sysconfig/docker file.
# OPTIONS='...', -H tcp://0.0.0.0:4243 or -H tcp://127.0.0.1:4243
#docker.host=localhost
#docker.port=4243

# docker daemon connect type : sock or net
# Must use sock in Openshift
docker.connect.type=sock

docker.sock=/var/run/docker.sock

# docker's cgroup driver type : cgroup or systemd
# Openshift 3.6 use systemd type, below Openshift 3.5 use cgroup type
docker.cgroup.driver.type=systemd
#docker.cgroup.driver.type=cgroup


# connect timeout in millisecond
docker.connectTimeout=5000

# read timeout in millisecond
docker.readTimeout=2000

#
# CRI-O Container status monitoring
#

# crio sock file location
crio.sock=/var/run/crio/crio.sock

# connect timeout in millisecond
crio.connectTimeout=5000

# read timeout in millisecond
crio.readTimeout=2000

#
# khan-plugin-containerd
#

# containerd sock file location
containerd.sock=/var/run/containerd/containerd.sock
# connect timeout in millisecond
containerd.connectTimeout=5000
# read timeout in millisecond
containerd.readTimeout=2000

## Create an account
mysql> CREATE USER 'openmaru'@'localhost' IDENTIFIED BY '[PASSWORD]';

mysql> CREATE USER 'openmaru'@'localhost' IDENTIFIED WITH mysql_native_password by '[PASSWORD]';

## Get a list of running sessions
mysql> GRANT PROCESS,SELECT ON *.* TO 'openmaru'@'localhost';

## Force query termination on a running session
mysql> grant super on *.* to 'openmaru'@'localhost';

mysql> SHOW VARIABLES LIKE 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+

mysql> GRANT SELECT ON performance_schema.* TO 'openmaru'@'localhost';

mysql> show global variables where VARIABLE_NAME in ('slow_query_log', 'log_output');
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| slow_query_log | ON |
| log_output | TABLE |
+--------------------+-------+

my.conf
[mysqld]
general_log=on
log_output='TABLE'

#
# khan-plugin-mysql
#

# Enable remote monitoring (default: false)
#0.remote.enabled=false
0.cluster.name=
0.instance.id=om-mariadb
#  - ex) jdbc:mariadb://localhost:3306/mysql, jdbc:mysql://localhost:3306/mysql
0.jdbc.jdbcUrl=jdbc:mariadb://192.168.23.23:3306/mysql
#  - ex) org.mariadb.jdbc.Driver, com.mysql.jdbc.Driver, com.mysql.cj.jdbc.Driver
0.jdbc.driverClassName=org.mariadb.jdbc.Driver
0.jdbc.username=root
0.jdbc.password=opennaru
0.jdbc.maximumPoolSize=10
0.jdbc.minimumIdle=0
0.jdbc.validationTimeout=5000
0.jdbc.connectionTimeout=5000
0.path.my.cnf=/etc/my.cnf