Freeradius & Oracle

Peter Nixon listuser at
Wed Aug 2 13:43:36 CEST 2006

Hi Brian

If you wish to use Oracle you will need to recompile FreeRADIUS on a machine 
that has Oracle development libraries installed. We have a number of 
FreeRADIUS + Oracle deployments and it works well.

Most rpm installations now (Including the SUSE packages which I maintain) do 
not included oraclesql.conf due to the fact that they also don't contain the 
Oracle drive (due to copyright reasons)

On SUSE Linux if you have the Oracle devel files in a sane location it should 
be a simple matter of taking the latest FreeRADIUS release tarball and 
dropping it in /usr/src/packages/SOURCES along with the other files from the 
suse/ directory inside the tarball with the exception of freeradius.spec 
which goes in /usr/src/packages/SPECS.

Then edit /usr/src/packages/SPECS/freeradius.spec and change "%define 
_oracle_support 0" to "%define _oracle_support 1"

The run:
rpmbuild -ba /usr/src/packages/SPECS/freeradius.spec



On Wed 02 Aug 2006 00:48, Dennis Skinner wrote:
> Brian Atkins wrote:
> > From What I could find, it seems that it required moving/copying
> > sql.conf to oraclesql.conf (correct me if I am wrong).
> >
> > Also, as I am weeding my way through this, has anyone used Freeradius to
> > query existing DBsTables/columns rather than creating a new/unique one?
> No.  Read what Alan wrote.  There is a real file called oraclesql.conf.
>  It is very similar to sql.conf, but there are differences.
> If you don't have that file, then you don't have the entire install for
> some reason.  If that reason is because you used an rpm, then you may
> need to install freeradius-oracle.x.x.rpm (you are probably missing the
> freeradius oracle libs too!).  Otherwise, download the tarball again and
> find that file.
> > Alan DeKok wrote:
> >> Brian Atkins <batkins at> wrote:
> >>> I have been installed Freeradius and the SQL module, but in sql.conf
> >>> it states to use oraclesql.conf. I have attempted to locate the
> >>> appropriate package, module, or config file.
> >>
> >>   That file is included in the server source distribution.  See the
> >> main web page, and download the latest release.
> >>
> >>   Alan DeKok.
> >> --
> >>       - The web site of the book
> >> - The blog
> >> - List info/subscribe/unsubscribe? See
> >>
> >
> > - List info/subscribe/unsubscribe? See
> >


Peter Nixon
PGP Key:
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <>

More information about the Freeradius-Users mailing list