<div dir="ltr">Hi again.<div><br></div><div>Trying Rate module, i have this info:</div><div><br></div><div><table class="" style="max-width:100%;background-color:transparent;border-collapse:collapse;border-spacing:0px;width:1205px;margin-bottom:14px;color:rgb(51,51,51);font-family:Verdana,Arial,Telex,sans-serif;font-size:11px;line-height:14px">
<tbody><tr rel="tooltip"><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">2013-03-25 15:32:13</td>
<td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">on-net</td><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">
559101001@187.xXXXXX</td><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)"></td><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">
</td><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">audio</td><td valign="top" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">
555596XXXXX@187.5XXXXX</td><td valign="top" align="right" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">00:03</td>
<td valign="top" align="right" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">0.0000</td><td valign="top" align="right" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">
0</td><td valign="top" align="right" style="padding:4px 5px;vertical-align:top;border-top-width:1px;border-top-style:solid;border-top-color:rgb(221,221,221);background-color:rgb(245,245,245)">0</td></tr></tbody></table></div>
<div><br></div><div style>The rate is 0.0000, but into Rates, I have Destination = 55559 and the tariff.</div><div style><br></div><div style>Into telnet command i tried this:</div><div style><br></div><div style><div>ShowPrice From=sip:559101001@187.XXXXXXX To=sip:00559XXXXX@187.5XXXXXXX Gateway=187.5XXXXXXX Duration=59 </div>
<div>0.0525</div><div>Increment: 6 s</div><div> Min duration: 30 s</div><div> Duration: 60 s</div><div> App: audio</div><div> Destination: 55</div><div> Customer: subscriber=559101001@187.5XXXXXX</div><div>
Connect: 0.0000</div>
<div> StartTime: 2013-03-25 15:18:47</div><div>--</div><div> Span: 1</div><div> Duration: 60 s</div><div> ProfileId: grn_premium / weekday</div><div> RateId: grn_premium / 0-24h</div><div> Rate: 0.0525 / 60 s</div>
<div> Price: 0.0525</div><div><br></div><div style>but when I put To=sip:555596XXXXXX@187.XXXXXXX the return is 0.</div><div style><br></div><div style>What am I missing?</div><div style><br></div><div style>Thanks</div>
</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">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 ... another thing.<div><br></div><div>Please review CSV files for importing sample data, because those errors:</div><div><br></div><div><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>and</div><div><br></div><div><br></div><div><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>Thanks</div></div></div></div><div class="gmail_extra"><div class="im"><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><div><div class="h5"><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><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">
<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></div></div>
</blockquote></div><br></div>