[OpenSIPS-Users] CDRtool loading data from Asterisk and multiple profiles

[Adria Vidal]

I'm performing some CDR rating with CDRtool, and would like to have
multiple ratings depending on domain or customer.

customers table

id reseller_id gateway domain subscriber profile_name1 profile_name1_alt
profile_name2 profile_name2_alt timezone increment min_duration
11 0 domainA.net domainA_default grn_premium domainA_default grn_premium
Europe/Amsterdam 0 0
18 0 domainB.net grn_premium grn_premium Europe/Amsterdam 0 0
17 0 62890009 <javascript:dialecticDial('17%200%2062890009');>@domainA.net
linea900_profile grn_premium linea900_profile grn_premium Europe/Amsterdam
0 0


asterisk_cdr table

id src dst calldate clid dcontext channel dstchannel lastapp lastdata
duration billsec disposition amaflags accountcode uniqueid userfield
DestinationId Rate Price Normalized
41800 62890000 <javascript:dialecticDial('41800%2062890000');> 34699980125
2012-10-01 <javascript:dialecticDial('34699980125%202012-10-01');> 17:27:47
62890000 0 373 <javascript:dialecticDial('47%2062890000%200%20373');> 0 0 0
346 Duration: 373 s

Only using domainA.net at dcontext i get correct rating, everything else is
rated as Default with

ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346 default
Profile=linea900_profile Period=weekday Rate=linea900 Interval=0-24
Cost=0.4568/60 Price=2.8398 PriceIn=0.0000


 after putting in dcontext domainA.net i get

 ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346
domain=domainA.net Profile=domainA_default Period=weekday
Rate=domainA_default Interval=0-24 Cost=0.0900/60 Price=0.5595
PriceIn=0.0000


 and trying with the secondary domain domainB it's ignored and rated as
domainA.net

 ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346
domain=domainA.net Profile=domainA_default Period=weekday
Rate=domainA_default Interval=0-24 Cost=0.0900/60 Price=0.5595
PriceIn=0.0000

 Tried too using domain at src user@


 There is some way to get diferent rates from these data?

--

Adrià Vidal Romero
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121108/90ee5473/attachment.htm>