2010/12/15 Александр Чурсин <achursin86@gmail.com>:
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@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_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?
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?
The logs should speak for itself. To fix this one you need to coordinate with network/dba guys. Sometimes its simply because oracle is dead or too busy to respond to anything. Other times in can be firewall issues.
Mon Dec 13 20:09:51 2010 : Error: There appears to be another RADIUS server running on the authentication port 1812
Like Ramon mentioned, you probably need to do a "kill -9" manually. -- Fajar