[Spce-user] Rate not Applied to Customer SPCE
Rene Krenn
rkrenn at sipwise.com
Tue Mar 12 11:52:21 EDT 2019
Hi Emmanuel,
very likely you also use the new fees with „prefix“ match mode. Make sure you use a version that
contains the recent fix https://github.com/sipwise/rate-o-mat/issues/1. 7.1.1 does not, we avoid db-related backports in general.
br
Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Daniel Grotti
Gesendet: Dienstag, 12. März 2019 16:48
An: EMMANUEL AFANG <afang.emmanuel at gmail.com>
Cc: spce-user <spce-user at lists.sipwise.com>
Betreff: Re: [Spce-user] Rate not Applied to Customer SPCE
Hi,
I asked id=38.
--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: www.sipwise.com <http://www.sipwise.com> FN: 305595f FG: LG Wiener Neustadt
On 3/12/19 4:33 PM, EMMANUEL AFANG wrote:
Noted.
MariaDB [accounting]> select * from cdr where id=39 \G;
*************************** 1. row ***************************
id: 39
update_time: 2019-03-12 13:34:53
source_user_id: defdcdee-14e0-4d11-80b0-64fcbdc5c7f4
source_provider_id: 1
source_external_subscriber_id: customer_name
source_external_contract_id: customer_name
source_account_id: 6
source_user: 11112222100
source_domain: app.sipwise.co.za <http://app.sipwise.co.za>
source_cli: 11112222100
source_clir: 0
source_ip: 127.0.0.1
source_gpp0: NULL
source_gpp1: NULL
source_gpp2: NULL
source_gpp3: NULL
source_gpp4: NULL
source_gpp5: NULL
source_gpp6: NULL
source_gpp7: NULL
source_gpp8: NULL
source_gpp9: NULL
source_lnp_prefix:
source_user_out: 11112222100
destination_user_id: 0
destination_provider_id: 4
destination_external_subscriber_id:
destination_external_contract_id:
destination_account_id: 0
destination_user: 8844014444110003347
destination_domain: sbc.provder.com <http://sbc.provder.com>
destination_user_dialed: 8844014444110003347
destination_user_in: 8844014444110003347
destination_domain_in: app.sipwise.co.za <http://app.sipwise.co.za>
destination_gpp0: NULL
destination_gpp1: NULL
destination_gpp2: NULL
destination_gpp3: NULL
destination_gpp4: NULL
destination_gpp5: NULL
destination_gpp6: NULL
destination_gpp7: NULL
destination_gpp8: NULL
destination_gpp9: NULL
destination_lnp_prefix:
destination_user_out: 4444110003347
peer_auth_user:
peer_auth_realm:
call_type: call
call_status: cancel
call_code: 487
init_time: 1552394085.050
start_time: 1552394085.217
duration: 0.000
call_id: 97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY
source_carrier_cost: 0.000000
source_reseller_cost: 0.000000
source_customer_cost: 0.000000
source_carrier_free_time: NULL
source_reseller_free_time: NULL
source_customer_free_time: NULL
source_carrier_billing_fee_id: NULL
source_reseller_billing_fee_id: NULL
source_customer_billing_fee_id: NULL
source_carrier_billing_zone_id: NULL
source_reseller_billing_zone_id: NULL
source_customer_billing_zone_id: NULL
destination_carrier_cost: 0.000000
destination_reseller_cost: 0.000000
destination_customer_cost: 0.000000
destination_carrier_free_time: NULL
destination_reseller_free_time: NULL
destination_customer_free_time: NULL
destination_carrier_billing_fee_id: NULL
destination_reseller_billing_fee_id: NULL
destination_customer_billing_fee_id: NULL
destination_carrier_billing_zone_id: NULL
destination_reseller_billing_zone_id: NULL
destination_customer_billing_zone_id: NULL
frag_carrier_onpeak: NULL
frag_reseller_onpeak: NULL
frag_customer_onpeak: NULL
is_fragmented: NULL
split: 0
rated_at: NULL
rating_status: unrated
exported_at: NULL
export_status: unexported
source_lnp_type: NULL
destination_lnp_type: NULL
1 row in set (0.00 sec)
ERROR: No query specified
Best Regards
Emmanuel Afang
Mobile +2347084280332
Email: <mailto:cuzomba at dial-mobile.com> afang.emmanuel at gmail.com <mailto:fang.emmanuel at gmail.com>
Skype: <mailto:cuzomba at dial-mobile.com> afang.emmanuel
On Tue, Mar 12, 2019 at 4:19 PM Daniel Grotti <dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> > wrote:
Hi,
please be so kind to use \G at the end of you mysql query, for readability purpose.
--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: www.sipwise.com <http://www.sipwise.com> FN: 305595f FG: LG Wiener Neustadt
On 3/12/19 4:15 PM, EMMANUEL AFANG wrote:
Here you it is. Also attached.
+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
| 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 |
+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
| 39 | 2019-03-12 13:34:53 | defdcdee-14e0-4d11-80b0-64fcbdc5c7f4 | 1 | test_custm | test_custm | 6 | 11112222100 | app.sipwise.com.za <http://app.sipwise.com.za> | 11112222100 | 0 | 127.0.0.1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 11112222100 | 0 | 4 | | | 0 | 8844014444110003347 | sbc.provder.com <http://sbc.provder.com> | 8844014444110003347 | 8844014444110003347 | app.sipwise.com.za <http://app.sipwise.com.za> | 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 |
+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
Best Regards
Emmanuel Afang
Mobile +2347084280332
Email: <mailto:cuzomba at dial-mobile.com> afang.emmanuel at gmail.com <mailto:fang.emmanuel at gmail.com>
Skype: <mailto:cuzomba at dial-mobile.com> afang.emmanuel
On Tue, Mar 12, 2019 at 4:00 PM Daniel Grotti <dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> > wrote:
please share or check how CDR id 38 looks like please.
Looks like there are some field that does not like to rateomat.
--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: www.sipwise.com <http://www.sipwise.com> FN: 305595f FG: LG Wiener Neustadt
On 3/12/19 3:58 PM, EMMANUEL AFANG wrote:
Rate-o-mat keeps crashing...
:~# 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
Best Regards
Emmanuel Afang
Mobile +2347084280332
Email: <mailto:cuzomba at dial-mobile.com> afang.emmanuel at gmail.com <mailto:fang.emmanuel at gmail.com>
Skype: <mailto:cuzomba at dial-mobile.com> afang.emmanuel
On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> > wrote:
You can try to enable rate-o-mat debug level:
cat /mnt/glusterfs/home/dgrotti# cat /etc/default/ngcp-rate-o-mat
# Options for the NGCP rate-o-mat
RATEOMAT_DEBUG=2
...
...
There restart rate-o-mat and check again the log.
--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: www.sipwise.com <http://www.sipwise.com> FN: 305595f FG: LG Wiener Neustadt
On 3/12/19 3:50 PM, EMMANUEL AFANG wrote:
The CallID for CDR 39 is 97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE
Everything is auto generated.
Best Regards
Emmanuel Afang
Mobile +2347084280332
Email: <mailto:cuzomba at dial-mobile.com> afang.emmanuel at gmail.com <mailto:fang.emmanuel at gmail.com>
Skype: <mailto:cuzomba at dial-mobile.com> afang.emmanuel
On Tue, Mar 12, 2019 at 3:46 PM Daniel Grotti <dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> > wrote:
Hi,
do you maybe have some string value out of range in CDR id 39 ?
Error: 1690 SQLSTATE: 22003 (ER_DATA_OUT_OF_RANGE)
Message: %s value is out of range in '%s'
--
Daniel Grotti
Head of Customer Support Sipwise GmbH
e: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com> Europaring F15
t: +43(0)130120332 A-2345 Brunn Am Gebirge
w: www.sipwise.com <http://www.sipwise.com> FN: 305595f FG: LG Wiener Neustadt
On 3/12/19 3:38 PM, EMMANUEL AFANG wrote:
Rate-o-mat service failed with the following log:
:~# 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
Best Regards,
Afang Emmanuel
Mobile: +234 708 428 0332
Skype: Afang.Emmanuel
On Tue, Mar 12, 2019, 2:02 PM EMMANUEL AFANG <afang.emmanuel at gmail.com <mailto:afang.emmanuel at gmail.com> > wrote:
Hi
I configured rate for customer with direction out. CDR still shows a cost of zero.
mr7.1.1
Please what am I doing wrong?
Best Regards
Emmanuel Afang
Mobile +2347084280332
Email: <mailto:cuzomba at dial-mobile.com> afang.emmanuel at gmail.com <mailto:fang.emmanuel at gmail.com>
Skype: <mailto:cuzomba at dial-mobile.com> afang.emmanuel
_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
https://lists.sipwise.com/listinfo/spce-user
_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
https://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190312/f517393c/attachment-0001.html>
More information about the Spce-user
mailing list