<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi,<br>
I asked id=38.<br>
<br>
<br>
</tt>
<pre class="moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="moz-txt-link-abbreviated" href="http://www.sipwise.com">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div class="moz-cite-prefix">On 3/12/19 4:33 PM, EMMANUEL AFANG
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAPbnNVLttJp=8qMw0BM_9yMRP8znJD40kzkabddW6hKnBdLhhQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">Noted. </div>
<div dir="ltr"><br>
<div>
<div>MariaDB [accounting]> select * from cdr where id=39
\G;</div>
<div>*************************** 1. row
***************************</div>
<div> id: 39</div>
<div> update_time: 2019-03-12
13:34:53</div>
<div> source_user_id:
defdcdee-14e0-4d11-80b0-64fcbdc5c7f4</div>
<div> source_provider_id: 1</div>
<div> source_external_subscriber_id: customer_name</div>
<div> source_external_contract_id: customer_name</div>
<div> source_account_id: 6</div>
<div> source_user: 11112222100</div>
<div> source_domain: <a
href="http://app.sipwise.co.za" moz-do-not-send="true">app.sipwise.co.za</a></div>
<div> source_cli: 11112222100</div>
<div> source_clir: 0</div>
<div> source_ip: 127.0.0.1</div>
<div> source_gpp0: NULL</div>
<div> source_gpp1: NULL</div>
<div> source_gpp2: NULL</div>
<div> source_gpp3: NULL</div>
<div> source_gpp4: NULL</div>
<div> source_gpp5: NULL</div>
<div> source_gpp6: NULL</div>
<div> source_gpp7: NULL</div>
<div> source_gpp8: NULL</div>
<div> source_gpp9: NULL</div>
<div> source_lnp_prefix: </div>
<div> source_user_out: 11112222100</div>
<div> destination_user_id: 0</div>
<div> destination_provider_id: 4</div>
<div> destination_external_subscriber_id: </div>
<div> destination_external_contract_id: </div>
<div> destination_account_id: 0</div>
<div> destination_user:
8844014444110003347</div>
<div> destination_domain: <a
href="http://sbc.provder.com" moz-do-not-send="true">sbc.provder.com</a></div>
<div> destination_user_dialed:
8844014444110003347</div>
<div> destination_user_in:
8844014444110003347</div>
<div> destination_domain_in: <a
href="http://app.sipwise.co.za" moz-do-not-send="true">app.sipwise.co.za</a></div>
<div> destination_gpp0: NULL</div>
<div> destination_gpp1: NULL</div>
<div> destination_gpp2: NULL</div>
<div> destination_gpp3: NULL</div>
<div> destination_gpp4: NULL</div>
<div> destination_gpp5: NULL</div>
<div> destination_gpp6: NULL</div>
<div> destination_gpp7: NULL</div>
<div> destination_gpp8: NULL</div>
<div> destination_gpp9: NULL</div>
<div> destination_lnp_prefix: </div>
<div> destination_user_out: 4444110003347</div>
<div> peer_auth_user: </div>
<div> peer_auth_realm: </div>
<div> call_type: call</div>
<div> call_status: cancel</div>
<div> call_code: 487</div>
<div> init_time: 1552394085.050</div>
<div> start_time: 1552394085.217</div>
<div> duration: 0.000</div>
<div> call_id:
97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY</div>
<div> source_carrier_cost: 0.000000</div>
<div> source_reseller_cost: 0.000000</div>
<div> source_customer_cost: 0.000000</div>
<div> source_carrier_free_time: NULL</div>
<div> source_reseller_free_time: NULL</div>
<div> source_customer_free_time: NULL</div>
<div> source_carrier_billing_fee_id: NULL</div>
<div> source_reseller_billing_fee_id: NULL</div>
<div> source_customer_billing_fee_id: NULL</div>
<div> source_carrier_billing_zone_id: NULL</div>
<div> source_reseller_billing_zone_id: NULL</div>
<div> source_customer_billing_zone_id: NULL</div>
<div> destination_carrier_cost: 0.000000</div>
<div> destination_reseller_cost: 0.000000</div>
<div> destination_customer_cost: 0.000000</div>
<div> destination_carrier_free_time: NULL</div>
<div> destination_reseller_free_time: NULL</div>
<div> destination_customer_free_time: NULL</div>
<div> destination_carrier_billing_fee_id: NULL</div>
<div> destination_reseller_billing_fee_id: NULL</div>
<div> destination_customer_billing_fee_id: NULL</div>
<div> destination_carrier_billing_zone_id: NULL</div>
<div>destination_reseller_billing_zone_id: NULL</div>
<div>destination_customer_billing_zone_id: NULL</div>
<div> frag_carrier_onpeak: NULL</div>
<div> frag_reseller_onpeak: NULL</div>
<div> frag_customer_onpeak: NULL</div>
<div> is_fragmented: NULL</div>
<div> split: 0</div>
<div> rated_at: NULL</div>
<div> rating_status: unrated</div>
<div> exported_at: NULL</div>
<div> export_status: unexported</div>
<div> source_lnp_type: NULL</div>
<div> destination_lnp_type: NULL</div>
<div>1 row in set (0.00 sec)</div>
<div><br>
</div>
<div>ERROR: No query specified</div>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr" class="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</p>
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div
style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span
style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span
style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a
href="mailto:cuzomba@dial-mobile.com"
style="color:rgb(17,85,204)"
target="_blank"
moz-do-not-send="true">a</a><a
href="mailto:fang.emmanuel@gmail.com"
target="_blank"
moz-do-not-send="true">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"
moz-do-not-send="true">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Mar 12, 2019 at 4:19
PM Daniel Grotti <<a href="mailto:dgrotti@sipwise.com"
moz-do-not-send="true">dgrotti@sipwise.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> <tt>Hi,<br>
please be so kind to use \G at the end of you mysql query,
for readability purpose.<br>
<br>
<br>
</tt>
<pre class="gmail-m_6102031327178381001moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_6102031327178381001moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank" moz-do-not-send="true">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_6102031327178381001moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank" moz-do-not-send="true">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div class="gmail-m_6102031327178381001moz-cite-prefix">On
3/12/19 4:15 PM, EMMANUEL AFANG wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Here you it is. Also attached.<br>
<div><br>
</div>
<div>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+</div>
<div>| 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 |</div>
<div>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+</div>
<div>| 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"
moz-do-not-send="true">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"
moz-do-not-send="true">sbc.provder.com</a> |
8844014444110003347 | 8844014444110003347 | <a
href="http://app.sipwise.com.za" target="_blank"
moz-do-not-send="true">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 |</div>
<div>+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+</div>
<div><br>
</div>
<br clear="all">
<div>
<div dir="ltr"
class="gmail-m_6102031327178381001gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div
style="font-family:sans-serif;font-size:13px">
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div
style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span
style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span
style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a
href="mailto:cuzomba@dial-mobile.com"
style="color:rgb(17,85,204)"
target="_blank"
moz-do-not-send="true">a</a><a
href="mailto:fang.emmanuel@gmail.com" target="_blank"
moz-do-not-send="true">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"
moz-do-not-send="true">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Mar 12, 2019
at 4:00 PM Daniel Grotti <<a
href="mailto:dgrotti@sipwise.com" target="_blank"
moz-do-not-send="true">dgrotti@sipwise.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> <tt>please share or check how
CDR id 38 looks like please.<br>
Looks like there are some field that does not like
to rateomat.<br>
<br>
</tt>
<pre class="gmail-m_6102031327178381001gmail-m_-4612200186684437095moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank" moz-do-not-send="true">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank" moz-do-not-send="true">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095moz-cite-prefix">On
3/12/19 3:58 PM, EMMANUEL AFANG wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Rate-o-mat keeps crashing...<br>
<pre style="color:rgb(0,0,0)">:~# tail -f /var/log/ngcp/rate-o-mat.log
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Trying to connect to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Successfully connected to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr time balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr relation column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr cash balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr tag column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Up and running.
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Grabbed 9 CDRs
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: 1/9 - rate CDR ID 38
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Caught DBI:err 1690</pre>
<div>
<div dir="ltr"
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div
style="font-family:sans-serif;font-size:13px">
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div
style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span
style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span
style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a
href="mailto:cuzomba@dial-mobile.com"
style="color:rgb(17,85,204)" target="_blank" moz-do-not-send="true">a</a><a
href="mailto:fang.emmanuel@gmail.com" target="_blank"
moz-do-not-send="true">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" moz-do-not-send="true">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Mar
12, 2019 at 3:54 PM Daniel Grotti <<a
href="mailto:dgrotti@sipwise.com"
target="_blank" moz-do-not-send="true">dgrotti@sipwise.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> <tt>You can try to
enable rate-o-mat debug level:<br>
<br>
cat /mnt/glusterfs/home/dgrotti# cat
/etc/default/ngcp-rate-o-mat<br>
<br>
# Options for the NGCP rate-o-mat<br>
RATEOMAT_DEBUG=2<br>
...<br>
...<br>
<br>
<br>
There restart rate-o-mat and check again
the log.<br>
<br>
</tt>
<pre class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank" moz-do-not-send="true">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank" moz-do-not-send="true">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905moz-cite-prefix">On
3/12/19 3:50 PM, EMMANUEL AFANG wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">The CallID for CDR 39 is <span>97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE<br>
</span>Everything is auto generated.
<div><br clear="all">
<div>
<div dir="ltr"
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div
style="font-family:sans-serif;font-size:13px">
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div
style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p class="MsoNormal"><span
style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span
style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a
href="mailto:cuzomba@dial-mobile.com"
style="color:rgb(17,85,204)" target="_blank" moz-do-not-send="true">a</a><a
href="mailto:fang.emmanuel@gmail.com" target="_blank"
moz-do-not-send="true">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"
moz-do-not-send="true">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On
Tue, Mar 12, 2019 at 3:46 PM Daniel
Grotti <<a
href="mailto:dgrotti@sipwise.com"
target="_blank"
moz-do-not-send="true">dgrotti@sipwise.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> <tt>Hi,<br>
do you maybe have some string
value out of range in CDR id 39 ?<br>
<br>
<b><br>
</b><b>Error: 1690</b> SQLSTATE:
22003 (ER_DATA_OUT_OF_RANGE)<br>
Message: %s value is out of range
in '%s'<b><br>
<br>
<br>
<br>
</b></tt>
<pre class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-signature" cols="72">--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="mailto:dgrotti@sipwise.com" target="_blank" moz-do-not-send="true">dgrotti@sipwise.com</a> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: <a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="http://www.sipwise.com" target="_blank" moz-do-not-send="true">www.sipwise.com</a> FN: 305595f FG: LG Wiener Neustadt
</pre>
<div
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-cite-prefix">On
3/12/19 3:38 PM, EMMANUEL AFANG
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="auto">Rate-o-mat
service failed with the
following log:
<div dir="auto">
<pre style="color:rgb(0,0,0)">:~# tail -f /var/log/ngcp/rate-o-mat.log
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 37
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 11 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 11 CDRs rated overall so far.
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 38
Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Caught DBI:err 1690</pre>
<br>
<div dir="auto">Best
Regards,<br>
<br>
Afang Emmanuel<br>
<br>
Mobile: +234 708 428 0332<br>
Skype: Afang.Emmanuel<br>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr"
class="gmail_attr">On Tue, Mar
12, 2019, 2:02 PM EMMANUEL
AFANG <<a
href="mailto:afang.emmanuel@gmail.com"
target="_blank"
moz-do-not-send="true">afang.emmanuel@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi<br>
I configured rate for
customer with direction out.
CDR still shows a cost of
zero.<br>
mr7.1.1<br>
Please what am I doing
wrong?<br>
<br clear="all">
<div>
<div dir="ltr"
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855gmail-m_-3861068147171175965m_2465156184426868469gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div
style="font-family:sans-serif;font-size:13px">
<p
class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small">Best
Regards</p>
<p
class="MsoNormal"
style="font-family:Arial,Helvetica,sans-serif;font-size:small"> </p>
<div
style="font-family:Arial,Helvetica,sans-serif;font-size:small">
<p
class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><span>Emmanuel</span> Afang </span></b></p>
<p
class="MsoNormal"><b><span
style="font-size:10pt;color:rgb(51,51,51)"><br>
</span></b></p>
<p
class="MsoNormal"><span
style="font-size:10pt;color:rgb(51,51,51)">Mobile </span><span
style="font-size:10pt;color:rgb(36,64,97)">+2347084280332<br>
Email: <u><a
href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)"
rel="noreferrer"
target="_blank" moz-do-not-send="true">a</a><a
href="mailto:fang.emmanuel@gmail.com"
rel="noreferrer" target="_blank" moz-do-not-send="true">fang.emmanuel@gmail.com</a></u></span></p>
<p
class="MsoNormal"><span
style="color:rgb(36,64,97);font-size:13.3333px">Skype: </span><u
style="color:rgb(36,64,97);font-size:13.3333px"><a
href="mailto:cuzomba@dial-mobile.com" style="color:rgb(17,85,204)"
rel="noreferrer"
target="_blank" moz-do-not-send="true">a</a>fang.emmanuel</u><br>
</p>
</div>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<fieldset
class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-quote-pre">_______________________________________________
Spce-user mailing list
<a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" target="_blank" moz-do-not-send="true">Spce-user@lists.sipwise.com</a>
<a class="gmail-m_6102031327178381001gmail-m_-4612200186684437095gmail-m_3445417585441005905gmail-m_5009845498419097855moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" target="_blank" moz-do-not-send="true">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Spce-user mailing list<br>
<a
href="mailto:Spce-user@lists.sipwise.com"
target="_blank"
moz-do-not-send="true">Spce-user@lists.sipwise.com</a><br>
<a
href="https://lists.sipwise.com/listinfo/spce-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.sipwise.com/listinfo/spce-user</a><br>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>