Hi,
I have several questions on orabbix. I already have zabbix installed.
I want to use orabbix for executing some queries on my 11g database.
However, I can use the username and password for this db that I already have. I do not really need to create a new user - zabbix. So I am assuming I do not have to run any extra db commands that this link talks about - http://www.smartmarmot.com/wiki/inde...r_Installation
Please correct me if I am wrong.
I have put some queries in my query.props.
I see the following messages in my logs which means I am connected to my db using the username that i use for this db:
INFO Orabbix - Connected as CC_DB
2014-12-09 15:48:46,153 [main] INFO Orabbix - --------- on Database -> ccdbuser
However, I see two issues:
1. Error while executing ->WFC_WFS_SYS_001- on database ->DB1- Exception received ORA-00936: missing expression
Not sure why this is happening.
My query is parameter in query.props is:
CC_001.query = SELECT count(*) as errorCount FROM message WHERE
TIME_STAMP>=TO_DATE(CURRENT_DATE, 'DD-MON-RR') and TIME_STAMP< (TO_DATE(CURRENT_DATE, 'DD-MON-RR') + interval '1' day) having count > 10
2. Second issue is - I see the following message in my logs:
2014-12-09 15:48:46,253 [pool-1-thread-1] DEBUG Orabbix - sending <req><host>REIx</host><key>T3JhYmJpeC5WZXJzaW9u</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4zIA==</data></req>
2014-12-09 15:48:46,254 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXD^A^@^@^@^@^........
What's the reason this is happening?
I have several questions on orabbix. I already have zabbix installed.
I want to use orabbix for executing some queries on my 11g database.
However, I can use the username and password for this db that I already have. I do not really need to create a new user - zabbix. So I am assuming I do not have to run any extra db commands that this link talks about - http://www.smartmarmot.com/wiki/inde...r_Installation
Please correct me if I am wrong.
I have put some queries in my query.props.
I see the following messages in my logs which means I am connected to my db using the username that i use for this db:
INFO Orabbix - Connected as CC_DB
2014-12-09 15:48:46,153 [main] INFO Orabbix - --------- on Database -> ccdbuser
However, I see two issues:
1. Error while executing ->WFC_WFS_SYS_001- on database ->DB1- Exception received ORA-00936: missing expression
Not sure why this is happening.
My query is parameter in query.props is:
CC_001.query = SELECT count(*) as errorCount FROM message WHERE
TIME_STAMP>=TO_DATE(CURRENT_DATE, 'DD-MON-RR') and TIME_STAMP< (TO_DATE(CURRENT_DATE, 'DD-MON-RR') + interval '1' day) having count > 10
2. Second issue is - I see the following message in my logs:
2014-12-09 15:48:46,253 [pool-1-thread-1] DEBUG Orabbix - sending <req><host>REIx</host><key>T3JhYmJpeC5WZXJzaW9u</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4zIA==</data></req>
2014-12-09 15:48:46,254 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXD^A^@^@^@^@^........
What's the reason this is happening?
Comment