Hi,
We are using two radiators working simultaneously, and AuthBy SQL authentication.
We have some troubles with SQL Timeout Problem.
The Error Logs are as below:
1. Error Log of 1st Radiator
Sun Jun 25 13:31:13 2000: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='213.186.130.66' and NASPORT=090': SQL Timeout
2. Error Log of 2nd Radiator
Sun Jun 25 13:33:07 2000: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='213.186.130.66' and NASPORT=090': SQL Timeout
Could you please explain the conditions and the behaviour of Radiator, when Radiator sends these error messages.
We guess, this problem occurs because of the SNMP query in one way or another, but it is not ceratin.
The cause of the problem can also be a deadlock in SQL or something else.
Now I need to know, when the users connection is checked by the SNMP Query.
Below is a part of Trace 4 log. Where is the right location of the SNMP query
in this sequence?
And it is also not clear, why the users session is deleted before a SELECT query is made on the RADONLINE table.
....
Sun Jun 25 17:47:27 2000: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sun Jun 25 17:47:27 2000: DEBUG: Rewrote user name to onurmersinlioglu
Sun Jun 25 17:47:27 2000: DEBUG: Deleting session for onurmersinlioglu, 213.186.131.66, 198
Sun Jun 25 17:47:27 2000: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='213.186.131.66' and NASPORT=0198
Sun Jun 25 17:47:27 2000: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE where USERNAME='onurmersinlioglu'
Sun Jun 25 17:47:27 2000: DEBUG: Handling with Radius::AuthSQL
Sun Jun 25 17:47:27 2000: DEBUG: Handling with Radius::AuthSQL
Sun Jun 25 17:47:27 2000: DEBUG: Query is: select PASSWORD,CHECKATTR,REPLYATTR || SESSIONFILTER || SESSIONFILTERVALUE || to_char(nvl(TOTALSESSION,2592000)) from SUBSCRIBERS,SESSIONFILTERS where USERNAME='onurmersinlioglu' AND (to_date(to_char(EXPIREDATE,'dd.mm.yyyy'),'dd.mm.yyyy') >=to_date(to_char(SYSDATE,'dd.mm.yyyy'),'dd.mm.yyyy') OR EXPIREDATE IS NULL) AND subscribers.SESSIONFILTERID = sessionfilters.SESSIONFILTERID
.....
