We had a system using Ciscosecure ACS that wrote the accounting records to textfiles in a directory. A perl script using Dirwatch monitored the directory and triggered a stored procedure in oracle which inserted the data. If oracle wasn't available, the data just accumulated. Once oracle was up again, the queue was processed.
 
Another solution would be to have an oracle replica on the radius box. It can continue to insert records until the main oracle DB returns, and processed the replication queue.
 
Regards,
Frank Ranner

From: freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org [mailto:freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org] On Behalf Of Dourty, Brian R. (IATS)
Sent: Tuesday, 23 January 2007 02:41
To: freeradius-users@lists.freeradius.org
Subject: radiusd and oracle accounting

We have configured our radius servers to send accounting information to an Oracle database. It works our really well except when the oraclce database server isn’t available (I.E. maintenance or cold backups). The radius process dies when it loses connectivity to the oracle server. Has anyone else noticed this problem? Any suggestions on how to make radiusd more robust and able to recover from this?

 

Thanks,

 

Brian Dourty

System Administrator - Team Lead

IAT Services

University of Missouri - Columbia

573-882-1035