No subject
Tue Jun 24 01:23:20 CDT 2008
html
Attribute NAS-Identifier and NAS-Port must unique.
Here are my questions:
1) I don't understand why these two attributes are used for default key,
even though we can define our own DeleteQuery,AddQuery,CountQuery.
2) Is it possible to release the 'unique' requirement
3) If the answer of (2) is not, how about using other attributes such as
Account-Session-Id or Framed-IP-Address
Regards,
Harrison
Tue Mar 9 14:10:52 2004 377905: DEBUG: Handling request with Handler
'Client-Id=/202.140.93.(11|12)/,Called-Station-Id=/(smartone)/,NAS-IP-Addres
s=10.32.16.1'
Tue Mar 9 14:10:52 2004 382082: DEBUG: SessionDatabaseA Adding session for
, 10.32.16.1, 1
Tue Mar 9 14:10:52 2004 383821: DEBUG: do query is: 'delete from RADONLINE
where NASIDENTIFIER='smartone' and ACCTSESSIONID='00000002543992' and
FRAMEDIPADDRESS='10.32.20.157'':
Tue Mar 9 14:10:52 2004 386700: DEBUG: do query is: 'insert into RADONLINE
(USERNAME,CALLINGSTATIONID,NASIDENTIFIER,
ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values
('','85291399096','smartone', '00000002543992',1078812652,'10.32.20.157')':
Tue Mar 9 14:10:52 2004 388700: ERR: do failed for 'insert into RADONLINE
(USERNAME,CALLINGSTATIONID,NASIDENTIFIER,
ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values
('','85291399096','smartone', '00000002543992',1078812652,'10.32.20.157')':
Duplicate entry 'smartone-0' for key 1
Tue Mar 9 14:10:52 2004 389810: DEBUG: Handling with Radius::AuthFILE:
defaultaccept
Tue Mar 9 14:10:52 2004 390911: DEBUG: Accounting accepted
------_=_NextPart_001_01C405A4.8A53A710
Content-Type: text/html;
charset="big5"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dbig5">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>SessionDatabaseSQL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2>We want to use SessionDatabaseSQL for controlling =
multiple logon.</FONT>
<BR><FONT SIZE=3D2>But INSERT query failed:"Duplicate entry =
'smartone-0' for key 1".</FONT>
</P>
<P><FONT SIZE=3D2>From mailing list <A =
HREF=3D"http://www.open.com.au/archives/radiator/2003-07/msg00186.html" =
TARGET=3D"_blank">http://www.open.com.au/archives/radiator/2003-07/msg00=
186.html</A></FONT>
<BR><FONT SIZE=3D2>Attribute NAS-Identifier and NAS-Port must =
unique.</FONT>
</P>
<P><FONT SIZE=3D2>Here are my questions:</FONT>
<BR><FONT SIZE=3D2>1) I don't understand why these two attributes are =
used for default key,</FONT>
<BR><FONT SIZE=3D2> even though we can define our own =
DeleteQuery,AddQuery,CountQuery.</FONT>
</P>
<P><FONT SIZE=3D2>2) Is it possible to release the 'unique' =
requirement</FONT>
</P>
<P><FONT SIZE=3D2>3) If the answer of (2) is not, how about using other =
attributes such as Account-Session-Id or Framed-IP-Address</FONT>
</P>
<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Harrison</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 377905: DEBUG: Handling =
request with Handler =
'Client-Id=3D/202.140.93.(11|12)/,Called-Station-Id=3D/(smartone)/,NAS-I=
P-Address=3D10.32.16.1'</FONT></P>
<P><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 382082: DEBUG: =
SessionDatabaseA Adding session for , 10.32.16.1, 1</FONT>
<BR><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 383821: DEBUG: do =
query is: 'delete from RADONLINE where NASIDENTIFIER=3D'smartone' and =
ACCTSESSIONID=3D'00000002543992' and FRAMEDIPADDRESS=3D'10.32.20.157'': =
</FONT></P>
<P><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 386700: DEBUG: do query =
is: 'insert into RADONLINE (USERNAME,CALLINGSTATIONID,NASIDENTIFIER, =
ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values =
('','85291399096','smartone', =
'00000002543992',1078812652,'10.32.20.157')': </FONT></P>
<P><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 388700: ERR: do failed =
for 'insert into RADONLINE (USERNAME,CALLINGSTATIONID,NASIDENTIFIER, =
ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values =
('','85291399096','smartone', =
'00000002543992',1078812652,'10.32.20.157')': Duplicate entry =
'smartone-0' for key 1</FONT></P>
<P><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 389810: DEBUG: Handling =
with Radius::AuthFILE: defaultaccept</FONT>
<BR><FONT SIZE=3D2>Tue Mar 9 14:10:52 2004 390911: DEBUG: =
Accounting accepted</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C405A4.8A53A710--
--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"
** This Email is virus-scanned and identified clean.
--------------InterScan_NT_MIME_Boundary--
--
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.
More information about the radiator
mailing list