Freeradius & Oracle

Brian Atkins batkins at
Wed Aug 2 14:42:30 CEST 2006

Peter & Dennis,

Thanks for the quick responses. I now understand why is wasn't just 
'there' after installing Freeradius. And, judging from the other things 
that I've read, even if I were somehow able to port it over, it would 
likely be too large for OpenWRT.

Thanks for the input. Time to drop back and punt...


Peter Nixon wrote:
> 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
> Regards
> Peter
> 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

More information about the Freeradius-Users mailing list