DBforBIX 2.0 BETA

[dalle]

I'm back to develop DBforBIX on my few spare time.
I've moved all the code on github to simplify the sharing, forking and help of the project, anyway if you like you can have a look on my website.
Please note that the documentation is still in progress and this version IS NOT compatible with the old one.
This incompatibility is due to many refactoring of the code and many improvements. Now the code is more readable, is lightweight and there is no need to write a specific query to extract every single value from a result set as now this is handled byt the code itself.
Enjoy!

[dalle]

DBforBIX 2.2-beta

The version 2.2 is available now! This release include a persistent framework that avoid any loss of items in case of Zabbix server's maintenace.
Tor more details please have a loot at:DBforBIX2

[zabglo]

Server DOWN

Hi,
smartmarmot.com seams to be down...
Anyway I downloaded your project from github, there's some documentation about windows service intallation?
Service is installed but not start, maybe an OS problem, what about the requisites?
Thanks

[Lurnux]

Multiple query files

First of all a big thank you for your work with the dbforbix!

Is it possible to use multiple query files in this version?
I would like to use stock query file for all db types and service specific files for certain databases.
With our current setup using older dbforbix release i'm forced to use multiple query files which contains mostly common queries for the databases and it seems a bit frustrating to edit all of those when adding some common queries. Am i making any sense here?

Is the value of "query time" for the actual frequency of query and i assume that it in seconds?

Is there any value that could be used for how log queries are waited to get response from the database. For example we have in our current setup a database that is not actually used for any application but there is a lot of data coming in and every time there is a backup running the alive warning is triggered with the old dbforbix release.

[Lurnux]

Missing file

In the wiki it states that dbforbix file should be copied to /etc/init.d:
Copy file /opt/dbforbix/init.d/dbforbix to /etc/init.d/dbforbix
However it seems that this file is not in the 2.2-beta package.

Instead should the instruction be changed so that the dbforbix.sh is copied to /etc/init.d/dbforbix?
And maybe there should be some information stating that this version by default uses dbforbix user that should be added before starting the service?

[Lurnux]

Double entry?

May i ask if there is a reason for uptime being two times in the oracle.xml items file?

[dalle]

You're right the file is missing, this because I don't have anymore a system that uses init.d ....

[Lurnux]

I moved our dbforbix installation to new server and now I'm getting java error from 600 timer:

ERROR Scheduler - Error null
java.lang.NullPointerException
        at java.lang.String.replace(String.java:2240)
        at com.smartmarmot.dbforbix.scheduler.SimpleItem.getItemData(SimpleItem.java:73)
        at com.smartmarmot.dbforbix.scheduler.Scheduler.run(Scheduler.java:96)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)

Old setup was on Oracle Linux Server release 6.2 and the new is on 7.3.
Java version on old server:
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)

And the new one is:
java version "1.7.0_131"
OpenJDK Runtime Environment (rhel-2.6.9.0.0.1.el7_3-x86_64 u131-b00)
OpenJDK 64-Bit Server VM (build 24.131-b00, mixed mode)

Any suggestions? Am I missing something from the new setup?
Dbforbix is exact copy from the old server.

[Lurnux]

I moved our dbforbix installation to new server and now I'm getting java error from 600 timer:

ERROR Scheduler - Error null
java.lang.NullPointerException
        at java.lang.String.replace(String.java:2240)
        at com.smartmarmot.dbforbix.scheduler.SimpleItem.getItemData(SimpleItem.java:73)
        at com.smartmarmot.dbforbix.scheduler.Scheduler.run(Scheduler.java:96)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)

Old setup was on Oracle Linux Server release 6.2 and the new is on 7.3.
Java version on old server:
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)

And the new one is:
java version "1.7.0_131"
OpenJDK Runtime Environment (rhel-2.6.9.0.0.1.el7_3-x86_64 u131-b00)
OpenJDK 64-Bit Server VM (build 24.131-b00, mixed mode)

Any suggestions? Am I missing something from the new setup?
Dbforbix is exact copy from the old server.

The problem disappeared by it self today after i changed all the 600 timers to 50 and back to 600. I don't have any clue what the problem might have been or where it was but it's gone at least for now.

[Cumbalero]

What about Sybase?

Firstable, let me thank you for your job.


I've been testing DBforBIX for a few days and it does the job perfectly monitoring MySQL and Oracle.


I now need to monitor Sybase. Any roadmap for DBforBIX about it? I've read a few about people managing to do so, I guess my main issue will be setting items and triggers.


Any tip, link... is really welcome.

[syndeysider]

Hey! Your tooling has proved invaluable in the past! Big thank you!

Not sure if you aware, but Microsoft has just released a Linux Driver to connect to Microsoft SQL

https://docs.microsoft.com/en-us/sql/connect/odbc/linux/microsoft-odbc-driver-for-sql-server-on-linux

Thought you might be interested as including MSSQL into this tooling would see it's adoption grow! I know that with the original unixODBC-FreeTDS setup it was a bit tricky, especially with the authentication etc.

Cheers again!

[erkann]

what is the real problem ?

The problem disappeared by it self today after i changed all the 600 timers to 50 and back to 600. I don't have any clue what the problem might have been or where it was but it's gone at least for now.

i have the same issue but i don't know how to fix it ... HELP pls

[Lurnux]

i have the same issue but i don't know how to fix it ... HELP pls

I'm also facing this issue again and this time timer value change didn't change the situation. Hoping to get some respond to this problem ASAP.

[Lurnux]

Now we have a new problem. After installing this to another environment we started to get errors like this:

2017-05-23 07:19:38 WARN  could not fetch value oracle.stats[%1]
java.sql.SQLException: ORA-12592: TNS:bad packet

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        at com.smartmarmot.dbforbix.scheduler.SimpleItem.getItemData(SimpleItem.java:48)
        at com.smartmarmot.dbforbix.scheduler.Scheduler.run(Scheduler.java:96)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)

Some googling around ORA-12592 it seems to indicate a problem with our firewall but this problem is only with dbforbix, everything else seems to be working and all of our other applications are working fine.
Anybody got any ideas how to proceed whit this?

[Lurnux]

Now we have a new problem. After installing this to another environment we started to get errors like this:

2017-05-23 07:19:38 WARN  could not fetch value oracle.stats[%1]
java.sql.SQLException: ORA-12592: TNS:bad packet

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        at com.smartmarmot.dbforbix.scheduler.SimpleItem.getItemData(SimpleItem.java:48)
        at com.smartmarmot.dbforbix.scheduler.Scheduler.run(Scheduler.java:96)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)

Some googling around ORA-12592 it seems to indicate a problem with our firewall but this problem is only with dbforbix, everything else seems to be working and all of our other applications are working fine.
Anybody got any ideas how to proceed whit this?

I've tried to change from ojdbc6.jar to ojdbc7.jar without any change to the probelm.