Freeradius3.0.3, Oracle database and UnixODBC
Hi, I'm trying to integrate Freeradius and Oracle database. I'm using UnixODBC for this. My Oracle client and ISQL is working (connecting to oracle database) but when i try to start radius i have logs: rlm_sql_unixodbc: 01000 [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client/lib/libsqora.so.11.1' : ????: undefined symbol: get_vtable rlm_sql_unixodbc: SQL down 08003 [unixODBC][Driver Manager]Connnection does not exist rlm_sql_unixodbc: Can't allocate the statement rlm_sql_unixodbc: Socket destructor called, closing socket rlm_sql (oracle_eduroam): Opening connection failed (0) rlm_sql (oracle_eduroam): Removing connection pool This configuration works fine on FR2.
On 4 Feb 2015, at 20:27, Puzzel <puzzel1982@gmail.com> wrote:
Hi,
I'm trying to integrate Freeradius and Oracle database.
I'm using UnixODBC for this.
Can you try the latest stable (3.0.6) and see if this is still an issue. -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
Where can i find it? I didn't know if native plugin for oracle exists. -----Original Message----- From: freeradius-users-bounces+puzzel1982=gmail.com@lists.freeradius.org [mailto:freeradius-users-bounces+puzzel1982=gmail.com@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, February 04, 2015 4:16 PM To: FreeRadius users mailing list Subject: Re: Freeradius3.0.3, Oracle database and UnixODBC On Feb 4, 2015, at 8:27 AM, Puzzel <puzzel1982@gmail.com> wrote:
I'm trying to integrate Freeradius and Oracle database.
I'm using UnixODBC for this.
Why? There's a native Oracle plugin for FreeRADIUS. I use it. It works. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
Where can i find it? I didn't know if native plugin for oracle exists.
from the FreeRADIUS WIKI "If you wish to use Oracle you will need to recompile FreeRADIUS on a machine that has Oracle development libraries installed. FreeRADIUS is known to work both with a full Oracle installation as well as with the Oracle Instant Client SDK" http://www.oracle.com/technetwork/database/features/instant-client/index-100... if building your own RPM or DEB packages, they resulting packages can be deployed with just the Oracle Instant Client (No need for the SDK on production machines) alan
On 6 Feb 2015, at 01:38, Alan DeKok <aland@deployingradius.com> wrote:
On Feb 5, 2015, at 3:03 AM, Puzzel <puzzel1982@gmail.com> wrote:
Where can i find it? I didn't know if native plugin for oracle exists.
See src/modules/rlm_sql/drivers/rlm_sql_oracle.
Install the relevant Oracle libraries, and they will be picked up by “configure”.
Works on OSX too :) Was just testing it a few days ago. It'd still be nice to know if the Unix ODBC driver is broken. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
It works. Tnx Alan. -----Original Message----- From: freeradius-users-bounces+puzzel1982=gmail.com@lists.freeradius.org [mailto:freeradius-users-bounces+puzzel1982=gmail.com@lists.freeradius.org] On Behalf Of Arran Cudbard-Bell Sent: Thursday, February 05, 2015 11:14 PM To: FreeRadius users mailing list Subject: Re: Freeradius3.0.3, Oracle database and UnixODBC
On 6 Feb 2015, at 01:38, Alan DeKok <aland@deployingradius.com> wrote:
On Feb 5, 2015, at 3:03 AM, Puzzel <puzzel1982@gmail.com> wrote:
Where can i find it? I didn't know if native plugin for oracle exists.
See src/modules/rlm_sql/drivers/rlm_sql_oracle.
Install the relevant Oracle libraries, and they will be picked up by "configure".
Works on OSX too :) Was just testing it a few days ago. It'd still be nice to know if the Unix ODBC driver is broken. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Arran Cudbard-Bell -
Puzzel