[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