<div dir="ltr">Hi ... another thing.<div><br></div><div style>Please review CSV files for importing sample data, because those errors:</div><div style><br></div><div style><div>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)</div>
<div><br></div><div><br></div><div style>and</div><div style><br></div><div style><br></div><div style><div>Reading file /var/spool/cdrtool/customers.csv</div><div>Importing customers from /var/spool/cdrtool/customers.csv for reseller 0:</div>
<div>Database error for query insert into billing_customers</div><div> (</div><div> reseller_id,</div><div> gateway,</div><div> domain,</div><div>
subscriber,</div><div> profile_name1,</div><div> profile_name2,</div><div> timezone,</div><div> profile_name1_alt,</div><div>
profile_name2_alt</div><div> ) values (</div><div> '0',</div><div> '',</div><div> '',</div><div> '',</div>
<div> 'grn_premium',</div><div> 'grn_premium',</div><div> 'Europe/Amsterdam',</div><div> '',</div><div> ''</div>
<div> ): 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)</div><div> 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</div>
<div><br></div><div><br></div><div style>Thanks</div></div></div></div><div class="gmail_extra"><br clear="all"><div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br">www.syssvoip.com.br</a><br>
55 3537 2030</div>
<br><br><div class="gmail_quote">2013/3/25 Willian Mazzardo - SYSSVOIP <span dir="ltr"><<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi ... I`ve made the change in sql.conf from FROM_UNIXTIME(blablabla) to '%S' and worked.<div><br></div><div>now I will see how to get rating work.</div><div><br></div><div>Thanks for your help Tijmen !! great job.</div>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br clear="all"><div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br><a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<br><br><div class="gmail_quote">2013/3/25 Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi,<br>
<br>
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.<br>
<br>
Best regards,<div><br>
<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<br></div><div><div>
On 03/25/2013 03:58 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div></div></div><div><div>
<blockquote type="cite">
<div dir="ltr">Yes .. but how ? the filed in there is
${Event-Timestamp} ... but where is this generated?
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>Willian Mazzardo<br>
Depto TI - SYSSVOIP<br>
<a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br>
<a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<br>
<br>
<div class="gmail_quote">2013/3/25 Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi,<br>
<br>
If you find the cause for this, the problem will be
solved: <br>
<div>
<blockquote type="cite">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div> You see it <span style="white-space:pre-wrap"></span>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?<br>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<br>
</div>
<div>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
</div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>