FreeRadius 2.1.10 with Oracle support under Fedora 14
Hi all, It might be redondant with another but slightly different. I have installed FreeRadius thanks to yum over Fedora 14. Everything went fine and was working fine until I need to add the Oracle support to have the accounting working with on Oracle database. When I needed LDAP support I installed the package freeradius-ldap.x86_64. Unfortunately I can't find the same for Oracle and I don't think it is already installed in the basic package. When I configured sql.conf and activate in site-available/default the accounting sql section I get this error : /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could you help me to find a solution ? Cheers Aurélien
Hi,
Hi all, It might be redondant with another but slightly different. I have installed FreeRadius thanks to yum over Fedora 14. Everything went fine and was working fine until I need to add the Oracle support to have the accounting working with on Oracle database. When I needed LDAP support I installed the package freeradius-ldap.x86_64. Unfortunately I can't find the same for Oracle and I don't think it is already installed in the basic package.� When I configured sql.conf and activate in site-available/default the accounting sql section I get this error : /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could you help me to find a solution ?
freeradius for Fedora14 has multiple packages: freeradius-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:04 1.3M freeradius-krb5-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:03 38K freeradius-ldap-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:04 52K freeradius-mysql-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:02 46K freeradius-perl-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:03 43K freeradius-postgresql-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:02 54K freeradius-python-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:04 39K freeradius-unixODBC-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:03 37K freeradius-utils-2.1.9-3.fc14.i686.rpm 31-Jul-2010 21:05 102K it might be that there isnt a sub package for Oracle.... or it might be that the Oracle stuff is in freeradius-unixODBC-2.1.9-3.fc14.i686.rpm the full debug output would show why/how it breaks - when its loading in the sql.conf configuration file (sql.conf fails....so 'sql' will die in any virtual server) alan
On Tue, Jul 5, 2011 at 6:13 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
Hi all, It might be redondant with another but slightly different.
I have installed FreeRadius thanks to yum over Fedora 14. Everything went fine and was working fine until I need to add the Oracle support to have the accounting working with on Oracle database. When I needed LDAP support I installed the package freeradius-ldap.x86_64. Unfortunately I can't find the same for Oracle and I don't think it is already installed in the basic package. When I configured sql.conf and activate in site-available/default the accounting sql section I get this error : /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could you help me to find a solution ? Cheers Aurélien
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to). What's wrong the 2.1.11 that you compiled earlier? -- Fajar
2011/7/5 Fajar A. Nugraha <list@fajar.net>
On Tue, Jul 5, 2011 at 6:13 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
Hi all, It might be redondant with another but slightly different.
I have installed FreeRadius thanks to yum over Fedora 14. Everything went fine and was working fine until I need to add the Oracle support to have the accounting working with on Oracle database. When I needed LDAP support I installed the package freeradius-ldap.x86_64. Unfortunately I can't find the same for Oracle and I don't think it is already installed in the basic package. When I configured sql.conf and activate in site-available/default the accounting sql section I get this error : /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could you help me to find a solution ? Cheers Aurélien
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to).
I don't understand why, because the instant client is a free tool so why not use it directly in the FreeRadius package ? It exists a Oracle package for Perl... Do you think that the UnixODBC will handle that ?
What's wrong the 2.1.11 that you compiled earlier?
Two problems with 2.1.11 : - firstly, it was a mess on my server because I mixed the two versions - secondly, I compile but it was not ok with Oracle (don't know why), and I am using chkconfig for configuring the services and I didn't manage start/stop/restart with the service command. All your help is very appreciated ! Thanks Aurélien
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Aurélien Lafranchise wrote:\
I don't understand why, because the instant client is a free tool so why not use it directly in the FreeRadius package ? It exists a Oracle package for Perl...
The Oracle license does not allow it.
Do you think that the UnixODBC will handle that ?
Ask Oracle if they support ODBC. Alan DeKok.
It may help : in /usr/lib/ i have rlm_sql.so -> rlm_sql-2.1.10.so If I changed oracle for mysql in sql.conf I still have the same problem ! I can't load the sql module. But sqllog works ! Thanks 2011/7/5 Alan DeKok <aland@deployingradius.com>
Aurélien Lafranchise wrote:\
I don't understand why, because the instant client is a free tool so why not use it directly in the FreeRadius package ? It exists a Oracle package for Perl...
The Oracle license does not allow it.
Do you think that the UnixODBC will handle that ?
Ask Oracle if they support ODBC.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Aurélien Lafranchise wrote:
It may help : in /usr/lib/ i have rlm_sql.so -> rlm_sql-2.1.10.so <http://rlm_sql-2.1.10.so>
If I changed oracle for mysql in sql.conf I still have the same problem ! I can't load the sql module. But sqllog works !
You need to read the messages on this list. Build the Oracle module yourself. Alan DeKok.
On Tue, Jul 5, 2011 at 7:12 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to).
I don't understand why, because the instant client is a free tool so why not use it directly in the FreeRadius package ? It exists a Oracle package for Perl...
As Alan said, licensing issues. I don't know about perl, but php's Oracle support basically just distribute php's part of the source code. You still need to download Oracle's software separately, and compile it. The main difference between php's method and FR is that php allows you to built just a module without the need for the complete php source code. AFAIK that's not possible in FR.
What's wrong the 2.1.11 that you compiled earlier?
Two problems with 2.1.11 :
firstly, it was a mess on my server because I mixed the two versions secondly, I compile but it was not ok with Oracle (don't know why), and I am using chkconfig for configuring the services and I didn't manage start/stop/restart with the service command.
A "clean" way to do this is: - get F14's freeradius SRPM - modify the spec file so it will build oracle module - build the RPM on your box - install it to replace F14's RPM All that should be doable, but takes time. I doubt anyone will go out of their way to help you do that for free. So you have some alternatives: - wait and pray, hope someone will give you what you need - learn about how RPM works, and do it yourself (http://www.rpm.org/max-rpm/s1-rpm-build-creating-spec-file.html is a good start) - ask for quotation from professional service, and if it's within your budget, pay them (I think networkradius.com should provide the service. Ask Alan to be sure). - post a bounty with your budget and requirement, and hope someone with enough experience can take it. -- Fajar
On 07/05/2011 08:33 AM, Fajar A. Nugraha wrote:
On Tue, Jul 5, 2011 at 7:12 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to).
I don't understand why, because the instant client is a free tool so why not use it directly in the FreeRadius package ? It exists a Oracle package for Perl...
As Alan said, licensing issues.
I don't know about perl, but php's Oracle support basically just distribute php's part of the source code. You still need to download Oracle's software separately, and compile it.
The main difference between php's method and FR is that php allows you to built just a module without the need for the complete php source code. AFAIK that's not possible in FR.
What's wrong the 2.1.11 that you compiled earlier?
Two problems with 2.1.11 :
firstly, it was a mess on my server because I mixed the two versions secondly, I compile but it was not ok with Oracle (don't know why), and I am using chkconfig for configuring the services and I didn't manage start/stop/restart with the service command.
A "clean" way to do this is: - get F14's freeradius SRPM - modify the spec file so it will build oracle module - build the RPM on your box - install it to replace F14's RPM
All that should be doable, but takes time. I doubt anyone will go out of their way to help you do that for free. So you have some alternatives: - wait and pray, hope someone will give you what you need - learn about how RPM works, and do it yourself (http://www.rpm.org/max-rpm/s1-rpm-build-creating-spec-file.html is a good start) - ask for quotation from professional service, and if it's within your budget, pay them (I think networkradius.com should provide the service. Ask Alan to be sure). - post a bounty with your budget and requirement, and hope someone with enough experience can take it.
see: http://wiki.freeradius.org/Red_Hat_FAQ It explains how to build RPM's and other handy info for working with FreeRADIUS on Fedora, RHEL, and CentOS. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
Aurélien Lafranchise <aurelien_lafranchise@snype.org> writes:
I don't understand why, because the instant client is a free tool
No, it is not. The license terms are here: http://www.oracle.com/technetwork/licenses/instant-client-lic-152016.html As you can see, there are plenty of restrictions on what you can do with this software. It may be "free" in the sense that you don't have to pay any money for it, but it is not "free" in the sense that you can use it as you like. This makes it incompatible with any GPL licensed software. Bjørn
"Fajar A. Nugraha" <list@fajar.net> writes:
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to).
I don't think they can either. If they did, they would have to change their licensing terms in a way that would allow anyone else to do the same, or they would violate the FreeRADIUS license. Bjørn
I have that : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. What if I just add the rlm_sql_oracle from someone with the same version ? or if I compiled just this module ? 2011/7/5 Bjørn Mork <bjorn@mork.no>
"Fajar A. Nugraha" <list@fajar.net> writes:
Short version, you need to compile oracle support yourself. There won't be any distro ship with freeradius-oracle due to lincense issue (well, except Oracle Linux, if they want to).
I don't think they can either. If they did, they would have to change their licensing terms in a way that would allow anyone else to do the same, or they would violate the FreeRADIUS license.
Bjørn
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Aurélien Lafranchise wrote:
What if I just add the rlm_sql_oracle from someone with the same version ? or if I compiled just this module ?
You have been told repeatedly to compile the module yourself. If you're not going to read the messages on this list, then don't post questions here. Or, if you're intent on wasting everyone's time, we can all ignore you. Alan DeKok.
Here the result of my compilation : [root@crm1 rlm_sql_oracle]# ./configure --with-oracle-version=11 --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/include/oracle/11.2/client64 checking for oci.h... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed yes configure: WARNING: oracle libraries not found. Use --with-oracle-lib-dir=<path>. configure: WARNING: silently not building rlm_sql_oracle. configure: WARNING: FAILURE: rlm_sql_oracle requires: libclntsh libnnz10. configure: creating ./config.status config.status: creating Makefile I don't understand why these warnings ! and if it will compile for Oracle 11 ! 2011/7/5 Alan DeKok <aland@deployingradius.com>
Aurélien Lafranchise wrote:
What if I just add the rlm_sql_oracle from someone with the same version ? or if I compiled just this module ?
You have been told repeatedly to compile the module yourself.
If you're not going to read the messages on this list, then don't post questions here.
Or, if you're intent on wasting everyone's time, we can all ignore you.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
configure: WARNING: FAILURE: rlm_sql_oracle requires: libclntsh libnnz10.
Hmmm ... that one line by itself (without any other lines mentioning libnnz11 or libnnz9 anywhere else seems odd). Alan, could it the configure script was not updated yet? configure.in was last updated by commit 3c006dec (2011-01-18 14:57:05 +0100) while the last change to configure seems to be 36940d49 (2010-07-29 14:03:31 +0200). Aurélien, could you get autoconf (install it from F14's repository if you don't already have it) and run "autoconf" in the directory? After that, retry the configure step and see if it at least shows that it's looking for version 11. I haven't tested this, but it might work. -- Fajar
I already had this warnings but Allan told me that was normal ..... Thanks you very much Fajar ! It works. and I am happy that was not a problem from me... I manage to get the .so compilated. I putted rlm_sql_oracle-2.1.11.so in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so on a 2.1.10 ? Thanks again 2011/7/5 Fajar A. Nugraha <list@fajar.net>
On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
configure: WARNING: FAILURE: rlm_sql_oracle requires: libclntsh libnnz10.
Hmmm ... that one line by itself (without any other lines mentioning libnnz11 or libnnz9 anywhere else seems odd).
Alan, could it the configure script was not updated yet? configure.in was last updated by commit 3c006dec (2011-01-18 14:57:05 +0100) while the last change to configure seems to be 36940d49 (2010-07-29 14:03:31 +0200).
Aurélien, could you get autoconf (install it from F14's repository if you don't already have it) and run "autoconf" in the directory? After that, retry the configure step and see if it at least shows that it's looking for version 11. I haven't tested this, but it might work.
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 07/05/2011 11:02 AM, Aurélien Lafranchise wrote:
I already had this warnings but Allan told me that was normal .....
Thanks you very much Fajar ! It works. and I am happy that was not a problem from me... I manage to get the .so compilated.
I putted rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.so> in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section.
Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.so> on a 2.1.10 ?
Are the permissions and ownership correct? Try running ldconfig -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
Yes, I found the problem it was environnement variable that were no set with the user that I used ! I am finishing the debug and write a step by step explanation to make it work ! 2011/7/5 John Dennis <jdennis@redhat.com>
On 07/05/2011 11:02 AM, Aurélien Lafranchise wrote:
I already had this warnings but Allan told me that was normal .....
Thanks you very much Fajar ! It works. and I am happy that was not a problem from me... I manage to get the .so compilated.
I putted rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.**so<http://rlm_sql_oracle-2.1.11.so>
in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_**oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/**default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/**default[360]: Errors parsing accounting section.
Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.**so<http://rlm_sql_oracle-2.1.11.so>> on a 2.1.10 ?
Are the permissions and ownership correct?
Try running ldconfig
-- John Dennis <jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/
It is finally working. I send you tomorrow the process ! Thanks all ! 2011/7/5 Aurélien Lafranchise <aurelien_lafranchise@snype.org>
Yes, I found the problem it was environnement variable that were no set with the user that I used !
I am finishing the debug and write a step by step explanation to make it work !
2011/7/5 John Dennis <jdennis@redhat.com>
On 07/05/2011 11:02 AM, Aurélien Lafranchise wrote:
I already had this warnings but Allan told me that was normal .....
Thanks you very much Fajar ! It works. and I am happy that was not a problem from me... I manage to get the .so compilated.
I putted rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.**so<http://rlm_sql_oracle-2.1.11.so>
in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_**oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/**default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/**default[360]: Errors parsing accounting section.
Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so <http://rlm_sql_oracle-2.1.11.**so<http://rlm_sql_oracle-2.1.11.so>> on a 2.1.10 ?
Are the permissions and ownership correct?
Try running ldconfig
-- John Dennis <jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/
On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I putted rlm_sql_oracle-2.1.11.so in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so on a 2.1.10 ?
That's why I said earlier it's better to rebuild the RPM with modified SPEC file. One of the reasons was to avoid version and location mess. John posted an additional link earlier with more useful information. If you want to mix RPM and self-compiled module, better use it from the same version, as there might be some incompatible changes between versions. -- Fajar
Hi all, As I said, here is the step by step when using Oracle Instant Client 11 : 1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so <http://rlm_sql_oracle-2.1.11.so/> 5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64 6.1 if not put it in the /etc/init.d/radiusd file 7. Launch freeradius (radiusd -X for debug and if ok service radiusd start) Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure. Thanks all 2011/7/6 Fajar A. Nugraha <list@fajar.net>
On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I putted rlm_sql_oracle-2.1.11.so in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so on a 2.1.10 ?
That's why I said earlier it's better to rebuild the RPM with modified SPEC file. One of the reasons was to avoid version and location mess. John posted an additional link earlier with more useful information.
If you want to mix RPM and self-compiled module, better use it from the same version, as there might be some incompatible changes between versions.
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Why don't you add it to the wiki ;) -Arran On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:
Hi all,
As I said, here is the step by step when using Oracle Instant Client 11 :
1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so 5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64 6.1 if not put it in the /etc/init.d/radiusd file 7. Launch freeradius (radiusd -X for debug and if ok service radiusd start)
Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure.
Thanks all
2011/7/6 Fajar A. Nugraha <list@fajar.net> On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I putted rlm_sql_oracle-2.1.11.so in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so on a 2.1.10 ?
That's why I said earlier it's better to rebuild the RPM with modified SPEC file. One of the reasons was to avoid version and location mess. John posted an additional link earlier with more useful information.
If you want to mix RPM and self-compiled module, better use it from the same version, as there might be some incompatible changes between versions.
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Arran Cudbard-Bell a.cudbardb@freeradius.org RADIUS - Half the complexity of Diameter
I am a newbie to FreeRadius, I prefer some kind of validation/authorization before. 2011/7/6 Arran Cudbard-Bell <a.cudbardb@freeradius.org>
Why don't you add it to the wiki ;)
-Arran
On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:
Hi all,
As I said, here is the step by step when using Oracle Instant Client 11 :
1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so <http://rlm_sql_oracle-2.1.11.so/> 5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64 6.1 if not put it in the /etc/init.d/radiusd file 7. Launch freeradius (radiusd -X for debug and if ok service radiusd start)
Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure.
Thanks all
2011/7/6 Fajar A. Nugraha <list@fajar.net>
On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I putted rlm_sql_oracle-2.1.11.so in /usr/lib64/freeradius/ and create the symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so but : Could not link driver rlm_sql_oracle: file not found Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section. Could it be because I compile a 2.1.11 version and putted the rlm_sql_oracle-2.1.11.so on a 2.1.10 ?
That's why I said earlier it's better to rebuild the RPM with modified SPEC file. One of the reasons was to avoid version and location mess. John posted an additional link earlier with more useful information.
If you want to mix RPM and self-compiled module, better use it from the same version, as there might be some incompatible changes between versions.
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Arran Cudbard-Bell a.cudbardb@freeradius.org
RADIUS - Half the complexity of Diameter
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Wed, Jul 6, 2011 at 4:39 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I am a newbie to FreeRadius, I prefer some kind of validation/authorization before.
Wiki is basically a collaborative tool. I agree with Arran, just add it to the wiki. If someone else finds a wrong info somewhere, or finds that some workarounds are no longer needed, they can always edit your post later. -- Fajar
2011/7/6 Arran Cudbard-Bell <a.cudbardb@freeradius.org>
Why don't you add it to the wiki ;) -Arran On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:
Hi all, As I said, here is the step by step when using Oracle Instant Client 11 : 1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so 5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64 6.1 if not put it in the /etc/init.d/radiusd file 7. Launch freeradius (radiusd -X for debug and if ok service radiusd start) Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure. Thanks all
On Wed, Jul 6, 2011 at 4:44 PM, Fajar A. Nugraha <list@fajar.net> wrote:
On Wed, Jul 6, 2011 at 4:39 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I am a newbie to FreeRadius, I prefer some kind of validation/authorization before.
Wiki is basically a collaborative tool. I agree with Arran, just add it to the wiki. If someone else finds a wrong info somewhere, or finds that some workarounds are no longer needed, they can always edit your post later.
-- Fajar
2011/7/6 Arran Cudbard-Bell <a.cudbardb@freeradius.org>
Why don't you add it to the wiki ;) -Arran On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:
Hi all, As I said, here is the step by step when using Oracle Instant Client 11 :
... and if you're going to add it to the wiki, I think it'd be better to add "get the source for your respective freeradius version". (e.g. if you're currently using 2.1.10, then get the source of that).
1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so
the directory .libs should have both rlm_sql_oracle-2.1.11.so and rlm_sql_oracle.so, so it's easier to just use "cp -a" to copy both.
5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export
you SHOULD be able to edit configure.in, edit the line that says ORACLE_LIBDIR_SWITCH="-L${oracle_lib_dir} " and change it to ORACLE_LIBDIR_SWITCH="-L${oracle_lib_dir} -R${oracle_lib_dir} " with that, it should be able to find the needed libraries without the need for LD_LIBRARY_PATH. Of course you need to rerun autoconf, configure and friends.
ORACLE_HOME=/usr/include/oracle/11.2/client64
I really hate having to set environment variables :) Have you tested using easy connect syntax (i.e. "host[:port][/service_name]") for radius_db? You should be able to connect without having to set ORACLE_HOME -- Fajar
Added a cleaned up version here: http://wiki.freeradius.org/Rlm_sql_oracle Aurélien, edit the page to credit yourself somewhere if you want... -Arran On Jul 6, 2011, at 11:44 AM, Fajar A. Nugraha wrote:
On Wed, Jul 6, 2011 at 4:39 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
I am a newbie to FreeRadius, I prefer some kind of validation/authorization before.
Wiki is basically a collaborative tool. I agree with Arran, just add it to the wiki. If someone else finds a wrong info somewhere, or finds that some workarounds are no longer needed, they can always edit your post later.
-- Fajar
2011/7/6 Arran Cudbard-Bell <a.cudbardb@freeradius.org>
Why don't you add it to the wiki ;) -Arran On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:
Hi all, As I said, here is the step by step when using Oracle Instant Client 11 : 1. Decompress the tar file. 2. In src/modules/rlm_sql/drivers/rlm_sql_oracle : 2.1. Do "autoconf" 2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64 2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so 3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/ 4. ln -s /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so 5.1 in /etc/raddb cnfigure sql.conf 5.2 radiusd.conf(uncomment $INCLUDE sql.conf) 5.3 site-available/default uncomment linewith sql in the wanted section 5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/ 6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64 6.1 if not put it in the /etc/init.d/radiusd file 7. Launch freeradius (radiusd -X for debug and if ok service radiusd start) Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure. Thanks all
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Arran Cudbard-Bell a.cudbardb@freeradius.org RADIUS - Half the complexity of Diameter
Indeed Fajar, I submitted a patch (which Alan merged) that mofidied the configure.in to loop over the oracle version and so not be stcuk with oracle 10. I did not modified the configure script ass I though it was regenerated for each release of freeradius. Apparently this was not a good idea. is it possible to rerun autogen on the git tree to correct this? 2011/7/5 Fajar A. Nugraha <list@fajar.net>
On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise <aurelien_lafranchise@snype.org> wrote:
configure: WARNING: FAILURE: rlm_sql_oracle requires: libclntsh libnnz10.
Hmmm ... that one line by itself (without any other lines mentioning libnnz11 or libnnz9 anywhere else seems odd).
Alan, could it the configure script was not updated yet? configure.in was last updated by commit 3c006dec (2011-01-18 14:57:05 +0100) while the last change to configure seems to be 36940d49 (2010-07-29 14:03:31 +0200).
Aurélien, could you get autoconf (install it from F14's repository if you don't already have it) and run "autoconf" in the directory? After that, retry the configure step and see if it at least shows that it's looking for version 11. I haven't tested this, but it might work.
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 07/05/2011 07:13 AM, Aurélien Lafranchise wrote:
Hi all,
It might be redondant with another but slightly different.
I have installed FreeRadius thanks to yum over Fedora 14. Everything went fine and was working fine until I need to add the Oracle support to have the accounting working with on Oracle database.
When I needed LDAP support I installed the package freeradius-ldap.x86_64. Unfortunately I can't find the same for Oracle and I don't think it is already installed in the basic package.
When I configured sql.conf and activate in site-available/default the accounting sql section I get this error : /etc/raddb/sites-enabled/default[393]: Failed to load module "sql". /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section.
Could you help me to find a solution ?
We do not supply Oracle support in Fedora. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
participants (8)
-
Alan Buxey -
Alan DeKok -
Alexandre -
Arran Cudbard-Bell -
Aurélien Lafranchise -
Bjørn Mork -
Fajar A. Nugraha -
John Dennis