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 -----
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 [EMAIL PROTECTED]
Your mouse has moved.
Windows NT must be restarted for the change to take effect. Reboot now? [
OK ]
-----Original Message----- From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Utku Er Sent: Friday,
May 10, 2002 9:59 AM To: [EMAIL PROTECTED]; Huaikun Lin; [EMAIL PROTECTED] 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 ; [EMAIL PROTECTED] 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 [EMAIL PROTECTED] >
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To
unsubscribe, email '[EMAIL PROTECTED]'
with 'unsubscribe radiator' in the body of the
message.
|