DBforBIX

[ke_sheng_jie]

Same here

Same issue as above, the download links just load the home page:

http://www.smartmarmot.com/?s2member_file_download=dbforbix-0.6.zip

http://www.smartmarmot.com/?s2member_file_download=dbforbix-0.5.zip

The contact us page also doesn't work on smartmarmot.com.

[heaje]

Just download it from the Sourceforge page: http://sourceforge.net/projects/dbforbix/

[lbjensen]

Max text send to items table

Hi

I'm trying to send about 2000 characters to latest data in the items table, which I have changed to a text datatype.

My problem is, that I still only receives 255 characters.

The history_text can display the hole string, but the text format I have made is not available in the history_text table.

My question is, can I change the max text value being sent to Zabbix?

Cheers
Lars Baad-Jensen
Denmark

[dalle]

Hi

I'm trying to send about 2000 characters to latest data in the items table, which I have changed to a text datatype.

My problem is, that I still only receives 255 characters.

The history_text can display the hole string, but the text format I have made is not available in the history_text table.

My question is, can I change the max text value being sent to Zabbix?

Cheers
Lars Baad-Jensen
Denmark

I need to check, so please give me the benefit of the doubt but shouldn't be a DBforBIX limitation I think is possible is a protocol limitation, but as said I need to check.

[lbjensen]

Follow up

Hi Dalle

Just to follow up.
I have checked the proxy log, and here is the complete string,
The complete string is also displayed in the "Latest data"

The problem is I cannot find the data in any tables in MySQL

Cheers
Lars
Denmark

[lbjensen]

Solution for large text strings

Hi

I have found a work-arround.
I have changed the datatype to log. That way the string can be sent and the formatting of the string is intact.

Cheers
Lars Baad-Jensen
Denmark

[r0k5t4r]

MS SQL Template?

Hi,

I can't find a template for MS SQL?

Is this still work in progress?

Regards,

[russianrick]

DBforBix continues to run, but stops sending data to zabbix

I am having an issue where dbforbix will stop sending data to zabbix after several hours. I cannot find anything specific in the logs around the time when data stops appearing. It appears that data is being collected. Has anyone else experienced this issue? It almost seems like there is a memory leak.

[esawyja]

Hi russianrick,
I have the same problem, mine collects for days though, before stopping without any problem in the logs. What I did was to create an item to see when the logfile is not growing and trigger on that
See the attached Item and Trigger

[dalle]

Hi russianrick,
I have the same problem, mine collects for days though, before stopping without any problem in the logs. What I did was to create an item to see when the logfile is not growing and trigger on that
See the attached Item and Trigger

Hi
I am sorry to hear that.
If you find some error please feel free to send me the logfile!
I will check if something odd happen.

[dalle]

Sybase ASE

DBforBIX now support Sysbase ASE.
For more information and software download please refer to:

http://www.smartmarmot.com/2013/09/dbforbix-0-6-1-is-out-now-dbforbix-support-sybase-ase/

[chrigu]

MS SQL template missing in version 0.6.1

After downloading the latest DBforBIX version 0.6.1, I wonder where to find the MS SQL XML template for importing into Zabbix. The template folder has one for MySQL, Oracle, PostgreSQL and Sybase but none for MS SQL.

Many thanks
Christian

[ebrose]

SQL Server Item / graph

Hey there, was hoping someone might be able to help since there isn't an mssql template anymore for dbforbix.
I have set up a mssql 2000 in my config and just have one query in my queries file.

QueryList=Processes

Processes.Query=select count(*) from master.dbo.sysprocesses where hostname != ''

The dbforbix log says it running properly for the sql server.
I create an item in zabbix that looks like this

Name: Processes
Type: Zabbix Trapper
Key: DBforBIX.mssql.Processes
Type: Numeric (Float)
Units: Blank/None
Custom Multiplier: Blank/None
Keep history: 90
Keep Trends: 365
Store Value: As is
Show Value: As is
Allowed Hosts: Blank/None
New Application: Blank/None
Populates host inventory field: -None-

According to zabbix, the item is fine with no errors and it is enabled.

I try to create a graph using this item. but the graph still says [no data]

I can execute the query on the host with the user credentials i've provided in the conf.props file.

Any thoughts?
Thanks ahead of time!

[theocastelo]

Man,

I really love DbforBix, but my boss need to monitor other thinks, like query´s, database sizes, etc etc and in the template attacched in DBforBIX , they monitor only 23 items.

Can dbforbix get this values from postgresql?

Have another template with more items to monitoring?


Sorry for my bad english... =/

[salzkrebs]

Database Queries stopped

Hallo Dalle,

I think you have done a great Job so far dbforbix is incredible and i am trying to get everything out of it.

So far I installed DBforBIX (0.6) on my Zabbix Server (RedHat 6.3, Zabbix 2.2, Postgres 9.2.4) and added some Queries to the pgsqlquery.props.

Now I have encountered a Problem which i didn't find in the Logs.
After about 10 hours of working without any Problems it (Queries every 1 minute) it stopped without any Error. The only Strange thing is, that the log shows for the last entrys only Thread 1!

2014-01-23 03:33:58,808 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database A elapsed time 3 ms
 2014-01-23 03:33:58,809 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database B elapsed time 3 ms
 2014-01-23 03:34:58,914 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database B elapsed time 103 ms
 2014-01-23 03:34:58,930 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database C elapsed time 122 ms
 2014-01-23 03:34:58,939 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database A elapsed time 129 ms
 2014-01-23 03:35:58,814 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database C elapsed time 2 ms
 2014-01-23 03:35:58,816 [pool-1-thread-9] INFO  DBforBIX - Done with dbJob on database A elapsed time 3 ms
 2014-01-23 03:35:58,816 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database B elapsed time 2 ms
 2014-01-23 03:36:58,938 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database C elapsed time 122 ms
 2014-01-23 03:36:58,984 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database A elapsed time 163 ms
 2014-01-23 03:36:59,068 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database B elapsed time 130 ms
 2014-01-23 03:37:58,826 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database C elapsed time 3 ms
 2014-01-23 03:37:58,829 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database A elapsed time 3 ms
 2014-01-23 03:37:58,831 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database B elapsed time 2 ms
 2014-01-23 03:38:59,305 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database C elapsed time 477 ms

I will try to leave it again over night on our testsystem, but i think this is quite critical.

Is this a known Problem/Issue, is it fixed in 0.6.1?

Br Manuel