(RADIATOR) Problem of Radiator MAXT TNT
Hugh Irvine
hugh at open.com.au
Thu Aug 12 18:05:09 CDT 2004
Hello Farooq -
I think at least part of your problem is shown below - you have two
<SessionDatabase SQL> lines and as you can see the debug log is _very_
confused. You should remove one of the lines and try your tests again.
<SessionDatabase SQL>
<SessionDatabase SQL>
DBSource dbi:Oracle:host=x.x.x.x;sid=x;port=1521
DBUsername xxxx
DBAuth xxxxxx
Timeout 60
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER,
NASPORT, \
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORTTYPE, \
SERVICETYPE) values ('%u', '%N', 0%{NAS-Port},
'%{Acct-Session-Id}',\
%{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}', \
'%{Service-Type}')
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%1' and
NASPORT=0%2
</SessionDatabase SQL>
BTW - You may find it easier to code at least some of your processing
in Oracle stored procedures. You will find an AuthPLSQL.pm module that
you can use for this purpose in the "goodies" directory.
regards
Hugh
On 13 Aug 2004, at 12:52, Muhammad Farooq Bhatti wrote:
> Dear hugh
>
> Please read uptill end; sorry its too large
>
> ########## Start of config ##########
> AcctPort 1646
> AuthPort 1645
> DbDir .
> DictionaryFile /cibs/radius/Radiator-3.9/dictionary
> FingerProg /usr/bin/finger
> LogDir .
> LogFile /var/log/radius/radlog
> LogStdout
> PidFile /tmp/radiusd.pid
> SnmpgetProg /usr/local/bin/snmpget
> Trace 5
>
>
> <SessionDatabase SQL>
> <SessionDatabase SQL>
> DBSource
> dbi:Oracle:host=x.x.x.x;sid=x;port=1521
> DBUsername xxxx
> DBAuth xxxxxx
> Timeout 60
>
> AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER,
> NASPORT, \
> ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORTTYPE, \
> SERVICETYPE) values ('%u', '%N', 0%{NAS-Port},
> '%{Acct-Session-Id}',\
> %{Timestamp}, '%{Framed-IP-Address}',
> '%{NAS-Port-Type}', \
> '%{Service-Type}')
>
>
> DeleteQuery delete from RADONLINE where NASIDENTIFIER='%1' and
> NASPORT=0%2
>
> </SessionDatabase SQL>
>
>
>
>
> <Client X.X.x.>
> Secret xxxxxxx
> </Client>
>
> <Client DEFAULT>
> Secret xxxxxx
> DupInterval 0
> </Client>
>
>
> ############################
>
>
>
> <Realm DEFAULT>
>
>
> <AuthBy SQL>
> DBSource
> dbi:Oracle:host=x.x.x.x;sid=x;port=1521
> DBUsername xxxx
> DBAuth xxxxx
> Timeout 60
>
>
>
> AddToReply
> Framed-Protocol=%{Framed-Protocol},Service-Type=%{Service-Type},Port-
> Limit=2
>
> AuthSelect select A.PASSWORD , B.SIMULTANEOUS_USE,
> B.FRAMED_IP_ADDRESS,
> B.FRAMED_IP_NETMASK, B.FRAMED_ROUTE, B
> .FILTER_ID, B.FILTER_ID_OUT, B.CISCO_AV_PAIR,
> B.FRAMED_ROUTE2,B.FRAMED_ROUTE3, GET_RADIUS_SESSION_TIME_OUT(%0)
> SESSION_TIMEOUT , D.TimeString from \
> customer_info A, Customer_account B,
> customer_contacts C,
> Tariff D \
> where A.tariff_Id = D.tariff_Id AND \
> ( \
> ( \
> (lOWER(NVL(C.OFF_CLI1,'no'))='yes' AND
> (C.OFFICE_PHONE1='%{Calling-Station-Id}' OR C.OF
> FICE_PHONE1='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.OFF_CLI2,'no'))='yes' AND
> (C.OFFICE_PHONE2='%{Calling-Station-Id}' OR C.OF
> FICE_PHONE2='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.OFF_CLI3,'no'))='yes' AND
> (C.OFFICE_PHONE3='%{Calling-Station-Id}' OR C.OF
> FICE_PHONE3='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.OFF_CLI4,'no'))='yes' AND
> (C.OFFICE_PHONE4='%{Calling-Station-Id}' OR C.OF
> FICE_PHONE4='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.RES_CLI1,'no'))='yes' AND
> (C.RES_PHONE1='%{Calling-Station-Id}' OR C.RES_P
> HONE1='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.RES_CLI2,'no'))='yes' AND
> (C.RES_PHONE2='%{Calling-Station-Id}' OR C.RES_P
> HONE2='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.RES_CLI3,'no'))='yes' AND
> (C.RES_PHONE3='%{Calling-Station-Id}' OR C.RES_P
> HONE3='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.RES_CLI4,'no'))='yes' AND
> (C.RES_PHONE4='%{Calling-Station-Id}' OR C.RES_P
> HONE4='0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.FAX_CLI1,'no'))='yes' AND
> (C.FAX1='%{Calling-Station-Id}' OR C.FAX1='0%{Ca
> lling-Station-Id}') ) OR \
> (lOWER(NVL(C.FAX_CLI2,'no'))='yes' AND
> (C.FAX2='%{Calling-Station-Id}' OR C.FAX2='0%{Ca
> lling-Station-Id}') ) OR \
> (lOWER(NVL(C.MOB_CLI1,'no'))='yes' AND
> (C.MOBILE1='%{Calling-Station-Id}' OR C.MOBILE1=
> '0%{Calling-Station-Id}') ) OR \
> (lOWER(NVL(C.MOB_CLI2,'no'))='yes' AND
> (C.MOBILE2='%{Calling-Station-Id}' OR C.MOBILE2=
> '0%{Calling-Station-Id}') ) \
> ) \
> OR \
> ( \
> lOWER(NVL(C.OFF_CLI1,'no'))='no' AND \
> lOWER(NVL(C.OFF_CLI2,'no'))='no' AND \
> lOWER(NVL(C.OFF_CLI3,'no'))='no' AND \
> lOWER(NVL(C.OFF_CLI4,'no'))='no' AND \
> lOWER(NVL(C.RES_CLI1,'no'))='no' AND \
> lOWER(NVL(C.RES_CLI2,'no'))='no' AND \
> lOWER(NVL(C.RES_CLI3,'no'))='no' AND \
> lOWER(NVL(C.RES_CLI4,'no'))='no' AND \
> lOWER(NVL(C.FAX_CLI1,'no'))='no' AND \
> lOWER(NVL(C.FAX_CLI2,'no'))='no' AND \
> lOWER(NVL(C.MOB_CLI1,'no'))='no' AND \
> lOWER(NVL(C.MOB_CLI2,'no'))='no' \
> ) \
> ) AND \
> A.customer_id = C.Customer_id (+) AND \
> sysDate < B.EXPIRY_DATE AND \
> B.ACCOUNT_BALANCE >= B.Credit_Limit AND \
> UPPER(B.Status) ='ACTIVE' AND \
> A.customer_id = B.Customer_id AND \
> A.login_Id=%0
>
> AuthColumnDef 0, Encrypted-Password, check
> AuthColumnDef 1, Simultaneous-Use, check
> AuthColumnDef 2, Framed-IP-Address, reply
> AuthColumnDef 3, Framed-IP-Netmask, reply
> AuthColumnDef 4, Framed-Route, reply
> AuthColumnDef 5, Filter-Id, reply
> AuthColumnDef 6, Filter-Id, reply
> AuthColumnDef 7, cisco-avpair, reply
> AuthColumnDef 8, Framed-Route, reply
> AuthColumnDef 9, Framed-Route, reply
> AuthColumnDef 10, Session-Timeout, reply
> AuthColumnDef 11, Time, check
>
>
> AccountingTable RadiusDump
> AcctColumnDef ACCT_SESSION_ID, Acct-Session-Id
> #AcctColumnDef TIMESTAMP,Timestamp,integer-date,
> %e/%b/%y
> #AcctColumnDef TIMESTAMP,Timestamp,integer-date,
> %e/%b/%y%H:%M:%S
> #AcctColumnDef TIMESTAMP,Timestamp,integer
> AcctColumnDef
> TIMESTAMP,Timestamp,formatted-date,to_date
> ('%e %m %Y %H: %M: %S','DD MM YYYY HH2
> 4:MI:SS')
> AcctColumnDef Acct_Delay_Time, Acct-Delay-Time
> AcctColumnDef USER_NAME, User-Name
> AcctColumnDef ACCT_STATUS_TYPE, Acct-Status-Type
> AcctColumnDef ACCT_SESSION_TIME, Acct-Session-Time
> AcctColumnDef ACCT_MULTI_SESSION_ID,
> Acct-Multi-Session-Id
> AcctColumnDef ACCT_LINK_COUNT, Acct-Link-Count
> AcctColumnDef SERVICE_TYPE, Framed-Protocol
> AcctColumnDef NAS_Identifier, NAS-Identifier
> AcctColumnDef NAS_IP_ADDRESS, NAS-IP-Address
> AcctColumnDef NAS_PORT, NAS-Port
> AcctColumnDef NAS_PORT_TYPE, NAS-Port-Type
> AcctColumnDef ACCT_AUTHENTIC, Acct-Authentic
> AcctColumnDef ACCT_INPUT_PACKETS, Acct-Input-Packets
> AcctColumnDef ACCT_OUTPUT_PACKETS, Acct-Output-Packets
> AcctColumnDef ACCT_INPUT_OCTETS, Acct-Input-Octets
> AcctColumnDef ACCT_OUTPUT_OCTETS, Acct-Output-Octets
> AcctColumnDef CALLED_STATION_ID, Called-Station-Id
> AcctColumnDef ACCT_TERMINATE_CAUSE,
> Acct-Terminate-Cause
> AcctColumnDef CALLING_STATION_ID, Calling-Station-Id
>
> </AuthBy>
>
>
> AcctLogFileFormat %o %{NAS-IP-Address} %{User-Name}
> %{Acct-Session-Id} \
> %{NAS-Port-Type} %{NAS-Port} %{Acct-Status-Type}
> %{Service-Type} %{Framed-Protocol} \
> %{Calling-Station-Id} %{Acct-Session-Time}
> %{Acct-Terminate-Cause} %{Framed-IP-Address}
>
> AcctLogFileName /var/log/radius/cibsRadiusAaccount.log
>
> </Realm>
> #
> #
> #
> ###the end #########################
>
> ############# The trace 5 log for user comsats on MAX TNT
>
> Packet length = 148
> 01 dd 00 94 af 3d 17 e8 0f 24 24 72 48 6a c3 67
> 1e 80 d0 30 01 0a 63 6f 6d 73 61 74 73 00 02 07
> df db ae 1b 67 04 06 cb d7 bf 02 20 20 53 57 41
> 54 2d 43 49 53 2d 4d 61 78 54 4e 54 2e 63 6f 6d
> 73 61 74 73 2e 6e 65 74 2e 70 6b 05 06 00 00 00
> 1a 3d 06 00 00 00 00 18 02 1f 0c 30 39 33 36 37
> 31 32 39 38 37 2c 0c 34 34 36 34 36 32 32 35 38
> 00 6d 17 01 13 01 48 be 6a 98 40 62 a8 83 c5 42
> 34 7a 10 7d 00 00 00 00 c5 06 00 00 67 20 ff 06
> 00 00 c5 eb
> Code: Access-Request
> Identifier: 221
> Authentic: <175>=<23><232><15>$$rHj<195>g<30><128><208>0
> Attributes:
> User-Name = "comsats"
> User-Password = "<223><219><174><27>g"
> NAS-IP-Address = 203.215.191.2
> NAS-Identifier = "SWAT-CIS-MaxTNT.comsats.net.pk"
> NAS-Port = 26
> NAS-Port-Type = Async
> State = ""
> Calling-Station-Id = "0936712987"
> Acct-Session-Id = "446462258"
> Ascend-Endpoint-Disc =
> "<1><19><1>H<190>j<152>@b<168><131><197>B4z<16>}"
> Ascend-Data-Rate = 26400
> Ascend-Xmit-Rate = 50667
>
>
> Wed Aug 11 17:56:37 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Wed Aug 11 17:56:37 2004: DEBUG: Deleting session for comsats,
> 203.215.191.2, 26
> Wed Aug 11 17:56:37 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='203.215.191.2' and NA
> SPORT=026':
>
> Wed Aug 11 17:56:37 2004: DEBUG: Handling with Radius::AuthSQL
> Wed Aug 11 17:56:37 2004: DEBUG: Handling with Radius::AuthSQL:
> Wed Aug 11 17:56:37 2004: DEBUG: Query is: 'select A.PASSWORD ,
> B.SIMULTANEOUS_USE, B.FRAMED_IP_ADDRESS, B.FRAM
> ED_IP_NETMASK, B.FRAMED_ROUTE, B.FILTER_ID, B.FILTER_ID_OUT,
> B.CISCO_AV_PAIR, B.FRAMED_ROUTE2,B.FRAMED_ROUTE3,
> GET_RADIUS_SESSION_TIME_OUT('comsats') SESSION_TIMEOUT , D.TimeString
> from
> customer_info A, Customer_account
> B, customer_contacts C, Tariff D where A.tariff_Id = D.tariff_Id AND (
> (
> (lOWER(NVL(C.OFF_CLI1,'no'))='yes' AND
> (C.OFFICE_PHONE1='0936712987' OR C.OFFICE_PHONE1='00936712987') ) OR
> (lOWER(NVL(C.OFF_CLI2,'no'))='yes' AND (
> C.OFFICE_PHONE2='0936712987' OR C.OFFICE_PHONE2='00936712987') ) OR
> (lOWER(NVL(C.OFF_CLI3,'no'))='yes' AND (C.O
> FFICE_PHONE3='0936712987' OR C.OFFICE_PHONE3='00936712987') ) OR
> (lOWER(NVL(C.OFF_CLI4,'no'))='yes' AND (C.OFFI
> CE_PHONE4='0936712987' OR C.OFFICE_PHONE4='00936712987') ) OR
> (lOWER(NVL(C.RES_CLI1,'no'))='yes' AND (C.RES_PHO
> NE1='0936712987' OR C.RES_PHONE1='00936712987') ) OR
> (lOWER(NVL(C.RES_CLI2,'no'))='yes' AND (C.RES_PHONE2='0936
> 712987' OR C.RES_PHONE2='00936712987') ) OR
> (lOWER(NVL(C.RES_CLI3,'no'))='yes' AND (C.RES_PHONE3='0936712987' O
> R C.RES_PHONE3='00936712987') ) OR (lOWER(NVL(C.RES_CLI4,'no'))='yes'
> AND
> (C.RES_PHONE4='0936712987' OR C.RES_P
> HONE4='00936712987') ) OR (lOWER(NVL(C.FAX_CLI1,'no'))='yes' AND
> (C.FAX1='0936712987' OR C.FAX1='00936712987')
> ) OR (lOWER(NVL(C.FAX_CLI2,'no'))='yes' AND (C.FAX2='0936712987' OR
> C.FAX2='00936712987') ) OR (lOWER(NVL(C.MOB
> _CLI1,'no'))='yes' AND (C.MOBILE1='0936712987' OR
> C.MOBILE1='00936712987') )
> OR (lOWER(NVL(C.MOB_CLI2,'no'))='y
> es' AND (C.MOBILE2='0936712987' OR C.MOBILE2='00936712987') ) ) OR (
> lOWER(NVL(C.OFF_CLI1,'no'))='no' AND lOWER
> (NVL(C.OFF_CLI2,'no'))='no' AND lOWER(NVL(C.OFF_CLI3,'no'))='no' AND
> lOWER(NVL(C.OFF_CLI4,'no'))='no' AND lOWER
> (NVL(C.RES_CLI1,'no'))='no' AND lOWER(NVL(C.RES_CLI2,'no'))='no' AND
> lOWER(NVL(C.RES_CLI3,'no'))='no' AND lOWER
> (NVL(C.RES_CLI4,'no'))='no' AND lOWER(NVL(C.FAX_CLI1,'no'))='no' AND
> lOWER(NVL(C.FAX_CLI2,'no'))='no' AND lOWER
> (NVL(C.MOB_CLI1,'no'))='no' AND lOWER(NVL(C.MOB_CLI2,'no'))='no' ) )
> AND
> A.customer_id = C.Customer_id (+) AND
> sysDate < B.EXPIRY_DATE AND B.ACCOUNT_BALANCE >= B.Credit_Limit AND
> UPPER(B.Status) ='ACTIVE' AND A.customer_id
> = B.Customer_id AND A.login_Id='comsats'':
>
> Wed Aug 11 17:56:37 2004: DEBUG: Radius::AuthSQL looks for match with
> comsats
> Wed Aug 11 17:56:37 2004: DEBUG: Query is: 'select NASIDENTIFIER,
> NASPORT,
> ACCTSESSIONID, FRAMEDIPADDRESS from
> RADONLINE where USERNAME='comsats'':
>
> Wed Aug 11 17:56:37 2004: DEBUG: Radius::AuthSQL ACCEPT:
> Wed Aug 11 17:56:37 2004: DEBUG: Access accepted for comsats
> Wed Aug 11 17:56:37 2004: DEBUG: Packet dump:
> *** Sending to 203.215.191.2 port 527 ....
>
> Packet length = 50
> 02 dd 00 32 83 4f 71 16 20 f2 f4 75 4f d8 c2 fd
> 16 cd bd b9 09 06 ff ff ff ff 1b 06 00 03 f4 80
> 07 06 00 00 00 00 06 06 00 00 00 00 3e 06 00 00
> 00 02
> Code: Access-Accept
> Identifier: 221
> Authentic: <175>=<23><232><15>$$rHj<195>g<30><128><208>0
> Attributes:
> Framed-IP-Netmask = 255.255.255.255
> Session-Timeout = 259200
> Framed-Protocol =
> Service-Type =
> Port-Limit = 2
>
> Wed Aug 11 17:56:37 2004: DEBUG: Packet dump:
> *** Received from 203.215.191.2 port 7018 ....
>
> Packet length = 212
> 04 7b 00 d4 ef 87 bf b6 38 ac f0 8d 39 cb d9 b4
> be db 4a d0 37 06 41 1a 63 43 04 06 cb d7 bf 02
> 20 20 53 57 41 54 2d 43 49 53 2d 4d 61 78 54 4e
> 54 2e 63 6f 6d 73 61 74 73 2e 6e 65 74 2e 70 6b
> 05 06 00 00 00 1a 3d 06 00 00 00 00 28 06 00 00
> 00 02 29 06 00 00 00 00 2c 0c 34 34 36 34 36 32
> 32 35 38 00 c3 06 00 00 00 65 c4 06 00 00 00 43
> c5 06 00 00 67 20 c6 06 00 00 00 18 be 06 00 00
> 01 86 bf 06 00 00 01 57 c0 06 00 00 00 0f c1 06
> 00 00 00 0f ff 06 00 00 c5 eb bb 06 bf 02 03 41
> bc 06 00 00 00 00 33 06 00 00 00 01 32 0a 62 66
> 30 32 30 33 34 31 78 06 00 00 00 03 79 06 00 00
> 00 05 7a 06 00 00 00 01 1f 0c 30 39 33 36 37 31
> 32 39 38 37
> Code: Accounting-Request
> Identifier: 123
> Authentic:
> <239><135><191><182>8<172><240><141>9<203><217><180><190><219>J<208>
> Attributes:
> Event-Timestamp = 1092248387
> NAS-IP-Address = 203.215.191.2
> NAS-Identifier = "SWAT-CIS-MaxTNT.comsats.net.pk"
> NAS-Port = 26
> NAS-Port-Type = Async
> Acct-Status-Type = Stop
> Acct-Delay-Time = 0
> Acct-Session-Id = "446462258"
> Ascend-Disconnect-Cause = 101
> Ascend-Connect-Progress = 67
> Ascend-Data-Rate = 26400
> Ascend-PreSession-Time = 24
> Ascend-Pre-Input-Octets = 390
> Ascend-Pre-Output-Octets = 343
> Ascend-Pre-Input-Packets = 15
> Ascend-Pre-Output-Packets = 15
> Ascend-Xmit-Rate = 50667
> Ascend-Multilink-ID = 3204580161
> Ascend-Num-In-Multilink = 0
> Acct-Link-Count = 1
> Acct-Multi-Session-Id = "bf020341"
> Ascend-Modem-PortNo = 3
> Ascend-Modem-SlotNo = 5
> Ascend-Modem-ShelfNo = 1
> Calling-Station-Id = "0936712987"
>
> Wed Aug 11 17:56:37 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Wed Aug 11 17:56:37 2004: DEBUG: Deleting session for ,
> 203.215.191.2, 26
> Wed Aug 11 17:56:37 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='203.215.191.2' and NA
> SPORT=026':
>
> Wed Aug 11 17:56:37 2004: DEBUG: Handling with Radius::AuthSQL
> Wed Aug 11 17:56:37 2004: DEBUG: Handling accounting with
> Radius::AuthSQL
> Wed Aug 11 17:56:37 2004: DEBUG: do query is: 'insert into RadiusDump
> (NAS_PORT_TYPE,ACCT_SESSION_ID,NAS_PORT,T
> IMESTAMP,ACCT_LINK_COUNT,NAS_IP_ADDRESS,ACCT_STATUS_TYPE,CALLING_STATIO
> N_ID,
> NAS_Identifier,ACCT_MULTI_SESSION_I
> D,Acct_Delay_Time) values ('Async','446462258','26',to_date ('11 08
> 2004 17:
> 56: 37','DD MM YYYY HH24:MI:SS'),'
> 1','203.215.191.2','Stop','0936712987','SWAT-CIS-
> MaxTNT.comsats.net.pk','bf0
> 20341','0')':
>
> ############################# End of log #############
>
> ############# Trace on Cisco AS5300 for user cnonews
>
> Code: Access-Request
> Identifier: 24
> Authentic:
> <223><210><135><226><167><187>7<14><169><222><137><232><158><216>Iw
> Attributes:
> Framed-Protocol = PPP
> User-Name = "cnonews"
> User-Password =
> "<235>n<228><158><240>:<138><238><16><184><188><246>4<2>#<157>"
> NAS-Port = 20019
> NAS-Port-Type = ISDN
> Calling-Station-Id = "0519225440"
> Service-Type = Framed-User
> NAS-IP-Address = 210.56.8.143
>
> Thu Aug 12 19:24:32 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Aug 12 19:24:32 2004: DEBUG: Deleting session for cnonews,
> 210.56.8.143, 20019
> Thu Aug 12 19:24:32 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='210.56.8.143' and NAS
> PORT=020019':
>
> Thu Aug 12 19:24:32 2004: DEBUG: Handling with Radius::AuthSQL
> Thu Aug 12 19:24:32 2004: DEBUG: Handling with Radius::AuthSQL:
> Thu Aug 12 19:24:32 2004: DEBUG: Query is: 'select A.PASSWORD ,
> B.SIMULTANEOUS_USE, B.FRAMED_IP_ADDRESS, B.FRAM
> ED_IP_NETMASK, B.FRAMED_ROUTE, B.FILTER_ID, B.FILTER_ID_OUT,
> B.CISCO_AV_PAIR, B.FRAMED_ROUTE2,B.FRAMED_ROUTE3,
> GET_RADIUS_SESSION_TIME_OUT('cnonews') SESSION_TIMEOUT, D.TimeString
> from
> customer_info A, Customer_account B
> , customer_contacts C, Tariff D where A.tariff_Id = D.tariff_Id AND ( (
> (lOWER(NVL(C.OFF_CLI1,'no'))='yes' AND
> (C.OFFICE_PHONE1='0519225440' OR C.OFFICE_PHONE1='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI2,'no'))='yes' AND (C
> .OFFICE_PHONE2='0519225440' OR C.OFFICE_PHONE2='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI3,'no'))='yes' AND (C.OF
> FICE_PHONE3='0519225440' OR C.OFFICE_PHONE3='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI4,'no'))='yes' AND (C.OFFIC
> E_PHONE4='0519225440' OR C.OFFICE_PHONE4='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI1,'no'))='yes' AND (C.RES_PHON
> E1='0519225440' OR C.RES_PHONE1='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI2,'no'))='yes' AND (C.RES_PHONE2='05192
> 25440' OR C.RES_PHONE2='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI3,'no'))='yes' AND (C.RES_PHONE3='0519225440' OR
> C.RES_PHONE3='00519225440') ) OR (lOWER(NVL(C.RES_CLI4,'no'))='yes'
> AND
> (C.RES_PHONE4='0519225440' OR C.RES_PH
> ONE4='00519225440') ) OR (lOWER(NVL(C.FAX_CLI1,'no'))='yes' AND
> (C.FAX1='0519225440' OR C.FAX1='00519225440') )
> OR (lOWER(NVL(C.FAX_CLI2,'no'))='yes' AND (C.FAX2='0519225440' OR
> C.FAX2='00519225440') ) OR (lOWER(NVL(C.MOB_
> CLI1,'no'))='yes' AND (C.MOBILE1='0519225440' OR
> C.MOBILE1='00519225440') )
> OR (lOWER(NVL(C.MOB_CLI2,'no'))='ye
> s' AND (C.MOBILE2='0519225440' OR C.MOBILE2='00519225440') ) ) OR (
> lOWER(NVL(C.OFF_CLI1,'no'))='no' AND lOWER(
> NVL(C.OFF_CLI2,'no'))='no' AND lOWER(NVL(C.OFF_CLI3,'no'))='no' AND
> lOWER(NVL(C.OFF_CLI4,'no'))='no' AND lOWER(
> NVL(C.RES_CLI1,'no'))='no' AND lOWER(NVL(C.RES_CLI2,'no'))='no' AND
> lOWER(NVL(C.RES_CLI3,'no'))='no' AND lOWER(
> NVL(C.RES_CLI4,'no'))='no' AND lOWER(NVL(C.FAX_CLI1,'no'))='no' AND
> lOWER(NVL(C.FAX_CLI2,'no'))='no' AND lOWER(
> NVL(C.MOB_CLI1,'no'))='no' AND lOWER(NVL(C.MOB_CLI2,'no'))='no' ) ) AND
> A.customer_id = C.Customer_id (+) AND s
> ysDate < B.EXPIRY_DATE AND B.ACCOUNT_BALANCE >= B.Credit_Limit AND
> UPPER(B.Status) ='ACTIVE' AND A.customer_id
> = B.Customer_id AND A.login_Id='cnonews'':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Radius::AuthSQL looks for match with
> cnonews
> Thu Aug 12 19:24:34 2004: DEBUG: Query is: 'select NASIDENTIFIER,
> NASPORT,
> ACCTSESSIONID, FRAMEDIPADDRESS from
> RADONLINE where USERNAME='cnonews'':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Radius::AuthSQL ACCEPT:
> Thu Aug 12 19:24:34 2004: DEBUG: Access accepted for cnonews
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Sending to 210.56.8.143 port 1645 ....
> Code: Access-Accept
> Identifier: 24
> Authentic:
> <223><210><135><226><167><187>7<14><169><222><137><232><158><216>Iw
> Attributes:
> Framed-Protocol = PPP
> Service-Type = Framed-User
>
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Received from 210.56.8.143 port 1646 ....
> Code: Accounting-Request
> Identifier: 213
> Authentic: <140>V<215><1><30><214>n\q<164><8><160><226><9>]<1>
> Attributes:
> Acct-Session-Id = "00061E4D"
> Framed-Protocol = PPP
> Acct-Authentic = RADIUS
> Acct-Status-Type = Start
> User-Name = "cnonews"
> Acct-Multi-Session-Id = "0003D41A"
> Acct-Link-Count = 1
> NAS-Port = 20019
> NAS-Port-Type = ISDN
> Calling-Station-Id = "0519225440"
> Service-Type = Framed-User
> NAS-IP-Address = 210.56.8.143
> Acct-Delay-Time = 0
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Aug 12 19:24:34 2004: DEBUG: Adding session for cnonews,
> 210.56.8.143,
> 20019
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='210.56.8.143' and NAS
> PORT=020019':
>
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSES
> SIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values
> ('cnonews', '210.56.8.143', 020019, '0006
> 1E4D',1092320674, '', 'ISDN', 'Framed-User')':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling with Radius::AuthSQL
> Thu Aug 12 19:24:34 2004: DEBUG: Handling accounting with
> Radius::AuthSQL
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'insert into RadiusDump
> (ACCT_AUTHENTIC,ACCT_LINK_COUNT,ACCT_MULT
> I_SESSION_ID,ACCT_SESSION_ID,ACCT_STATUS_TYPE,Acct_Delay_Time,CALLING_S
> TATIO
> N_ID,NAS_IP_ADDRESS,NAS_PORT,NAS_PO
> RT_TYPE,SERVICE_TYPE,TIMESTAMP,USER_NAME) values
> ('RADIUS','1','0003D41A','00061E4D','Start','0','0519225440','
> 210.56.8.143','20019','ISDN','PPP',to_date ('12 08 2004 19: 24:
> 34','DD MM
> YYYY HH24:MI:SS'),'cnonews')':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Accounting accepted
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Sending to 210.56.8.143 port 1646 ....
> Code: Accounting-Response
> Identifier: 213
> Authentic: <140>V<215><1><30><214>n\q<164><8><160><226><9>]<1>
> Attributes:
>
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Received from 210.56.8.143 port 1645 ....
>
>
> Code: Access-Request
> Identifier: 25
> Authentic:
> <223><210><135><226><167><187>7<14><169><222><137><232><158><216>Iw
> Attributes:
> Framed-Protocol = PPP
> User-Name = "cnonews"
> User-Password =
> "<235>n<228><158><240>:<138><238><16><184><188><246>4<2>#<157>"
> NAS-Port = 20206
> NAS-Port-Type = ISDN
> Calling-Station-Id = "0519225440"
> Service-Type = Framed-User
> NAS-IP-Address = 210.56.8.143
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Aug 12 19:24:34 2004: DEBUG: Deleting session for cnonews,
> 210.56.8.143, 20206
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='210.56.8.143' and NAS
> PORT=020206':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling with Radius::AuthSQL
> Thu Aug 12 19:24:34 2004: DEBUG: Handling with Radius::AuthSQL:
> Thu Aug 12 19:24:34 2004: DEBUG: Query is: 'select A.PASSWORD ,
> B.SIMULTANEOUS_USE, B.FRAMED_IP_ADDRESS, B.FRAM
> ED_IP_NETMASK, B.FRAMED_ROUTE, B.FILTER_ID, B.FILTER_ID_OUT,
> B.CISCO_AV_PAIR, B.FRAMED_ROUTE2,B.FRAMED_ROUTE3,
> GET_RADIUS_SESSION_TIME_OUT('cnonews') SESSION_TIMEOUT, D.TimeString
> from
> customer_info A, Customer_account B
> , customer_contacts C, Tariff D where A.tariff_Id = D.tariff_Id AND ( (
> (lOWER(NVL(C.OFF_CLI1,'no'))='yes' AND
> (C.OFFICE_PHONE1='0519225440' OR C.OFFICE_PHONE1='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI2,'no'))='yes' AND (C
> .OFFICE_PHONE2='0519225440' OR C.OFFICE_PHONE2='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI3,'no'))='yes' AND (C.OF
> FICE_PHONE3='0519225440' OR C.OFFICE_PHONE3='00519225440') ) OR
> (lOWER(NVL(C.OFF_CLI4,'no'))='yes' AND (C.OFFIC
> E_PHONE4='0519225440' OR C.OFFICE_PHONE4='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI1,'no'))='yes' AND (C.RES_PHON
> E1='0519225440' OR C.RES_PHONE1='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI2,'no'))='yes' AND (C.RES_PHONE2='05192
> 25440' OR C.RES_PHONE2='00519225440') ) OR
> (lOWER(NVL(C.RES_CLI3,'no'))='yes' AND (C.RES_PHONE3='0519225440' OR
> C.RES_PHONE3='00519225440') ) OR (lOWER(NVL(C.RES_CLI4,'no'))='yes'
> AND
> (C.RES_PHONE4='0519225440' OR C.RES_PH
> ONE4='00519225440') ) OR (lOWER(NVL(C.FAX_CLI1,'no'))='yes' AND
> (C.FAX1='0519225440' OR C.FAX1='00519225440') )
> OR (lOWER(NVL(C.FAX_CLI2,'no'))='yes' AND (C.FAX2='0519225440' OR
> C.FAX2='00519225440') ) OR (lOWER(NVL(C.MOB_
> CLI1,'no'))='yes' AND (C.MOBILE1='0519225440' OR
> C.MOBILE1='00519225440') )
> OR (lOWER(NVL(C.MOB_CLI2,'no'))='ye
> s' AND (C.MOBILE2='0519225440' OR C.MOBILE2='00519225440') ) ) OR (
> lOWER(NVL(C.OFF_CLI1,'no'))='no' AND lOWER(
> NVL(C.OFF_CLI2,'no'))='no' AND lOWER(NVL(C.OFF_CLI3,'no'))='no' AND
> lOWER(NVL(C.OFF_CLI4,'no'))='no' AND lOWER(
> NVL(C.RES_CLI1,'no'))='no' AND lOWER(NVL(C.RES_CLI2,'no'))='no' AND
> lOWER(NVL(C.RES_CLI3,'no'))='no' AND lOWER(
> NVL(C.RES_CLI4,'no'))='no' AND lOWER(NVL(C.FAX_CLI1,'no'))='no' AND
> lOWER(NVL(C.FAX_CLI2,'no'))='no' AND lOWER(
> NVL(C.MOB_CLI1,'no'))='no' AND lOWER(NVL(C.MOB_CLI2,'no'))='no' ) ) AND
> A.customer_id = C.Customer_id (+) AND s
> ysDate < B.EXPIRY_DATE AND B.ACCOUNT_BALANCE >= B.Credit_Limit AND
> UPPER(B.Status) ='ACTIVE' AND A.customer_id
> = B.Customer_id AND A.login_Id='cnonews'':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Radius::AuthSQL looks for match with
> cnonews
> Thu Aug 12 19:24:34 2004: DEBUG: Query is: 'select NASIDENTIFIER,
> NASPORT,
> ACCTSESSIONID, FRAMEDIPADDRESS from
> RADONLINE where USERNAME='cnonews'':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Radius::AuthSQL ACCEPT:
> Thu Aug 12 19:24:34 2004: DEBUG: Access accepted for cnonews
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Sending to 210.56.8.143 port 1645 ....
> Code: Access-Accept
> Identifier: 25
> Authentic:
> <223><210><135><226><167><187>7<14><169><222><137><232><158><216>Iw
> Attributes:
> Framed-Protocol = PPP
> Service-Type = Framed-User
>
> Thu Aug 12 19:24:34 2004: DEBUG: Packet dump:
> *** Received from 210.56.8.143 port 1646 ....
> Code: Accounting-Request
> Identifier: 214
> Authentic: S<201><169><20>gf:j7<6><182><18>g|<156>4
> Attributes:
> Acct-Session-Id = "00061E4D"
> Framed-Protocol = PPP
> Acct-Session-Time = 0
> Acct-Input-Octets = 110
> Acct-Output-Octets = 112
> Acct-Input-Packets = 4
> Acct-Output-Packets = 5
> Acct-Authentic = RADIUS
> Acct-Status-Type = Alive
> User-Name = "cnonews"
> Acct-Multi-Session-Id = "0003D41A"
> Acct-Link-Count = 1
> Framed-IP-Address = 210.56.9.235
> NAS-Port = 20019
> NAS-Port-Type = ISDN
> Calling-Station-Id = "0519225440"
> Service-Type = Framed-User
> NAS-IP-Address = 210.56.8.143
> Acct-Delay-Time = 0
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Aug 12 19:24:34 2004: DEBUG: Adding session for cnonews,
> 210.56.8.143,
> 20019
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='210.56.8.143' and NAS
> PORT=020019':
>
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSES
> SIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values
> ('cnonews', '210.56.8.143', 020019, '0006
> 1E4D',1092320674, '210.56.9.235', 'ISDN', 'Framed-User')':
>
> Thu Aug 12 19:24:34 2004: DEBUG: Handling with Radius::AuthSQL
> Thu Aug 12 19:24:34 2004: DEBUG: Handling accounting with
> Radius::AuthSQL
> Thu Aug 12 19:24:34 2004: DEBUG: do query is: 'insert into RadiusDump
> (ACCT_AUTHENTIC,ACCT_INPUT_OCTETS,ACCT_IN
> PUT_PACKETS,ACCT_LINK_COUNT,ACCT_MULTI_SESSION_ID,ACCT_OUTPUT_OCTETS,AC
> CT_OU
> TPUT_PACKETS,ACCT_SESSION_ID,ACCT_S
> ESSION_TIME,ACCT_STATUS_TYPE,Acct_Delay_Time,CALLING_STATION_ID,NAS_IP_
> ADDRE
> SS,NAS_PORT,NAS_PORT_TYPE,SERVICE_T
> YPE,TIMESTAMP,USER_NAME) values
> ('RADIUS','110','4','1','0003D41A','112','5','00061E4D','0','Alive','0'
> ,'051
> 922
> 5440','210.56.8.143','20019','ISDN','PPP',to_date ('12 08 2004 19: 24:
> 34','DD MM YYYY HH24:MI:SS'),'cnonews')'
> :
>
> Thu Aug 12 19:24:35 2004: DEBUG: Accounting accepted
> Thu Aug 12 19:24:35 2004: DEBUG: Packet dump:
> *** Sending to 210.56.8.143 port 1646 ....
> Code: Accounting-Response
> Identifier: 214
> Authentic: S<201><169><20>gf:j7<6><182><18>g|<156>4
> Attributes:
>
> Thu Aug 12 19:24:35 2004: DEBUG: Packet dump:
> *** Received from 210.56.8.143 port 1646 ....
> Code: Accounting-Request
> Identifier: 215
> Authentic: R<10>N<128><240><1>`<210><187><247><157><157><146><226>'-
> Attributes:
> Acct-Session-Id = "00061E4E"
> Framed-Protocol = PPP
> Acct-Authentic = RADIUS
> Acct-Status-Type = Start
> User-Name = "cnonews"
> Acct-Multi-Session-Id = "0003D41A"
> Acct-Link-Count = 2
> Framed-IP-Address = 210.56.9.235
> NAS-Port = 20206
> NAS-Port-Type = ISDN
> Calling-Station-Id = "0519225440"
> Service-Type = Framed-User
> NAS-IP-Address = 210.56.8.143
> Acct-Delay-Time = 0
>
> Thu Aug 12 19:24:35 2004: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Aug 12 19:24:35 2004: DEBUG: Adding session for cnonews,
> 210.56.8.143,
> 20206
> Thu Aug 12 19:24:35 2004: DEBUG: do query is: 'delete from RADONLINE
> where
> NASIDENTIFIER='210.56.8.143' and NAS
> PORT=020206':
>
> Thu Aug 12 19:24:35 2004: DEBUG: do query is: 'insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSES
> SIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values
> ('cnonews', '210.56.8.143', 020206, '0006
> 1E4E',1092320675, '210.56.9.235', 'ISDN', 'Framed-User')':
>
> Thu Aug 12 19:24:35 2004: DEBUG: Handling with Radius::AuthSQL
> Thu Aug 12 19:24:35 2004: DEBUG: Handling accounting with
> Radius::AuthSQL
> Thu Aug 12 19:24:35 2004: DEBUG: do query is: 'insert into RadiusDump
> (ACCT_AUTHENTIC,ACCT_LINK_COUNT,ACCT_MULT
> I_SESSION_ID,ACCT_SESSION_ID,ACCT_STATUS_TYPE,Acct_Delay_Time,CALLING_S
> TATIO
> N_ID,NAS_IP_ADDRESS,NAS_PORT,NAS_PO
> RT_TYPE,SERVICE_TYPE,TIMESTAMP,USER_NAME) values
> ('RADIUS','2','0003D41A','00061E4E','Start','0','0519225440','
> 210.56.8.143','20206','ISDN','PPP',to_date ('12 08 2004 19: 24:
> 35','DD MM
> YYYY HH24:MI:SS'),'cnonews')':
>
> Thu Aug 12 19:24:35 2004: DEBUG: Accounting accepted
> Thu Aug 12 19:24:35 2004: DEBUG: Packet dump:
> *** Sending to 210.56.8.143 port 1646 ....
> Code: Accounting-Response
> Identifier: 215
> Authentic: R<10>N<128><240><1>`<210><187><247><157><157><146><226>'-
> Attributes:
>
> Thu Aug 12 19:24:45 2004: DEBUG: Packet dump:
> *** Received from 210.56.8.145 port 1646 ....
>
>
> ########## Note it repeat the two CODES of access-request and
> accountig-request for 2nd login
>
>
>
>
>
>
>
>
> ##########################################
>
>
> please advice, I personaly thing that it seems to be some problem with
> MAX
> tnt
>
> Regards Farooq
>
> ----- Original Message -----
> From: "Hugh Irvine" <hugh at open.com.au>
> To: "Muhammad Farooq Bhatti" <farooq.bhatti at comsats.net.pk>
> Cc: <radiator at open.com.au>
> Sent: Thursday, August 12, 2004 3:52 AM
> Subject: Re: (RADIATOR) Problem of Radiator MAXT TNT
>
>
>>
>> Hello Farooq -
>>
>> Could you please send me a copy of your configuration file (no
>> secrets)
>> together with a trace 4 debug from Radiator showing what is happening
>> with an access request, an accounting start and an accounting stop
>> with
>> both the Cisco and the Ascend.
>>
>> regards
>>
>> Hugh
>>
>>
>> On 13 Aug 2004, at 06:59, Muhammad Farooq Bhatti wrote:
>>
>>> Dear all,
>>>
>>> After doing a lot of search without positive result, finally I am
>>> going to write u.
>>>
>>> I have MAX TNT with 10.1.0 TAOS and Radiator 3.9 , I am getting a
>>> problem of Multi-login where as MPP i.e., multilink is working fine.
>>>
>>> I am using same with Cisco AS5300 without any problem plz let me know
>>> what could be wrong.
>>>
>>> For any further info let me know.
>>>
>>> Muhammad Farooq Bhatti
>>> Assistant Director (Systems)
>>> First Floor, COMSATS Headquarters,
>>> Shahra-e-Jamhuriyat, G-5/2, Islamabad
>>> Ph. +92-51-9208063-5 Ext. 124
>>> Fax. +92-51-9212411
>>> farooq.bhatti at comsats.net.pk
>>> www.comsats.net.pk
>>>
>>
>> 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, MacOS X.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>> -
>> CATool: Private Certificate Authority for Unix and Unix-like systems.
>>
>> --
>> 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, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
--
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