Sorry, no idea about Oracle, but:
Mon Dec 13 20:09:51 2010 : Error: There appears to be another RADIUS server running on the authentication port 1812 Seems the radius proces is still running, so does not stops properly. Maybe the former rasiusd process was hanged. Do an <xx>radius stop & look via "ps -eaf |grep -ie radius" if still appears, kill it by hand. Restart radius. Hope it helps a bit. -----Original Message----- From: freeradius-users-bounces+escriba=cells...@lists.freeradius.org [mailto:freeradius-users-bounces+escriba=cells...@lists.freeradius.org] On Behalf Of ????????? ?????? Sent: miércoles, 15 de diciembre de 2010 9:06 To: freeradius-users@lists.freeradius.org Subject: FreeRADIUS - no service! Hi to all! We have an issue with a FreeRADIUS server (FreeRADIUS server and Oracle Database). Sometimes it fails and stops to process the AAA requests (only complete server reboot helps)! Here is the log output during the time of a failed situation: [r...@aaa0 ~]# tailf /usr/local/var/log/radius/radius.log Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: Oracle logon failed: 'rlm_sql_oracle: no connection to db' Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct) in sql_accounting: stop packet with zero session length. [user 'mobile', nas '10.115.66.5'] Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct) in sql_accounting: stop packet with zero session length. [user 'mobile', nas '10.115.66.5'] Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: Oracle logon failed: '(null)' Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): Failed to connect DB handle #7 Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): reconnect failed, database down? Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): Couldn't insert SQL accounting START record - rlm_sql_oracle: no connection to db Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct) in sql_accounting: stop packet with zero session length. [user 'mobile', nas '10.115.66.5'] Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: execute query failed in sql_query: ORA-00001: unique constraint (RADIUS.ACCT_IDX1) violated Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: Oracle logon failed: 'rlm_sql_oracle: no connection to db' [r...@aaa0 ~]# [r...@aaa0 ~]# /etc/init.d/rc.radiusd restart Starting FreeRADIUS:Mon Dec 13 20:09:51 2010 : Info: Starting - reading configuration files ... radiusd [r...@aaa0 ~]# tailf /usr/local/var/log/radius/radius.log Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct) in sql_accounting: stop packet with zero session length. [user 'mobile', nas '10.115.66.5'] Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: Oracle logon failed: '(null)' Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): Failed to connect DB handle #7 Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): reconnect failed, database down? Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct): Couldn't insert SQL accounting START record - rlm_sql_oracle: no connection to db Mon Dec 13 19:25:12 2010 : Error: rlm_sql (sqlacct) in sql_accounting: stop packet with zero session length. [user 'mobile', nas '10.115.66.5'] Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: execute query failed in sql_query: ORA-00001: unique constraint (RADIUS.ACCT_IDX1) violated Mon Dec 13 19:25:12 2010 : Error: rlm_sql_oracle: Oracle logon failed: 'rlm_sql_oracle: no connection to db' Mon Dec 13 20:09:51 2010 : Info: Using deprecated naslist file. Support for this will go away soon. Mon Dec 13 20:09:51 2010 : Error: There appears to be another RADIUS server running on the authentication port 1812 [r...@aaa0 ~]# reboot Please, advise what can be the reason of such negative behaviour of the RADIUS server? Why does it lose connection to a db? How can we troubleshoot the issue further? Alexander - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
