(RADIATOR) Re: Conditional IP Pool Allocation
Hugh Irvine
hugh at open.com.au
Mon May 5 17:26:46 CDT 2003
Hello Nayeem -
Thanks for sending the debug trace.
I think you are seeing the warning because Radiator is trying to send
the PoolHint attribute in the reply to the NAS.
You should probably use a StripFromReply to remove it.
<AuthBy DYNADDRESS>
....
StripFromReply PoolHint
</AuthBy>
regards
Hugh
On Monday, May 5, 2003, at 23:23 Australia/Melbourne, Nayeem wrote:
> 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.
>>
>>
>
>
>
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.
More information about the radiator
mailing list