[RADIATOR] Question about AuthByPolicy anything else and AuthBy SQL

Ricardo Martinez rmartinez at redvoiss.net
Wed Jun 27 15:23:11 CDT 2012


Hello.

I’m using Radiator 3.1.13



I have this configuration file :



<Handler Request-Type = Accounting-Request, Acct-Status-Type = Stop>

        <AuthBy GROUP>

                AuthByPolicy anything else

                <AuthBy SQL>

                        DBSource                dbi:Oracle:DEV

                        DBusername              user

                        DBAuth                      pass

                        FailureBackoffTime      60



                        AccountingTable VOIPACCOUNTING2

                        AcctColumnDef
LOGGEDAT,%{GlobalVar:DBsysdate},literal

                        AcctColumnDef   CALL_LEG_SETUP_TIME,h323-setup-time

                        AcctColumnDef   GATEWAY_IDENTIFIER,h323-gw-id

                        AcctColumnDef   CONNECTION_ID,h323-conf-id

                        AcctColumnDef   CALL_LEG_DIRECTION,h323-call-origin

                        AcctColumnDef   CALL_LEG_TYPE,h323-call-type

                        AcctColumnDef
CALL_LEG_CONNECT_TIME,h323-connect-time

                        AcctColumnDef
CALL_LEG_DISCONNECT_TIME,h323-disconnect-time

                        AcctColumnDef
CALL_LEG_DISCONNECT_CAUSE,h323-disconnect-cause

                        AcctColumnDef
REMOTE_GATEWAY_IP_ADDRESS,h323-remote-address

                        AcctColumnDef   VOICE_QUALITY,h323-voice-quality

                        AcctColumnDef   USER_NAME,User-Name

                        AcctColumnDef   CALLED_STATION_ID,Called-Station-Id

                        AcctColumnDef
CALLING_STATION_ID,Calling-Station-Id

                        AcctColumnDef
ACCT_STATUS_TYPE,Acct-Status-Type,integer

                        AcctColumnDef
ACCT_DELAY_TIME,Acct-Delay-Time,integer

                        AcctColumnDef
ACCT_INPUT_OCTETS,Acct-Input-Octets,integer

                        AcctColumnDef
ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer

                        AcctColumnDef   ACCT_SESSION_ID,Acct-Session-Id

                        AcctColumnDef
ACCT_SESSION_TIME,Acct-Session-Time,integer

                        AcctColumnDef
ACCT_INPUT_PACKETS,Acct-Input-Packets,integer

                        AcctColumnDef
ACCT_OUTPUT_PACKETS,Acct-Output-Packets,integer

                        AcctColumnDef   NAS_PORT_TYPE,NAS-Port-Type,integer

                        AcctColumnDef   ACCESS_DEVICE,h323-gw-id

                        AcctColumnDef
NETWORK_DEVICE_GROUP,Acct-Status-Type,intege

                </AuthBy>

                <AuthBy SQL>

                        DBSource                dbi:Oracle:SID1

                        DBUsername              user

                        DBAuth                        pass

                        FailureBackoffTime      60



                        AccountingTable VOIPACCOUNTING2

                        AcctColumnDef
LOGGEDAT,%{GlobalVar:DBsysdate},literal

                        AcctColumnDef   CALL_LEG_SETUP_TIME,h323-setup-time

                        AcctColumnDef   GATEWAY_IDENTIFIER,h323-gw-id

                        AcctColumnDef   CONNECTION_ID,h323-conf-id

                        AcctColumnDef   CALL_LEG_DIRECTION,h323-call-origin

                        AcctColumnDef   CALL_LEG_TYPE,h323-call-type

                        AcctColumnDef
CALL_LEG_CONNECT_TIME,h323-connect-time

                        AcctColumnDef
CALL_LEG_DISCONNECT_TIME,h323-disconnect-time

                        AcctColumnDef
CALL_LEG_DISCONNECT_CAUSE,h323-disconnect-cause

                        AcctColumnDef
REMOTE_GATEWAY_IP_ADDRESS,h323-remote-address

                        AcctColumnDef   VOICE_QUALITY,h323-voice-quality

                        AcctColumnDef   USER_NAME,User-Name

                        AcctColumnDef   CALLED_STATION_ID,Called-Station-Id

                        AcctColumnDef
CALLING_STATION_ID,Calling-Station-Id

                        AcctColumnDef
ACCT_STATUS_TYPE,Acct-Status-Type,integer

                        AcctColumnDef   ACCT_DELAY_TIME,Acct-Delay-Time

                        AcctColumnDef   ACCT_INPUT_OCTETS,Acct-Input-Octets

                        AcctColumnDef
ACCT_OUTPUT_OCTETS,Acct-Output-Octets

                        AcctColumnDef   ACCT_SESSION_ID,Acct-Session-Id

                        AcctColumnDef   ACCT_SESSION_TIME,Acct-Session-Time

                        AcctColumnDef
ACCT_INPUT_PACKETS,Acct-Input-Packets

                        AcctColumnDef
ACCT_OUTPUT_PACKETS,Acct-Output-Packets

                        AcctColumnDef   NAS_PORT_TYPE,NAS-Port-Type,integer

                        AcctColumnDef   ACCESS_DEVICE,h323-gw-id

                        AcctColumnDef
NETWORK_DEVICE_GROUP,Acct-Status-Type,integer

                </AuthBy>

        </AuthBy>



        # Log accounting to a detail file. %D is replaced by DbDir above

        AcctLogFileName %L/acct/%Y/VoIP_Acct_%Y.%m.%d.%q.csv



        PostProcessingHook file:"%D/NAS_Stats"



</Handler>



When I see the debug I get this :



Code:       Accounting-Request

Identifier: 169

Authentic:  <142><223>lD<30><195>[4<30><135>/<155><133><2><204>:

Attributes:

        NAS-IP-Address = 64.76.155.44

        User-Name = "51121000537485571"

        Calling-Station-Id = "51121000537485571"

        Called-Station-Id = "02580056974833290"

        Acct-Status-Type = Stop

        Service-Type = Login-User

        Acct-Delay-Time = 0

        Acct-Session-Id = "376634662D651"

        CALL-ID =
"CALL-ID=d87f4f4e-ef90-42ab-cbd2-0002a4051f26 at 10.104.57.2-b2b_1"

        Acct-Session-Time = 46

        cisco-h323-connect-time = "h323-connect-time=16:19:17.895 CMT Wed
Jun 27 2012"

        cisco-h323-disconnect-time = "h323-disconnect-time=16:20:03.075 CMT
Wed Jun 27 2012"

        cisco-h323-disconnect-cause = "h323-disconnect-cause=10"

        IMSI = "IMSI=730020700332516"

        cisco-h323-setup-time = "h323-setup-time=16:19:09.055 CMT Wed Jun
27 2012"

        cisco-h323-call-origin = "h323-call-origin=originate"

        cisco-h323-call-type = "h323-call-type=Telephony"

        cisco-h323-conf-id = "h323-conf-id=BD6A EB4F0010 8EF3155C 7E0CBC81"

        cisco-avpair = "h323-incoming-conf-id=0 0 0 0"

        cisco-h323-remote-address = "h323-remote-address=64.76.154.36"

        cisco-avpair = "h323-remote-id=51121000537485571 at 64.76.154.149:5060"

        cisco-h323-gw-id = "h323-gw-id=iGate05"



Wed Jun 27 16:20:03 2012: DEBUG: DST: 0

Wed Jun 27 16:20:03 2012: DEBUG: Handling request with Handler
'Request-Type = Accounting-Request, Acct-Status-Type = Stop'

Wed Jun 27 16:20:03 2012: DEBUG:  Deleting session for 51121000537485571,
64.76.155.44,

Wed Jun 27 16:20:03 2012: DEBUG: Handling with Radius::AuthGROUP

Wed Jun 27 16:20:03 2012: DEBUG: Handling with Radius::AuthSQL

Wed Jun 27 16:20:03 2012: DEBUG: Handling accounting with Radius::AuthSQL

Wed Jun 27 16:20:03 2012: DEBUG: do query is: 'insert into VOIPACCOUNTING2
(ACCESS_DEVICE,ACCT_DELAY_TIME,ACCT_SESSION_ID,ACCT_SESSION_TIME,ACCT_STATUS_TYPE,CALLED_STATION_ID,CALLING_STATION_ID,CALL_LEG_CONNECT_TIME,CALL_LEG_DIRECTION,CALL_LEG_DISCONNECT_CAUSE,CALL_LEG_DISCONNECT_TIME,CALL_LEG_SETUP_TIME,CALL_LEG_TYPE,CONNECTION_ID,GATEWAY_IDENTIFIER,LOGGEDAT,NETWORK_DEVICE_GROUP,USER_NAME)
values (,0,,46,2,,,,,,,,,,,sysdate,2,)':

Wed Jun 27 16:20:03 2012: DEBUG: Handling with Radius::AuthSQL

Wed Jun 27 16:20:03 2012: DEBUG: Handling accounting with Radius::AuthSQL

Wed Jun 27 16:20:03 2012: DEBUG: do query is: 'insert into VOIPACCOUNTING2
(ACCESS_DEVICE,ACCT_DELAY_TIME,ACCT_SESSION_ID,ACCT_SESSION_TIME,ACCT_STATUS_TYPE,CALLED_STATION_ID,CALLING_STATION_ID,CALL_LEG_CONNECT_TIME,CALL_LEG_DIRECTION,CALL_LEG_DISCONNECT_CAUSE,CALL_LEG_DISCONNECT_TIME,CALL_LEG_SETUP_TIME,CALL_LEG_TYPE,CONNECTION_ID,GATEWAY_IDENTIFIER,LOGGEDAT,NETWORK_DEVICE_GROUP,USER_NAME)
values
('iGate05','0','376634662D651','46',2,'02580056974833290','51121000537485571','16:19:17.895
CHILE Wed Jun 27 2012','originate','10','16:20:03.075 CMT Wed Jun 27
2012','16:19:09.055 CMT Wed Jun 27 2012','Telephony','BD6A EB4F0010
8EF3155C 7E0CBC81','iGate05',sysdate,2,'51121000537485571')':

Wed Jun 27 16:20:03 2012: DEBUG: AuthBy GROUP result: ACCEPT,

Wed Jun 27 16:20:03 2012: DEBUG: Accounting accepted

* *

* *

*Why the first insert does not have all the values ???????*

* *

* *

* *

*Regards,*

*Ricardo.-*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20120627/7a82a7eb/attachment-0001.html 


More information about the radiator mailing list