[Spce-user] Rate not Applied to Customer SPCE
Daniel Grotti
dgrotti at sipwise.com
Tue Mar 12 11:47:46 EDT 2019
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
> <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: _a <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <mailto:fang.emmanuel at gmail.com>_
>
> Skype: _a <mailto:cuzomba at dial-mobile.com>fang.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: _a <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>> <mailto:fang.emmanuel at gmail.com>_
>>
>> Skype: _a <mailto:cuzomba at dial-mobile.com>fang.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: _a
>>> <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>> <mailto:fang.emmanuel at gmail.com>_
>>>
>>> Skype: _a <mailto:cuzomba at dial-mobile.com>fang.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: _a
>>>> <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>>> <mailto:fang.emmanuel at gmail.com>_
>>>>
>>>> Skype: _a <mailto:cuzomba at dial-mobile.com>fang.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: _a
>>>>> <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>>>> <mailto:fang.emmanuel at gmail.com>_
>>>>>
>>>>> Skype: _a
>>>>> <mailto:cuzomba at dial-mobile.com>fang.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/feb843a0/attachment-0001.html>
More information about the Spce-user
mailing list