<div dir="ltr">Rate-o-mat keeps crashing...<br><pre style="color:rgb(0,0,0)">:~# tail -f /var/log/ngcp/rate-o-mat.log
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Trying to connect to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Successfully connected to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr time balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr relation column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr cash balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr tag column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Up and running.
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Grabbed 9 CDRs
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: 1/9 - rate CDR ID 38
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Caught DBI:err 1690</pre><pre style="color:rgb(0,0,0)"><br></pre><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div><div style="font-family:sans-serif;font-size:13px"><p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best Regards<u></u><u></u></p><p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small"><u></u> <u></u></p><div style="font-family:Arial,Helvetica,sans-serif;font-size:small"><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><br></span></b></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" target="_blank">a</a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span></p><p class="MsoNormal"><span style="color:rgb(36,64,97);font-size:13.3333px">Skype: </span><u style="color:rgb(36,64,97);font-size:13.3333px"><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" target="_blank">a</a>fang.emmanuel</u><br></p></div></div></div><div><br></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<tt>You can try to enable rate-o-mat debug level:<br>
<br>
cat /mnt/glusterfs/home/dgrotti# cat /etc/default/ngcp-rate-o-mat<br>
<br>
# Options for the NGCP rate-o-mat<br>
RATEOMAT_DEBUG=2<br>
...<br>
...<br>
<br>
<br>
There restart rate-o-mat and check again the log.<br>
<br>
</tt>
<pre class="gmail-m_3445417585441005905moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_3445417585441005905moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_3445417585441005905moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div class="gmail-m_3445417585441005905moz-cite-prefix">On 3/12/19 3:50 PM, EMMANUEL AFANG
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">The CallID for CDR 39 is <span>97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE<br>
</span>Everything is auto generated.
<div><br clear="all">
<div>
<div dir="ltr" class="gmail-m_3445417585441005905gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div style="font-family:sans-serif;font-size:13px">
<p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" target="_blank">a</a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span></p>
<p class="MsoNormal"><span style="color:rgb(36,64,97);font-size:13.3333px">Skype: </span><u style="color:rgb(36,64,97);font-size:13.3333px"><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" target="_blank">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Mar 12, 2019 at 3:46
PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> <tt>Hi,<br>
do you maybe have some string value out of range in CDR id
39 ?<br>
<br>
<b><br>
</b><b>Error: 1690</b> SQLSTATE: 22003
(ER_DATA_OUT_OF_RANGE)<br>
Message: %s value is out of range in '%s'<b><br>
<br>
<br>
<br>
</b></tt>
<pre class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-cite-prefix">On
3/12/19 3:38 PM, EMMANUEL AFANG wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="auto">Rate-o-mat service failed with the
following log:
<div dir="auto">
<pre style="color:rgb(0,0,0)">:~# tail -f /var/log/ngcp/rate-o-mat.log
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 37
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 11 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 11 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 38
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Caught DBI:err 1690</pre>
<br>
<div dir="auto">Best Regards,<br>
<br>
Afang Emmanuel<br>
<br>
Mobile: +234 708 428 0332<br>
Skype: Afang.Emmanuel<br>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Mar 12, 2019,
2:02 PM EMMANUEL AFANG <<a href="mailto:afang.emmanuel@gmail.com" target="_blank">afang.emmanuel@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi<br>
I configured rate for customer with direction out.
CDR still shows a cost of zero.<br>
mr7.1.1<br>
Please what am I doing wrong?<br>
<br clear="all">
<div>
<div dir="ltr" class="gmail-m_3445417585441005905gmail-m_5009845498419097855gmail-m_-3861068147171175965m_2465156184426868469gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div style="font-family:sans-serif;font-size:13px">
<p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p class="MsoNormal" style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" rel="noreferrer" target="_blank">a</a><a href="mailto:fang.emmanuel@gmail.com" rel="noreferrer" target="_blank">fang.emmanuel@gmail.com</a></u></span></p>
<p class="MsoNormal"><span style="color:rgb(36,64,97);font-size:13.3333px">Skype: </span><u style="color:rgb(36,64,97);font-size:13.3333px"><a href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)" rel="noreferrer" target="_blank">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<fieldset class="gmail-m_3445417585441005905gmail-m_5009845498419097855mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-quote-pre">_______________________________________________
Spce-user mailing list
<a class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>
<a class="gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote></div>