FreeRadius and SQL/ORACLE
Hello, I have successfully connected to Oracle from FreeRadius but it seems that I am unable to return the correct data to FreeRadius. I am getting the correct logs until I make an request from the client. Here is a snippet of the output after I make a request using the Radtest app. I have the user 'adam' in the oracle database in both the radreply and the radcheck tables and my oracle user has the correct privileges. What other information must I store in order for the requests to exchange correctly. The 'rlm_sql: failed after reconnect' below, is from the rlm_sql_select_query call. Also I built FreeRadius with Threads and Thread pool enabled. Thanks. rad_recv: Access-Request packet from host 10.11.10.24:32871, id=209, length=54 User-Name = adam User-Password = '2cH\257\246\002\341!Z\300\341\263\314\240 NAS-IP-Address = 255.255.255.255 NAS-Port-Id = 10 modcall: entering group authorize modcall[authorize]: module preprocess returns ok radius_xlat: 'adam' sql_set_user: escaped user -- 'adam' radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'adam' ORDER BY id' rlm_sql: Reserving sql socket id: 4 SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'adam' ORDER BY id rlm_sql: Attempting to connect #4 rlm_sql: Connected new DB handle, #4 SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'adam' ORDER BY id rlm_sql: failed after re-connect rlm_sql_getvpdata: database query error rlm_sql: SQL query error; rejecting user rlm_sql: Released sql socket id: 4 modcall[authorize]: module sql returns fail modcall: group authorize returns fail There was no response configured: rejecting request 0 Server rejecting request 0. Finished request 0 Going to the next request -- Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
sql.conf and oracle
Hello, I am having trouble getting freeRadius to connect to oracle. In sql.conf the 'server' is the host name that the oracle database is running on, the 'login' and 'password' are to log onto the host. Is 'radius_db' the radius database name or the global database name? Is this correct? Does FreeRadius then use the host login name to connect to the database? The error that I am getting is that logon to the oracle database fails with: 'Error while trying to retrieve text for error ORA-12154 ', but I can connect using sqlplus and I can see that the TNS listener is running correctly for my database. I have run the netmgr oracle program to setup oracle to use radius. Any help would be appreciated. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
configuration/runtime issues with Oracle and FreeRadius
Hello, I have successfully built freeradius 0.7 with rlm_sql_oracle however I get an error during runtime about a relocation error. It is my understanding that relocation errors occur when you install something more than once and the program is reading the wrong library although I have only installed oracle once. Has anyone else had a similar problem? ./radiusd -x Starting - reading configuration files ... Module: Loaded System Module: Instantiated unix (unix) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded SQL rlm_sql: Driver rlm_sql_oracle loaded and linked rlm_sql: Attempting to connect to oracle@doom1:/somadb rlm_sql: starting 0 rlm_sql: Attempting to connect #0 ./radiusd: relocation error: /usr/local/lib/rlm_sql_oracle.so.0: undefined symbol: OCIEnvCreate - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: configuration/runtime issues with Oracle and FreeRadius
I am using Oracle 9.i, so I don't think that this is the problem. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
configuration/runtime issues with Oracle and FreeRadius
Thanks Josh, I think in my last response I misread your post, but it seems to be working now. Thank you for your help. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius configuration with Oracle, (continued)
Hello, I have the following configuration settings and I am still unable to build freeRadius with the rlm_sql_oracle sub module. Has freeRadius 0.7 ever been tested with Oracle 9.i? ./configure --prefix=/usr --with-logdir=/var/log --with-radacctdir=/var/log/radacct --with-raddbdir=/etc/raddb --with-rlm_sql --with-rlm_sql_oracle --with-oracle-home-dir=/export/home/oracle/OraHome1 --with-experimental-modules --with-snmp --without-rlm_x99_token This is the correct oracle home directory but I get output after this call saying the the headers cannot be found. Any ideas? Adam - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius configuration with Oracle, (continued)
I think that my problem goes a little deeper than that as I am pretty sure that I am missing some libraries. Here is a snippet of the warnings that I receive from running configure. configure: warning: snmpget not found - Simultaneous-Use and checkrad.pl may not work configure: warning: snmpwalk not found - Simultaneous-Use and checkrad.pl may not work /export/freeradius/freeradius-0.7/missing: Unknown `--run' option Try `/export/freeradius/freeradius-0.7/missing --help' for more information configure: warning: `missing' script is too old or missing configure: warning: silently not building rlm_krb5. configure: warning: FAILURE: rlm_krb5 requires: krb5. configure: warning: silently not building rlm_sql_postgresql. configure: warning: FAILURE: rlm_sql_postgresql requires: libpq-fe.h libpq. configure: warning: freetds headers not found. Use --with-freetds-include-dir=path. configure: warning: sql submodule 'freetds' disabled configure: warning: oracle headers not found. Use --with-oracle-home-dir=path. configure: warning: sql submodule 'oracle' disabled configure: warning: iodbc headers not found. Use --with-iodbc-include-dir=path. configure: warning: sql submodule 'iodbc' disabled configure: warning: mysql headers not found. Use --with-mysql-include-dir=path. configure: warning: sql submodule 'mysql' disabled configure: warning: ibm db2 headers not found. Use --with-ibmdb2-include-dir=path. configure: warning: sql submodule 'db2' disabled configure: warning: unixODBC headers not found. Use --with-unixodbc-include-dir=path. configure: warning: sql submodule 'unixodbc' disabled configure: warning: silently not building rlm_sql_postgresql. configure: warning: FAILURE: rlm_sql_postgresql requires: libpq-fe.h libpq. configure: warning: freetds headers not found. Use --with-freetds-include-dir=path. configure: warning: sql submodule 'freetds' disabled configure: warning: oracle headers not found. Use --with-oracle-home-dir=path. configure: warning: sql submodule 'oracle' disabled configure: warning: iodbc headers not found. Use --with-iodbc-include-dir=path. configure: warning: sql submodule 'iodbc' disabled configure: warning: mysql headers not found. Use --with-mysql-include-dir=path. configure: warning: sql submodule 'mysql' disabled configure: warning: ibm db2 headers not found. Use --with-ibmdb2-include-dir=path. configure: warning: sql submodule 'db2' disabled configure: warning: unixODBC headers not found. Use --with-unixodbc-include-dir=path. configure: warning: sql submodule 'unixodbc' disabled what do I have to setup prior to running running ./configure? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius configuration with Oracle
Hello, I'm trying to setup freeRadius to use Oracle for Authentication and Authorization. I'm currently running into a problem where when I run radiusd I get the following error. rlm_sql: Could not link driver rlm_sql_oracle: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[12]: sql: Module instantiation failed. I get the error because I don't think that I setup my configurations properly for the build. Is there anyone that knows how to do this? I read the FAQ and the mailing list archives and noone has seemed to post a solution to this. Is there any other documentation that I can get that will provide a solution to seting up FreeRadius with Oracle? Thanks. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: running freeRadius server and Clients on the same machine
I am new to freeRadius and I remember reading that when you run the server and client on the same machine it does not broadcast the requests over the network. I don't think any broadcast packets are involved, ever. I suspect your terminology is a bit off; do you mean send requests over the network? Yes, this is what I meant. If the client and server are running on the same machine, do the requests get sent over the network? Thanks. Does it used named pipes to communicate? No, it can be/is configured to use the loopback network device. -- Regards, Daryl Tester, Software Wrangler and Bit Herder, IOCANE Pty. Ltd. Security Alert: Your Computer Is Currently Broadcasting An Internet IP Address. With This Address, Someone Can Immediately Begin Attacking Your Computer! -- One Of Those Profound Dialog Box Adverts. - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
running freeRadius server and Clients on the same machine
Hello, I am new to freeRadius and I remember reading that when you run the server and client on the same machine it does not broadcast the requests over the network. Does it used named pipes to communicate? Thanks. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html