MySQLBix to monitor MySQL

[dalle]

I’ve wrote MySQLBix as a fork of Orabbix
this mean that MySQLBix has the same features of Orabbix:

• Connection Pooling
• Multithread
• No limits on number of monitored databases
• Is opensource and released under GPL

and all the other features that every Orabbix user know
It’s just a pre-release so be patience with him (and me of course )
Any help to develope this project is really welcome i mean that if someone has some request, want add a query, trigger, item please notice to me.
all is available as usual on sourceforge or
here

[sue]

i try to use mysqlbix and follow the instruction but still cannot show the latest data. why this happen?

[dalle]

i try to use mysqlbix and follow the instruction but still cannot show the latest data. why this happen?

try to see in tail -f /opt/mysqlbix/logs/mysqlbix.log
what is happening and let me know

[sue]

try to see in tail -f /opt/mysqlbix/logs/mysqlbix.log
what is happening and let me know

when i run this command, it give me
tail: cannot open `/opt/mysqlbix/logs/mysqlbix.log' for reading: No such file or directory
tail: no files remaining

[sue]

I successfully run mysqlbix but then show this error

[root@localhost conf]# java.lang.IllegalArgumentException
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1275)
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1163)
at java.util.concurrent.Executors.newFixedThreadPool( Executors.java:89)
at main.main(main.java:105)

how to solve this problem??

[dalle]

I successfully run mysqlbix but then show this error

[root@localhost conf]# java.lang.IllegalArgumentException
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1275)
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1163)
at java.util.concurrent.Executors.newFixedThreadPool( Executors.java:89)
at main.main(main.java:105)

how to solve this problem??

do you have installed java?on my redhat there is
java-1.6.0-openjdk-1.6.0.0-1.18.b17.el5

and is tested on ubuntu/redhat/and aix (with oracle jvm)

try to do the following command
rpm -qa |grep java

and doesn't matter where is the database you need to create an user with a password and mysql should listen on some port this software don't work on socket
let me know

[dalle]

when i run this command, it give me
tail: cannot open `/opt/mysqlbix/logs/mysqlbix.log' for reading: No such file or directory
tail: no files remaining

if there are no files may be that is not running or your log4j is configured to log in another place or you have unpacked in a different location (different from the one specified on installation instruction)

[sue]

if there are no files may be that is not running or your log4j is configured to log in another place or you have unpacked in a different location (different from the one specified on installation instruction)

this error i get from mysqlbix.log

2011-04-14 15:05:36,873 [main] INFO Mysqlbix - Starting Mysqlbix Version 1.1.0 BETA
2011-04-14 15:05:36,877 [main] ERROR Mysqlbix - Error on Configurator while retriving query file QueryListFile C:/Dropbox/My Dropbox/workspace/orabbix/conf/query.props (No such file or directory)
2011-04-14 15:05:36,890 [main] INFO Mysqlbix - Mysqlbix started with pid:17867
2011-04-14 15:05:36,891 [main] INFO Mysqlbix - PidFile -> ./logs/mysqlbix.pid

[sue]

do you have installed java?on my redhat there is
java-1.6.0-openjdk-1.6.0.0-1.18.b17.el5

and is tested on ubuntu/redhat/and aix (with oracle jvm)

try to do the following command
rpm -qa |grep java

and doesn't matter where is the database you need to create an user with a password and mysql should listen on some port this software don't work on socket
let me know

[root@localhost ~]# rpm -qa | grep java
java-1.6.0-openjdk-1.6.0.0-1.2.b09.el5
java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

(with oracle jvm)..do i need install oracle jvm??what the function..sory if my question like stupid. i very new with all this and still in learning process. what i know, oracle something like databse. same as mysql. so do we need oracle jvm when want to monitor mysql??
i use centos for my os

[dalle]

this error i get from mysqlbix.log

2011-04-14 15:05:36,873 [main] INFO Mysqlbix - Starting Mysqlbix Version 1.1.0 BETA
2011-04-14 15:05:36,877 [main] ERROR Mysqlbix - Error on Configurator while retriving query file QueryListFile C:/Dropbox/My Dropbox/workspace/orabbix/conf/query.props (No such file or directory)
2011-04-14 15:05:36,890 [main] INFO Mysqlbix - Mysqlbix started with pid:17867
2011-04-14 15:05:36,891 [main] INFO Mysqlbix - PidFile -> ./logs/mysqlbix.pid

where have you downloaded this software? because seems that has a different config file from the one that i've released on my website....
please replace in config.props the key QueryListFile with thisone

#Query Parameter Files
QueryListFile=./conf/query.props

[dalle]

[root@localhost ~]# rpm -qa | grep java
java-1.6.0-openjdk-1.6.0.0-1.2.b09.el5
java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

(with oracle jvm)..do i need install oracle jvm??what the function..sory if my question like stupid. i very new with all this and still in learning process. what i know, oracle something like databse. same as mysql. so do we need oracle jvm when want to monitor mysql??
i use centos for my os

don't worry
it's just because Oracle has bought Sun and now Java is a trade mark of Oracle anyway don't worry about your question if you have centos should be something like this
yum install java-1.6.0-openjdk
try and let me know your progress

[sue]

where have you downloaded this software? because seems that has a different config file from the one that i've released on my website....
please replace in config.props the key QueryListFile with thisone

#Query Parameter Files
QueryListFile=./conf/query.props

i take from smartmarmot.com..still got this error after a few second run mysqlbix
[root@localhost conf]# java.lang.IllegalArgumentException
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1275)
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1163)
at java.util.concurrent.Executors.newFixedThreadPool( Executors.java:89)
at main.main(main.java:105)
and at mysqlbix.log
2011-04-14 15:45:03,910 [main] INFO Mysqlbix - Starting Mysqlbix Version 1.1.0 BETA
2011-04-14 15:45:03,923 [main] INFO Mysqlbix - Mysqlbix started with pid:20169
2011-04-14 15:45:03,923 [main] INFO Mysqlbix - PidFile -> ./logs/mysqlbix.pid
2011-04-14 15:50:04,237 [main] ERROR Mysqlbix - Error on Configurator for database zabbix -->Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2011-04-14 15:50:04,237 [main] INFO Mysqlbix - This Database zabbix removed
2011-04-14 15:50:04,237 [main] ERROR Mysqlbix - ERROR on main - Connections is empty or null
2011-04-14 15:50:04,239 [main] ERROR Mysqlbix - Error on Configurator while retriving the MysqlbixDaemon.MaxThreadNumber java.lang.NumberFormatException: null

[dalle]

i take from smartmarmot.com..still got this error after a few second run mysqlbix
[root@localhost conf]# java.lang.IllegalArgumentException
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1275)
at java.util.concurrent.ThreadPoolExecutor.<init>(Thr eadPoolExecutor.java:1163)
at java.util.concurrent.Executors.newFixedThreadPool( Executors.java:89)
at main.main(main.java:105)
and at mysqlbix.log
2011-04-14 15:45:03,910 [main] INFO Mysqlbix - Starting Mysqlbix Version 1.1.0 BETA
2011-04-14 15:45:03,923 [main] INFO Mysqlbix - Mysqlbix started with pid:20169
2011-04-14 15:45:03,923 [main] INFO Mysqlbix - PidFile -> ./logs/mysqlbix.pid
2011-04-14 15:50:04,237 [main] ERROR Mysqlbix - Error on Configurator for database zabbix -->Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2011-04-14 15:50:04,237 [main] INFO Mysqlbix - This Database zabbix removed
2011-04-14 15:50:04,237 [main] ERROR Mysqlbix - ERROR on main - Connections is empty or null
2011-04-14 15:50:04,239 [main] ERROR Mysqlbix - Error on Configurator while retriving the MysqlbixDaemon.MaxThreadNumber java.lang.NumberFormatException: null

do you have specified an account with right username and password and an IP and a port on config.props?
Mysql is listening on some port or is runnin with socket?
socket are not supported by mysqlbix

[sue]

i still got the same error. Now i want ask you. Maybe i do wrong in config.props
i not very clear about this script
#define here your connection string for each database
#jdbc:mysql://[hostort],[hostort].../[database]

if i want to monitor my localhost mysql, what suppose i should do.

i replace with this script
jdbc:mysql://127.0.0.1:10051/zabbix

how about this?
ZABBIX.Url=jdbc:mysql://monitor.ente.regione.emr.it:3306/zabbix

[dalle]

i still got the same error. Now i want ask you. Maybe i do wrong in config.props
i not very clear about this script
#define here your connection string for each database
#jdbc:mysql://[hostort],[hostort].../[database]

if i want to monitor my localhost mysql, what suppose i should do.

i replace with this script
jdbc:mysql://127.0.0.1:10051/zabbix

how about this?
ZABBIX.Url=jdbc:mysql://monitor.ente.regione.emr.it:3306/zabbix

ZABBIX.Url=jdbc:mysql://127.0.0.1:3306/zabbix
10051 is the port of Zabbix and it has nothing to do with mysql