<div dir="ltr">Walter,<div><br></div><div>After service restart, I found this on the logs</div><div><br></div><div>***</div>Nov 23 13:48:56 ssw (info) ngcp-rate-o-mat[13449]: WARNING: 1/5 - rating CDR ID 7 aborted (retry 1): FATAL: No outbound fee info for profile 2 and source user '181341XXXXX' or user/domain '<a href="mailto:181341XXXXX@ssw.jt.co.cr">181341XXXXX@ssw.jt.co.cr</a>' and destination user '506843XXXXX' or user/domain '<a href="mailto:506843XXXXX@out.didww.com">506843XXXXX@out.didww.com</a>' found<br>***<div><br><div>So, It seems to be a pattern problem more than anything else</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El sáb., 23 nov. 2019 a las 6:47, Walter Klomp (<<a href="mailto:walter@myrepublic.net">walter@myrepublic.net</a>>) escribió:<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><div dir="auto">Hi Oscar,</div><div dir="auto"><br></div><div dir="auto">Rating is also on community edition. Just try to restart the rate-o-mat service and make sure you have at least the wildcard entry in the billing so it can always match something. (For voicemail and other stuff)</div></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, 23 Nov 2019 at 20:43, Oscar Rodriguez <<a href="mailto:oscaredmu@gmail.com" target="_blank">oscaredmu@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">Sorry Walter<div><br></div><div>I forgot to paste this</div><div><br></div>root@ssw:~# systemctl status rate-o-mat.service <br>ngcp-rate-o-mat.service - NGCP CDR Rating Daemon<br> Loaded: loaded (/lib/systemd/system/ngcp-rate-o-mat.service; enabled; vendor preset: enabled)<br> Active: failed (Result: exit-code) since Sat 2019-11-23 01:12:37 CET; 12h ago<br> Process: 1110 ExecStart=/usr/sbin/ngcp-rate-o-mat (code=exited, status=11)<br> Main PID: 1110 (code=exited, status=11)</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El sáb., 23 nov. 2019 a las 6:39, Oscar Rodriguez (<<a href="mailto:oscaredmu@gmail.com" target="_blank">oscaredmu@gmail.com</a>>) escribió:<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 Walter and Rene,<div><br></div><div>Thanks for the fast response...</div><div><br></div><div>There are the relevant lines at /var/log/ngcp/rate-o-mat.log</div><div><br></div>***<br>
Nov 23 00:39:42 ssw (info) ngcp-rate-o-mat[1110]: WARNING: No duplication db credentials, disabled.<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to connect to billing db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully connected to duplication db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to connect to provisioning db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully connected to provisioning db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to connect to accounting db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully connected to accounting db...<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr cash balance column model loaded<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr relation column model loaded<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr time balance column model loaded<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr tag column model loaded<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Up and running.<br>.<div>.</div><div>.<br><div>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 0 CDRs rated overall so far.<br>Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 0 CDRs rated overall so far.Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR ID 1<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 month period costs 0.000000 (customer), 0.000000 (reseller) (1 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 day period costs 0.000000 (customer), 0.000000 (reseller) (1 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 1 CDRs completed. 1 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 1 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 2 CDRs<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/2 - rate CDR ID 2<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 month period costs 0.000000 (customer), 0.000000 (reseller) (2 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 day period costs 0.000000 (customer), 0.000000 (reseller) (2 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 2/2 - rate CDR ID 3<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 month period costs 0.000000 (customer), 0.000000 (reseller) (3 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5 day period costs 0.000000 (customer), 0.000000 (reseller) (3 cdrs)<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 2 CDRs completed. 3 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 3 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 3 CDRs rated overall so far.<div>.</div><div>.</div><div>.</div>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 3 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR ID 4<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 3 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: There were 1 failed CDRs, sleep 30<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR ID 4<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs completed. 3 CDRs rated overall so far.<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: There were 1 failed CDRs, sleep 30<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs<br>Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR ID 4<div><br></div><div>I do see the failed CDR, curiously I tried, mr5.5 and the latest version, no way to make it work, obviously there must be something that I am doing wrong (please note I followed the manual step by step) or "maybe" this feature is not present on the Community Edition</div></div></div><div><br></div><div>The CDRs are present, but, for some reason, there is not a "Billing Zone" associated, I meant "blank/empty" that column</div><div><br></div><div>Any idea or guidance would be really appreciated</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El sáb., 23 nov. 2019 a las 3:33, Walter Klomp (<<a href="mailto:walter@myrepublic.net" target="_blank">walter@myrepublic.net</a>>) escribió:<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 Oscar,<div><br></div><div>Could you verify if rate-o-mat is actually running? If not, rate-o-mat log should tell you why it isn't working.</div><div><br></div><div>You may want to check /var/log/ngcp/rate-o-mat.log</div><div><br></div><div>Rating is done AFTER mediator writes the log, which is why you will see CDR.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Nov 23, 2019 at 9:40 AM Oscar Rodriguez <<a href="mailto:oscaredmu@gmail.com" target="_blank">oscaredmu@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, <div><br></div><div>This is my first post... :)</div><div><br></div><div>I am giving a try to SipWise C5 CE ( mr7.5.2 ), it looks simple and good, it have also a nice handbook that makes que setup and/or configuration a really easy task, but I am experiencing problems with the billing.</div><div><br></div><div>I tried both ways for the fees (uploading and typing directly on the WUI), unfortunately, it is impossible to me even make it bill a subscriber, to be honest I have no way to understand what I could be doing wrong.</div><div><br></div><div>These is the line of the fees I am actually testing</div><div><br></div><div>/***</div><div><br>.,^506,out,CR_US,"Costa Rica and All",0.0015,6,0.0015,6,0.0015,6,0.0015,6,0,regex_longest_pattern<br></div><div><br></div><div>The outgoing calls are working fine, but at the CDRs the cost appears as "0.00" neither they show a Billing Zone</div><div><br></div><div>Please note I am dialing 506XXXXYYYY</div><div><br></div><div>Asking to see if someone had a similar problem in the past, if there are any other documentation or examples, any tips or directions would be helpful too</div><div><br></div><div>Thank you in advance</div></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="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" width="346" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><br></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman"">Warmest Regards,</div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="color:purple"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><br><img border="0" width="140" height="92" src="https://myrepublic.com.sg/resources/email-signature.png"></a></span><span></span></div></td><td style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><b><span style="font-size:10pt;font-family:Arial;color:rgb(127,43,153)">Walter Klomp</span></b><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Head of Voice & Systems</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">T: +65 6816 1120</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">F: +65 6717 2031</span></div></td></tr><tr><td width="333" colspan="2" style="width:249.75pt;padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""> <span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px"><a href="https://www.google.com/maps/search/11+Lorong+3+Toa+Payoh+Block+B?entry=gmail&source=g" target="_blank">11 Lorong 3 Toa Payoh Block B</a> Jackson Square</span></font></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px">#04-11/15 Singapore 319579</span></font></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)"><br></span><span style="color:rgb(77,77,77)"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">myrepublic.com.sg</span></a></span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Follow us on: <a href="https://twitter.com/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Twitter</span></a> | <a href="https://facebook.com/myrepublicsg" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Facebook</span></a> | <a href="https://www.linkedin.com/company/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(5,99,193)">LinkedIn</span></a></span></div></td></tr></tbody></table><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:14px"><br></div><table border="0" cellspacing="0" cellpadding="0" width="400" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0in"><br></td></tr></tbody></table></div></div>
<br>
<span style="color:rgb(34,34,34);font-family:sans-serif;background-color:rgb(255,255,255)"><font size="1"><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">The contents of this email and any attachments are confidential and may also be privileged. You must not disseminate the contents of this email and any attachments without permission of the sender. If you have received this email by mistake, please delete all copies and inform the sender immediately. You may refer to our company's Privacy Policy </span><span style="color:rgb(102,102,102);font-family:Arial;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><a href="https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/" target="_blank">here</a></span><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">.</span></font></span></blockquote></div>
</blockquote></div>
</blockquote></div></div>-- <br><div dir="ltr"><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" width="346" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><br></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman"">Warmest Regards,</div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="color:purple"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><br><img border="0" width="140" height="92" src="https://myrepublic.com.sg/resources/email-signature.png"></a></span><span></span></div></td><td style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><b><span style="font-size:10pt;font-family:Arial;color:rgb(127,43,153)">Walter Klomp</span></b><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Head of Voice & Systems</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">T: +65 6816 1120</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">F: +65 6717 2031</span></div></td></tr><tr><td width="333" colspan="2" style="width:249.75pt;padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""> <span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px">11 Lorong 3 Toa Payoh Block B Jackson Square</span></font></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px">#04-11/15 Singapore 319579</span></font></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)"><br></span><span style="color:rgb(77,77,77)"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">myrepublic.com.sg</span></a></span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Follow us on: <a href="https://twitter.com/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Twitter</span></a> | <a href="https://facebook.com/myrepublicsg" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Facebook</span></a> | <a href="https://www.linkedin.com/company/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(5,99,193)">LinkedIn</span></a></span></div></td></tr></tbody></table><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:14px"><br></div><table border="0" cellspacing="0" cellpadding="0" width="400" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0in"><br></td></tr></tbody></table></div></div>
<br>
<span style="color:rgb(34,34,34);font-family:sans-serif;background-color:rgb(255,255,255)"><font size="1"><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">The contents of this email and any attachments are confidential and may also be privileged. You must not disseminate the contents of this email and any attachments without permission of the sender. If you have received this email by mistake, please delete all copies and inform the sender immediately. You may refer to our company's Privacy Policy </span><span style="color:rgb(102,102,102);font-family:Arial;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><a href="https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/" target="_blank">here</a></span><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">.</span></font></span></blockquote></div>