Good afternoon. I'm working on implementing a wireless hotspot using Chillispot and Freeradius. I have an Oracle DB that I would like to pul username/password credentials from. 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. I found an old (2002) reference on the developer's list to a link where it can be downloaded (http://www.intelcom.sm/oraclesql.conf), but even though the site is active, the link is non-existent. Any assistance would be appreciated. Thanks, -- Brian "An adventure is never an adventure when it's happening. Challenging experiences need time to ferment, and an adventure is simply physical and emotional discomfort recollected in tranquility." -- Tim Cahill
Brian Atkins <batkins@tlcdelivers.com> 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. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
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? Brian Alan DeKok wrote:
Brian Atkins <batkins@tlcdelivers.com> 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. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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@tlcdelivers.com> 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. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com
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@tlcdelivers.com> 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. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
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... Brian 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@tlcdelivers.com> 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. >>>> -- >>>> http://deployingradius.com - The web site of the book >>>> http://deployingradius.com/blog/ - The blog >>>> - List info/subscribe/unsubscribe? See >>>> http://www.freeradius.org/list/users.html >>> - List info/subscribe/unsubscribe? See >>> http://www.freeradius.org/list/users.html >
29M oracle-instantclient-basic-10.1.0.4-1.i386.rpm :-) -Peter On Wed 02 Aug 2006 15:42, Brian Atkins wrote:
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...
Brian
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@tlcdelivers.com> 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. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
participants (4)
-
Alan DeKok -
Brian Atkins -
Dennis Skinner -
Peter Nixon