(RADIATOR) radiusd re-start so often

Fri May 10 10:00:48 CDT 2002

 Hi Patrick,

 We are using DBD::Sybase || DBI:Freetds... no other thing... and my SQL is also win2k
 Freetds version is 0.53 and we are using the queries I wrote into the radius config like:

AddQuery insert into AAA_SESSIONTABLEWR (USERNAME, NASIDENTIFIER, NASPORT, \
ACCTSESSIONID, TIME_STAMP, TIME_TODATE,FRAMEDIPADDRESS, NASPORTTYPE, \
SERVICETYPE, DNIS, REALM, CLASS) values ('%U', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}',\
%{Timestamp}, '%f.%g.%i %j:%k:%p', '%{Framed-IP-Address}', '%{NAS-Port-Type}', \
'%{Service-Type}', '%{Called-Station-Id}', '%R', '%{Class}')

DeleteQuery delete from AAA_SESSIONTABLEWR where NASIDENTIFIER='%N' and NASPORT=0%{NAS-Port}
ClearNasQuery delete from AAA_SESSIONTABLEWR where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from AAA_SESSIONTABLEWR where USERNAME='%U' and REALM='%R'

Utku.

  ----- Original Message ----- 
  From: Patrick Muldoon 
  To: 'Utku Er' 
  Cc: radiator at open.com.au 
  Sent: Friday, May 10, 2002 5:35 PM
  Subject: RE: (RADIATOR) radiusd re-start so often

  Hmm

  We have radiator 3.0 Running on FreeBSD-4.5 Using FreeTDS to connect to
  M$ SQL Server 2k running On Win2k.  And we have never had a problem. 

  What version of FreeTDS are you using?  
  Are you using DBD::Sybase || DBD::Freetds || Something else 

  We use DBD::Sybase to connect on ours.

  Are you using Stored procedures or queries to the db?

  -Patrick  

  --
  Patrick Muldoon, Network/Software Engineer
  INOC, LLC
  doon at inoc.net

  Your mouse has moved. Windows NT must be restarted for the change to
  take effect. Reboot now? [ OK ]

  -----Original Message-----
  From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
  Behalf Of Utku Er
  Sent: Friday, May 10, 2002 9:59 AM
  To: hugh at open.com.au; Huaikun Lin; radiator at open.com.au
  Cc: Mehmet Ugursoy
  Subject: Re: (RADIATOR) radiusd re-start so often

  I have nearly the same problem... I am using radiator 3.0 on linux
  2.4.7-10, redhat 7.2 with freetds to connect to SQL database on
  win2000.. It works fine but it goes down without any error
  messages... 20-30 times a day. I have trace 4 open in my config. I see
  every kind of packet coming and going but it does not write anything to
  the log before it goes down... I wrote a script to restart it AND it
  mails me the latest 100 lines of log before it starts it again... I
  search every one of that mails and I see it only get stuck with the SQL
  queries... I debug also the SQL and see some requests are delayed for 1
  (max 1.4) seconds... 

  I am suspecting this: my radiator makes 2-3 (sometimes more of
  course) sql requests per second. and there are also cgi scripts for the
  call center people for the auth test and session database and see
  accounting on the same machine... When SQL database fails to respond in
  1 second, radiator receives 2-4 more requests... Then the process is
  dead... so this may be a buffer problem? how many packets can radiator
  can handle within its buffer ?

  I can send the configs and tail -100 of trace4 log for all the radiator
  death incidence.. but it wont help because there is only a sql query as
  the last line ;-)

  what do you think?
  thanks in advance...

  Utku Er
  Technical Manager
  NetOne - http://www.netone.com.tr
  Phone: +90 212 3551700
  Fax: +90 212 216 5566
  ----- Original Message ----- 
  From: Hugh Irvine 
  To: Huaikun Lin ; radiator at open.com.au 
  Sent: Friday, May 10, 2002 8:19 AM
  Subject: Re: (RADIATOR) radiusd re-start so often

  Hello Lin -

  You should check a trace 4 debug from Radiator and the error message as 
  reported by restartWrapper to find out what the problem is.

  If you still have trouble, please send me a copy of your configuration
  file 
  together with the trace 4 and error messages mentioned above. I will
  also 
  need to know what version of Radiator you are running, and what 
  hardware/software platform you are using.

  regards

  Hugh

  On Fri, 10 May 2002 12:29, Huaikun Lin wrote:
  > Hi
  >
  > Just notice my radiusd restart about every 20 minutes br radius
  Wrapper.
  >
  > Does anyone has similar experience?
  >
  > Any fix to this?
  >
  > Lin
  >
  > ===
  > Archive at http://www.open.com.au/archives/radiator/
  > Announcements on radiator-announce at open.com.au
  > To unsubscribe, email 'majordomo at open.com.au' with
  > 'unsubscribe radiator' in the body of the message.

  -- 
  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 radiator-announce at open.com.au
  To unsubscribe, email 'majordomo at open.com.au' with
  'unsubscribe radiator' in the body of the message.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020510/cabaa028/attachment.html>