[Spce-user] Rate not Applied to Customer SPCE
EMMANUEL AFANG
afang.emmanuel at gmail.com
Tue Mar 12 11:57:56 EDT 2019
Hi Rene
Please how do I update to have the fix? Must I upgrade to mr7.2.1 ?
Best Regards
*Emmanuel Afang *
Mobile +2347084280332
Email: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
<fang.emmanuel at gmail.com>*
Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
On Tue, Mar 12, 2019 at 4:52 PM Rene Krenn <rkrenn at sipwise.com> wrote:
> 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 Europaring F15
>
> t: +43(0)130120332 A-2345 Brunn Am Gebirge
>
> w: 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
>
> 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
>
> destination_user_dialed: 8844014444110003347
>
> destination_user_in: 8844014444110003347
>
> destination_domain_in: 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: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
>
>
>
>
> On Tue, Mar 12, 2019 at 4:19 PM Daniel Grotti <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 Europaring F15
>
> t: +43(0)130120332 A-2345 Brunn Am Gebirge
>
> w: 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 | 11112222100
> | 0 | 127.0.0.1 | NULL | NULL | NULL | NULL
> | NULL | NULL | NULL | NULL | NULL
> | NULL | | 11112222100 | 0
> | 4 |
> | | 0 |
> 8844014444110003347 | sbc.provder.com | 8844014444110003347 |
> 8844014444110003347 | 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: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
>
>
>
>
> On Tue, Mar 12, 2019 at 4:00 PM Daniel Grotti <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 Europaring F15
>
> t: +43(0)130120332 A-2345 Brunn Am Gebirge
>
> w: 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: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
>
>
>
>
> On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <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 Europaring F15
>
> t: +43(0)130120332 A-2345 Brunn Am Gebirge
>
> w: 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: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
>
>
>
>
> On Tue, Mar 12, 2019 at 3:46 PM Daniel Grotti <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 Europaring F15
>
> t: +43(0)130120332 A-2345 Brunn Am Gebirge
>
> w: 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>
> 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: *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
>
>
> _______________________________________________
>
> Spce-user mailing list
>
> Spce-user at lists.sipwise.com
>
> https://lists.sipwise.com/listinfo/spce-user
>
>
>
> _______________________________________________
> Spce-user mailing list
> 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/12e29f7f/attachment-0001.html>
More information about the Spce-user
mailing list