(RADIATOR) Re: Conditional IP Pool Allocation
Nayeem
nayeem at gulfnetksa.com
Mon May 5 08:23:13 CDT 2003
Dear Hugh,
same we got Warning "Invalid reply item PoolHint ignored" in trace 4.
please see the Trace 4 Debug text below ...
######################### Trace 4 ###################################
on May 5 16:01:01 2003: DEBUG: Packet dump:
*** Received from 212.24.224.66 port 1645 ....
Code: Access-Request
Identifier: 4
Authentic: <140><198>\<139>k<174><155><221><210><145><136>eBsT<149>
Attributes:
NAS-IP-Address = 212.24.224.66
NAS-Port = 3
Cisco-NAS-Port = "Async3"
NAS-Port-Type = Async
User-Name = "ahmedalsalim"
User-Password =
"<226><227><227>R<173><174><200><159><252>W<181>R{V<233><4>"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon May 5 16:01:01 2003: DEBUG: Handling request with Handler ''
Mon May 5 16:01:01 2003: DEBUG: Rewrote user name to ahmedalsalim
Mon May 5 16:01:01 2003: DEBUG: Rewrote user name to ahmedalsalim
Mon May 5 16:01:01 2003: DEBUG: Rewrote user name to ahmedalsalim
Mon May 5 16:01:01 2003: DEBUG: Rewrote user name to
ahmedalsalim at zajilemail.net
Mon May 5 16:01:01 2003: DEBUG: SDB1 Deleting session for ahmedalsalim,
212.24.224.66, 3
Mon May 5 16:01:01 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'ahmedalsalim at zajilemail.net'':
Mon May 5 16:01:01 2003: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='ahmedalsalim at zajilemail.net'':
Mon May 5 16:01:01 2003: DEBUG: Handling with Radius::AuthGROUP
Mon May 5 16:01:01 2003: DEBUG: Handling with Radius::AuthFILE:
Check_wodomain_FILE
Mon May 5 16:01:01 2003: DEBUG: Radius::AuthFILE looks for match with
ahmedalsalim at zajilemail.net
Mon May 5 16:01:01 2003: DEBUG: Radius::AuthFILE looks for match with
DEFAULT
Mon May 5 16:01:01 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:01 2003: DEBUG: Handling with Radius::AuthSQL:
Check_wodomain_SQL
Mon May 5 16:01:01 2003: DEBUG: Query is: 'select Epassword,classify from
EmailUsersForAuth_DSL where status = 'A' and Eusername =
substring('ahmedalsalim at zajilemail.net', 1, patindex('%@%',
'ahmedalsalim at zajilemail.net') -1)':
Mon May 5 16:01:01 2003: DEBUG: Radius::AuthSQL looks for match with
ahmedalsalim at zajilemail.net
Mon May 5 16:01:01 2003: DEBUG: Radius::AuthSQL ACCEPT:
Mon May 5 16:01:01 2003: DEBUG: Radius::AuthFILE ACCEPT:
Mon May 5 16:01:02 2003: DEBUG: Access accepted for
ahmedalsalim at zajilemail.net
Mon May 5 16:01:02 2003: WARNING: Invalid reply item PoolHint ignored
Mon May 5 16:01:02 2003: DEBUG: Packet dump:
*** Sending to 212.24.224.66 port 1645 ....
Code: Access-Accept
Identifier: 4
Authentic: <140><198>\<139>k<174><155><221><210><145><136>eBsT<149>
Attributes:
PoolHint = "ezajil"
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
Mon May 5 16:01:02 2003: DEBUG: Packet dump:
*** Received from 212.26.73.240 port 1646 ....
Code: Accounting-Request
Identifier: 48
Authentic: <208>#<184>Q<184>WH<128><242>;<235><221>*3<31><201>
Attributes:
Acct-Session-Id = "001CAA47"
Tunnel-Server-Endpoint = 212.24.230.1
Tunnel-Client-Endpoint = 192.168.225.1
Tunnel-Assignment-ID = 1
Tunnel-ID = 101372769
Tunnel-Client-Auth-ID = inet-ula-tnt2
Tunnel-Server-Auth-ID = AS101-L2TP
Framed-Protocol = PPP
Framed-IP-Address = 212.24.231.83
Acct-Terminate-Cause = User-Request
Acct-Session-Time = 818
Acct-Input-Octets = 27857
Acct-Output-Octets = 20130
Acct-Input-Packets = 352
Acct-Output-Packets = 263
Acct-Authentic = RADIUS
User-Name = "bcsa at zajil.net"
Acct-Status-Type = Stop
NAS-Port = 37
Calling-Station-Id = "14646541"
Called-Station-Id = "2428"
NAS-Port-Type = Virtual
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.240
Event-Timestamp = 1052139510
Acct-Delay-Time = 140
Mon May 5 16:01:02 2003: DEBUG: Handling request with Handler 'Request-Type
= Accounting-Request, Client-Identifier=NAS0, Realm = zajil.net'
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to bcsa at zajil.net
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to bcsa at zajil.net
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to bcsa
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to bcsa at zajil.net
Mon May 5 16:01:02 2003: DEBUG: SDB1 Deleting session for bcsa at zajil.net,
212.26.73.240, 37
Mon May 5 16:01:02 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '001CAA47' AND UserName like 'bcsa at zajil.net'':
Mon May 5 16:01:02 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:02 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:02 2003: DEBUG: do query is: 'exec UTimeUsernameN
'bcsa at zajil.net', 27857, 20130,'001CAA47', 818, '05/05/2003 16:01:02', '37',
'14646541','2428', 'Stop'
,'212.24.230.1','192.168.225.1','User-Request','140','101372769','212.24.231
.83'':
Mon May 5 16:01:02 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:02 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:02 2003: DEBUG: do query is: 'exec UTimeUsernameN
'bcsa at zajil.net', 27857, 20130,'001CAA47', 818, '05/05/2003 16:01:02', '37',
'14646541','2428', 'Stop'
,'212.24.230.1','192.168.225.1','User-Request','140','101372769','212.24.231
.83'':
Mon May 5 16:01:02 2003: DEBUG: Handling with Radius::AuthDYNADDRESS
Mon May 5 16:01:02 2003: DEBUG: do query is: 'update RADPOOL set STATE=0,
TIME_STAMP=1052139662 where YIADDR='212.24.231.83'':
Mon May 5 16:01:02 2003: DEBUG: Accounting accepted
Mon May 5 16:01:02 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.240 port 1646 ....
Code: Accounting-Response
Identifier: 48
Authentic: <208>#<184>Q<184>WH<128><242>;<235><221>*3<31><201>
Attributes:
Mon May 5 16:01:02 2003: DEBUG: Packet dump:
*** Received from 212.26.73.240 port 1645 ....
Code: Access-Request
Identifier: 86
Authentic:
<139><253><149>Y<173><167><244><156><197><178><234><200><246>h<27><129>
Attributes:
Framed-Protocol = PPP
User-Name = "technica at zajil.net"
User-Password =
"E<3><24><29><27><205><171><11><28><201><223><159><152><242>\<202>"
NAS-Port = 166
cisco-avpair = "interface=Virtual-Access166"
NAS-Port-Type = Virtual
Calling-Station-Id = "26514742"
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.240
Mon May 5 16:01:02 2003: DEBUG: Handling request with Handler
'Client-Identifier=NAS0, Realm = zajil.net'
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to technica at zajil.net
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to technica at zajil.net
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to technica
Mon May 5 16:01:02 2003: DEBUG: Rewrote user name to technica at zajil.net
Mon May 5 16:01:02 2003: DEBUG: SDB1 Deleting session for
technica at zajil.net, 212.26.73.240, 166
Mon May 5 16:01:03 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'technica at zajil.net'':
Mon May 5 16:01:03 2003: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='technica at zajil.net'':
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthGROUP
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthFILE:
Check_zajilnet_FILE
Mon May 5 16:01:03 2003: DEBUG: Radius::AuthFILE looks for match with
technica at zajil.net
Mon May 5 16:01:03 2003: DEBUG: Radius::AuthFILE looks for match with
DEFAULT
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthSQL:
Check_zajilnet_SQL
Mon May 5 16:01:03 2003: DEBUG: Query is: 'select Ipassword, timeleft from
Isubscription where status = 'A' and ISPID = 1 and Iusername =
substring('technica at zajil.net', 1, patindex('%@%','technica at zajil.net') -1)
and timeleft > 0':
Mon May 5 16:01:03 2003: DEBUG: Radius::AuthSQL looks for match with
technica at zajil.net
Mon May 5 16:01:03 2003: DEBUG: Radius::AuthSQL ACCEPT:
Mon May 5 16:01:03 2003: DEBUG: Radius::AuthFILE ACCEPT:
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthDYNADDRESS
Mon May 5 16:01:03 2003: DEBUG: Query is: 'select TIME_STAMP, YIADDR,
SUBNETMASK, DNSSERVER from RADPOOL
where POOL='NAS0.zajil.net' and STATE=0 order by TIME_STAMP':
Mon May 5 16:01:03 2003: DEBUG: do query is: 'update RADPOOL set STATE=1,
TIME_STAMP=1052139663,
EXPIRY=1061534568, USERNAME='technica at zajil.net' where YIADDR='212.24.231.71
' and TIME_STAMP =1052135713':
Mon May 5 16:01:03 2003: DEBUG: Access accepted for technica at zajil.net
Mon May 5 16:01:03 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.240 port 1645 ....
Code: Access-Accept
Identifier: 86
Authentic:
<139><253><149>Y<173><167><244><156><197><178><234><200><246>h<27><129>
Attributes:
Session-Timeout = 9394905
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
Framed-IP-Netmask = 255.255.255.0
Framed-IP-Address = 212.24.231.71
Mon May 5 16:01:03 2003: DEBUG: Packet dump:
*** Received from 212.26.73.240 port 1646 ....
Code: Accounting-Request
Identifier: 49
Authentic: <220>8<176><150>N<185><24><221><193><201>,<165><27>_<251><244>
Attributes:
Acct-Session-Id = "001C36B1"
Tunnel-Server-Endpoint = 212.24.230.1
Tunnel-Client-Endpoint = 192.168.80.1
Tunnel-Assignment-ID = 1
Tunnel-ID = 117646888
Tunnel-Client-Auth-ID = inet-kho-tnt4
Tunnel-Server-Auth-ID = AS101-L2TP
Framed-Protocol = PPP
Framed-IP-Address = 212.24.231.124
Acct-Terminate-Cause = Port-Error
Acct-Session-Time = 29430
Acct-Input-Octets = 5183591
Acct-Output-Octets = 30716050
Acct-Input-Packets = 55991
Acct-Output-Packets = 58405
Acct-Authentic = RADIUS
User-Name = "summit at zajil.net"
Acct-Status-Type = Stop
NAS-Port = 603
Calling-Station-Id = "38673347"
Called-Station-Id = "3602428"
NAS-Port-Type = Virtual
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.240
Event-Timestamp = 1052139510
Acct-Delay-Time = 140
Mon May 5 16:01:03 2003: DEBUG: Handling request with Handler 'Request-Type
= Accounting-Request, Client-Identifier=NAS0, Realm = zajil.net'
Mon May 5 16:01:03 2003: DEBUG: Rewrote user name to summit at zajil.net
Mon May 5 16:01:03 2003: DEBUG: Rewrote user name to summit at zajil.net
Mon May 5 16:01:03 2003: DEBUG: Rewrote user name to summit
Mon May 5 16:01:03 2003: DEBUG: Rewrote user name to summit at zajil.net
Mon May 5 16:01:03 2003: DEBUG: SDB1 Deleting session for summit at zajil.net,
212.26.73.240, 603
Mon May 5 16:01:03 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '001C36B1' AND UserName like 'summit at zajil.net'':
Mon May 5 16:01:03 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:03 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:04 2003: DEBUG: do query is: 'exec UTimeUsernameN
'summit at zajil.net', 5183591, 30716050,'001C36B1', 29430, '05/05/2003
16:01:03', '603', '38673347','3602428', 'Stop'
,'212.24.230.1','192.168.80.1','Port-Error','140','117646888','212.24.231.12
4'':
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:04 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:04 2003: DEBUG: do query is: 'exec UTimeUsernameN
'summit at zajil.net', 5183591, 30716050,'001C36B1', 29430, '05/05/2003
16:01:04', '603', '38673347','3602428', 'Stop'
,'212.24.230.1','192.168.80.1','Port-Error','140','117646888','212.24.231.12
4'':
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthDYNADDRESS
Mon May 5 16:01:04 2003: DEBUG: do query is: 'update RADPOOL set STATE=0,
TIME_STAMP=1052139664 where YIADDR='212.24.231.124'':
Mon May 5 16:01:04 2003: DEBUG: Accounting accepted
Mon May 5 16:01:04 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.240 port 1646 ....
Code: Accounting-Response
Identifier: 49
Authentic: <220>8<176><150>N<185><24><221><193><201>,<165><27>_<251><244>
Attributes:
Mon May 5 16:01:04 2003: DEBUG: Packet dump:
*** Received from 212.26.73.240 port 1645 ....
Code: Access-Request
Identifier: 111
Authentic: <131><239>K<214>r4?E<178><7>1<246>c<230>$9
Attributes:
Framed-Protocol = PPP
User-Name = "badawood"
User-Password = "<143>U6<3>8<227><129>M<237>0<17><163>5<167><244>L"
NAS-Port = 640
cisco-avpair = "interface=Virtual-Access640"
NAS-Port-Type = Virtual
Calling-Station-Id = "26487138"
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.240
Mon May 5 16:01:04 2003: DEBUG: Handling request with Handler ''
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to badawood
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to badawood
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to badawood
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to
badawood at zajilemail.net
Mon May 5 16:01:04 2003: DEBUG: SDB1 Deleting session for badawood,
212.26.73.240, 640
Mon May 5 16:01:04 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'badawood at zajilemail.net'':
Mon May 5 16:01:04 2003: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='badawood at zajilemail.net'':
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthGROUP
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthFILE:
Check_wodomain_FILE
Mon May 5 16:01:04 2003: DEBUG: Radius::AuthFILE looks for match with
badawood at zajilemail.net
Mon May 5 16:01:04 2003: DEBUG: Radius::AuthFILE looks for match with
DEFAULT
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:04 2003: DEBUG: Handling with Radius::AuthSQL:
Check_wodomain_SQL
Mon May 5 16:01:04 2003: DEBUG: Query is: 'select Epassword,classify from
EmailUsersForAuth_DSL where status = 'A' and Eusername =
substring('badawood at zajilemail.net', 1, patindex('%@%',
'badawood at zajilemail.net') -1)':
Mon May 5 16:01:04 2003: DEBUG: Radius::AuthSQL looks for match with
badawood at zajilemail.net
Mon May 5 16:01:04 2003: DEBUG: Radius::AuthSQL ACCEPT:
Mon May 5 16:01:04 2003: DEBUG: Radius::AuthFILE ACCEPT:
Mon May 5 16:01:04 2003: DEBUG: Access accepted for badawood at zajilemail.net
Mon May 5 16:01:04 2003: WARNING: Invalid reply item PoolHint ignored
Mon May 5 16:01:04 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.240 port 1645 ....
Code: Access-Accept
Identifier: 111
Authentic: <131><239>K<214>r4?E<178><7>1<246>c<230>$9
Attributes:
PoolHint = "ezajil"
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
Mon May 5 16:01:04 2003: DEBUG: Packet dump:
*** Received from 212.26.73.1 port 21824 ....
Code: Accounting-Request
Identifier: 162
Authentic: <133><29>7<155><241>5\<181>9<212>"<239><223><214><173>c
Attributes:
Acct-Session-Id = "0002AC9D"
Framed-Protocol = PPP
Framed-IP-Address = 212.24.233.32
Acct-Authentic = RADIUS
Acct-Session-Time = 106814
Acct-Input-Octets = 122757175
Acct-Output-Octets = 388166050
Acct-Input-Packets = 452753
Acct-Output-Packets = 849274
Acct-Terminate-Cause = Port-Error
User-Name = "bandardsl"
Acct-Status-Type = Stop
NAS-Port-Type = Virtual
NAS-Port = 0
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.1
Acct-Delay-Time = 0
Mon May 5 16:01:04 2003: DEBUG: Handling request with Handler 'Request-Type
= Accounting-Request'
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:04 2003: DEBUG: Rewrote user name to
bandardsl at zajilemail.net
Mon May 5 16:01:05 2003: DEBUG: SDB1 Deleting session for bandardsl,
212.26.73.1, 0
Mon May 5 16:01:05 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '0002AC9D' AND UserName like 'bandardsl at zajilemail.net'':
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:05 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:05 2003: DEBUG: do query is: 'exec IEmailUsage
'bandardsl at zajilemail.net','0', 122757175,388166050,'0002AC9D', 106814,
'05/05/2003 16:01:05'':
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:05 2003: DEBUG: Handling accounting with Radius::AuthSQL
Mon May 5 16:01:05 2003: DEBUG: do query is: 'exec IEmailUsage
'bandardsl at zajilemail.net','0',122757175,388166050,'0002AC9D', 106814,
'05/05/2003 16:01:05'':
Mon May 5 16:01:05 2003: DEBUG: Accounting accepted
Mon May 5 16:01:05 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.1 port 21824 ....
Code: Accounting-Response
Identifier: 162
Authentic: <133><29>7<155><241>5\<181>9<212>"<239><223><214><173>c
Attributes:
Mon May 5 16:01:05 2003: DEBUG: Packet dump:
*** Received from 212.26.73.1 port 21824 ....
Code: Access-Request
Identifier: 163
Authentic: <164>:!<142>t<223><13>k<214>1K<226>I<187><23>t
Attributes:
Framed-Protocol = PPP
User-Name = "bandardsl"
User-Password = "<10><205>K<0>G_<30>,U<7><173><189><184><174><222><208>"
NAS-Port-Type = Virtual
NAS-Port = 0
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.1
Mon May 5 16:01:05 2003: DEBUG: Handling request with Handler ''
Mon May 5 16:01:05 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:05 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:05 2003: DEBUG: Rewrote user name to bandardsl
Mon May 5 16:01:05 2003: DEBUG: Rewrote user name to
bandardsl at zajilemail.net
Mon May 5 16:01:05 2003: DEBUG: SDB1 Deleting session for bandardsl,
212.26.73.1, 0
Mon May 5 16:01:05 2003: DEBUG: do query is: 'DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'bandardsl at zajilemail.net'':
Mon May 5 16:01:05 2003: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='bandardsl at zajilemail.net'':
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthGROUP
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthFILE:
Check_wodomain_FILE
Mon May 5 16:01:05 2003: DEBUG: Radius::AuthFILE looks for match with
bandardsl at zajilemail.net
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthSQL
Mon May 5 16:01:05 2003: DEBUG: Handling with Radius::AuthSQL:
Check_wodomain_SQL
Mon May 5 16:01:05 2003: DEBUG: Query is: 'select Epassword,classify from
EmailUsersForAuth_DSL where status = 'A' and Eusername =
substring('bandardsl at zajilemail.net', 1, patindex('%@%',
'bandardsl at zajilemail.net') -1)':
Mon May 5 16:01:05 2003: DEBUG: Radius::AuthSQL looks for match with
bandardsl at zajilemail.net
Mon May 5 16:01:05 2003: DEBUG: Radius::AuthSQL ACCEPT:
Mon May 5 16:01:05 2003: DEBUG: Radius::AuthFILE ACCEPT:
Mon May 5 16:01:05 2003: DEBUG: Access accepted for
bandardsl at zajilemail.net
Mon May 5 16:01:05 2003: WARNING: Invalid reply item PoolHint ignored
Mon May 5 16:01:05 2003: DEBUG: Packet dump:
*** Sending to 212.26.73.1 port 21824 ....
Code: Access-Accept
Identifier: 163
Authentic: <164>:!<142>t<223><13>k<214>1K<226>I<187><23>t
Attributes:
PoolHint = "ezajil"
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
Framed-IP-Address = 212.24.233.32
Mon May 5 16:01:06 2003: DEBUG: Packet dump:
*** Received from 212.26.73.240 port 1646 ....
Code: Accounting-Request
Identifier: 50
Authentic: <142><1>H<18><150>u<198><213><186><168><242>B<226><246>b<194>
Attributes:
Acct-Session-Id = "001CABAD"
Tunnel-Server-Endpoint = 212.24.230.1
Tunnel-Client-Endpoint = 192.168.244.1
Tunnel-Assignment-ID = 1
Tunnel-ID = 119316006
Tunnel-Client-Auth-ID = inet-der-tnt1
Tunnel-Server-Auth-ID = AS101-L2TP
Framed-Protocol = PPP
Framed-IP-Address = 212.24.231.67
Acct-Terminate-Cause = User-Request
Acct-Session-Time = 622
Acct-Input-Octets = 107040
Acct-Output-Octets = 1349511
Acct-Input-Packets = 1954
Acct-Output-Packets = 2690
Acct-Authentic = RADIUS
User-Name = "zajil139744 at zajil.net"
Acct-Status-Type = Stop
NAS-Port = 379
Calling-Station-Id = "14135618"
Called-Station-Id = "3602428"
NAS-Port-Type = Virtual
Service-Type = Framed-User
NAS-IP-Address = 212.26.73.240
Event-Timestamp = 1052139616
Acct-Delay-Time = 35
#########################################################################
End here ###########################
Regards,
Nayeem.
----- Original Message -----
From: "Hugh Irvine" <hugh at open.com.au>
To: "Nayeem" <nayeem at gulfnetksa.com>
Cc: "'Radiator (Radiator)'" <radiator at open.com.au>; "Mohammed AbdusSami"
<abdussami at gulfnetksa.com>
Sent: Monday, May 05, 2003 3:07 PM
Subject: Re: (RADIATOR) Re: Conditional IP Pool Allocation
>
> Hello Nayeem -
>
> Please send me the complete trace 4 debug from Radiator showing what is
> happening.
>
> I will also need to see the SQL record for the user being authenticated.
>
> regards
>
> Hugh
>
>
> On Monday, May 5, 2003, at 21:07 Australia/Melbourne, Nayeem wrote:
>
> > Dear Hugh,
> >
> > After modification our configuration file, we got error "Invalid Reply
> > Item
> > PoolHint Ignored" , below is my configuration file text
> >
> > ###### Configuration File
> >
> > <Client 212.24.75.20>
> > Identifier NAS0
> > Secret mysecret
> > DupInterval 0
> > </Client>
> >
> > <AddressAllocator SQL>
> >
> > Identifier AllocateFromSQL
> >
> > DBSource dbi:ODBC:mydsn
> > DBUsername username
> > DBAuth password
> >
> > AddAddressQuery insert into RADPOOL (STATE, TIME_STAMP, POOL, \
> > YIADDR, SUBNETMASK, DNSSERVER, USERNAME, NAS ) values (0, %t, '%0',
> > '%1',
> > \
> > '%2', '%3', '%n', '%{Calling-Station-Id}')
> >
> > <AddressPool NAS0.zajilemail.net>
> > Subnetmask 255.255.255.0
> > DNSServer 212.24.74.5
> > Range 212.26.222.3 212.26.222.99
> > </AddressPool>
> >
> > </AddressAllocator>
> >
> > <AddressAllocator SQL>
> >
> >
> > Identifier AllocateFromSQL1
> >
> > DBSource dbi:ODBC:mydsn
> > DBUsername username
> > DBAuth pasword
> >
> > AddAddressQuery insert into RADPOOL (STATE, TIME_STAMP, POOL, \
> > YIADDR, SUBNETMASK, DNSSERVER, USERNAME, NAS) values (0, %t, '%0',
> > '%1',
> > \
> > '%2', '%3', '%n', '%{Calling-Station-Id}')
> >
> > <AddressPool NAS0.domainname.net>
> > Subnetmask 255.255.255.0
> > DNSServer 212.24.74.5
> > Range 212.26.253.54 212.26.253.244
> > </AddressPool>
> > </AddressAllocator>
> >
> >
> > <AddressAllocator SQL>
> >
> >
> > Identifier AllocateFromSQL2
> >
> > DBSource dbi:ODBC:mydsn
> > DBUsername username
> > DBAuth password
> >
> > AddAddressQuery insert into RADPOOL (STATE, TIME_STAMP, POOL, \
> > YIADDR, SUBNETMASK, DNSSERVER, USERNAME, NAS) values (0, %t, '%0',
> > '%1',
> > \
> > '%2', '%3', '%n', '%{Calling-Station-Id}')
> >
> > <AddressPool NAS0.domainname.net>
> > Subnetmask 255.255.255.0
> > DNSServer 212.24.74.5
> > Range 212.26.253.128 212.26.253.191
> > </AddressPool>
> > </AddressAllocator>
> >
> >
> >
> >
> > <AuthBy FILE>
> > Identifier Check_in_FILE
> > NoDefaultIfFound
> > Filename %D/in_users1
> >
> > </AuthBy>
> >
> > <AuthBy SQL>
> > NoDefault
> > Identifier Check_SQL
> >
> > DBSource dbi:ODBC:mydsn
> > DBUsername username
> > DBAuth password
> >
> >
> > AuthSelect select password,plantype from subscriber \
> > where username = substring('%n', 1, patindex('%@%', '%n') -1)
> >
> >
> > AuthColumnDef 0, User-Password, check
> > AuthColumnDef 1, PoolHint, reply
> >
> > AccountingStopsOnly
> >
> > AcctSQLStatement exec Usage '%n','%{NAS-Port}', %{Acct-Input-Octets},\
> > %{Acct-Output-Octets},'%{Acct-Session-Id}', %{Acct-Session-Time}, \
> > '%m/%d/%Y %H:%M:%S'
> >
> > AddToReplyIfNotExist PoolHint = AllocateIPAddress
> >
> > AddToReply Service-Type = Framed-User, \
> > Framed-Protocol = PPP, \
> > Framed-Compression = Van-Jacobson-TCP-IP
> >
> > </AuthBy>
> >
> >
> >
> > <AuthBy DYNADDRESS>
> > Identifier AllocateIPAddress
> > Allocator AllocateFromSQL
> > PoolHint %{Client:Identifier}.%R
> > </AuthBy>
> >
> > # dsl1 and dsl2 is plantype mention in Database.
> >
> > <AuthBy DYNADDRESS>
> > Identifier dsl1
> > Allocator AllocateFromSQL1
> > PoolHint %{Reply:PoolHint}.%R
> > </AuthBy>
> >
> > <AuthBy DYNADDRESS>
> > Identifier dsl2
> > Allocator AllocateFromSQL2
> > PoolHint %{Reply:PoolHint}.%R
> > </AuthBy>
> >
> >
> > <Handler Request-Type = Accounting-Request>
> >
> > RewriteUsername s/\s+//g
> > RewriteUsername tr/A-Z/a-z/
> > RewriteUsername s/^([^@]+).*/$1/
> > RewriteUsername s/(.*)/$1\@domainname.net/
> >
> > AuthByPolicy ContinueAlways
> > AuthBy Check_SQL
> > AuthBy Check_SQL1
> > AcctLogFileName %L/email/detail
> > SessionDatabase SDB1
> >
> > </Handler>
> >
> > <Handler>
> > MaxSessions 1
> >
> > RewriteUsername s/\s+//g
> > RewriteUsername tr/A-Z/a-z/
> > RewriteUsername s/^([^@]+).*/$1/
> > RewriteUsername s/(.*)/$1\@domainname.net/
> >
> > <AuthLog SQL>
> >
> > DBSource dbi:ODBC:mydsn
> > DBUsername username
> > DBAuth password
> >
> > Table Logcalls
> > SuccessQuery Insert into Logcalls (username, priority, Message,
> > Phonenumber, Password, NAS) \
> > values ('%n', %0, %1, '%{Calling-Station-Id}', '%P', '%N')
> >
> > FailureQuery Insert into Logcalls (username, priority, Message,
> > Phonenumber, Password, NAS) \
> > values ('%n', %0, %1, '%{Calling-Station-Id}', '%P', '%N')
> >
> > LogSuccess 1
> > LogFailure 1
> >
> > </AuthLog>
> >
> > AuthByPolicy ContinueWhileAccept
> > <AuthBy GROUP>
> > AuthByPolicy ContinueUntilAccept
> > AuthBy Check_in_FILE
> >
> > </AuthBy>
> >
> > SessionDatabase SDB1
> > </Handler>
> >
> >
> > #### End here.
> >
> >
> > Regards,
> > Nayeem.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Hugh Irvine" <hugh at open.com.au>
> > To: "Mohammed AbdusSami" <abdussami at gulfnetksa.com>
> > Cc: "'Radiator (Radiator)'" <radiator at open.com.au>
> > Sent: Monday, May 05, 2003 2:53 AM
> > Subject: (RADIATOR) Re: Conditional IP Pool Allocation
> >
> >
> >>
> >> Hello AdbusSami -
> >>
> >> You should set up your address pools with the plantype values and use
> >> them directly in the PoolHint:
> >>
> >> <AddressPool p1>
> >> ....
> >> </AddressPool>
> >> <AddressPool p2>
> >> ....
> >> </AddressPool>
> >> <AddressPool p3>
> >> .....
> >> </AddressPool>
> >>
> >> Then your AuthSelect would look like this:
> >>
> >> AuthSelect select PASSWORD, PLANTYPE, ....
> >> AuthColumnDef 0, Password, check
> >> AuthColumnDef 1, PoolHint, reply
> >> .....
> >> AddToReplyIfNotExist PoolHint = p3
> >>
> >> And your AuthBy DYNADDRESS would look like this:
> >>
> >> .....
> >> PoolHint %{Reply:PoolHint}
> >> .....
> >>
> >> See the corresponding sections in the Radiator 3.6 reference manual
> >> ("doc/ref.html").
> >>
> >> regards
> >>
> >> Hugh
> >>
> >>
> >> On Sunday, May 4, 2003, at 17:15 Australia/Melbourne, Mohammed
> >> AbdusSami wrote:
> >>
> >>> Dear All,
> >>>
> >>> How can I do following :
> >>>
> >>> Allocation of IP pool depend on plan type. For example I have 2 DSL
> >>> customers of plan type p1 & p2 respectively. when they request to
> >>> connect
> >>> they should get ip pool pool1 & pool2 respectively. And the plan
> >>> type
> >>> value I want to retrieve from "AuthSelect"
> >>>
> >>>
> >>> If plantype = p1
> >>> Pool1
> >>> If plantype = p2
> >>> Pool2
> >>> Else
> >>> Pool3
> >>>
> >>>
> >>>
> >>>
> >>> Thanks in Advance.
> >>>
> >>> Regards,
> >>>
> >>> AbdusSami
> >>>
> >>>
> >>>
> >>>
> >>
> >> NB: have you included a copy of your configuration file (no secrets),
> >> together with a trace 4 debug showing what is happening?
> >>
> >> --
> >> 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.
> >>
> >>
> >
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> 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.
>
>
===
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