(RADIATOR) AllocateQuery
Harrison Ng
Harrison_Ng at hksmartone.com
Mon Aug 20 21:59:02 CDT 2001
Hello,
Does anyone know is it valid to include %{attribute-name} in AllocateQuery
of <AddressAllocator SQL>.
We've append a new column called MSISDN in RADPOOL to record
Calling-Station-Id. Then add custom AllocateQuery as below.
Under trace 4, it seems that radiator return empty value for
%{Calling-Station-Id}.
However we tried similar things in AuthSelect of <AuthBy SQL>,
%{Calling-Station-Id} works properly.
Can anyone give me a hint.
Harrison
SmarTone Mobile Communications Ltd.
This is an extract of radius.cfg
--------------------------------------------
<AuthBy SQL>
Identifier getpoolhint
DBSource dbi:mysql:radius:10.25.157.33
DBUsername dbuser1
DBAuth netra323
AuthSelect select POOLHINT from APN where ROAMDIGIT =
left("%{Calling-Station-Id}",3)
AuthColumnDef 0, PoolHint, reply
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef CLASS,Class
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef NASIPADDRESS,NAS-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef ACCTAUTHENTIC,Acct-Authentic
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef FRAMEDPROTOCOL,Framed-Protocol
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef TIMESTAMP,Timestamp,integer
AcctFailedLogFileName %L/grad1.%c.missing.%Y%m%d
</AuthBy SQL>
<AddressAllocator SQL>
Identifier myallocator
DBSource dbi:mysql:radius:10.25.157.33
DBUsername dbuser1
DBAuth netra323
AllocateQuery update RADPOOL set
STATE=1,TIME_STAMP=%0,EXPIRY=%1,USERNAME='%2',MSISDN='%{Calling-Station-Id}'
\
where YIADDR='%3' and TIME_STAMP%4
<AddressPool local>
Subnetmask 255.255.255.0
Range 202.140.74.11 202.140.74.20
</AddressPool>
<AddressPool roam>
Subnetmask 255.255.255.0
Range 10.25.155.11 10.25.155.20
</AddressPool>
</AddressAllocator SQL>
This is radiator trace 4
--------------------------------
Tue Aug 21 10:48:09 2001: DEBUG: Packet dump:
*** Received from 202.140.74.1 port 2859 ....
Code: Access-Request
Identifier: 199
Authentic: <0><0>'_<0><0><7><249><0><0>bm<0><0><7>T
Attributes:
User-Name = "aaaa"
User-Password =
"A<228><31><204><205>(<27><166>-v<150>Z<220><180><207>U"
NAS-IP-Address = 202.140.74.1
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 1
Calling-Station-Id = "85298699517"
NAS-Identifier = "radius"
Tue Aug 21 10:48:09 2001: DEBUG: Check if Handler Client-Id =
202.140.74.1,NAS-Identifier = "radius" should be used to handle this request
Tue Aug 21 10:48:09 2001: DEBUG: Handling request with Handler 'Client-Id =
202.140.74.1,NAS-Identifier = "radius"'
Tue Aug 21 10:48:09 2001: DEBUG: simultaneous Deleting session for aaaa,
202.140.74.1, 1
Tue Aug 21 10:48:09 2001: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='202.140.74.1' and NASPORT=1
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthFILE
Tue Aug 21 10:48:09 2001: DEBUG: Radius::AuthFILE looks for match with aaaa
Tue Aug 21 10:48:09 2001: DEBUG: Radius::AuthFILE looks for match with
DEFAULT
Tue Aug 21 10:48:09 2001: DEBUG: Radius::AuthFILE ACCEPT: Accept explicitly
by Auth-Type=Accept
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthSQL
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthSQL
Tue Aug 21 10:48:09 2001: DEBUG: Query is: select POOLHINT from APN where
ROAMDIGIT = left("85298699517",3)
Tue Aug 21 10:48:09 2001: DEBUG: Radius::AuthSQL looks for match with aaaa
Tue Aug 21 10:48:09 2001: DEBUG: Radius::AuthSQL ACCEPT:
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
Tue Aug 21 10:48:09 2001: DEBUG: Query is: select TIME_STAMP, YIADDR,
SUBNETMASK, DNSSERVER from RADPOOL
where POOL='local' and STATE=0 order by TIME_STAMP
Tue Aug 21 10:48:09 2001: DEBUG: do query is: update RADPOOL set
STATE=1,TIME_STAMP=998362089,EXPIRY=998448489,USERNAME='aaaa',MSISDN=''
where YIADDR='202.140.74.11' and TIME_STAMP=998362069
Tue Aug 21 10:48:09 2001: DEBUG: Access accepted for aaaa
Tue Aug 21 10:48:09 2001: DEBUG: Packet dump:
*** Sending to 202.140.74.1 port 2859 ....
Code: Access-Accept
Identifier: 199
Authentic: <0><0>'_<0><0><7><249><0><0>bm<0><0><7>T
Attributes:
Framed-IP-Netmask = 255.255.255.0
Framed-IP-Address = 202.140.74.11
Class = "SI=Testing"
Tue Aug 21 10:48:09 2001: DEBUG: Packet dump:
*** Received from 202.140.74.1 port 2860 ....
Code: Accounting-Request
Identifier: 200
Authentic: <181><135>T<224><207>t<172>mc<239>$<206>c*W<182>
Attributes:
User-Name = "aaaa"
Class = "SI=Testing"
Acct-Session-Id = ""000000Testing""
NAS-IP-Address = 202.140.74.1
Acct-Status-Type = Start
NAS-Port = 1
Acct-Authentic = RADIUS
NAS-Identifier = "radius"
Framed-Protocol = PPP
Calling-Station-Id = "85298699517"
Framed-IP-Address = 202.140.74.11
Tue Aug 21 10:48:09 2001: DEBUG: Check if Handler Client-Id =
202.140.74.1,NAS-Identifier = "radius" should be used to handle this request
Tue Aug 21 10:48:09 2001: DEBUG: Handling request with Handler 'Client-Id =
202.140.74.1,NAS-Identifier = "radius"'
Tue Aug 21 10:48:09 2001: DEBUG: simultaneous Adding session for aaaa,
202.140.74.1, 1
Tue Aug 21 10:48:09 2001: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='202.140.74.1' and NASPORT=1
Tue Aug 21 10:48:09 2001: DEBUG: do query is: insert into RADONLINE
(USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NAS
PORTTYPE,SERVICETYPE) values
('aaaa','202.140.74.1',1,'"000000Testing"',998362089,'202.140.74.11','','')
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthFILE
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthSQL
Tue Aug 21 10:48:09 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Aug 21 10:48:09 2001: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, CLASS, ACCTSESSIONID, NASIPADDRESS,
ACCTSTATUSTYPE, NASPORT, ACCTAUTHENTIC, NASIDENTIFIER, FRAMEDPROTOCOL,
CALLINGSTATIONID, FRAMEDIPADDRESS, TIMESTAMP)
values
('aaaa', 'SI=Testing', '"000000Testing"', '202.140.74.1',
'Start', 1, 'RADIUS', 'radius', 'PPP', '85298699517', '202.140.74.11',
998362089)
Tue Aug 21 10:48:09 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
Tue Aug 21 10:48:09 2001: DEBUG: Accounting accepted
Tue Aug 21 10:48:09 2001: DEBUG: Packet dump:
*** Sending to 202.140.74.1 port 2860 ....
Code: Accounting-Response
Identifier: 200
Authentic: <181><135>T<224><207>t<172>mc<239>$<206>c*W<182>
Attributes:
Tue Aug 21 10:49:54 2001: DEBUG: Packet dump:
*** Received from 202.140.74.1 port 2863 ....
Code: Accounting-Request
Identifier: 201
Authentic: <157><156>W<220>8k<9><26>H<181><203>a<133><229><130><24>
Attributes:
User-Name = "aaaa"
Class = "SI=Testing"
Acct-Session-Id = ""000000Testing""
NAS-IP-Address = 202.140.74.1
Acct-Status-Type = Stop
NAS-Port = 1
Acct-Authentic = RADIUS
NAS-Identifier = "radius"
Framed-Protocol = PPP
Calling-Station-Id = "85298699517"
Framed-IP-Address = 202.140.74.11
Tue Aug 21 10:49:54 2001: DEBUG: Check if Handler Client-Id =
202.140.74.1,NAS-Identifier = "radius" should be used to handle this request
Tue Aug 21 10:49:54 2001: DEBUG: Handling request with Handler 'Client-Id =
202.140.74.1,NAS-Identifier = "radius"'
Tue Aug 21 10:49:54 2001: DEBUG: simultaneous Deleting session for aaaa,
202.140.74.1, 1
Tue Aug 21 10:49:54 2001: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='202.140.74.1' and NASPORT=1
Tue Aug 21 10:49:54 2001: DEBUG: Handling with Radius::AuthFILE
Tue Aug 21 10:49:54 2001: DEBUG: Handling with Radius::AuthSQL
Tue Aug 21 10:49:54 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Aug 21 10:49:54 2001: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, CLASS, ACCTSESSIONID, NASIPADDRESS,
ACCTSTATUSTYPE, NASPORT, ACCTAUTHENTIC, NASIDENTIFIER, FRAMEDPROTOCOL,
CALLINGSTATIONID, FRAMEDIPADDRESS, TIMESTAMP)
values
('aaaa', 'SI=Testing', '"000000Testing"', '202.140.74.1',
'Stop', 1, 'RADIUS', 'radius', 'PPP', '85298699517', '202.140.74.11',
998362194)
Tue Aug 21 10:49:54 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
Tue Aug 21 10:49:54 2001: DEBUG: do query is: update RADPOOL set STATE=0,
TIME_STAMP=998362194 where YIADDR='202.140.74.11'
Tue Aug 21 10:49:54 2001: DEBUG: Accounting accepted
Tue Aug 21 10:49:54 2001: DEBUG: Packet dump:
*** Sending to 202.140.74.1 port 2863 ....
Code: Accounting-Response
Identifier: 201
Authentic: <157><156>W<220>8k<9><26>H<181><203>a<133><229><130><24>
Attributes:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010821/b329f9bc/attachment.html>
More information about the radiator
mailing list