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 [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. 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 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 > > > _______________________________________________ > 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
