Re: [exim] oracle lookups problem

Top Page
Delete this message
Reply to this message
Author: Marcos Monge
Date:  
To: Odhiambo G. Washington, mmonge, exim-users
CC: 
Subject: Re: [exim] oracle lookups problem
On Tue, 16 Nov 2004 19:26:55 +0300, Odhiambo G. Washington
<wash@???> wrote:

> The last time I had a problem like this, I discovered that the
> configuration should be like this:
>
> tns name        = main
> service name    = main
> user            = USERNAME
> password        = PASSWORD

>
> So you have to set:
>
> hide oracle_servers = main/main/USERNAME/PASSWORD


Yes, I have tri this also... :( same error

> > The options I'm using in configure file are:
> > ----------
> > hide oracle_servers = localhost/DBNAME/user/password
>
> Does this conform to what I have put above?


Yes, also I have try several other combinations of host/dbname/etc...
always the same error. I think this is not the problem, and like you
say in your post, the reference guide is wrong. The correct is the
format you say.

> > It's seens to be something related to the oracle client library that
> > Exim use to connect. But I have no idea of how to solve this...
> >
> > Anyone have compile Exim with oracle support and is using oracle
> > lookups correctely? I will apreciate any help
>
> Well, the other thing that I discovered you had to do was to initialize
> the oracle ENV when starting Exim. So in your init.d/exim, you need
> something like:
>
> #!/bin/sh
> . /$ORACLE_HOME/.profile


Yes, I put also all the oracle env before starting the Exim. Is the same result.

What I think is that the oracle support is not correctely compiled in
the exim binary. I use a strange path to compile it (because the make
fail with some not found files, and this files was in this
directorys). To compile I put this paths and options in
Local/Makefile:

LOOKUP_ORACLE=yes
LOOKUP_INCLUDE=-I /usr/include -I /opt/oracle/product/9i/rdbms/demo \
-I /opt/oracle/product/9i/xdk/include
LOOKUP_LIBS=-L/opt/oracle/product/9i/lib -L/usr/lib -lclntsh

I think that the "/opt/oracle/product/9i/rdbms/demo" where are some .h
files needed to compile, is not the "correct" path. Anyway, with this
path the exim compile without error, but I'm not sure that it's
correct...

Someone with oracle support have the Local/Makefile used to compile?

Best Regards
Marcos