Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 l...@fajar.net On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise aurelien_lafranch...@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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 l...@fajar.net On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise aurelien_lafranch...@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.cudba...@freeradius.org RADIUS - Half the complexity of Diameter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
I am a newbie to FreeRadius, I prefer some kind of validation/authorization before. 2011/7/6 Arran Cudbard-Bell a.cudba...@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 l...@fajar.net On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise aurelien_lafranch...@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.cudba...@freeradius.org RADIUS - Half the complexity of Diameter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On Wed, Jul 6, 2011 at 4:39 PM, Aurélien Lafranchise aurelien_lafranch...@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.cudba...@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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On Wed, Jul 6, 2011 at 4:44 PM, Fajar A. Nugraha l...@fajar.net wrote: On Wed, Jul 6, 2011 at 4:39 PM, Aurélien Lafranchise aurelien_lafranch...@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.cudba...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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_lafranch...@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.cudba...@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.cudba...@freeradius.org RADIUS - Half the complexity of Diameter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 failsso 'sql' will die in any virtual server) alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On Tue, Jul 5, 2011 at 6:13 PM, Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
2011/7/5 Fajar A. Nugraha l...@fajar.net On Tue, Jul 5, 2011 at 6:13 PM, Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On Tue, Jul 5, 2011 at 7:12 PM, Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 al...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
Fajar A. Nugraha l...@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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 bj...@mork.no Fajar A. Nugraha l...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 al...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise aurelien_lafranch...@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
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 l...@fajar.net On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
On 07/05/2011 08:33 AM, Fajar A. Nugraha wrote: On Tue, Jul 5, 2011 at 7:12 PM, Aurélien Lafranchise aurelien_lafranch...@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 jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 jden...@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.**sohttp://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.**sohttp://rlm_sql_oracle-2.1.11.so on a 2.1.10 ? Are the permissions and ownership correct? Try running ldconfig -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
It is finally working. I send you tomorrow the process ! Thanks all ! 2011/7/5 Aurélien Lafranchise aurelien_lafranch...@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 jden...@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.**sohttp://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.**sohttp://rlm_sql_oracle-2.1.11.so on a 2.1.10 ? Are the permissions and ownership correct? Try running ldconfig -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius 2.1.10 with Oracle support under Fedora 14
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 l...@fajar.net On Tue, Jul 5, 2011 at 9:05 PM, Aurélien Lafranchise aurelien_lafranch...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html