[OpenSIPS-Users] CDRTool prepaid bebits correct customer with wrong pricing of another

[Jan Baumann]

Hi,

thank you for the quick answer.
I at least think I did the mirgration of the mysql structures correctly. 
Everything else works as expected and with no sql errors.

I am using latest php 5.3.6 and mysql 5.1.51, both compiled from source.
Upgrade was performed due to problems with the ratingengine loosing the 
mysql connection and failing to reconnect once every day. That was a 
show-stopper for prepaid in the past and seems to be fixed now.

Can you tell me where to find (and debug) the mysql query that selects 
the customer and profiles in the case of prepaid calls? Can I increase 
the logging verbosity?

Thank you and
Best Regards,

Jan





Am 30.06.11 15:06, schrieb Tijmen de Mes:
> Hi,
>
> We have never seen this before. Have you done al the migration steps
> required to go to 8.1.2?
>
> Also which php version are you using?
>
> Best regards,
>
> Tijmen de Mes
> AG Projects.
>
> Op 6/30/11 1:40 PM, Jan Baumann schreef:
>> Good afternoon,
>>
>> I have updated to CDRTool 8.1.2, callcontrol 2.0.12 and mediaproxy
>> 2.5.0 running together with an older opensips 1.5.3.
>> Everything works perfectly for postpaid calls.
>>
>> I now have come across very strange behaviour when testing prepaid calls.
>> After terminating a prepaid call I get the following syslog - all with
>> the same callid and surely belonging together.
>> "Default" is the name of the fallback billing profile for all customer
>> accounts.
>> The calling user has in fact assigned a dedicated rating plan
>> "euroflat" with free calls to Austria.
>>
>> When user 0821723xxx now calls to Austria the prepaid system uses the
>> rating profile of subscriber 08219987xyz(!) to calculate the pricing
>> and debits 0821723xxx's prepaid account with the inappropriate default
>> rate of the wrong other customer.
>> The wrongly chosen 08219987xyz seems a random, but always the same
>> choice, even for different prepaid callers. If I delete the
>> 08219987xyz user the system chooses another wrong one and sticks with
>> that.
>>
>> Immediately after prepaid call ends:
>> First line wrong customer choice, second line correct caller's balance
>> debited with wrong rate:
>>
>> Jun 30 13:12:24 voip cdrtool[4901]: Increment=60 MinDuration=60
>> ConnectFee=0.0000 CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1
>> Duration=60 DestId=43 subscriber=08219987xxx at mysipserver.de
>> Profile=default Period=weekday Rate=default Interval=0-24
>> Cost=0.0250/60 Price=0.0250 PriceIn=0.0181
>> Jun 30 13:12:24 voip cdrtool[4901]: DebitBalance=0.0250 Duration=4
>> CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5pBillingParty=0821723xxx at mysipserver.de
>> DestId=43 MaxSessionTime=0 Counter=1->0
>>
>>
>> When cron normalizes the radius CDRs 2 min. later (or I renormalize
>> from the web GUI) it grabs the correct profile for the correct customer:
>>
>> Jun 30 13:15:02 voip cdrtool[5305]: Increment=60 MinDuration=60
>> ConnectFee=0.0000 CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1
>> Duration=60 DestId=43 subscriber=0821723xxx at mysipserver.de
>> Profile=euroflat Period=weekday Rate=euroflat Interval=0-24
>> Cost=0.0000/60 Price=0.0000 PriceIn=0.0181
>>
>>
>> Any ideas what can be going on there???
>>
>> Thank you and
>> Kind Regards,
>>
>> Jan Baumann
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users