30 Jul
2007
30 Jul
'07
8:36 a.m.
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(a)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(a)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(a)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(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>