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