* Marcos Monge <mmonge@???> [20041116 18:18]: wrote:
> Hi
>
> I'm trying to do some oracle lookups, but I always get the same error:
>
> DEFER: ORACLE connection failed: Error while trying to retrieve text
> for error ORA-01019
Hi Marcos,
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
> I have try SEVERAL combinatios for the oracle_servers options, like
> the reference guide say, and like "Odhiambo G. Washington
> <wash@???>" say recentely in a message in this list.
So you saw the post ;)
> 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?
> special_user:
> driver = redirect
> allow_fail
> allow_defer
> data = ${lookup oracle{select '| /usr/local/bin/specialdelivery.sh'
> from usuario_info where email='$local_part@$domain'}{$value}fail}
> pipe_transport = address_pipe
I love Oracle-ism ;) Inasmuch as I know nothing about it.
> 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
exim_startup_args_here
HTH
cheers
- wash
+----------------------------------+-----------------------------------------+
Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
<wash at wananchi dot com> . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
+---------------------------------+------------------------------------------+
"Oh My God! They killed init! You Bastards!"
--from a /. post
