[prev in list] [next in list] [prev in thread] [next in thread]
List: freeradius-users
Subject: RE: radiusd and oracle accounting [unclas]
From: "Ranner, Frank MR" <Frank.Ranner () defence ! gov ! au>
Date: 2007-01-30 3:59:13
Message-ID: 3497E314EE23D54EACE26B5CFFD896980A60EB () drnrxm01 ! drn ! mil ! au
[Download RAW message or body]
--===============1838821081==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C74423.01326016"
This is a multi-part message in MIME format.
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.or
g
[mailto:freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freer
adius.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
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR>
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Consolas;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=528083803-30012007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=528083803-30012007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=528083803-30012007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=528083803-30012007></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=528083803-30012007><FONT face=Arial
color=#0000ff size=2>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=528083803-30012007><FONT face=Arial
color=#0000ff size=2>Frank Ranner</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org
[mailto:freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org]
<B>On Behalf Of </B>Dourty, Brian R. (IATS)<BR><B>Sent:</B> Tuesday, 23
January 2007 02:41<BR><B>To:</B>
freeradius-users@lists.freeradius.org<BR><B>Subject:</B> radiusd and oracle
accounting<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal>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?<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Thanks,<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; FONT-FAMILY: Consolas">Brian
Dourty<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; FONT-FAMILY: Consolas">System Administrator - Team
Lead<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10.5pt; FONT-FAMILY: Consolas">IAT
Services<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; FONT-FAMILY: Consolas">University of Missouri -
Columbia<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; FONT-FAMILY: Consolas">573-882-1035<o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BLOCKQUOTE></BODY></HTML>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--===============1838821081==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic