Re: [Exim] Oracle & exim

Top Page
Delete this message
Reply to this message
Author: George Schlossnagle
Date:  
To: Nathan Ollerenshaw
CC: Paul Makepeace, exim-users
Subject: Re: [Exim] Oracle & exim
I posted to the list a few months ago volunteering to write this (and
quite clearly havent :). One of the major issues for me is that oci is
an evil beast, and doesn't support some of the nicer api functions that
mysql has. That's all lazy talk, of course. If people are comfortable
having to link against a oci wrapper library like libsqlora, I would be
happy to re-volunteer to write this....

Opinions? I feel like linking against other 3rdparty libraries is sort
of against exim style....

George

Nathan Ollerenshaw wrote:
>
> Moderator, please don't approve the previous message I sent from an
> incorrect address...
>
> Paul,
>
> If you know C (or have a good friend who knows C and will work for beer)
> look at the README file in src/lookups/README. The interface for writing
> lookups is very well documented and easy to understand - and if you were to
> submit an oracle lookup to exim, I'm sure you'd get a few cases of beer
> yourself.
>
> Just looking at the mysql.c lookup, it doesn't look like there is too much
> "work" to be done, it would just take some time to develop, test and debug.
> Also, Oracle make it harder for you because its a pain in the backside to
> find their C libraries...
>
> Just a thought...
>
> Oh, it also occurred to me to look for a more open oracle library to make it
> easier to add support into exim, and I came across this:
> http://www.netcologne.de/~nc-poitscka/
>
> This looks like it's a fairly robust and mature library for Oracle 8 that
> allows you to do all the sorts of things you'd expect.
>
> Nathan.
>
> -----Original Message-----
> From: exim-users-admin@??? [mailto:exim-users-admin@exim.org]On
> Behalf Of Paul Makepeace
> Sent: 22 February 2001 20:33
> To: exim-users@???
> Subject: Re: [Exim] Oracle & exim
>
> From: "Philip Hazel" <ph10@???>
> > > Are there moves afoot to have exim have the facility to lookup
> > > using an Oracle database along with its ability to work with
> > > {My,Postgre}SQL? Or, perhaps has someone done it using Perl's DBI &
> > > DBD::Oracle?
> >
> > Not to my knowledge.
>
> OK, I'll have a go thru' the perl/DBI route.
>
> > The latest per-release ChangeLog files on the ftp site are there in both
> > .gz and non-gz forms, since somebody previously complained, but I didn't
> > take time to retro-provide older versions.
>
> FWIW, if they're on the Web site they're easier to find (for some of us) and
> best of all get indexed so ?q=exim+oracle would lead me to the changelog and
> hopefully version number.. in an ideal world.
>
> Paul
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
> details at http://www.exim.org/ ##
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##


--
$_ = 'George Schlossnagle';
s#.#(ord$')-(ord$&)+((index($_,$')-$&)?1002:0)#ego;s#-#((substr($],4,1)-6)?67:$-[0])#eog;$:=$_;print
join('',(map chr$_,reverse
map{substr($:,(3*$_),3)+(11,-109,-14,94,-894,-28,-61,-202,-417,83,-20,-678,53,96,4,-494,82,-869,-826,24,16,-684,-450,-27)[$_]}(0...length($_)/3)),chr(length($_)/2+ord$/),$/);