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