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 [email protected]
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=0821723...@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 [email protected]
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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
