Re: SQL Query question

: maximum 30 requests/second. I'm now thinking of altering the code so that when the connection to the DB is reestablished a stored procedure( named SYNC_DB) will be launched. Does anyone know which files I have to modify ? -- View this message in context: http://www.nabble.com/SQL-Query-question

Re: SQL Query question

connectivity with the DB ? Thanks -- View this message in context: http://www.nabble.com/SQL-Query-question-tp19992564p19993704.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: SQL Query question

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

Re: SQL Query question

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. - List

Re: SQL Query question

I'm using 2 Freeradius 2.0.5 servers for writting Accounting Requests into separate Oracle DBs (one for each server ). let's say one of the servers stops. On restart I need the radius server to execute a stored procedure that will syncronize the DBs. Why? Are you using copy-acct-to-home-server

SQL Query question

this procedure without any accounting requests coming in ? -- View this message in context: http://www.nabble.com/SQL-Query-question-tp19992564p19992564.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list

Re: SQL Query question

Hi, No. But then authentication will fail too. I am not sure if buffered-sql virtual server will queue requests when sql connection fails. ...it does do here - the file just grows and grows until it can start putting things away again. You might want to look at setting up robust proxy

Re: SQL Query question

I don't use authentication. I hope this means I don't use radius 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