<div dir="ltr">Hi Rene<br>Please how do I update to have the fix? Must I upgrade to mr7.2.1 ?<br><br clear="all"><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 4:52 PM Rene Krenn <<a href="mailto:rkrenn@sipwise.com">rkrenn@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="white" lang="DE-AT"><div class="gmail-m_-6395690278302610253WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hi Emmanuel,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">very likely you also use the new fees with „prefix“ match mode. Make sure you use a version that<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">contains the recent fix <a href="https://github.com/sipwise/rate-o-mat/issues/1" target="_blank">https://github.com/sipwise/rate-o-mat/issues/1</a>. 7.1.1 does not, we avoid db-related backports in general.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">br<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm"><p class="MsoNormal"><b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif;color:windowtext">Von:</span></b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif;color:windowtext"> Spce-user [mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>] <b>Im Auftrag von </b>Daniel Grotti<br><b>Gesendet:</b> Dienstag, 12. März 2019 16:48<br><b>An:</b> EMMANUEL AFANG <<a href="mailto:afang.emmanuel@gmail.com" target="_blank">afang.emmanuel@gmail.com</a>><br><b>Cc:</b> spce-user <<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br><b>Betreff:</b> Re: [Spce-user] Rate not Applied to Customer SPCE<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><tt><span style="font-size:10pt">Hi,</span></tt><span style="font-size:10pt;font-family:"Courier New""><br><tt>I asked id=38.</tt><br><br><br><br></span><u></u><u></u></p><pre>--<u></u><u></u></pre><pre>Daniel Grotti<u></u><u></u></pre><pre><u></u> <u></u></pre><pre>Head of Customer Support                               Sipwise GmbH<u></u><u></u></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>                               Europaring F15<u></u><u></u></pre><pre>t: +43(0)130120332                          A-2345 Brunn Am Gebirge<u></u><u></u></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a>          FN: 305595f      FG: LG Wiener Neustadt<u></u><u></u></pre><div><p class="MsoNormal">On 3/12/19 4:33 PM, EMMANUEL AFANG wrote:<u></u><u></u></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt"><div><div><p class="MsoNormal">Noted. <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">MariaDB [accounting]> select * from cdr where id=39 \G;<u></u><u></u></p></div><div><p class="MsoNormal">*************************** 1. row ***************************<u></u><u></u></p></div><div><p class="MsoNormal">                                  id: 39<u></u><u></u></p></div><div><p class="MsoNormal">                         update_time: 2019-03-12 13:34:53<u></u><u></u></p></div><div><p class="MsoNormal">                      source_user_id: defdcdee-14e0-4d11-80b0-64fcbdc5c7f4<u></u><u></u></p></div><div><p class="MsoNormal">                  source_provider_id: 1<u></u><u></u></p></div><div><p class="MsoNormal">       source_external_subscriber_id: customer_name<u></u><u></u></p></div><div><p class="MsoNormal">         source_external_contract_id: customer_name<u></u><u></u></p></div><div><p class="MsoNormal">                   source_account_id: 6<u></u><u></u></p></div><div><p class="MsoNormal">                         source_user: 11112222100<u></u><u></u></p></div><div><p class="MsoNormal">                       source_domain: <a href="http://app.sipwise.co.za" target="_blank">app.sipwise.co.za</a><u></u><u></u></p></div><div><p class="MsoNormal">                          source_cli: 11112222100<u></u><u></u></p></div><div><p class="MsoNormal">                         source_clir: 0<u></u><u></u></p></div><div><p class="MsoNormal">                           source_ip: 127.0.0.1<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp0: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp1: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp2: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp3: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp4: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp5: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp6: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp7: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp8: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                         source_gpp9: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                   source_lnp_prefix: <u></u><u></u></p></div><div><p class="MsoNormal">                     source_user_out: 11112222100<u></u><u></u></p></div><div><p class="MsoNormal">                 destination_user_id: 0<u></u><u></u></p></div><div><p class="MsoNormal">             destination_provider_id: 4<u></u><u></u></p></div><div><p class="MsoNormal">  destination_external_subscriber_id: <u></u><u></u></p></div><div><p class="MsoNormal">    destination_external_contract_id: <u></u><u></u></p></div><div><p class="MsoNormal">              destination_account_id: 0<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_user: 8844014444110003347<u></u><u></u></p></div><div><p class="MsoNormal">                  destination_domain: <a href="http://sbc.provder.com" target="_blank">sbc.provder.com</a><u></u><u></u></p></div><div><p class="MsoNormal">             destination_user_dialed: 8844014444110003347<u></u><u></u></p></div><div><p class="MsoNormal">                 destination_user_in: 8844014444110003347<u></u><u></u></p></div><div><p class="MsoNormal">               destination_domain_in: <a href="http://app.sipwise.co.za" target="_blank">app.sipwise.co.za</a><u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp0: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp1: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp2: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp3: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp4: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp5: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp6: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp7: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp8: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                    destination_gpp9: NULL<u></u><u></u></p></div><div><p class="MsoNormal">              destination_lnp_prefix: <u></u><u></u></p></div><div><p class="MsoNormal">                destination_user_out: 4444110003347<u></u><u></u></p></div><div><p class="MsoNormal">                      peer_auth_user: <u></u><u></u></p></div><div><p class="MsoNormal">                     peer_auth_realm: <u></u><u></u></p></div><div><p class="MsoNormal">                           call_type: call<u></u><u></u></p></div><div><p class="MsoNormal">                         call_status: cancel<u></u><u></u></p></div><div><p class="MsoNormal">                           call_code: 487<u></u><u></u></p></div><div><p class="MsoNormal">                           init_time: 1552394085.050<u></u><u></u></p></div><div><p class="MsoNormal">                          start_time: 1552394085.217<u></u><u></u></p></div><div><p class="MsoNormal">                            duration: 0.000<u></u><u></u></p></div><div><p class="MsoNormal">                             call_id: 97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY<u></u><u></u></p></div><div><p class="MsoNormal">                 source_carrier_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">                source_reseller_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">                source_customer_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">            source_carrier_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">           source_reseller_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">           source_customer_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">       source_carrier_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">      source_reseller_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">      source_customer_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">      source_carrier_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">     source_reseller_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">     source_customer_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">            destination_carrier_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">           destination_reseller_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">           destination_customer_cost: 0.000000<u></u><u></u></p></div><div><p class="MsoNormal">       destination_carrier_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">      destination_reseller_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">      destination_customer_free_time: NULL<u></u><u></u></p></div><div><p class="MsoNormal">  destination_carrier_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal"> destination_reseller_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal"> destination_customer_billing_fee_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal"> destination_carrier_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">destination_reseller_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">destination_customer_billing_zone_id: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                 frag_carrier_onpeak: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                frag_reseller_onpeak: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                frag_customer_onpeak: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                       is_fragmented: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                               split: 0<u></u><u></u></p></div><div><p class="MsoNormal">                            rated_at: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                       rating_status: unrated<u></u><u></u></p></div><div><p class="MsoNormal">                         exported_at: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                       export_status: unexported<u></u><u></u></p></div><div><p class="MsoNormal">                     source_lnp_type: NULL<u></u><u></u></p></div><div><p class="MsoNormal">                destination_lnp_type: NULL<u></u><u></u></p></div><div><p class="MsoNormal">1 row in set (0.00 sec)<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">ERROR: No query specified<u></u><u></u></p></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><div><div><div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:Arial,sans-serif">Best Regards<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:Arial,sans-serif"> <u></u><u></u></span></p><div><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)">Emmanuel Afang </span></b><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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" target="_blank"><span style="color:rgb(17,85,204)">a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(36,64,97)">Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style="color:rgb(17,85,204)">a</span></a>fang.emmanuel</u></span><u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Tue, Mar 12, 2019 at 4:19 PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal"><tt><span style="font-size:10pt">Hi,</span></tt><span style="font-size:10pt;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><u></u><u></u></p><pre>--<u></u><u></u></pre><pre>Daniel Grotti<u></u><u></u></pre><pre><u></u> <u></u></pre><pre>Head of Customer Support                               Sipwise GmbH<u></u><u></u></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>                               Europaring F15<u></u><u></u></pre><pre>t: +43(0)130120332                          A-2345 Brunn Am Gebirge<u></u><u></u></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a>          FN: 305595f      FG: LG Wiener Neustadt<u></u><u></u></pre><div><p class="MsoNormal">On 3/12/19 4:15 PM, EMMANUEL AFANG wrote:<u></u><u></u></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt"><div><div><p class="MsoNormal">Here you it is. Also attached.<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<u></u><u></u></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 |<u></u><u></u></p></div><div><p class="MsoNormal">+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<u></u><u></u></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                 |<u></u><u></u></p></div><div><p class="MsoNormal">+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal"><br clear="all"><u></u><u></u></p><div><div><div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:Arial,sans-serif">Best Regards<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:Arial,sans-serif"> <u></u><u></u></span></p><div><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)">Emmanuel Afang </span></b><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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" target="_blank"><span style="color:rgb(17,85,204)">a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(36,64,97)">Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style="color:rgb(17,85,204)">a</span></a>fang.emmanuel</u></span><u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal"><tt><span style="font-size:10pt">please share or check how CDR id 38 looks like please.</span></tt><span style="font-size:10pt;font-family:"Courier New""><br><tt>Looks like there are some field that does not like to rateomat.</tt><br><br><br></span><u></u><u></u></p><pre>--<u></u><u></u></pre><pre>Daniel Grotti<u></u><u></u></pre><pre><u></u> <u></u></pre><pre>Head of Customer Support                               Sipwise GmbH<u></u><u></u></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>                               Europaring F15<u></u><u></u></pre><pre>t: +43(0)130120332                          A-2345 Brunn Am Gebirge<u></u><u></u></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a>          FN: 305595f      FG: LG Wiener Neustadt<u></u><u></u></pre><div><p class="MsoNormal">On 3/12/19 3:58 PM, EMMANUEL AFANG wrote:<u></u><u></u></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt"><div><p class="MsoNormal">Rate-o-mat keeps crashing...<u></u><u></u></p><pre>:~# tail -f /var/log/ngcp/rate-o-mat.log <u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Trying to connect to accounting db...<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Successfully connected to accounting db...<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr time balance column model loaded<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr relation column model loaded<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr cash balance column model loaded<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr tag column model loaded<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Up and running.<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Grabbed 9 CDRs<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: 1/9 - rate CDR ID 38<u></u><u></u></pre><pre>Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Caught DBI:err 1690<u></u><u></u></pre><div><div><div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:Arial,sans-serif">Best Regards<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:Arial,sans-serif"> <u></u><u></u></span></p><div><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)">Emmanuel Afang </span></b><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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" target="_blank"><span style="color:rgb(17,85,204)">a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(36,64,97)">Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style="color:rgb(17,85,204)">a</span></a>fang.emmanuel</u></span><u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal"><tt><span style="font-size:10pt">You can try to enable rate-o-mat debug level:</span></tt><span style="font-size:10pt;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><u></u><u></u></p><pre>--<u></u><u></u></pre><pre>Daniel Grotti<u></u><u></u></pre><pre><u></u> <u></u></pre><pre>Head of Customer Support                               Sipwise GmbH<u></u><u></u></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>                               Europaring F15<u></u><u></u></pre><pre>t: +43(0)130120332                          A-2345 Brunn Am Gebirge<u></u><u></u></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a>          FN: 305595f      FG: LG Wiener Neustadt<u></u><u></u></pre><div><p class="MsoNormal">On 3/12/19 3:50 PM, EMMANUEL AFANG wrote:<u></u><u></u></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt"><div><p class="MsoNormal">The CallID for CDR 39 is 97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE<br>Everything is auto generated. <u></u><u></u></p><div><p class="MsoNormal"><br clear="all"><u></u><u></u></p><div><div><div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:Arial,sans-serif">Best Regards<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:Arial,sans-serif"> <u></u><u></u></span></p><div><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)">Emmanuel Afang </span></b><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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" target="_blank"><span style="color:rgb(17,85,204)">a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(36,64,97)">Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style="color:rgb(17,85,204)">a</span></a>fang.emmanuel</u></span><u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal"><tt><span style="font-size:10pt">Hi,</span></tt><span style="font-size:10pt;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><u></u><u></u></p><pre>--<u></u><u></u></pre><pre>Daniel Grotti<u></u><u></u></pre><pre><u></u> <u></u></pre><pre>Head of Customer Support                               Sipwise GmbH<u></u><u></u></pre><pre>e: <a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>                               Europaring F15<u></u><u></u></pre><pre>t: +43(0)130120332                          A-2345 Brunn Am Gebirge<u></u><u></u></pre><pre>w: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a>          FN: 305595f      FG: LG Wiener Neustadt<u></u><u></u></pre><div><p class="MsoNormal">On 3/12/19 3:38 PM, EMMANUEL AFANG wrote:<u></u><u></u></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt"><div><div><p class="MsoNormal">Rate-o-mat service failed with the following log: <u></u><u></u></p><div><pre>:~# tail -f /var/log/ngcp/rate-o-mat.log <u></u><u></u></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.<u></u><u></u></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.<u></u><u></u></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.<u></u><u></u></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs<u></u><u></u></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 37<u></u><u></u></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.<u></u><u></u></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.<u></u><u></u></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs<u></u><u></u></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 38<u></u><u></u></pre><pre>Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Caught DBI:err 1690<u></u><u></u></pre><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Best Regards,<br><br>Afang Emmanuel<br><br>Mobile: +234 708 428 0332<br>Skype: Afang.Emmanuel<br>    <u></u><u></u></p></div></div></div></div><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;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"><u></u><u></u></p><div><div><div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:Arial,sans-serif">Best Regards<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:Arial,sans-serif"> <u></u><u></u></span></p><div><p class="MsoNormal"><b><span style="font-size:10pt;color:rgb(51,51,51)">Emmanuel Afang </span></b><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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" target="_blank"><span style="color:rgb(17,85,204)">a</span></a><a href="mailto:fang.emmanuel@gmail.com" target="_blank">fang.emmanuel@gmail.com</a></u></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10pt;color:rgb(36,64,97)">Skype: <u><a href="mailto:cuzomba@dial-mobile.com" target="_blank"><span style="color:rgb(17,85,204)">a</span></a>fang.emmanuel</u></span><u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div></div></div></blockquote></div><p class="MsoNormal"><br><br><u></u><u></u></p><pre>_______________________________________________<u></u><u></u></pre><pre>Spce-user mailing list<u></u><u></u></pre><pre><a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><u></u><u></u></pre><pre><a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><u></u><u></u></pre></blockquote><p class="MsoNormal"><u></u> <u></u></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><u></u><u></u></p></blockquote></div></blockquote><p class="MsoNormal"><u></u> <u></u></p></div></blockquote></div></blockquote><p class="MsoNormal"><u></u> <u></u></p></div></blockquote></div></blockquote><p class="MsoNormal"><u></u> <u></u></p></div></blockquote></div></blockquote><p class="MsoNormal"><u></u> <u></u></p></div></div></blockquote></div>