Oracle 10g and 1.1.4 login problem

[Sandor Feher]

Hi,

I would like to run zabbix with my oracle 10g database.
Here is what i did:

Installed libsqlora8 then compiled --enable-server --enable-agent --with-oracle=/usr/local
It has compiled successfully.
I created the database schema and called it zabbix with passwd zabbix.
I set server config file under /etc/zabbix/ then tried to start zabbix_server.

# Database host name
# Default is localhost

DBHost=localhost

# Database name

DBName=oracle

# Database user

DBUser=zabbix

# Database password
# Comment this line if no password used

DBPassword=zabbix


I get the following error message:

030247:20070104:220110 Starting zabbix_server. ZABBIX 1.1.4.
030247:20070104:220110 Cannot login with zabbix/zabbix@oracle

However I can login in with sqlplus used the user/pass above.

thanks in advance,, Sandor

[Sandor Feher]

Some additional information.

This is a RHEL 4 with 2.6.9-5.EL
libsqlora8-2.3.3 installed and works fine if i run ./testlora zabbix/zabbix@oracle
But I had to set ORACLE_HOME var to get libsqlora8 worked.
I did the same at the beginning of the zabbix_server_ctl script but nothing changed.

[Alexei]

Perhaps you could check Oracle side (logs) to see what is wrong.

[Sandor Feher]

Goddam. You can't believe this. I was thinking on the suckerd starting process and realized that it becomes zabbix user first then does the rest of the things eg db connect too. I su-ed to zabbix and saw that it unable to see my oracle home and i know it have to reach oracle's libraries. So I changed zabbix's group to oinstall and voila. Started.