tnt-4 wrote:
I'm not using copy-acct-to-home-server yet. I have another question. Can copy-acct-to-home-server still help me to sync DBs if the 2 radius servers are online but one of them losses its connectivity with the DB ?
No. But then authentication will fail too. I am not sure if buffered-sql virtual server will queue requests when sql connection fails.
You might want to look at setting up robust proxy accounting (also in raddb/sites-available) which uses new features and requires bit more setting up.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I don't use authentication. I'll give you the full description of my system and maybe you think of a solution without modifying the source code: A client sends only Accounting Start Requests(the same request for the 2 servers) to my 2 radius servers (geographically separated). The requests are send to separate DBs. I need to sync the DBs in the following situations: 1. one radius server goes down. on restart the DBs must sync 2. one servers loses connectivity to its DB. when the connection is reestablished the DBs must sync. I thought it could be possible to execute a stored procedure on these 2 cases. ( upon restart and upon reestablishing the connection). -- View this message in context: http://www.nabble.com/SQL-Query-question-tp19992564p19995681.html Sent from the FreeRadius - User mailing list archive at Nabble.com.