Ad Widget

**michelis** · 03-02-2012, 12:41

Hi,

the problem is, the connection can't even be established. I tried it from different machines and they can establish the connection. The firewall-settings are correct and selinux is disabled. On the database-server side I receive the following error messages:

Code:

ONNECT_DATA=3D(SID=3DIMDB)(CID=3D(PROGRAM=3D)(HOST=3D__jdbc__)(USER=3Dro=
ot))) * (ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D192.168.176.119)(PORT=3D59145))=
 * establish * IMDB * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12571: TNS:packet writer failure
  TNS-12560: TNS:protocol adapter error
   TNS-00530: Protocol adapter error
    Linux Error: 104: Connection reset by peer
Fri Feb 03 11:11:05 2012
03-FEB-2012 11:11:05 * =
(CONNECT_DATA=3D(SID=3DIMDB)(CID=3D(PROGRAM=3D)(HOST=3D__jdbc__)(USER=3Dor=
acle))) * (ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D192.168.176.119)(PORT=3D59310=
)) * establish * IMDB * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12571: TNS:packet writer failure
  TNS-12560: TNS:protocol adapter error
   TNS-00530: Protocol adapter error
    Linux Error: 104: Connection reset by peer

I found an entry in an oracle forum but it only said, that this is a problem with firewall settings and/or the DBMS. But I ruled that already out (or to be more precise the networkadmin did).
Thank you for your help.

EDIT: I think it is a problem with our cluster. Thank you everyone for have a look at my problem. I hope I will be able to resolve the problem, because I really think this is a great tool and I want to employ it.

**ehartmann** · 07-02-2012, 18:04

Hi,

I'm trying to use dbforbix with a Postgresql database.
All the data received are empty except "Alive" and "PostbixVersion" that are updated.

It seems to be due to an incorrect key sent to Zabbix, the log show :

2012-02-07 16:59:53,742 [pool-1-thread-95] DEBUG DBforBIX - sending <req><host>RG9yeQ==</host><key>REJmb3JCSVguUG9zdGdyZVNRTC5EQmZvckJJWC5Q b3N0Z3JlU1FMLnR1cGZldGNoZWQ=</key><data>MTk0MDUzNTE=</data></req>
2012-02-07 16:59:53,742 [pool-1-thread-95] DEBUG DBforBIX - received OK

The base64 key is : DBforBIX.PostgreSQL.DBforBIX.PostgreSQL.tupfetched instead of DBforBIX.PostgreSQL.tupfetched.

Is it a known issue ?

I did not find the source code on sourceforge.net to investigate more. Is available at another place ?

Thanks for this monitoring tool !

-éric

**dalle** · 08-02-2012, 11:36

Originally posted by ehartmann

Hi,

I'm trying to use dbforbix with a Postgresql database.
All the data received are empty except "Alive" and "PostbixVersion" that are updated.

It seems to be due to an incorrect key sent to Zabbix, the log show :

2012-02-07 16:59:53,742 [pool-1-thread-95] DEBUG DBforBIX - sending <req><host>RG9yeQ==</host><key>REJmb3JCSVguUG9zdGdyZVNRTC5EQmZvckJJWC5Q b3N0Z3JlU1FMLnR1cGZldGNoZWQ=</key><data>MTk0MDUzNTE=</data></req>
2012-02-07 16:59:53,742 [pool-1-thread-95] DEBUG DBforBIX - received OK

The base64 key is : DBforBIX.PostgreSQL.DBforBIX.PostgreSQL.tupfetched instead of DBforBIX.PostgreSQL.tupfetched.

Is it a known issue ?

I did not find the source code on sourceforge.net to investigate more. Is available at another place ?

Thanks for this monitoring tool !

-éric

Dear Eric
Thank you for your help!
the sources are available on sourceforge via svn.
The trunk dbforbix\trunk\0.5 it's empty because 0.5 version is on main branch
btw I'm going to commit inside the trunk on 0.5.

**ehartmann** · 08-02-2012, 11:50

Thanks Andrea,

However I did not find the sourcecode on sf.net. I may not use the right project ?

The following url http://sourceforge.net/p/dbforbix/code/commit_browser, show no commit. I may miss something.

It would be really nice if you can give me the SVN url.

Again thanks !

-éric

**dalle** · 08-02-2012, 12:04

Originally posted by ehartmann

Thanks Andrea,

However I did not find the sourcecode on sf.net. I may not use the right project ?

The following url http://sourceforge.net/p/dbforbix/code/commit_browser, show no commit. I may miss something.

It would be really nice if you can give me the SVN url.

Again thanks !

-éric

DBforBIX

https://dbforbix.svn.sourceforge.net/svnroot/dbforbix

Download DBforBIX for free. DBforBIX is a daemon designed to work in combination with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for the many kind of different databases, along with server performance metrics. It provides an effective mechanism to acquire data from numerous databases installation, and in turn provides this information for monitoring and performance metrics to your Zabbix server.

I've double check, I've made a new checkout and it's full of sources... no clue what mean this url

DBforBIX

http://sourceforge.net/p/dbforbix/code/commit_browser

Download DBforBIX for free. DBforBIX is a daemon designed to work in combination with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for the many kind of different databases, along with server performance metrics. It provides an effective mechanism to acquire data from numerous databases installation, and in turn provides this information for monitoring and performance metrics to your Zabbix server.

let me know
If you are able or if you can't download my sources

**ehartmann** · 08-02-2012, 19:01

Thanks it's working fine.
I'll have a look at the reason of the bad key.

The link I posted is the one offered by sf.net to view code. It's quite strange.

-éric

**dalle** · 08-02-2012, 19:08

Originally posted by ehartmann

Thanks it's working fine.
I'll have a look at the reason of the bad key.

The link I posted is the one offered by sf.net to view code. It's quite strange.

-éric

well!
I was looking for the issue notified by you.. but it's quite strange.... on my eclipse is working fine...
I'll let you know if I find the bug

I have seen that sf.net offer that link to all my app... but refers to cvs that I don't use... and it's disabled

I apologize for the incovnenience
Please let me know if you find the cause of the issue!

regards
Andrea

**tiagosoares** · 08-02-2012, 20:02

Hi guys,

Im setup the dbforbix to monitor a MySQL instance... But Im getting this error:

Code:

2012-02-08 15:41:07,210 [main] INFO  DBforBIX - Starting DBforBIX Version 0.5
 2012-02-08 15:41:07,229 [main] INFO  DBforBIX - DBforBIX started with pid:26937
 2012-02-08 15:41:07,229 [main] INFO  DBforBIX - PidFile -> ./logs/orabbix.pid
 2012-02-08 15:41:07,696 [main] INFO  DBforBIX - Connected as [email protected]
 2012-02-08 15:41:07,697 [main] INFO  DBforBIX - --------- on Database -> zabbix
 2012-02-08 15:41:07,772 [pool-1-thread-1] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:41:07,772 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 22 ms
 2012-02-08 15:42:07,752 [pool-1-thread-2] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:42:07,752 [pool-1-thread-2] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:43:07,753 [pool-1-thread-3] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:43:07,754 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:44:07,754 [pool-1-thread-4] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:44:07,754 [pool-1-thread-4] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:45:07,756 [pool-1-thread-5] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:45:07,756 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:46:07,757 [pool-1-thread-6] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:46:07,757 [pool-1-thread-6] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:47:07,758 [pool-1-thread-7] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:47:07,758 [pool-1-thread-7] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:48:07,763 [pool-1-thread-8] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:48:07,764 [pool-1-thread-8] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 6 ms
 2012-02-08 15:49:07,760 [pool-1-thread-9] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:49:07,760 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:50:07,761 [pool-1-thread-10] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:50:07,761 [pool-1-thread-10] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms

**dalle** · 08-02-2012, 20:04

Originally posted by tiagosoares

Hi guys,

Im setup the dbforbix to monitor a MySQL instance... But Im getting this error:

Code:

2012-02-08 15:41:07,210 [main] INFO  DBforBIX - Starting DBforBIX Version 0.5
 2012-02-08 15:41:07,229 [main] INFO  DBforBIX - DBforBIX started with pid:26937
 2012-02-08 15:41:07,229 [main] INFO  DBforBIX - PidFile -> ./logs/orabbix.pid
 2012-02-08 15:41:07,696 [main] INFO  DBforBIX - Connected as [email protected]
 2012-02-08 15:41:07,697 [main] INFO  DBforBIX - --------- on Database -> zabbix
 2012-02-08 15:41:07,772 [pool-1-thread-1] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:41:07,772 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 22 ms
 2012-02-08 15:42:07,752 [pool-1-thread-2] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:42:07,752 [pool-1-thread-2] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:43:07,753 [pool-1-thread-3] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:43:07,754 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:44:07,754 [pool-1-thread-4] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:44:07,754 [pool-1-thread-4] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:45:07,756 [pool-1-thread-5] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:45:07,756 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:46:07,757 [pool-1-thread-6] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:46:07,757 [pool-1-thread-6] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 2 ms
 2012-02-08 15:47:07,758 [pool-1-thread-7] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:47:07,758 [pool-1-thread-7] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:48:07,763 [pool-1-thread-8] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:48:07,764 [pool-1-thread-8] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 6 ms
 2012-02-08 15:49:07,760 [pool-1-thread-9] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:49:07,760 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms
 2012-02-08 15:50:07,761 [pool-1-thread-10] ERROR DBforBIX - Error on dbJob for database zabbix error: java.lang.IllegalArgumentException: Query's array is empty or null
 2012-02-08 15:50:07,761 [pool-1-thread-10] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 1 ms

may be that QueryList contain an invaid character or a new line without a "\"

**tiagosoares** · 08-02-2012, 20:37

I already got this working now, but the only thing that is send to zabbix server is if "MySQL: is Alive" or not...

I set the querylist to "zabbix.QueryListFile=/opt/dbforbix/conf/mysqlquery.props" (see attached)

The log bellow:

Code:

2012-02-08 16:22:21,270 [main] INFO  DBforBIX - Starting DBforBIX Version 0.5
 2012-02-08 16:22:21,294 [main] INFO  DBforBIX - DBforBIX started with pid:29682
 2012-02-08 16:22:21,294 [main] INFO  DBforBIX - PidFile -> ./logs/orabbix.pid
 2012-02-08 16:22:21,791 [main] INFO  DBforBIX - Connected as [email protected]
 2012-02-08 16:22:21,792 [main] INFO  DBforBIX - --------- on Database -> zabbix
 2012-02-08 16:22:22,552 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 558 ms
 2012-02-08 16:23:22,074 [pool-1-thread-2] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 35 ms
 2012-02-08 16:24:22,597 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 513 ms
 2012-02-08 16:25:22,175 [pool-1-thread-4] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 38 ms
 2012-02-08 16:26:22,652 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 457 ms
 2012-02-08 16:27:22,234 [pool-1-thread-6] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 27 ms
 2012-02-08 16:28:22,684 [pool-1-thread-7] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 454 ms
 2012-02-08 16:29:22,263 [pool-1-thread-8] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 17 ms
 2012-02-08 16:30:22,672 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 412 ms
 2012-02-08 16:31:22,291 [pool-1-thread-10] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 16 ms
 2012-02-08 16:32:22,725 [pool-1-thread-11] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 436 ms
 2012-02-08 16:33:22,321 [pool-1-thread-12] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 18 ms
 2012-02-08 16:34:22,726 [pool-1-thread-13] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 409 ms
 2012-02-08 16:35:22,346 [pool-1-thread-14] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 13 ms

**NikkoBelik** · 09-02-2012, 13:29

never does

I never does that , will try too ))

**dalle** · 09-02-2012, 14:27

Originally posted by tiagosoares

I already got this working now, but the only thing that is send to zabbix server is if "MySQL: is Alive" or not...

I set the querylist to "zabbix.QueryListFile=/opt/dbforbix/conf/mysqlquery.props" (see attached)

The log bellow:

Code:

2012-02-08 16:22:21,270 [main] INFO  DBforBIX - Starting DBforBIX Version 0.5
 2012-02-08 16:22:21,294 [main] INFO  DBforBIX - DBforBIX started with pid:29682
 2012-02-08 16:22:21,294 [main] INFO  DBforBIX - PidFile -> ./logs/orabbix.pid
 2012-02-08 16:22:21,791 [main] INFO  DBforBIX - Connected as [email protected]
 2012-02-08 16:22:21,792 [main] INFO  DBforBIX - --------- on Database -> zabbix
 2012-02-08 16:22:22,552 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 558 ms
 2012-02-08 16:23:22,074 [pool-1-thread-2] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 35 ms
 2012-02-08 16:24:22,597 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 513 ms
 2012-02-08 16:25:22,175 [pool-1-thread-4] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 38 ms
 2012-02-08 16:26:22,652 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 457 ms
 2012-02-08 16:27:22,234 [pool-1-thread-6] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 27 ms
 2012-02-08 16:28:22,684 [pool-1-thread-7] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 454 ms
 2012-02-08 16:29:22,263 [pool-1-thread-8] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 17 ms
 2012-02-08 16:30:22,672 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 412 ms
 2012-02-08 16:31:22,291 [pool-1-thread-10] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 16 ms
 2012-02-08 16:32:22,725 [pool-1-thread-11] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 436 ms
 2012-02-08 16:33:22,321 [pool-1-thread-12] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 18 ms
 2012-02-08 16:34:22,726 [pool-1-thread-13] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 409 ms
 2012-02-08 16:35:22,346 [pool-1-thread-14] INFO  DBforBIX - Done with dbJob on database zabbix elapsed time 13 ms

I've found the bug
And is exactly the one signaled from ehartmann
Now I need someone that can confirm solved the issue so if you can try the release 0.5.1
it's available as a preview here
I will wait some feedback before confirm solved the issue

a special thank you to ehartmann and all the feedback of this thread!!!

please let me know
Andrea

**tiagosoares** · 09-02-2012, 16:16

Dalle,

Tested with 0.5.1 and work perfectly!

Many tks!

**dalle** · 09-02-2012, 16:21

Originally posted by tiagosoares

Dalle,

Tested with 0.5.1 and work perfectly!

Many tks!

Thank you!!!
I've already committed the new sources and now I'm going to publish officially this new version!

**dalle** · 09-02-2012, 17:25

DBforBIX 0.5.1 released!

It's available on my website

Page not found

http://bit.ly/ziAHeB

and on sourceforge as ususal
thank you to all my follower

Ad Widget

DBforBIX

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment