Re: [exim] oracle lookups problem

Top Page
Delete this message
Reply to this message
Author: Odhiambo G. Washington
Date:  
To: mmonge
CC: exim-users
Subject: Re: [exim] oracle lookups problem
* 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