Hi again, Have you look at the radius.log or radwatch.log files..? There should be an oracle error message if the modules were loaded but unable to connect... >From the oracle side... try doing a client trace in the sqlnet.ora and log it... it may give you a clue why the connection failed...
Rgds -----Original Message----- From: Peter Shin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 5:12 AM To: '[EMAIL PROTECTED]' Subject: RE: Oracle module question Hi, Thanks for the reply. The oracle module would get loaded ok if I used the Oracle 9 library but no connection to the oracle database would be established. If I used the oracle 8.0.5 library, the module would not get loaded and radiusd would terminate immediately. Regards, Peter -----Original Message----- From: Bond Bonds [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 5:15 PM To: [EMAIL PROTECTED] Subject: RE: Oracle module question Hi, I'm using Oracle 8.1.7 on the same machine (Running RedHat 7.2) as Freeradius 0.4 and it's working just fine. You didn't say whether the oracle sql module was successfully loadded and linked on your system? If it doesn't, try doing `ldd lib/rlm_sql_oracle.so`. If there's an error, you need to verify that your oracle env is set up properly and you have `libclntsh.so.8.0` and `libwtc8.so` installed on your oracle libdir. The only problem I have is that the module seems unable to connect to the oracle during startup (for example, using an rc.radiusd-redhat file or daemontools). But it can be done manually (for example, typing `/bin/sh /etc/rc.d/init.d/radiusd start`) it connects smoothly. anybody can help me out here...? Tx -----Original Message----- From: Peter Shin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:15 AM To: '[EMAIL PROTECTED]' Subject: Oracle module question Hello, I am trying to get the rlm_sql_oracle working with FreeRadius 0.4. So far I can make the radiusd program running compiled with the Oracle 9 library but I am not getting any connection to Oracle database. However sqlplus works. sql_oracle.c supplied in freeradius 0.4 was written for Oracle 9. I believe so because the source used OCIEnvCreate() which was introduced in Oracle 9 and it replaces OCIInitialize() and OCIEnvInit(). I did this modification to try with Oracle 8 but when I compiled with the Oracle 8 library, the radiusd program terminated during the sql initialisation due to that it cannot load some of dependent libraries. My question: is there any one who has worked on the oracle module in freeradius? I want to know whether the module has been tested with which version of Oracle. Thanks and regards, Peter Shin OzEmail Internet - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
