<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">&lt;<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>&gt;</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(),&#39;ImportScript&#39;,&#39;localhost&#39;,&#39;customers.csv-e50d270391eb500aea66cc52600888d4&#39;,&#39;&#39;,&#39;Imported /var/spool/cdrtool/customers.csv&#39;,&#39;/var/spool/cdrtool&#39;,0): Field &#39;reedit&#39; doesn&#39;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>                    &#39;0&#39;,</div><div>                    &#39;&#39;,</div><div>                    &#39;&#39;,</div><div>                    &#39;&#39;,</div>


<div>                    &#39;grn_premium&#39;,</div><div>                    &#39;grn_premium&#39;,</div><div>                    &#39;Europe/Amsterdam&#39;,</div><div>                    &#39;&#39;,</div><div>                    &#39;&#39;</div>


<div>                    ): Field &#39;increment&#39; doesn&#39;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(),&#39;ImportScript&#39;,&#39;localhost&#39;,&#39;customers.csv-e50d270391eb500aea66cc52600888d4&#39;,&#39;&#39;,&#39;Imported /var/spool/cdrtool/customers.csv&#39;,&#39;/var/spool/cdrtool&#39;,0): Field &#39;reedit&#39; doesn&#39;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">&lt;<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>&gt;</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 &#39;%S&#39; 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">&lt;<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>&gt;</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">&lt;<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>&gt;</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&#39;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>