<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</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 link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi everyone,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>we are having an issue on our FreeRadius setup where our redundant servers will maybe once, twice a day create duplicate accounting entries.<o:p></o:p></p><p class=MsoNormal>I have switched the servers to debug for a full day and caught one of these incidents in the log file, see attached.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The strange thing is it only happens maybe once a day, regardless of realm or user, and the other couple of hundred accounting requests are fine.<o:p></o:p></p><p class=MsoNormal>Can anyone see why this particular one would bounce back and forth?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Our setup consists of two virtually identical FreeRadius2 servers, each with their own mySQL database, so each of them is capable of doing Auth and Acct, and proxies Acct to the other one.<o:p></o:p></p><p class=MsoNormal>Also I changed the acct_update_alt query to write to a failover table since I thought this was the alt query being triggered, but this does not make a difference. Still duplicates in radacct table.<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>Marius<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><i><span style='font-size:10.0pt'>__________________________________________</span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><b><i><span style='color:blue;background:yellow'>Marius Pesé<br></span></i></b><i><span style='font-size:10.0pt;color:blue'>Senior Software Developer</span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><i><span style='font-size:10.0pt;color:blue'>B.Sc. Computer Science</span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><a href="http://www.mindspring.co.za/"><i><span style='font-size:10.0pt;color:blue;text-decoration:none'><img border=0 width=240 height=57 id="Picture_x0020_1" src="cid:image003.jpg@01CBF85B.77F8AF50" alt="Mindspring_tiny_logo"></span></i></a><i><span style='font-size:10.0pt;color:blue'> </span></i><i><span style='font-size:10.0pt;color:black'> </span></i><i><span style='font-size:10.0pt;color:black'><br></span></i><i><span style='font-size:10.0pt;color:blue'>Unit 5, Doncaster Office Park</span></i><i><span style='font-size:10.0pt;color:black'> </span></i><i><span style='font-size:10.0pt;color:#1F497D'>Mindspring Computing</span></i><i><span style='font-size:10.0pt;color:black'> </span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><i><span style='font-size:10.0pt;color:blue'>Punters Way, Kenilworth </span></i><i><span style='font-size:10.0pt;color:#1F497D'>P O Box 46926</span></i><i><span style='font-size:10.0pt;color:blue'> </span></i><i><span style='font-size:10.0pt;color:maroon'> </span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><i><span style='font-size:10.0pt;color:blue'>Cape Town, South Africa </span></i><i><span style='font-size:10.0pt;color:#1F497D'>Glosderry 7702</span></i><i><span style='font-size:10.0pt;color:blue'> </span></i><i><span style='font-size:10.0pt;color:blue'><br></span></i><i><span style='font-size:10.0pt;color:black'>Phone:</span></i><i><span style='font-size:10.0pt;color:blue'> +27 21 657 1780 </span></i><i><span style='font-size:10.0pt;color:black'>Fax </span></i><i><span style='font-size:10.0pt;color:blue'>: +27 21 671 7599</span></i><i><span style='font-size:10.0pt;color:blue'><o:p></o:p></span></i></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><i><span style='font-size:10.0pt;color:black'>Cell :</span></i><i><span style='font-size:10.0pt;color:blue'> 072 100 70 73</span></i><i><span style='font-size:10.0pt;color:black'><br>E-mail:</span></i><i><span style='font-size:10.0pt;color:blue'> <a href="mailto:marius@mindspring.co.za">marius@mindspring.co.za</a></span></i><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>