Primary, Secondary, Radrelay, Mysql Problem

[Jeff]

I kinda see whats going on  
User connects to primary  
Radrelay then sends accounting data to secondary  
Thus user shows up online in both databases  
Then radrelay on secondary sends accounting info back to the primary  
Thus creating a double entry in mysql in the primary  
   
Am I right?  
If so is the solution just not running radrelay on the primary?  
 
      _____  

  From: Jeff [mailto:jeffa at jahelpdesk.com]
To: FreeRadius users mailing list [mailto:freeradius-users at lists.freeradius.org]
Sent: Wed, 20 Jun 2007 10:52:01 -0400
Subject: Primary, Secondary, Radrelay, Mysql Problem

I am doing the following and have an issue
Issue is on the primary I get duplicate entry on accounting in mysql for a user
I don't use this accounting for nothing but users online listing, I have to use accounting from the detail file for that.

Ok heres the expanation
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.

Primary Server (Freeradius 1.16)
I have radrelay configured to push accounting detail to the secondary freeradius server
I also have mysql setup on that server with accounting going into it to be able to see users online for that server 

Secondary Server (Freeradius 1.16)
I have radrelay configured to push accounting detail to the primary freeradius server
I also have mysql setup on that server with accounting going into it to be able to see users online for that server 

Heres what happens
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

On Primary Server, I get a duplicate entry for start and duplicate entry for stop
and thus also show the user online twice.

I am not sure what to do.
Bascially what i was tyring to have here is
A primary and secondary radius, with the detail file combined and in sync for purpose of the reasons.
1. To input on detail file into the billing program
2. To make sure it was showing users logged on.

I didn't setup radsqlrelay didn't think that was necesaary, and mabe I am going about this wrong.

ANy suggestions?

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
      
   
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070620/b64d8614/attachment.html>