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 [email protected], 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 <[email protected]> wrote: > Hi Samuel, > > A domain can be defined in the billing_customers table. In your case > testintern.domain.com <[email protected]>. 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:[email protected] Gateway=X.Y.Z.W To=sip > :[email protected].. > > ## > 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 [email protected], > 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 > [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 > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
