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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> 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 = "[EMAIL PROTECTED]" >> 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@openser.org >> http://openser.org/cgi-bin/mailman/listinfo/users >> _______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users