root@mysql-host-control:~# cat /var/log/cmon.log Aug 31 12:33:41 : (INFO) Starting cmon version 1.1.33 with the following parameters: --mysql-password=hidden --mysql-hostname=mysql-host-control --mysql-port=3306 --ndb-connectstring=127.0.0.1 --cluster-id=1 --hostname=mysql-host-control --db_stats_collection_interval=30 --host_stats_collection_interval=30 --ssh_opts= --ssh_identity= --os_user=root --os=debian --mysql_basedir=/var/lib/mysql --enable_autorecovery=1 Aug 31 12:33:41 : (INFO) If that doesn't look correct, kill cmon and restart with -? for help on the parameters, or change the params in /etc/init.d/cmon Aug 31 12:33:41 : (INFO) Going to daemoinze.. - cmon will write a log in /var/log/cmon.log from now Aug 31 12:33:41 : (INFO) IPv4 address: 10.212.11.93 (mysql-host-control.wvnet.at) Aug 31 12:33:41 : (INFO) You need to GRANT (and specify a password if you wish) the following on mysql on mysql-host-control: Aug 31 12:33:41 : (INFO) GRANT create,select,update,insert,delete on cmon.* to 'cmon'@'mysql-host-control.wvnet.at'; Aug 31 12:33:41 : (INFO) GRANT super on *.* to 'cmon'@'mysql-host-control.wvnet.at'; Aug 31 12:33:41 : (INFO) Also GRANT (if you have CMON and the MYSQLD on the same host): Aug 31 12:33:41 : (INFO) GRANT create,select,update,insert,delete on cmon.* to 'cmon'@'127.0.0.1'; Aug 31 12:33:41 : (INFO) GRANT super on *.* to 'cmon'@'127.0.0.1'; Aug 31 12:33:41 : (INFO) and start cmon with --mysql-hostname=127.0.0.1 Aug 31 12:33:41 : (INFO) Testing connection to mysqld.. Aug 31 12:33:41 : (INFO) Table 'alarm' exists Aug 31 12:33:41 : (INFO) Table 'alarm_log' exists Aug 31 12:33:41 : (INFO) Table 'backup' exists Aug 31 12:33:41 : (INFO) Table 'backup_log' exists Aug 31 12:33:41 : (INFO) Table 'email_notification' exists Aug 31 12:33:41 : (INFO) Table 'restore' exists Aug 31 12:33:41 : (INFO) Table 'restore_log' exists Aug 31 12:33:41 : (INFO) Table 'cluster_log' exists Aug 31 12:33:41 : (INFO) Table 'cluster_state' exists Aug 31 12:33:41 : (INFO) Table 'node_state' exists Aug 31 12:33:41 : (INFO) Table 'node_statistics' exists Aug 31 12:33:41 : (INFO) Table 'cluster_statistics' exists Aug 31 12:33:41 : (INFO) Table 'memory_usage' exists Aug 31 12:33:41 : (INFO) Table 'mysql_server' exists Aug 31 12:33:41 : (INFO) Table 'mysql_slave_status' exists Aug 31 12:33:41 : (INFO) Table 'mysql_master_status' exists Aug 31 12:33:41 : (INFO) Table 'mysql_processlist' exists Aug 31 12:33:41 : (INFO) Table 'mysql_performance_meta' exists Aug 31 12:33:41 : (INFO) Table 'mysql_performance_probes' exists Aug 31 12:33:41 : (INFO) Table 'mysql_performance_results' exists Aug 31 12:33:41 : (INFO) Table 'mysql_statistics' exists Aug 31 12:33:41 : (INFO) Table 'mysql_global_statistics' exists Aug 31 12:33:41 : (INFO) Table 'mysql_variables' exists Aug 31 12:33:41 : (INFO) Table 'diskdata' exists Aug 31 12:33:41 : (INFO) Table 'schema_object' exists Aug 31 12:33:41 : (INFO) Table 'cluster' exists Aug 31 12:33:41 : (INFO) Table 'configurator_nodemap' exists Aug 31 12:33:41 : (INFO) Table 'mailserver' exists Aug 31 12:33:41 : (INFO) Table 'cmon_user' exists Aug 31 12:33:41 : (INFO) Table 'cmon_configuration' exists Aug 31 12:33:41 : (INFO) Table 'cmon_status' exists Aug 31 12:33:41 : (INFO) Table 'cmon_job' exists Aug 31 12:33:41 : (INFO) Table 'cmon_host_log' exists Aug 31 12:33:41 : (INFO) Table 'cmon_job_message' exists Aug 31 12:33:41 : (INFO) Table 'backup_schedule' exists Aug 31 12:33:41 : (INFO) Table 'ndbinfo_logbuffers' exists Aug 31 12:33:41 : (INFO) Table 'backup_schedule' exists Aug 31 12:33:41 : (INFO) Table 'ndbinfo_logbuffers' exists Aug 31 12:33:41 : (INFO) Table 'ndbinfo_logspaces' exists Aug 31 12:33:41 : (INFO) Table 'cmon_cluster_counters' exists Aug 31 12:33:41 : (INFO) Table 'cmon_cluster_graphs' exists Aug 31 12:33:41 : (INFO) Table 'cmon_mysql_counters' exists Aug 31 12:33:41 : (INFO) Table 'cmon_mysql_graphs' exists Aug 31 12:33:41 : (INFO) Table 'hosts' exists Aug 31 12:33:41 : (INFO) Table 'processes' exists Aug 31 12:33:41 : (INFO) Table 'mysql_repl_link' exists Aug 31 12:33:41 : (INFO) Table 'mysql_repl_bw' exists Aug 31 12:33:41 : (INFO) Table 'mysql_slow_queries' exists Aug 31 12:33:41 : (INFO) Table 'mysql_explains' exists Aug 31 12:33:41 : (INFO) Table 'database_conf' exists Aug 31 12:33:41 : (INFO) Table 'cmon_uploads' exists Aug 31 12:33:41 : (INFO) Checked tables - seems ok Aug 31 12:33:41 : (INFO) Schema looks complete. Aug 31 12:33:41 : (INFO) Registering managed cluster with cluster id=1 Aug 31 12:33:41 : (INFO) Managed cluster has been registered - registered cluster id=1 Aug 31 12:33:41 : (INFO) IPv4 address: 10.212.11.93 (mysql-host-control.wvnet.at) Aug 31 12:33:41 : (INFO) Setting up threads to handle monitoring Aug 31 12:33:41 : (INFO) Looking up and adding '10.212.11.90' Aug 31 12:33:41 : (INFO) IPv4 address: 10.212.11.90 (10.212.11.90) Aug 31 12:33:41 : (WARNING) Executing: GRANT INSERT,UPDATE,DELETE,SELECT ON cmon.* TO 'cmon'@'10.212.11.90' IDENTIFIED BY 'hidden' - ok! Aug 31 12:33:41 : (WARNING) Executing: GRANT SUPER ON *.* TO 'cmon'@'10.212.11.90' IDENTIFIED BY 'hidden' - ok! Aug 31 12:33:41 : (INFO) Looking up and adding '10.212.11.91' Aug 31 12:33:41 : (INFO) IPv4 address: 10.212.11.91 (10.212.11.91) Aug 31 12:33:41 : (WARNING) Executing: GRANT INSERT,UPDATE,DELETE,SELECT ON cmon.* TO 'cmon'@'10.212.11.91' IDENTIFIED BY 'hidden' - ok! Aug 31 12:33:41 : (WARNING) Executing: GRANT SUPER ON *.* TO 'cmon'@'10.212.11.91' IDENTIFIED BY 'hidden' - ok! Aug 31 12:33:41 : (INFO) Starting Mail Sender Thread Aug 31 12:33:41 : (INFO) Starting command listener thread Aug 31 12:33:41 : (INFO) Starting MySQLCNTRCollectorThread Aug 31 12:33:41 : (INFO) Starting MaintenanceThread Aug 31 12:33:41 : (INFO) Starting host collector Aug 31 12:33:41 : (WARNING) MAIL Client: No email recipients found Aug 31 12:33:41 : (INFO) Starting Process Manager Thread Aug 31 12:33:41 : (INFO) local command : mkdir -p /tmp//1//galera returned 0 Aug 31 12:33:41 : (INFO) local command : sync returned 0 Aug 31 12:33:41 : (INFO) local command : mkdir -p /tmp//1//galera/config/ returned 0 Aug 31 12:33:41 : (INFO) local command : sync returned 0 Aug 31 12:33:41 : (INFO) local command : mkdir -p /tmp//1//galera/etc/ returned 0 Aug 31 12:33:41 : (INFO) local command : sync returned 0 Aug 31 12:33:41 : (INFO) local command : mkdir -p /tmp//1//galera/init.d/ returned 0 Aug 31 12:33:41 : (INFO) local command : sync returned 0 Aug 31 12:33:41 : (INFO) local command : chown -R root:root /tmp//1//galera returned 0 Aug 31 12:33:41 : (INFO) local command : cp /root/mysqlcluster-71///mysql/config/* /tmp//1//galera/config/ returned 0 Aug 31 12:33:41 : (INFO) local command : cp /root/mysqlcluster-71///mysql/init.d/cmon /tmp//1//galera/init.d/ returned 0 Aug 31 12:33:41 : (INFO) Collecting config files Aug 31 12:33:41 : (INFO) ssh -q -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -oNumberOfPasswordPrompts=0 -oIdentityFile=/root/.ssh/id_rsa root@mysql-host-1.wvnet.at "/bin/cat /etc//my.cnf" Aug 31 12:33:41 : (WARNING) Could not pull log /etc//my.cnf from mysql-host-1.wvnet.at Aug 31 12:33:41 : (INFO) ssh -q -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -oNumberOfPasswordPrompts=0 -oIdentityFile=/root/.ssh/id_rsa root@mysql-host-2.wvnet.at "/bin/cat /etc//my.cnf" Aug 31 12:33:41 : (WARNING) Could not pull log /etc//my.cnf from mysql-host-2.wvnet.at Aug 31 12:33:41 : (INFO) Gathering Database Stats Aug 31 12:33:42 : (INFO) Collecting config files Aug 31 12:33:42 : (INFO) ssh -q -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -oNumberOfPasswordPrompts=0 -oIdentityFile=/root/.ssh/id_rsa root@mysql-host-1.wvnet.at "/bin/cat /etc//my.cnf" Aug 31 12:33:42 : (WARNING) Could not pull log /etc//my.cnf from mysql-host-1.wvnet.at Aug 31 12:33:42 : (INFO) ssh -q -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -oNumberOfPasswordPrompts=0 -oIdentityFile=/root/.ssh/id_rsa root@mysql-host-2.wvnet.at "/bin/cat /etc//my.cnf" Aug 31 12:33:42 : (WARNING) Could not pull log /etc//my.cnf from mysql-host-2.wvnet.at Aug 31 12:33:42 : (INFO) Collecting logs Aug 31 12:33:42 : (WARNING) Query INSERT IGNORE INTO processes(cid, hid, nodeid, process, exec_cmd, pidfile, active, pgrep_expr) VALUES failed Aug 31 12:33:42 : (WARNING) Creating processlist failed, DATADIR is not set, could not read from MY.CNF.SLAVE. This may be okay, check Process Mgmt in web interface to verify Aug 31 12:33:42 : (WARNING) Creating processlist failed, DATADIR is not set, could not read from MY.CNF.MASTER. This may be okay, check Process Mgmt in web interface to verify root@mysql-host-control:~#