Hi Everyone.
I've been trying to setup FromDual Performance Monitor for MySQL in order to monitor my Percona database servers via Zabbix.
I've been trying to install fpmmm on one of my DB servers using the instructions given on their official website: https://www.fromdual.com/fpmmm-installation-guide
I've been trying to make it work without success, I'm quite sure that I'm doing something wrong and since there is not a lot of documentation on the Internet I thought to come here and ask for an opinion.
My fpmmm configuration file looks like this
The strange thing is that the fpmmm module is working when I connect it to the respective template with all the graphs and latest data. So I guess the connection between the zabbix server and DB server is working.
But when when I login to zabbix and add all the other templates they are showing no data.
Also, the log files are giving the following errors
I was wondering if anyone here had any experience with this and any suggestions of how to fix this errors and make the monitoring work.
Many thanks in advance!Z
I've been trying to setup FromDual Performance Monitor for MySQL in order to monitor my Percona database servers via Zabbix.
I've been trying to install fpmmm on one of my DB servers using the instructions given on their official website: https://www.fromdual.com/fpmmm-installation-guide
I've been trying to make it work without success, I'm quite sure that I'm doing something wrong and since there is not a lot of documentation on the Internet I thought to come here and ask for an opinion.
My fpmmm configuration file looks like this
# Here you could enter the hostname of your machine (uname -n)
[Percona_Slave2] # This MUST match Hostname in Zabbix!
Type = mysqld
Modules = fpmmm server
# All MySQL databases here
# Try to avoid section names with spaces!
# Here you could add a random name of your MySQL/MariaDB instance
[Percona_Slave2] # This MUST match Hostname in Zabbix!
Type = mysqld
Username = fpmmm
Password = secret
MysqlHost = 127.0.0.1
MysqlPort = 3306
Modules = process mysql myisam innodb master slave security
PidFile = /var/run/mysqld/mysqld.pid
[Percona_Slave2] # This MUST match Hostname in Zabbix!
Type = mysqld
Modules = fpmmm server
# All MySQL databases here
# Try to avoid section names with spaces!
# Here you could add a random name of your MySQL/MariaDB instance
[Percona_Slave2] # This MUST match Hostname in Zabbix!
Type = mysqld
Username = fpmmm
Password = secret
MysqlHost = 127.0.0.1
MysqlPort = 3306
Modules = process mysql myisam innodb master slave security
PidFile = /var/run/mysqld/mysqld.pid
But when when I login to zabbix and add all the other templates they are showing no data.
Also, the log files are giving the following errors
24505:2016-06-11 15:03:10.898 - INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
24505:2016-06-11 15:03:10.939 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.939 - ERR : Database connection for Percona_Slave2 failed (rc=1006).
24505:2016-06-11 15:03:10.944 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.944 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=Percona_Slave2
24505:2016-06-11 15:03:10.944 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.947 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.947 - ERR : Database connection for Percona_Slave2 failed (rc=1006).
24505:2016-06-11 15:03:10.951 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.951 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=Percona_Slave2
24505:2016-06-11 15:03:10.951 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.952 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.952 - ERR : Database connection for memcached failed (rc=1006).
24505:2016-06-11 15:03:10.956 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.956 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=memcached
24505:2016-06-11 15:03:10.956 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.988 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.988 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=memcached
24505:2016-06-11 15:03:10.988 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.988 - ERR : Module FromDualMySQLmemcached got an error (rc=1800).
24505:2016-06-11 15:03:10.988 - INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc=1800).
24505:2016-06-11 15:03:10.939 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.939 - ERR : Database connection for Percona_Slave2 failed (rc=1006).
24505:2016-06-11 15:03:10.944 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.944 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=Percona_Slave2
24505:2016-06-11 15:03:10.944 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.947 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.947 - ERR : Database connection for Percona_Slave2 failed (rc=1006).
24505:2016-06-11 15:03:10.951 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.951 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=Percona_Slave2
24505:2016-06-11 15:03:10.951 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.952 - ERR : mysqli connect with database=mysql, host=127.0.0.1, port=3306 and user=fpmmm failed: Connection refused
24505:2016-06-11 15:03:10.952 - ERR : Database connection for memcached failed (rc=1006).
24505:2016-06-11 15:03:10.956 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.956 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=memcached
24505:2016-06-11 15:03:10.956 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.988 - ERR : Cannot find program zabbix_sender zabbix-sender (rc=1106).
24505:2016-06-11 15:03:10.988 - WARN: ZabbixServer=158.69.82.164, ZabbixServerPort=10051, Hostname=memcached
24505:2016-06-11 15:03:10.988 - WARN: Connection to zabbix server failed (rc=1800)!
24505:2016-06-11 15:03:10.988 - ERR : Module FromDualMySQLmemcached got an error (rc=1800).
24505:2016-06-11 15:03:10.988 - INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc=1800).
Many thanks in advance!Z
Comment