Hello Alexey -

On Sat, 23 Sep 2000, Alexey A. Shavaldin wrote:
> Hello !
> 
> On Sat, 23 Sep 2000, Hugh Irvine wrote:
> 
> > Could you send us a bit more detail on your hardware and software plaforms and
> > the Radiator and database setups (in terms of what software is running on what
> > host)? Also, have you tried altering the Timeout and FailureBackoffTime
> > parameters in the AuthBy SQL clause? Normally, Radiator will wait 60 seconds
> > for a reply to an SQL query, then it will not try to reconnect for a further
> > 600 seconds (10 minutes).
> 
............
> > > 
> > > Trace 4 log:
> > > 
> > > Fri Sep 22 20:05:32 2000: ERR: do failed for 'insert into RADONLINE ( USERNAME, 
> > > REALM, NASIDENTIFIER, NASPORT,  ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> > > NASPORTTYPE, SERVICETYPE, CalledStationId, CallingStationId ) values ( 'xxxxx',
> > >  '' , 'yyy.yyy.yyy.yyy' , nvl('48',0), '0000CA86', SYSDATE, '', 'Async',
> > > 'Framed-User', '38', '' )'': SQL Timeout
> > > 
> > > Besides, I've found such a thing: Oracle refuses to shut down by command, when
> > > Radiator is running. Oracle reports: waiting for unclosed connections. When I
> > > stop Radiator, Oracle shuts down correctly.
> > > 
> > > Thirdly, when I make radpwtst test FREQUENTLY for some test user, first test
> > > works OK for Access-Request,Start and Stop, but the second, which goes right
> > > adter the first, reports OK for "Access-Request" and "Accounting Stop", but No
> > > reply for Start:
> 

It may be the case that Radiator is incorrectly interpreting errors being
reported by the database. Can you have a look at the logs prior to the SQL
Timeout shown above, to see whether there have been any other errors reported?
If so, can you please send us a copy of all of the SQL errors up to and
including the last one.

thanks

Hugh

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.



===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to