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