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 >