[OpenSIPS-Users] CDRTool 9.1.1

[Willian Mazzardo - SYSSVOIP]

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/b8b845de/attachment-0001.htm>