[OpenSIPS-Users] domain in prepaid scenarios not honoured

[samuel]

great to know!

That's what it looked like and just wanted to get reliable confirmation.

Thanks a lot!

Samuel.

On 14 February 2012 12:48, Adrian Georgescu <ag at ag-projects.com> wrote:

> CDRTool Prepaid Engine was designed to work for individual SIP accounts,
> not for entire domains.
>
> Adrian
>
> On Feb 14, 2012, at 12:04 PM, samuel wrote:
>
> The domain is already in the billing_customers table with the
> corresponding timezone.
>
> The problem, as far as I could see, was that in the SQL query retrieving
> the customer the domain was not set and only billing_party and gateway, as
> states the following line of the log I sent:
>
> billing party=mas at testintern.domain.com, domain=, gateway=X.Y.Z.W
>
> Since only the domain is stored in the customers table is set, the
> previous query did not return any value and the callcontrol->cdrtool
> connection returned error (which should be changed from the timezone to the
> customer not found.)
>
> Thanks a lot for taking a look at it, case you need more infromation, I
> can surely provide it.
>
> Best regards,
> Samuel
>
> On 14 February 2012 10:00, Tijmen de Mes <tijmen at ag-projects.com> wrote:
>
>>  Hi Samuel,
>>
>> A domain can be defined in the billing_customers table. In your case
>> testintern.domain.com <0034123456789 at testintern.domain.com>. You should
>> also add the timezone to this domain in the same table.
>>
>> If this still does not work, and like you said, the domain is not
>> properly split/retrieved from the uri, I've to look deeper in the code why
>> this can happen.
>>
>> So can you please add the domain and let me know the outcome?
>>
>> Best regards,
>>
>> --
>> Tijmen de Mes
>> AG Projects
>>
>>
>> On 02/13/2012 05:30 PM, samuel wrote:
>>
>> Hi all,
>>
>> Recently I was playing with the prepaid functionallity of CDRTool (8.2.3)
>> and found out that when the customer is not explicitely defined in the
>> field Subscriber, the domain is not looked up.
>> I have opensips (1.7.1) with call control application from apt sources
>> (2.0.15) and when the following call is sent:
>>
>> sent from opensips to CDRTool:
>>   MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53
>> From=sip:mas at testintern.domain.com Gateway=X.Y.Z.W To=sip
>>   :0034123456789 at testintern.domain.com..
>>
>> ##
>> reply from CDRTool
>>   error: cannot figure out the billing timezone.type=prepaid.type=prepaid
>>
>> Looking in the syslog we find the right answer:
>> Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in
>> billing_customers table for billing party=mas at testintern.domain.com,
>> domain=, gateway=X.Y.Z.W
>> Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the
>> billing timezone#012type=prepaid
>>
>> so it looks like the domain is not extracted from the user part and it is
>> not checked in the billing_customers table. The query in the function
>> lookupProfiles  (file rating.php) uses $this->dictionary['domain'] as the
>> source for the domain but in the prepaid scenario, this parameter hasn't
>> got a value. Am I right?
>>
>> I've tried to dig further in the code but unfortunately got lost in the
>> exportation of the CDR's dictionary to the function that is used in prepaid
>> scenarios.
>>
>> Is there any option I'm missing? Is it possible to setup just the domain
>> in the billing_customers table and not a line foreach prepaid customer?
>>
>> Congratulations for the project and thanks in advance,
>> Samuel
>>
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120214/079ce5aa/attachment-0001.htm>