FreeRADIUS - no service!

[Ramon Escriba]

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.es at lists.freeradius.org
[mailto:freeradius-users-bounces+escriba=cells.es at lists.freeradius.org] On
Behalf Of ????????? ??????
Sent: miércoles, 15 de diciembre de 2010 9:06
To: freeradius-users at 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:

[root at 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'


[root at aaa0 ~]#
[root at aaa0 ~]# /etc/init.d/rc.radiusd restart Starting FreeRADIUS:Mon Dec 13
20:09:51 2010 : Info: Starting - reading configuration files ...
radiusd
[root at 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

[root at 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