radiusd and oracle accounting [unclas]
Ranner, Frank MR
Frank.Ranner at defence.gov.au
Tue Jan 30 04:59:13 CET 2007
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 at lists.freeradius.or
g
[mailto:freeradius-users-bounces+frank.ranner=defence.gov.au at lists.freer
adius.org] On Behalf Of Dourty, Brian R. (IATS)
Sent: Tuesday, 23 January 2007 02:41
To: freeradius-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070130/82feafc9/attachment.html>
More information about the Freeradius-Users
mailing list