Fwd: Re: (RADIATOR) SNMP Agent, Openlink, Oracle and Radiator

[Mike McCauley]

Hi All, 

After a long struggle with Oracle, I can add some more to this thread.

I was able to reproduce what seems like the same problem reported here with 
Oracle 9i on RedHat 7.1. The symptoms during the Oracle installation included 
a number of reported errrors during the link phase of the installation. Later 
when building DBD-Oracle-1.12, no errors were reported, but when trying to 
connect using DBD-Oracle, it reported problems with missing libraries.

The fine print in the Oracle release notes says Oracle is actually only 
certified for SuSE Linux 7.1 with particular versions of kernel, glibc and 
binutils.

However closer investigation shows that it _is_ possible to avoid the install 
problems on RH 7.1 and get a dynamically linked DBD-Oracle.

The cause of the linking problems (on my host at least) is a failure to 
correctly build one of the libraries at link time.

The solution is discussed at:
http://dbforums.com/archive/49/2001/11/1/193916

I have confirmed that after this you can build a dynalically linked 
DBD-Oracle that loads and works.

Hope that helps.

Cheers.

> ----------  Forwarded Message  ----------
>
> Subject: Re: (RADIATOR) SNMP Agent, Openlink, Oracle and Radiator
> Date: Mon, 18 Feb 2002 12:14:24 +0100
> From: "Tunde Itayemi" <aitayemi at taralos.metrong.com>
> To: <hugh at open.com.au>
>
> Hi Hugh,
>
> The following info is just in case anyone else has trouble with installing
> DBI/DBD-Oracle
> on Redhat Linux 7.2 .
> Note that you must use the "static linking" option to install DBD-Oracle or
> else, you won't
> be able to get radiator to authenticate via the module against an Oracle
> DB. You will see a reference to the errors that you get (after using the
> default dynamic linking option in the
> Readme.help file that comes with the DBD-Oracle-1.12.tar.gz file) and how
> to do the
> static linking under the "For platforms which require static linking."
> section.
>
> Thanks for the info on the ODBC module. Though as I remember, when I
> downloaded the
> ODBC module, it said that it was just for Informix or so - not Oracle?
>
> Regards,
> Tunde Itayemi.
>
> ----- Original Message -----
> From: "Hugh Irvine" <hugh at open.com.au>
> To: "Tunde Itayemi" <aitayemi at taralos.metrong.com>; <radiator at open.com.au>
> Sent: Monday, February 18, 2002 00:09
> Subject: Re: (RADIATOR) SNMP Agent, Openlink, Oracle and Radiator
>
> > Hello Tunde -
> >
> > On Sun, 17 Feb 2002 02:43, Tunde Itayemi wrote:
> > > Hi All,
> > >
> > > I have installed Openlink's ODBC driver for Linux on my Redhat 7.2
>
> system.
>
> > > I have also tested it. I have also installed Oracle 9i client on the
>
> same
>
> > > system with a view to implementing the DBI/Oracle DBD connection as I
>
> want
>
> > > to use a remote database for authentication. Please, with respect to
> > > Openlink's software, How do I reference the DSN in the radius.cfg file?
>
> Do
>
> > > I just put the DSN's name in the DBI clause? - I don't think this would
> > > work though. Is there anything I need to know about the Perl DBD/DBI
>
> before
>
> > > installing it? I have the files DBI-1.21.tar.gz and
>
> DBD-Oracle-1.12.tar.gz
>
> > > and I am just about to install them.
> > >
> > > I hope to hear from you soon as I should have the system up and running
> > > before Monday - today is Saturday in Nigeria.
> >
> > Its Monday morning here in Australia.
> >
> > Normally if you are using Oracle with DBI and DBD-Oracle, you do not use
>
> ODBC
>
> > at all - you just need the Oracle client libraries. If you do want to use
> > ODBD, you would use DBI and DBD-ODBC.
> >
> > You will have to check the Openlink ODBC documentation to see how to
> > configure it for use with various databases.
> >
> > regards
> >
> > Hugh
> >
> > --
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> > -
> > Nets: internetwork inventory and management - graphical, extensible,
> > flexible with hardware, software, platform and database independence.
>
> -------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.