RE: [Help-gnu-radius] Cisco VOIP Vendor Specific Attributes

[Scott Donovan]

Hi Sergey,

I should have been a little more specific. The tags in the dict/voip appear
to be directly related to the "PACKED" session ID rewrite rules, as apposed
to the Vendor Specific stuff I am seeing.

According to the cisco documentation there are 2 ways of sending the
information. The prefered (and new) is to use the VSA method which pumps out
vendor specific attributes and the oldway (which gnu radius can cope with)
to send them packed inside a acct-session-id. The version of the IOS I am
using no longer supports the packed method it appears.

In the dictionary file I have:

$INCLUDE dict/voip

Sql Server Config:

# Query to be used on session start
acct_start_query     INSERT INTO calls \
                     VALUES(%C{Acct-Status-Type},\
                            '%u',\
                            '%G',\
                            '%C{NAS-IP-Address}',\
                            %C{NAS-Port-Id},\
                            '%C{Acct-Session-Id}',\
                            0,\
                            0,\
                            0,\
                            0,\
                            '%C{Framed-IP-Address}',\
                            '%C{Called-Station-Id}',\
                            '%C{Calling-Station-Id}',\
                            '%C{Voip-Connect-Time}%C{Voip-Connection-ID}
%C{Voip-Disconnect-Cause}')

# Query to be used on session end
acct_stop_query      UPDATE calls \
                     SET status=%C{Acct-Status-Type},\
                         acct_session_time=%C{Acct-Session-Time},\
                         acct_input_octets=%C{Acct-Input-Octets},\
                         acct_output_octets=%C{Acct-Output-Octets},\
                         connect_term_reason=%C{Acct-Terminate-Cause}, \
                         VOIP = '%C{Voip-Connect-Time}%C{Voip-Connection-ID}
%C{Voip-Disconnect-Cause}' \
                     WHERE user_name='%C{User-Name}' \
                       AND status = 1 \
                       AND acct_session_id='%C{Acct-Session-Id}'


The SQL Queries generated (extracted from the sql.log)

INSERT INTO calls VALUES(1,'4425','2002-02-28
22:10:02','192.168.1.2',0,'000004C6',0,0,0,0,'0','063340031','4425',' ');
INSERT INTO calls VALUES(1,'4425','2002-02-28
22:10:01','192.168.1.2',0,'000004C5',0,0,0,0,'0','063340031','4425',' ');
INSERT INTO calls VALUES(1,'4425','2002-02-28
22:10:02','192.168.1.2',0,'000004C6',0,0,0,0,'0','063340031','4425',' ');

Example Stop Record:

Thu Feb 28 15:15:54 2002
        NAS-IP-Address = 192.168.1.2
        NAS-Port-Type = Async
        User-Name = 7102
        Called-Station-Id = 4403
        Calling-Station-Id = 7102
        Acct-Status-Type = Stop
        Service-Type = Login-User
        Vendor-Specific = V9!#h323-gw-id=voip.gw.company.com
        Vendor-Specific = V9\030+h323-conf-id=45637AA2 A82B87C3 1 2685EDA0
        Vendor-Specific = V9\0014h323-incoming-conf-id=45637AA2 A82B87C3 1
2685EDA0
        Vendor-Specific = V9\032\031h323-call-origin=answer
        Vendor-Specific = V9\033\032h323-call-type=Telephony
        Vendor-Specific = V9\0313h323-setup-time=15:15:30.326 AEDT Thu Feb
28 2002
        Vendor-Specific = V9\0345h323-connect-time=15:15:44.807 AEDT Thu Feb
28 2002
        Vendor-Specific = V9\0358h323-disconnect-time=15:15:56.337 AEDT Thu
Feb 28 2002
        Vendor-Specific = V9\036\032h323-disconnect-cause=10
        Vendor-Specific = V9\037\026h323-voice-quality=0
        Acct-Session-Id = 00000225
        Acct-Input-Octets = 23628
        Acct-Output-Octets = 83497
        Acct-Input-Packets = 142
        Acct-Output-Packets = 534
        Acct-Session-Time = 12
        Acct-Delay-Time = 0
        Timestamp = 1014869754
        Request-Authenticator = Unverified



-----Original Message-----
From: Sergey Poznyakoff [mailto:address@hidden
Sent: Thursday, 28 February 2002 7:48 PM
To: Scott Donovan
Cc: address@hidden
Subject: Re: [Help-gnu-radius] Cisco VOIP Vendor Specific Attributes


> Could someone give me a quick heads up on how to get these defined so I
can
> inject them with the INSERT into the Mysql Database ?

Uncomment the following line in your raddb/dictionary:

#$INCLUDE dict/cisco

Regards,
Sergey