Ad Widget

**sue** · 14-04-2011, 10:38

what i have to do now? maybe i not understand the flow how it work. You understand what i want to monitor right? i want to monitor my zabbix server itself. i use mysql as databse and i want to monitor this database that i give name zabbix. so, i think the ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=127.0.0.1
ZabbixServer1.Port=10051
#DatabaseList=ZABBIX
DatabaseList=zabbix-->i name it zabbix when create mysql databse before
#define here your connection string for each database
#jdbc:mysql://[host

ort],[host

ort].../[database]
jdbc:mysql://127.0.0.1:3306/zabbix
#ZABBIX.Url=jdbc:mysql://monitor.ente.regione.emr.it:3306/zabbix
ZABBIX.Url=jdbc:mysql://127.0.0.1:3306/zabbix

SO, WHAT IS WRONG HERE?? THE REST I USE THE RIGHT USER AND PASSWORD FOR ZABBIX DATABASE.

**dalle** · 14-04-2011, 10:43

Originally posted by sue

what i have to do now? maybe i not understand the flow how it work. You understand what i want to monitor right? i want to monitor my zabbix server itself. i use mysql as databse and i want to monitor this database that i give name zabbix. so, i think the ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=127.0.0.1
ZabbixServer1.Port=10051
#DatabaseList=ZABBIX
DatabaseList=zabbix-->i name it zabbix when create mysql databse before
#define here your connection string for each database
#jdbc:mysql://[host

ort],[host

ort].../[database]
jdbc:mysql://127.0.0.1:3306/zabbix
#ZABBIX.Url=jdbc:mysql://monitor.ente.regione.emr.it:3306/zabbix
ZABBIX.Url=jdbc:mysql://127.0.0.1:3306/zabbix

SO, WHAT IS WRONG HERE?? THE REST I USE THE RIGHT USER AND PASSWORD FOR ZABBIX DATABASE.

Dear sue, I have no clue everything seem right what error have you now? i mean logfile is empty?
please don't use capital (uppercase) letter is like you are screaming
if you want you colud send me your logfile and config files and I'll try to see what is not right
you can send me as a private message or at [email protected]

**dalle** · 22-04-2011, 18:15

I've released today DBforBIX.
DBforBIX arises from the need to integrate all born of Orabbix’s fork.
DBforBIX can enquiry and monitor vital parameter of:

Oracle
MySQL
PostgreSQL
MS SQL Server
DB2

Till now DB2 and MS SQL Server are not tested and they can be unstable

DBforBIX still remain superscalar and multi thread.
NOTE: now Items are collisionless because they have a prefix how adviced from Aaron Kulik (thank you Aaron)

THIS IS A PREVIEW IT’S ONLY 0.1 RELEASE AND IS NOT FULLY TESTED PRODUCTION RELEASE
You can download DBforBIX from my website, sources are available on sourceforge as usual
NOTE: there are not included ojdbc6.jar needed for oracle and db2jcc.jar db2jcc_license_cu.jar needed by DB2

**Yello** · 07-07-2011, 22:06

Hi,
I'm having some problems getting to grips with using dbforbix 0.3 with zabbix 1.8.5. When I start it I get the following output:

Starting DBforBIX service:
root on zbxhost[conf] Stopping
java.lang.NullPointerException
at java.lang.String.<init>(String.java:147)
at com.smartmarmot.dbforbix.Configurator.getQueryFile (Configurator.java:621)
at com.smartmarmot.dbforbix.DBforBIX.run(DBforBIX.jav a:133)
at com.smartmarmot.dbforbix.bootstrap.main(bootstrap. java:56)

The log file shows the following:

2011-07-07 21:00:07,478 [main] INFO DBforBIX - Starting DBforBIX Version 0.3
2011-07-07 21:00:07,515 [main] INFO DBforBIX - DBforBIX started with pid:8499
2011-07-07 21:00:07,515 [main] INFO DBforBIX - PidFile -> /var/run/zabbix/db4bix.pid
2011-07-07 21:00:07,799 [main] INFO DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@578088c0
2011-07-07 21:00:07,799 [main] INFO DBforBIX - URL=jdbc:mysql://127.0.0.1:3306/zabbix
2011-07-07 21:00:07,799 [main] INFO DBforBIX - maxPoolSize=10
2011-07-07 21:00:07,799 [main] INFO DBforBIX - maxIdleSize=1
2011-07-07 21:00:07,799 [main] INFO DBforBIX - maxIdleTime=1800000ms
2011-07-07 21:00:07,799 [main] INFO DBforBIX - poolTimeout=100
2011-07-07 21:00:07,799 [main] INFO DBforBIX - timeBetweenEvictionRunsMillis=-1
2011-07-07 21:00:07,799 [main] INFO DBforBIX - numTestsPerEvictionRun=3
2011-07-07 21:00:09,498 [main] INFO DBforBIX - Connected as zabbix@localhost
2011-07-07 21:00:09,502 [main] INFO DBforBIX - --------- on Database -> zabbix

So the logfile looks ok but the java app is failing. I'd appreciate some guidance on what may be happening here.

Regards,
David

**dalle** · 07-07-2011, 22:19

Maybe that dbforbix don't find query file on his specified location or the query file has ".sample" extension
let me know

**Yello** · 07-07-2011, 23:53

Hi,
Yes, it was that. To be exact, the reference to the query file had a typo. Thanks for your help.

BTW, are there any MS SQL templates for dbforbix? I anticipate needing to monitor mysql, oracle and MS SQL 2005/8.

Regards,
David

**dalle** · 07-07-2011, 23:56

Originally posted by Yello

Hi,
Yes, it was that. To be exact, the reference to the query file had a typo. Thanks for your help.

BTW, are there any MS SQL templates for dbforbix? I anticipate needing to monitor mysql, oracle and MS SQL 2005/8.

Regards,
David

I'm still working on it

I'm in the same situation but really busy at the moment I don't have time to test enough..

kind regards
Andrea

**dalle** · 27-07-2011, 11:42

Originally posted by Plushzilla

Thanks for sharing the comparative features.Great job.

thanks for the greetings

usually get inquiries from the forums

thanks again
regards

**dalle** · 27-07-2011, 17:08

about what I can see you have called your database
2011-07-27 16:07:18,289 [main] ERROR Mysqlbix - Error on Configurator for database zabbix_db -->Unknown database 'zabbix>'
'zabbix>'
with the sign ">"
may be that this cause an error
let me know

**hirschnf** · 28-07-2011, 08:43

Thank you Dalle,

as you can see I have delete the post view minutes later because after I submit the reply I look on the screen and read and read and then I saw this issue.
I removed the ">" sign and then it works.
As I said, it was a little problem

Thank you for reply

best regards
Frank

**hirschnf** · 29-07-2011, 09:17

Hello,

MySQLBix runs quite good. But in the dashboard I get often the following message:

Code:

MySQL : High Usage of Innodb Pages on server.x.local

I think the trigger relates to "MySQL Innodb Buffer Pool Pages Data" (avg value is 31.81K) and "MySQL Innodb Buffer Pool Pages Total" (value is 32.77K).

When I look at the values I can't find the correct variable in MySQL to tune. Has somebody an idea?

CentOS 5.6
zabbix 1.8.5
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1

variables configuration in my.cnf:

Code:

[mysqld]
innodb_file_per_table

innodb_log_arch_dir=/opt/mysqldb/ibdata/archive
innodb_log_archive

innodb_buffer_pool_size = 512M
key_buffer_size = 16M
thread_cache_size = 8
max_connections = 300
table_cache = 128
query_cache_limit = 32M
query_cache_size = 64M

max_allowed_packet = 16M
tmp_table_size = 256M
max_heap_table_size = 256M
join_buffer_size = 5M

best regards
Frank

**cloudmafia** · 17-05-2013, 12:19

How to install/Setup MysqlBix

Hi,

Mysqlbix installation Documentation is not available, please check and provide an installation/setup guide.

Thanks

**dalle** · 17-05-2013, 12:24

Originally posted by cloudmafia

Hi,

Mysqlbix installation Documentation is not available, please check and provide an installation/setup guide.

Thanks

Hi
please use dbforbix instead mysqlbix.
or... well are all more or less the same so you can refer to dbforbix documentation od Orabbix as well
I am sorry but actually I don't have time to produce a complete documentation and please rember that all that is done for free

Ad Widget

MySQLBix to monitor MySQL

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment