[Help-gnu-radius] Crap...sql/rad ACCOUNTING consistancy?

[Gerald]

Crap! I'm looking for consistancy in the accounting table. Auth I have
setup fine as I described below.

G

On Tue, 10 Dec 2002, Gerald wrote:

> What are the workarounds people have used to get full accounting table
> consistancy in mysql?
>
> I currently have wonderful redundancy in authentication table since there
> is one source and multiple destinations. Replication from a central mysql
> server works great.
>
> I have the radius boxes that run gnu-radius running the replicated auth-db
> to allow them to act independantly in the case of an outage. Currently the
> sqlserver file won't let you split authentication to a seperate database
> than accounting. I'm still learning our RAS equipment to see if I can
> split it there and have accounting info sent back to the central mysql
> server. (USR Total Control boxes for the curious)
>
> Another solution we are looking at is trying to run 2 instances of
> gnu-radius. One would listen on a bogus accounting port and auth off of
> local DB. The other would have a config that points accounting to the
> central accounting server and listen on the proper accounting port.
>
> Radprocess1:
>       - sqlserver points to local DB
>       - listens on 1645 and 9999 (or some bogus number)
> Radprocess2:
>       - sqlserver points to central acct db
>       - listens on 1646 (for acct) and 9998 (for auth)
>
> Does anyone have a better suggestion or examples of what I'm talking about
> doing?
>
> Thanks in advance for help. I really hope we have split DB capability in
> gnu-radius soon.
>
> Gerald
>
>
>
>
> _______________________________________________
> Help-gnu-radius mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/help-gnu-radius
>