[OpenSER-Users] OpenSER + Freeradius + CDRTool

[Marc LEURENT]

You were right, The CDRTool query looks strange and use Billing-Party to set the UserName,
I have to debug the radius_extra option documentation from the CDRTool installation

accounting_start_query      = "\
          CALL insert_radacct_record( \
                'radius', \
                '%{Acct-Session-Id}', \
                '%{Acct-Unique-Session-Id}', \
                '%{Billing-Party}', \
                '%{Billing-Party}', \
                '%{SIP-Proxy-IP}', \
                '%{NAS-Port}', \
                '%S', \
                '0', \
                '0', \
                '0', \
                '0', \
                '%{Called-Station-Id}', \
                '%{Calling-Station-Id}', \
                '%{Sip-Response-Code}', \
                '%{Service-Type}', \
                '%{Framed-Protocol}', \
                '%{Framed-IP-Address}', \
                '%{Acct-Delay-Time}', \
                '0', \
                '%{Sip-Response-Code}', \
                '%{Sip-Method}', \
                '%{Sip-Translated-Request-URI}', \
                '%{Sip-To-Tag}', \
                '%{Sip-From-Tag}', \
                '%{Sip-RPId}', \
                '%{Source-IP}', \
                '%{Source-Port}', \
                '%{Canonical-URI}', \
                '', \
                '' \
                )"






Dan-Cristian Bogos a écrit :
> Hi Marc,
> 
> I would suggest that u check your freeradius sql queries, and make
> sure that u insert properly the username in - proper form should be
> %{User-Name}. Also make sure that u send additional parameters (extra
> accounting) from openser in order to see the called and calling
> parties.
> 
> Cheers,
> DanB
> 
> On 7/30/07, Marc LEURENT <lftsy at free.fr> wrote:
>> Hello, I'm still trying to get openser + freeradius + cdrtool working together
>> I have stil one problem, it's that UserName are not stored in the acct database, whereas they are displayed in the aact logs
>> Any piece of advice will be welcome
>> Thanks
>>
>>
>> This is a view of the CDRTool interface: SIP Caller, In, SIP destination, don't appear in the database!
>> Id      Start time      SIP Proxy       SIP caller      In      SIP destination         Out     Dur     Price   KBIn    KBOut   Status          Codec
>> 3N      2007-07-30 10:00:19                                                                     05:22           0.00    0.00    Ok (200)
>>
>> Signalling information
>>         Session:         1ec37-c0a80101-0-2 at 192.168.95.4
>>         Start time:     2007-07-30 10:00:19 Europe/Paris
>>         Stop time:      2007-07-30 10:05:41 Europe/Paris
>>         Method:         INVITE from :
>>         From:
>>         Dialed URI:
>>         Next hop URI:
>>         Billing Party:
>>
>>
>>
>> This is a part of the acct log
>> Mon Jul 30 13:55:19 2007
>>         Acct-Status-Type = Start
>>         Service-Type = Sip-Session
>>         Sip-Response-Code = 200
>>         Sip-Method = INVITE
>>         Event-Timestamp = "Jul 30 2007 13:55:19 CEST"
>>         Sip-From-Tag = "c0a80101-6e0646"
>>         Sip-To-Tag = "c0a80101-888e30"
>>         Acct-Session-Id = "3f9aaaf-c0a80101-0-10 at 192.168.95.4"
>>         Sip-Src-IP = "192.168.95.4"
>>         Sip-Src-Port = "5060"
>>         User-Agent = "THOMSON ST2030 hw0 fw1.50 00-0E-50-4E-AF-AE"
>>         User-Name = "105"
>>         NAS-Port = 5060
>>         Acct-Delay-Time = 0
>>         NAS-IP-Address = 192.168.95.248
>>         Client-IP-Address = 192.168.95.248
>>         Acct-Unique-Session-Id = "694a4cf65dd7fd9f"
>>         Timestamp = 1185796519
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>