Thanks.. Will try it out...

Do I need to make any addition/changes in Makefile to compile radsqlrelay...? If yes... What changes is needed..

thanks..

--haizam

----- Original Message ----- From: "Nicolas Baradakis" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, January 24, 2005 19:16
Subject: Re: SQL db failover



Rohaizam Abu Bakar wrote:

How can we possible do to ensure only when sql1 down.. then the accounting
will be sent to sql2..??

You might try a different approach: - store accounting in "detail" files (man rlm_detail) - run radsqlrelay to send accounting in the database (get it from a CVS snapshot)

Even if the SQL server is down for a day, radsqlrelay will buffer the
accounting packets and send them later.

The advantages:
 - all accounting go in a single database (it's easier to check
   simultaneous login)
 - even under high load radsqlrelay still sends accounting requests
   according to the SQL server's capabilities
 - you won't have a lot of outstanding requests on the RADIUS sever
   when the SQL server is slow

--
Nicolas Baradakis

-
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