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:[EMAIL PROTECTED]
To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED]
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
      
   
 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to