[OpenSIPS-Users] CDRTool 9.1.1

Tijmen de Mes tijmen at ag-projects.com
Tue Mar 26 10:22:34 CET 2013


Hi,

You give the solution yourself. After the normalize the number need to 
be in the form 00XXXX for PSTN destinations.

-- 
Tijmen de Mes
AG Projects


On 03/25/2013 07:38 PM, Willian Mazzardo - SYSSVOIP wrote:
> Hi again.
>
> Trying Rate module, i have this info:
>
> 2013-03-25 15:32:13 	on-net 	559101001 at 187.xXXXXX 	
> 	
> 	audio 	555596XXXXX at 187.5XXXXX 	00:03 	0.0000 	0 	0
>
>
> The rate is 0.0000, but into Rates, I have Destination = 55559 and the 
> tariff.
>
> Into telnet command i tried this:
>
> ShowPrice From=sip:559101001 at 187.XXXXXXX 
> To=sip:00559XXXXX at 187.5XXXXXXX Gateway=187.5XXXXXXX Duration=59
> 0.0525
> Increment: 6 s
>  Min duration: 30 s
>     Duration: 60 s
>          App: audio
>  Destination: 55
>     Customer: subscriber=559101001 at 187.5XXXXXX
>      Connect: 0.0000
>    StartTime: 2013-03-25 15:18:47
> --
>         Span: 1
>     Duration: 60 s
>    ProfileId: grn_premium / weekday
>       RateId: grn_premium / 0-24h
>         Rate: 0.0525 / 60 s
>        Price: 0.0525
>
> but when I put To=sip:555596XXXXXX at 187.XXXXXXX the return is 0.
>
> What am I missing?
>
> Thanks
>
>
> Willian Mazzardo
> Depto TI - SYSSVOIP
> www.syssvoip.com.br <http://www.syssvoip.com.br>
> 55 3537 2030
>
>
> 2013/3/25 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br 
> <mailto:willian at syssvoip.com.br>>
>
>     Hi ... another thing.
>
>     Please review CSV files for importing sample data, because those
>     errors:
>
>     Mar 25 14:10:34 xen cdrtool[31701]: Database error for query
>     insert into log
>     (date,login,ip,url,results,description,datasource,reseller_id)#012
>            values
>     (NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
>     /var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
>     'reedit' doesn't have a default value (1364)
>
>
>     and
>
>
>     Reading file /var/spool/cdrtool/customers.csv
>     Importing customers from /var/spool/cdrtool/customers.csv for
>     reseller 0:
>     Database error for query insert into billing_customers
>                         (
>                         reseller_id,
>                         gateway,
>                         domain,
>                         subscriber,
>                         profile_name1,
>                         profile_name2,
>                         timezone,
>                         profile_name1_alt,
>                         profile_name2_alt
>                         ) values (
>                         '0',
>                         '',
>                         '',
>                         '',
>                         'grn_premium',
>                         'grn_premium',
>                         'Europe/Amsterdam',
>                         '',
>                         ''
>                         ): Field 'increment' doesn't have a default
>     value (1364)Database error for query insert into log
>     (date,login,ip,url,results,description,datasource,reseller_id)
>             values
>     (NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
>     /var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
>     'reedit' doesn't have a default value (1364)Reading file
>     /var/spool/cdrtool/destinations.csv
>
>
>     Thanks
>
>     Willian Mazzardo
>     Depto TI - SYSSVOIP
>     www.syssvoip.com.br <http://www.syssvoip.com.br>
>     55 3537 2030 <tel:55%203537%202030>
>
>
>     2013/3/25 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br
>     <mailto:willian at syssvoip.com.br>>
>
>         Hi ... I`ve made the change in sql.conf
>         from FROM_UNIXTIME(blablabla)  to '%S' and worked.
>
>         now I will see how to get rating work.
>
>         Thanks for your help Tijmen !! great job.
>
>         Willian Mazzardo
>         Depto TI - SYSSVOIP
>         www.syssvoip.com.br <http://www.syssvoip.com.br>
>         55 3537 2030 <tel:55%203537%202030>
>
>
>         2013/3/25 Tijmen de Mes <tijmen at ag-projects.com
>         <mailto:tijmen at ag-projects.com>>
>
>             Hi,
>
>             This is generated by the first radius server the ACC is
>             arriving. If you use only 1 server without any proxy,
>             relay  or forwarding, I guess you can also use the %S
>             since there is no possibility to measure the network delay
>             in this case.
>
>             Best regards,
>
>
>             -- 
>             Tijmen de Mes
>             AG Projects
>
>
>             On 03/25/2013 03:58 PM, Willian Mazzardo - SYSSVOIP wrote:
>>             Yes .. but how ? the filed in there is ${Event-Timestamp}
>>             ... but where is this generated?
>>
>>
>>
>>             Willian Mazzardo
>>             Depto TI - SYSSVOIP
>>             www.syssvoip.com.br <http://www.syssvoip.com.br>
>>             55 3537 2030 <tel:55%203537%202030>
>>
>>
>>             2013/3/25 Tijmen de Mes <tijmen at ag-projects.com
>>             <mailto:tijmen at ag-projects.com>>
>>
>>                 Hi,
>>
>>                 If you find the cause for this, the problem will be
>>                 solved:
>>>
>>>                     You see it FROM_UNIXTIME(), is empty , so that
>>>                     won't work. You have to find out why the
>>>                     event-timestamp attribute is now empty. To give
>>>                     you any hints, what is in the detail file, and
>>>                     in which format, is the attribute only defined
>>>                     once in the dictionaries?
>>>
>>
>>                 -- 
>>                 Tijmen de Mes
>>                 AG Projects
>>
>>
>>                 _______________________________________________
>>                 Users mailing list
>>                 Users at lists.opensips.org
>>                 <mailto:Users at lists.opensips.org>
>>                 http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>>             _______________________________________________
>>             Users mailing list
>>             Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>             http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>             _______________________________________________
>             Users mailing list
>             Users at lists.opensips.org <mailto: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/20130326/b7988367/attachment-0001.htm>


More information about the Users mailing list