<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
You give the solution yourself. After the normalize the number
need to be in the form 00XXXX for PSTN destinations.<br>
<pre class="moz-signature" cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
On 03/25/2013 07:38 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div>
<blockquote
cite="mid:CAL2ykgGEBwD9PAOUT7zNMMTB9C1t6v=95fbOrtVk_=aZnUgvKA@mail.gmail.com"
type="cite">
<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 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)"
valign="top">2013-03-25 15:32:13</td>
<td 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)"
valign="top">on-net</td>
<td 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)"
valign="top">
<a class="moz-txt-link-abbreviated" href="mailto:559101001@187.xXXXXX">559101001@187.xXXXXX</a></td>
<td 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)"
valign="top"><br>
</td>
<td 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)"
valign="top">
<br>
</td>
<td 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)"
valign="top">audio</td>
<td 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)"
valign="top">
<a class="moz-txt-link-abbreviated" href="mailto:555596XXXXX@187.5XXXXX">555596XXXXX@187.5XXXXX</a></td>
<td 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)"
valign="top" align="right">00:03</td>
<td 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)"
valign="top" align="right">0.0000</td>
<td 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)"
valign="top" align="right">
0</td>
<td 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)"
valign="top" align="right">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 <a class="moz-txt-link-abbreviated" href="mailto:From=sip:559101001@187.XXXXXXX">From=sip:559101001@187.XXXXXXX</a>
<a class="moz-txt-link-abbreviated" href="mailto:To=sip:00559XXXXX@187.5XXXXXXX">To=sip:00559XXXXX@187.5XXXXXXX</a> 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: <a class="moz-txt-link-abbreviated" href="mailto:subscriber=559101001@187.5XXXXXX">subscriber=559101001@187.5XXXXXX</a></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 <a class="moz-txt-link-abbreviated" href="mailto:To=sip:555596XXXXXX@187.XXXXXXX">To=sip:555596XXXXXX@187.XXXXXXX</a>
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br>
<a moz-do-not-send="true" 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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.syssvoip.com.br"
target="_blank">www.syssvoip.com.br</a><br>
<a moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.syssvoip.com.br"
target="_blank">www.syssvoip.com.br</a><br>
<a moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>