[OpenSER-Users] OpenSER + Freeradius + CDRTool

[Dan-Cristian Bogos]

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
>