Question on Readme instructions for installation.

[mbribeiro]

The second step in the installation says: "Create zabbix api user with read permissions on group, where databases hosts will be."

We got confused regarding this zabbix api user, if this user must be created in oracle database we want to monitor or in the server running the scripts. We also don't know what is this "group" that this user must have read permission. Is this api user a simple linux user we must create in the server that holds the agent or another user created in oracle just like in the step 1.

Thanks in advance.

Marcelo.

[dan-aksenov]

Agree, sounds confusing. Yet I always user same user as one running zabbix-agent.
Works fine.

[mbribeiro]

Great, so is this ok if I skip step 2 and simply use the "zabbix" user ?

[Lelik13a]

In second step we created zabbix user in web-interface. He will be read data from DB hosts and create items check list in /usr/lib/zabbix/cache/items-*.

[as007012]

Linux安装的zabbix.3.4.15版本，被监控端必须手动执行py脚本服务端才能展示数据。

[dmjaya]

12 Configure needed template and hosts items
is this step must or can ignore, If it is must could you please advice how to do it?
And My Output is Nothing

[Lelik13a]

This is active checks.
"Perform checks by items list and print additional verbose information for every check"
pyora-active.py --address 10.0.0.1 --database SID -v
In this step data send on zabbix server to host.
Host and items must be exist.

[dmjaya]

Hello Lelik
Thanks For replying , Im newer to Oracle monitoring,
Could you please send me the steps how to monitoring the Oracle DB using your scripts
Even I dont know how to edit .py files Please Help Me

Thanks

[Lelik13a]

Unfortunately, I worked for a long time with oracle monitoring. And now I have no opportunity to test the script.
Try to see the instructions of the original verification script https://github.com/bicofino/Pyora

[dmjaya]

do you have any idea regarding above attachment

[Lelik13a]

Check step 7 and 8 - zabbix agent must have checks items:

UserParameter=pyora-discovery[*],/usr/lib/zabbix/externalscripts/pyora-discovery.py --address $1 --database $2 $3
UserParameter=pyora-items-list[*],/usr/lib/zabbix/externalscripts/pyora-items-list.py --zabbixurl "$1" --zabbixuser "$2" --zabbixpassword "$3" --hostname "$4" --address "$5" --database "$6"

[dmjaya]

I update the above file like this Please check is this ok?

UserParameter=pyora-discovery[],/usr/lib/zabbix/externalscripts/pyora-discovery.py --address '192.168.10.10' $1 --database 'TEST1' $2 $3
UserParameter=pyora-items-list[],/usr/lib/zabbix/externalscripts/pyora-items-list.py --zabbixurl'http://192.168.10.20/zabbix' "$1" --zabbixuser 'SYS' "$2" --zabbixpassword 'admin@123' "$3" --hostname "ol7" "$4" --address '192.168.10.10' "$5" --database 'TEST1' "$6"

[Lelik13a]

No.
$1, $2 and so - zabbix variables, you don't need edit them.
Just copy file oracle_pyora.conf to /etc/zabbix/zabbix_agentd.d/ directory and restart zabbix agent.
When a zabbix server requests an agent, instead of "$1" variables will be presented.
See step 10.

[dmjaya]

it means no need to change any $ values?
UserParameter=pyora-discovery[],/usr/lib/zabbix/externalscripts/pyora-discovery.py --address $1 --database $2 $3
UserParameter=pyora-items-list[],/usr/lib/zabbix/externalscripts/pyora-items-list.py --zabbixurl "$1" --zabbixuser "$2" --zabbixpassword "$3" --hostname "$4" --address "$5" --database "$6"

& step 10

for your reference

[Lelik13a]

Yes.
Try use zabbix_get.
https://www.zabbix.com/documentation/current/manual/concepts/get
Check agent settings. May be config not included.

[dmjaya]

Hi.
Thanks, @Lelik13a finally I manage to configure the script, Thanks Again. Do I need to reduce the check_active checking interval time 800 to 10 please advice how to do it? "{Template Pyora active send:check_active.nodata(800)}=1"
Thanks.

[Lelik13a]

The period should not be less than 30 seconds because the timer process calculates this function only every 30 seconds.
https://www.zabbix.com/documentation/3.4/manual/appendix/triggers/functions
Verification period is determined by cron (cron.d/zabbix-pyora). You can set necessary time, but 1 minute is the minimal interval supported.
If you want to check the availability of the database, it is better to use other, separate checks.

[dmjaya]

Noted, but after that, I got below issue

[wang509020]

hi,dmjaya

do you have any idea regarding above attachment
tell me ,thks

[dmjaya]

What is the zabbix version your using?
if your using 4.6+ versions download the new shared template & change the trigger & item values according to original template.