Hello Steve -
It may be useful to define a seperate Handler for "adm" so this doesn't happen. regards Hugh On Wed, 17 Apr 2002 09:13, Steve Brown wrote: > Interesting thing happened today. When I enable <Log EMERALD> and the > following ERR comes up: > > Tue Apr 16 13:55:41 2002: ERR: do failed for 'update ServerPorts set > Username='adm', AcctSessionId='adm15375', AcctStatusType= case 'Start' > wh > en 'Start' then 1 when 'Stop' then 2 else 3 end, CallDate=getdate(), > FramedAddress='', CallerId='', ConnectInfo='', ConnectionSpeed='', > Modula > tionType='', ModemTrainingTime=, ChassisCallSlot=, ChassisCallChannel=, > DisconnectReason='', AccountTermCause='' where ServerID=(select Server > ID from Servers where IPAddress='AAA.BBB.CCC.DDD') and Port=0': > > It proceeds to try to log (via Perl, FreeTDS, SyBase) - then the insert > fails, so it logs that. The problem appears to be a failed insert > returns more data, and then it tries logging the error via Log EMERALD, > which returns even more data, then it tries to log that, and so on and > so on and so on . until you kill -9 the server before it chews up all > your RAM and slams the box to a halt. > > I think it has something to do with the single quotes. > > BTW, that ERR is perfectly acceptable - the AcctSQLStatement works just > fine when someone dials in, it is only a problem when adm logs into the > console which I don't care about (well, I do . but oh well) > > Steve -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
