Primary, Secondary, Radrelay, Mysql Problem

Jeff jeffa at jahelpdesk.com
Wed Jun 20 16:52:01 CEST 2007


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?




More information about the Freeradius-Users mailing list