<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html;charset=us-ascii'>
<style>BODY{font:10pt Tahoma, Verdana, sans-serif;}</style>
</head>
<body>
<DIV>I kinda see whats going on</DIV>
<DIV>User connects to primary</DIV>
<DIV>Radrelay then sends accounting data to secondary</DIV>
<DIV>Thus user shows up online in both databases</DIV>
<DIV>Then radrelay on secondary sends accounting info back to the primary</DIV>
<DIV>Thus creating a double entry in mysql in the primary</DIV>
<DIV> </DIV>
<DIV>Am I right?</DIV>
<DIV>If so is the solution just not running radrelay on the primary?</DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<HR>
<B>From:</B> Jeff [mailto:jeffa@jahelpdesk.com]<BR><B>To:</B> FreeRadius users mailing list [mailto:freeradius-users@lists.freeradius.org]<BR><B>Sent:</B> Wed, 20 Jun 2007 10:52:01 -0400<BR><B>Subject:</B> Primary, Secondary, Radrelay, Mysql Problem<BR><BR>I am doing the following and have an issue<BR>Issue is on the primary I get duplicate entry on accounting in mysql for a user<BR>I don't use this accounting for nothing but users online listing, I have to use accounting from the detail file for that.<BR><BR>Ok heres the expanation<BR>I use radrelay so each radius accounting will be in sync (I need detail file for accounting) the billing package we have won't read the sql data.<BR><BR>Primary Server (Freeradius 1.16)<BR>I have radrelay configured to push accounting detail to the secondary freeradius server<BR>I also have mysql setup on that server with accounting going into it to be able to see users online for that server <BR><BR>Secondary Server (Freeradius 1.16)<BR>I have radrelay configured to push accounting detail to the primary freeradius server<BR>I also have mysql setup on that server with accounting going into it to be able to see users online for that server <BR><BR>Heres what happens<BR>On the secondary server in mysql radacct table i get on entry for start and stop on a client, as it should be showing i user online<BR><BR>On Primary Server, I get a duplicate entry for start and duplicate entry for stop<BR>and thus also show the user online twice.<BR><BR>I am not sure what to do.<BR>Bascially what i was tyring to have here is<BR>A primary and secondary radius, with the detail file combined and in sync for purpose of the reasons.<BR>1. To input on detail file into the billing program<BR>2. To make sure it was showing users logged on.<BR><BR>I didn't setup radsqlrelay didn't think that was necesaary, and mabe I am going about this wrong.<BR><BR>ANy suggestions?<BR><BR>- <BR>List info/subscribe/unsubscribe? See <A href="http://www.freeradius.org/list/users.html" target=_blank>http://www.freeradius.org/list/users.html</A><BR></BLOCKQUOTE>
<STYLE>
</STYLE>
<DIV> </DIV>
<DIV> </DIV></body></html>