DBforBIX

[kunajn]

there is a new version of DBforBIX available is currently in beta testing but it looks stable.
This new version manage even the discovery item and all the new features anyway the configuration is quite different and is not compatible with the previous one as it has been completely re-factored.
Well if you would like to give it a try the software and the source code are available as always on sourceforge.

That's great news!

Andrea - is there any documentation regarding what has changed and how it works now?

[dalle]

That's great news!

Andrea - is there any documentation regarding what has changed and how it works now?

Hi
I'm sorry but currently is not well documented as DBforBIX 0.6.x.
I've done a complete re-factoring of the project, now the code is a lot more clean and readable, also this version is a little less greedy of ram. On the previous version I managed to have more than 80 oracle instances, 13 mysql,9 postgreqsl under monitoring and was consuming 250MB of ram now is almost the half.
The sourcce code and the eclipse project itself is committed on sourceforge if you have some java knowledge I think you can download it and see the difference
Anyway so far I don't see bugs... but the old one has been installed and used so much that this one can't be considered really production ready like the old one
I'll write the documentation as soon as I have a bit of spare time.

[kunajn]

Hi
I'm sorry but currently is not well documented as DBforBIX 0.6.x.
I've done a complete re-factoring of the project, now the code is a lot more clean and readable, also this version is a little less greedy of ram. On the previous version I managed to have more than 80 oracle instances, 13 mysql,9 postgreqsl under monitoring and was consuming 250MB of ram now is almost the half.
The sourcce code and the eclipse project itself is committed on sourceforge if you have some java knowledge I think you can download it and see the difference
Anyway so far I don't see bugs... but the old one has been installed and used so much that this one can't be considered really production ready like the old one
I'll write the documentation as soon as I have a bit of spare time.

Understood. Unfortunately I'm not JAVA programmer, just DBA.
Anyway I have problems with running it.

dbforbix.err throws error:
log4j:WARN No appenders could be found for logger (com.smartmarmot.dbforbix.config.Config).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.commons.daemon.support.DaemonLoader.sta rt(DaemonLoader.java:243)
Caused by: java.lang.NullPointerException
at com.smartmarmot.dbforbix.DBforBix.loadItemConfig(D BforBix.java:249)
at com.smartmarmot.dbforbix.DBforBix.main(DBforBix.ja va:180)
at com.smartmarmot.dbforbix.DBforBix.start(DBforBix.j ava:425)
... 5 more
Cannot start daemon
Service exit with a return value of 5

And when I trace process it seems it has problems with relative paths and opening ./items directory:
19857 open("./items", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
19857 --- SIGSEGV (Segmentation fault) @ 0 (0) ---

I see that it also had problems with looking for config file - it also didn't work with relative path, but then it tried to find it using absolute paths and finally found it:

19857 stat("./conf/config.properties", 0x7fff7d9fcdf0) = -1 ENOENT (No such file or directory)
19857 stat("/var/lib/zabbix/conf/config.properties", 0x7fff7d9fcdf0) = -1 ENOENT (No such file or directory)
19857 stat("/usr/local/dbforbix-new/./conf/config.properties", {st_mode=S_IFREG|0644, st_size=1268, ...}) = 0

[ik_zelf]

logging query name?

Good to see there is still development going on into dbforbix. I am just starting with it and one thing I can not find is: how can I make it log the query names that are executed?
It is good to know that:
"
INFO DBforBIX - Done with dbJob on database ORCL elapsed time 5 ms
"
but instead of the "dbJob" I would like to see (or add) the query name.

An other question: can we run queries based on the connected database version? In 12c there are some changes that require some other views to be polled ....

Thanks,
Ronald.

[ik_zelf]

Lld

Hi,

can we use dbforbix to discover - for example - tablespaces, and generate items, graphs and triggers on them, similar as how filesystems are now discovered (zabbix-2.4.4)? That would be VERY nice. For 12c this would probably mean discover plugin databases and their tablespaces.

thanks,
Ronald.

[ik_zelf]

dbfoxbix-2 beta-3

Hi, I did get the daemon running. Sofar, so good.
It is just not connecting to my databases. That's a pity.
Comments on DBforBIX V.2 beta3 is now available!

In the 0.6 version, the database names were related to a hostname in zabbix. How do we define that in the beta?

#DB.DB1.Type=pgsql
#DB.DB1.Name=PostgreSVR
#DB.DB1.Url=jdbcostgresql://localhost:5432/
#DB.DB1.User=user
#DB.DB1.Password=passwd

Should I have a host 'DB1' defined? or should I have a host named 'PostgreSVR' defined in zabbix? (I tried both and for none I got connections to the database, in my case an oracle database) (of course using oracle jdbc etc.)

A hint how to get this working is very welcome.
Thanks,
Ronald.

[erisan500]

Dalle, dove sei?

Is this still under active development?
The last post is from 5 march 2015 on this forum and on the author's website his last comment is dated 12 march 2015. After that nothing anymore.

I tried the beta 3 version on Centos 6.6 and i also have the problem that i can’t start DBforBIX. it throws the following error:

service dbforbix start
jsvc error: Invalid option -procname
jsvc error: Cannot parse command line arguments

Does anyone have a clue on what i might be missing?

Kind regards

[dalle]

Yes is still developed
let me try to see if it work on Centos 6.6

[bagaceira]

Monitoring PostgreSQL

Hi Dalle and all of Zabbix forum.

This is my first post and my problem is:

I'm using DBforBIX to monitor my PostgreSQL. When I check the Zabbix Recent Data does not have any information.

Checking the log of DbforBix I look the follow:
2015-06-23 18:13:26,834 [main] INFO DBforBIX - Starting DBforBIX Version 0.6.1
2015-06-23 18:13:26,861 [main] INFO DBforBIX - DBforBIX started with pid:4603
2015-06-23 18:13:26,861 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2015-06-23 18:13:27,134 [main] INFO DBforBIX - Connected as zabbix
2015-06-23 18:13:27,147 [main] ERROR DBforBIX - Error on Configurator for database PGSQLDB2 -->ERRO: function db_name() doesn't exist
Hint: No function matches the name and type of informed arguments. You need to add explicit type conversions .

I looked at several places but not found who had the same problem.

Thanks in advance and sorry my poor English hehe...

[Lurnux]

Does anybody have any suggestions for my problem?
I'm currently checking ETL sequence number from db and triggering an alarm if there is no change in this number between checks. This works perfectly but the problem is night time, when there is no changes coming in and I cant change the monitor period since it's Zabbix trapper type.
Is it even possible to change the check period or even interval with dbforbix?

[Lurnux]

Does anybody have any suggestions for my problem?
I'm currently checking ETL sequence number from db and triggering an alarm if there is no change in this number between checks. This works perfectly but the problem is night time, when there is no changes coming in and I cant change the monitor period since it's Zabbix trapper type.
Is it even possible to change the check period or even interval with dbforbix?

To answer my self:
DBforBIX interval can be adjusted in the query file by using

customQueryItemName.Period=<Express a period in minute>

but this won't help with the problem since it's not controlled by any specific time or date. Instead the query interval can be limited with this.

For what I use now to limit the alarm times is the trigger's triggering times like:

{hostname:db_item.last()}>4 and 
{hostname.db:DBforBIX.Oracle.item.dayofweek(0)}<6 and
{hostname.db:DBforBIX.Oracle.item.time(0)}<170000 and 
{hostname.db:DBforBIX.Oracle.item.time(0)}>081000

So if the received value is more than 4 and day of week is mon-fri and time is between 08:10-17:00 alarm is triggered.

[AlanDBA]

Dbforbix is not respecting Period parameter

Hi,

I have dbforbix 0.6 installed and working on a host with two instance using the same query props file.
But for one instance the dbforbix is ignoring the period parameter and is send data every minute.

Please, could some one help?

[lbjensen]

JDBC as sysdba

Hi,

Is there a way to connect to the database as sysdba og sysasm?

I want to monitor an ASM instance, but cannot figure out how to send "/ as sysdba" or "/ as sysasm"
I have found a parameter called: internal_logon, but the config.props file seems to ignore it.

Any help would be apreciated.

Cheers
Lars
Denmark

[joeyski]

Oracle SELECT results in columnar format

Hi,

select owner, count(*) from dba_objects where status = 'INVALID' group by owner order by owner

The above code is an oracle item that counts INVALID objects.
The trigger includes the item data as part of email notification.

However it comes up as a one liner text instead of the columnar output
just like when you run it from SQLPLUS.

Like the ff:

Trigger: Invalid Objects DB1
Trigger status: PROBLEM
Trigger severity: Warning
Trigger URL:

Item values:

1. Invalid Objects (PROD DB1BforBIX.Oracle.invalids): APPS 151BRABI 2BRENT 2CUSTOM 2PUBLIC 4SPV 1SYS 6TSAHA 1

Original event ID: 24532

Instead of :

APPS 128
BRABI 2
BRENT 2
CUSTOM 2
PUBLIC 4
SPV 1
SYS 6
TSAHA 1

How do we make the output into columnar format?

TIA

[thvillegas]

hello, bagaceira, you're from Brazil, for gentiliza already hit its BDFORBIX if this still does not work, let me know and put your settings.

ok????

Hi Dalle and all of Zabbix forum.

This is my first post and my problem is:

I'm using DBforBIX to monitor my PostgreSQL. When I check the Zabbix Recent Data does not have any information.

Checking the log of DbforBix I look the follow:
2015-06-23 18:13:26,834 [main] INFO DBforBIX - Starting DBforBIX Version 0.6.1
2015-06-23 18:13:26,861 [main] INFO DBforBIX - DBforBIX started with pid:4603
2015-06-23 18:13:26,861 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2015-06-23 18:13:27,134 [main] INFO DBforBIX - Connected as zabbix
2015-06-23 18:13:27,147 [main] ERROR DBforBIX - Error on Configurator for database PGSQLDB2 -->ERRO: function db_name() doesn't exist
Hint: No function matches the name and type of informed arguments. You need to add explicit type conversions .

I looked at several places but not found who had the same problem.

Thanks in advance and sorry my poor English hehe...