[OpenSIPS-Users] CDRTool 9.1.1

Willian Mazzardo - SYSSVOIP willian at syssvoip.com.br
Mon Mar 25 19:38:27 CET 2013


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 00

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.5XXXXXXXGateway=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
55 3537 2030


2013/3/25 Willian Mazzardo - SYSSVOIP <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
> 55 3537 2030
>
>
> 2013/3/25 Willian Mazzardo - SYSSVOIP <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
>> 55 3537 2030
>>
>>
>> 2013/3/25 Tijmen de Mes <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
>>> 55 3537 2030
>>>
>>>
>>> 2013/3/25 Tijmen de Mes <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
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130325/898b1cb5/attachment.htm>


More information about the Users mailing list