<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.E-MailFormatvorlage21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=DE-AT link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi Emmanuel,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>very likely you also use the new fees with „prefix“ match mode. Make sure you use a version that<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>contains the recent fix <a href="https://github.com/sipwise/rate-o-mat/issues/1">https://github.com/sipwise/rate-o-mat/issues/1</a>. 7.1.1 does not, we avoid db-related backports in general.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>br<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Spce-user [mailto:spce-user-bounces@lists.sipwise.com] <b>Im Auftrag von </b>Daniel Grotti<br><b>Gesendet:</b> Dienstag, 12. März 2019 16:48<br><b>An:</b> EMMANUEL AFANG <afang.emmanuel@gmail.com><br><b>Cc:</b> spce-user <spce-user@lists.sipwise.com><br><b>Betreff:</b> Re: [Spce-user] Rate not Applied to Customer SPCE<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><tt><span style='font-size:10.0pt'>Hi,</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>I asked id=38.</tt><br><br><br><br></span><o:p></o:p></p><pre>--<o:p></o:p></pre><pre>Daniel Grotti<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Head of Customer Support Sipwise GmbH<o:p></o:p></pre><pre>e: <a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a> Europaring F15<o:p></o:p></pre><pre>t: +43(0)130120332 A-2345 Brunn Am Gebirge<o:p></o:p></pre><pre>w: <a href="http://www.sipwise.com">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt<o:p></o:p></pre><div><p class=MsoNormal>On 3/12/19 4:33 PM, EMMANUEL AFANG wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>Noted. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>MariaDB [accounting]> select * from cdr where id=39 \G;<o:p></o:p></p></div><div><p class=MsoNormal>*************************** 1. row ***************************<o:p></o:p></p></div><div><p class=MsoNormal> id: 39<o:p></o:p></p></div><div><p class=MsoNormal> update_time: 2019-03-12 13:34:53<o:p></o:p></p></div><div><p class=MsoNormal> source_user_id: defdcdee-14e0-4d11-80b0-64fcbdc5c7f4<o:p></o:p></p></div><div><p class=MsoNormal> source_provider_id: 1<o:p></o:p></p></div><div><p class=MsoNormal> source_external_subscriber_id: customer_name<o:p></o:p></p></div><div><p class=MsoNormal> source_external_contract_id: customer_name<o:p></o:p></p></div><div><p class=MsoNormal> source_account_id: 6<o:p></o:p></p></div><div><p class=MsoNormal> source_user: 11112222100<o:p></o:p></p></div><div><p class=MsoNormal> source_domain: <a href="http://app.sipwise.co.za">app.sipwise.co.za</a><o:p></o:p></p></div><div><p class=MsoNormal> source_cli: 11112222100<o:p></o:p></p></div><div><p class=MsoNormal> source_clir: 0<o:p></o:p></p></div><div><p class=MsoNormal> source_ip: 127.0.0.1<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp0: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp1: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp2: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp3: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp4: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp5: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp6: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp7: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp8: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_gpp9: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_lnp_prefix: <o:p></o:p></p></div><div><p class=MsoNormal> source_user_out: 11112222100<o:p></o:p></p></div><div><p class=MsoNormal> destination_user_id: 0<o:p></o:p></p></div><div><p class=MsoNormal> destination_provider_id: 4<o:p></o:p></p></div><div><p class=MsoNormal> destination_external_subscriber_id: <o:p></o:p></p></div><div><p class=MsoNormal> destination_external_contract_id: <o:p></o:p></p></div><div><p class=MsoNormal> destination_account_id: 0<o:p></o:p></p></div><div><p class=MsoNormal> destination_user: 8844014444110003347<o:p></o:p></p></div><div><p class=MsoNormal> destination_domain: <a href="http://sbc.provder.com">sbc.provder.com</a><o:p></o:p></p></div><div><p class=MsoNormal> destination_user_dialed: 8844014444110003347<o:p></o:p></p></div><div><p class=MsoNormal> destination_user_in: 8844014444110003347<o:p></o:p></p></div><div><p class=MsoNormal> destination_domain_in: <a href="http://app.sipwise.co.za">app.sipwise.co.za</a><o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp0: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp1: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp2: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp3: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp4: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp5: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp6: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp7: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp8: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_gpp9: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_lnp_prefix: <o:p></o:p></p></div><div><p class=MsoNormal> destination_user_out: 4444110003347<o:p></o:p></p></div><div><p class=MsoNormal> peer_auth_user: <o:p></o:p></p></div><div><p class=MsoNormal> peer_auth_realm: <o:p></o:p></p></div><div><p class=MsoNormal> call_type: call<o:p></o:p></p></div><div><p class=MsoNormal> call_status: cancel<o:p></o:p></p></div><div><p class=MsoNormal> call_code: 487<o:p></o:p></p></div><div><p class=MsoNormal> init_time: 1552394085.050<o:p></o:p></p></div><div><p class=MsoNormal> start_time: 1552394085.217<o:p></o:p></p></div><div><p class=MsoNormal> duration: 0.000<o:p></o:p></p></div><div><p class=MsoNormal> call_id: 97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY<o:p></o:p></p></div><div><p class=MsoNormal> source_carrier_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> source_reseller_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> source_customer_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> source_carrier_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_reseller_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_customer_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_carrier_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_reseller_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_customer_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_carrier_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_reseller_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> source_customer_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_carrier_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> destination_reseller_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> destination_customer_cost: 0.000000<o:p></o:p></p></div><div><p class=MsoNormal> destination_carrier_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_reseller_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_customer_free_time: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_carrier_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_reseller_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_customer_billing_fee_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_carrier_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal>destination_reseller_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal>destination_customer_billing_zone_id: NULL<o:p></o:p></p></div><div><p class=MsoNormal> frag_carrier_onpeak: NULL<o:p></o:p></p></div><div><p class=MsoNormal> frag_reseller_onpeak: NULL<o:p></o:p></p></div><div><p class=MsoNormal> frag_customer_onpeak: NULL<o:p></o:p></p></div><div><p class=MsoNormal> is_fragmented: NULL<o:p></o:p></p></div><div><p class=MsoNormal> split: 0<o:p></o:p></p></div><div><p class=MsoNormal> rated_at: NULL<o:p></o:p></p></div><div><p class=MsoNormal> rating_status: unrated<o:p></o:p></p></div><div><p class=MsoNormal> exported_at: NULL<o:p></o:p></p></div><div><p class=MsoNormal> export_status: unexported<o:p></o:p></p></div><div><p class=MsoNormal> source_lnp_type: NULL<o:p></o:p></p></div><div><p class=MsoNormal> destination_lnp_type: NULL<o:p></o:p></p></div><div><p class=MsoNormal>1 row in set (0.00 sec)<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>ERROR: No query specified<o:p></o:p></p></div></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'>Best Regards<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;color:#333333'>Emmanuel Afang </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#333333'>Mobile </span><span style='font-size:10.0pt;color:#244061'>+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#244061'>Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a>fang.emmanuel</u></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Mar 12, 2019 at 4:19 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal><tt><span style='font-size:10.0pt'>Hi,</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>please be so kind to use \G at the end of you mysql query, for readability purpose.</tt><br><br><br><br></span><o:p></o:p></p><pre>--<o:p></o:p></pre><pre>Daniel Grotti<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Head of Customer Support Sipwise GmbH<o:p></o:p></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15<o:p></o:p></pre><pre>t: +43(0)130120332 A-2345 Brunn Am Gebirge<o:p></o:p></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt<o:p></o:p></pre><div><p class=MsoNormal>On 3/12/19 4:15 PM, EMMANUEL AFANG wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>Here you it is. Also attached.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<o:p></o:p></p></div><div><p class=MsoNormal>| id | update_time | source_user_id | source_provider_id | source_external_subscriber_id | source_external_contract_id | source_account_id | source_user | source_domain | source_cli | source_clir | source_ip | source_gpp0 | source_gpp1 | source_gpp2 | source_gpp3 | source_gpp4 | source_gpp5 | source_gpp6 | source_gpp7 | source_gpp8 | source_gpp9 | source_lnp_prefix | source_user_out | destination_user_id | destination_provider_id | destination_external_subscriber_id | destination_external_contract_id | destination_account_id | destination_user | destination_domain | destination_user_dialed | destination_user_in | destination_domain_in | destination_gpp0 | destination_gpp1 | destination_gpp2 | destination_gpp3 | destination_gpp4 | destination_gpp5 | destination_gpp6 | destination_gpp7 | destination_gpp8 | destination_gpp9 | destination_lnp_prefix | destination_user_out | peer_auth_user | peer_auth_realm | call_type | call_status | call_code | init_time | start_time | duration | call_id | source_carrier_cost | source_reseller_cost | source_customer_cost | source_carrier_free_time | source_reseller_free_time | source_customer_free_time | source_carrier_billing_fee_id | source_reseller_billing_fee_id | source_customer_billing_fee_id | source_carrier_billing_zone_id | source_reseller_billing_zone_id | source_customer_billing_zone_id | destination_carrier_cost | destination_reseller_cost | destination_customer_cost | destination_carrier_free_time | destination_reseller_free_time | destination_customer_free_time | destination_carrier_billing_fee_id | destination_reseller_billing_fee_id | destination_customer_billing_fee_id | destination_carrier_billing_zone_id | destination_reseller_billing_zone_id | destination_customer_billing_zone_id | frag_carrier_onpeak | frag_reseller_onpeak | frag_customer_onpeak | is_fragmented | split | rated_at | rating_status | exported_at | export_status | source_lnp_type | destination_lnp_type |<o:p></o:p></p></div><div><p class=MsoNormal>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<o:p></o:p></p></div><div><p class=MsoNormal>| 39 | 2019-03-12 13:34:53 | defdcdee-14e0-4d11-80b0-64fcbdc5c7f4 | 1 | test_custm | test_custm | 6 | 11112222100 | <a href="http://app.sipwise.com.za" target="_blank">app.sipwise.com.za</a> | 11112222100 | 0 | 127.0.0.1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 11112222100 | 0 | 4 | | | 0 | 8844014444110003347 | <a href="http://sbc.provder.com" target="_blank">sbc.provder.com</a> | 8844014444110003347 | 8844014444110003347 | <a href="http://app.sipwise.com.za" target="_blank">app.sipwise.com.za</a> | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 4444110003347 | | | call | cancel | 487 | 1552394085.050 | 1552394085.217 | 0.000 | 97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | unrated | NULL | unexported | NULL | NULL |<o:p></o:p></p></div><div><p class=MsoNormal>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><br clear=all><o:p></o:p></p><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'>Best Regards<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;color:#333333'>Emmanuel Afang </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#333333'>Mobile </span><span style='font-size:10.0pt;color:#244061'>+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#244061'>Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a>fang.emmanuel</u></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Mar 12, 2019 at 4:00 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal><tt><span style='font-size:10.0pt'>please share or check how CDR id 38 looks like please.</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>Looks like there are some field that does not like to rateomat.</tt><br><br><br></span><o:p></o:p></p><pre>--<o:p></o:p></pre><pre>Daniel Grotti<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Head of Customer Support Sipwise GmbH<o:p></o:p></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15<o:p></o:p></pre><pre>t: +43(0)130120332 A-2345 Brunn Am Gebirge<o:p></o:p></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt<o:p></o:p></pre><div><p class=MsoNormal>On 3/12/19 3:58 PM, EMMANUEL AFANG wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>Rate-o-mat keeps crashing...<o:p></o:p></p><pre>:~# tail -f /var/log/ngcp/rate-o-mat.log <o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Trying to connect to accounting db...<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Successfully connected to accounting db...<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr time balance column model loaded<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr relation column model loaded<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr cash balance column model loaded<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr tag column model loaded<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Up and running.<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Grabbed 9 CDRs<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: 1/9 - rate CDR ID 38<o:p></o:p></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Caught DBI:err 1690<o:p></o:p></pre><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'>Best Regards<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;color:#333333'>Emmanuel Afang </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#333333'>Mobile </span><span style='font-size:10.0pt;color:#244061'>+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#244061'>Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a>fang.emmanuel</u></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal><tt><span style='font-size:10.0pt'>You can try to enable rate-o-mat debug level:</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><br><tt>cat /mnt/glusterfs/home/dgrotti# cat /etc/default/ngcp-rate-o-mat</tt><br><br><tt># Options for the NGCP rate-o-mat</tt><br><tt>RATEOMAT_DEBUG=2</tt><br><tt>...</tt><br><tt>...</tt><br><br><br><tt>There restart rate-o-mat and check again the log.</tt><br><br><br></span><o:p></o:p></p><pre>--<o:p></o:p></pre><pre>Daniel Grotti<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Head of Customer Support Sipwise GmbH<o:p></o:p></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15<o:p></o:p></pre><pre>t: +43(0)130120332 A-2345 Brunn Am Gebirge<o:p></o:p></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt<o:p></o:p></pre><div><p class=MsoNormal>On 3/12/19 3:50 PM, EMMANUEL AFANG wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>The CallID for CDR 39 is 97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE<br>Everything is auto generated. <o:p></o:p></p><div><p class=MsoNormal><br clear=all><o:p></o:p></p><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'>Best Regards<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;color:#333333'>Emmanuel Afang </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#333333'>Mobile </span><span style='font-size:10.0pt;color:#244061'>+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#244061'>Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a>fang.emmanuel</u></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Mar 12, 2019 at 3:46 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal><tt><span style='font-size:10.0pt'>Hi,</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>do you maybe have some string value out of range in CDR id 39 ?</tt><br><br><b><br><tt>Error: 1690</tt></b><tt> SQLSTATE: 22003 (ER_DATA_OUT_OF_RANGE)</tt><br><tt>Message: %s value is out of range in '%s'</tt><b><br><br><br><br><br></b></span><o:p></o:p></p><pre>--<o:p></o:p></pre><pre>Daniel Grotti<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Head of Customer Support Sipwise GmbH<o:p></o:p></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a> Europaring F15<o:p></o:p></pre><pre>t: +43(0)130120332 A-2345 Brunn Am Gebirge<o:p></o:p></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt<o:p></o:p></pre><div><p class=MsoNormal>On 3/12/19 3:38 PM, EMMANUEL AFANG wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>Rate-o-mat service failed with the following log: <o:p></o:p></p><div><pre>:~# tail -f /var/log/ngcp/rate-o-mat.log <o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 10 CDRs rated overall so far.<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 37<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 11 CDRs rated overall so far.<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 11 CDRs rated overall so far.<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 38<o:p></o:p></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Caught DBI:err 1690<o:p></o:p></pre><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Best Regards,<br><br>Afang Emmanuel<br><br>Mobile: +234 708 428 0332<br>Skype: Afang.Emmanuel<br> <o:p></o:p></p></div></div></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>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:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal>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><o:p></o:p></p><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'>Best Regards<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;color:#333333'>Emmanuel Afang </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#333333'>Mobile </span><span style='font-size:10.0pt;color:#244061'>+2347084280332<br>Email: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;color:#244061'>Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style='color:#1155CC'>a</span></a>fang.emmanuel</u></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div></div></blockquote></div><p class=MsoNormal><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Spce-user mailing list<o:p></o:p></pre><pre><a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><o:p></o:p></pre><pre><a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></pre></blockquote><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>_______________________________________________<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" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></p></blockquote></div></blockquote><p class=MsoNormal><o:p> </o:p></p></div></blockquote></div></blockquote><p class=MsoNormal><o:p> </o:p></p></div></blockquote></div></blockquote><p class=MsoNormal><o:p> </o:p></p></div></blockquote></div></blockquote><p class=MsoNormal><o:p> </o:p></p></div></body></html>