[Spce-user] Regarding billing fees and billing zones

[Oscar Rodriguez]

Walter,

After service restart, I found this on the logs

***
Nov 23 13:48:56 ssw (info) ngcp-rate-o-mat[13449]: WARNING: 1/5 - rating
CDR ID 7 aborted  (retry 1): FATAL: No outbound fee info for profile 2 and
source user '181341XXXXX' or user/domain '181341XXXXX at ssw.jt.co.cr' and
destination user '506843XXXXX' or user/domain '506843XXXXX at out.didww.com'
found
***

So, It seems to be a pattern problem more than anything else

El sáb., 23 nov. 2019 a las 6:47, Walter Klomp (<walter at myrepublic.net>)
escribió:

> Hi Oscar,
>
> Rating is also on community edition. Just try to restart the rate-o-mat
> service and make sure you have at least the wildcard entry in the billing
> so it can always match something. (For voicemail and other stuff)
>
> On Sat, 23 Nov 2019 at 20:43, Oscar Rodriguez <oscaredmu at gmail.com> wrote:
>
>> Sorry Walter
>>
>> I forgot to paste this
>>
>> root at ssw:~# systemctl status rate-o-mat.service
>> ngcp-rate-o-mat.service - NGCP CDR Rating Daemon
>>   Loaded: loaded (/lib/systemd/system/ngcp-rate-o-mat.service; enabled;
>> vendor preset: enabled)
>>   Active: failed (Result: exit-code) since Sat 2019-11-23 01:12:37 CET;
>> 12h ago
>>   Process: 1110 ExecStart=/usr/sbin/ngcp-rate-o-mat (code=exited,
>> status=11)
>>  Main PID: 1110 (code=exited, status=11)
>>
>> El sáb., 23 nov. 2019 a las 6:39, Oscar Rodriguez (<oscaredmu at gmail.com>)
>> escribió:
>>
>>> Hi Walter and Rene,
>>>
>>> Thanks for the fast response...
>>>
>>> There are the relevant lines at /var/log/ngcp/rate-o-mat.log
>>>
>>> ***
>>> Nov 23 00:39:42 ssw (info) ngcp-rate-o-mat[1110]: WARNING: No
>>> duplication db credentials, disabled.
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to
>>> connect to billing db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully
>>> connected to duplication db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to
>>> connect to provisioning db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully
>>> connected to provisioning db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Trying to
>>> connect to accounting db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Successfully
>>> connected to accounting db...
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr cash
>>> balance column model loaded
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr
>>> relation column model loaded
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr time
>>> balance column model loaded
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: local cdr tag
>>> column model loaded
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Up and running.
>>> .
>>> .
>>> .
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 0 CDRs rated overall so far.
>>> Nov 23 00:41:00 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 0 CDRs rated overall so far.Nov 23 01:12:37 ssw (info)
>>> ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR ID 1
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> month period costs 0.000000 (customer), 0.000000 (reseller) (1 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> day period costs 0.000000 (customer), 0.000000 (reseller) (1 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 1 CDRs
>>> completed. 1 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 1 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 2 CDRs
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/2 - rate CDR
>>> ID 2
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> month period costs 0.000000 (customer), 0.000000 (reseller) (2 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> day period costs 0.000000 (customer), 0.000000 (reseller) (2 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 2/2 - rate CDR
>>> ID 3
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> month period costs 0.000000 (customer), 0.000000 (reseller) (3 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: contract ID 5
>>> day period costs 0.000000 (customer), 0.000000 (reseller) (3 cdrs)
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 2 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> .
>>> .
>>> .
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR
>>> ID 4
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: There were 1
>>> failed CDRs, sleep 30
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR
>>> ID 4
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Batch of 0 CDRs
>>> completed. 3 CDRs rated overall so far.
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: There were 1
>>> failed CDRs, sleep 30
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: Grabbed 1 CDRs
>>> Nov 23 01:12:37 ssw (info) ngcp-rate-o-mat[1110]: INFO: 1/1 - rate CDR
>>> ID 4
>>>
>>> I do see the failed CDR, curiously I tried, mr5.5 and the latest
>>> version, no way to make it work, obviously there must be something that I
>>> am doing wrong (please note I followed the manual step by step) or "maybe"
>>> this feature is not present on the Community Edition
>>>
>>> The CDRs are present, but, for some reason, there is not a "Billing
>>> Zone" associated, I meant "blank/empty" that column
>>>
>>> Any idea or guidance would be really appreciated
>>>
>>> El sáb., 23 nov. 2019 a las 3:33, Walter Klomp (<walter at myrepublic.net>)
>>> escribió:
>>>
>>>> Hi Oscar,
>>>>
>>>> Could you verify if rate-o-mat is actually running?  If not, rate-o-mat
>>>> log should tell you why it isn't working.
>>>>
>>>> You may want to check /var/log/ngcp/rate-o-mat.log
>>>>
>>>> Rating is done AFTER mediator writes the log, which is why you will see
>>>> CDR.
>>>>
>>>>
>>>> On Sat, Nov 23, 2019 at 9:40 AM Oscar Rodriguez <oscaredmu at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> This is my first post... :)
>>>>>
>>>>> I am giving a try to SipWise C5 CE ( mr7.5.2 ), it looks simple and
>>>>> good, it have also a nice handbook that makes que setup and/or
>>>>> configuration a really easy task, but I am experiencing problems with the
>>>>> billing.
>>>>>
>>>>> I tried both ways for the fees (uploading and typing directly on the
>>>>> WUI), unfortunately, it is impossible to me even make it bill a subscriber,
>>>>> to be honest I have no way to understand what I could be doing wrong.
>>>>>
>>>>> These is the line of the fees I am actually testing
>>>>>
>>>>> /***
>>>>>
>>>>> .,^506,out,CR_US,"Costa Rica and
>>>>> All",0.0015,6,0.0015,6,0.0015,6,0.0015,6,0,regex_longest_pattern
>>>>>
>>>>> The outgoing calls are working fine, but at the CDRs the cost appears
>>>>> as "0.00" neither they show a Billing Zone
>>>>>
>>>>> Please note I am dialing 506XXXXYYYY
>>>>>
>>>>> Asking to see if someone had a similar problem in the past, if there
>>>>> are any other documentation or examples, any tips or directions would be
>>>>> helpful too
>>>>>
>>>>> Thank you in advance
>>>>> --
>>>>> Spce-user mailing list
>>>>> Spce-user at lists.sipwise.com
>>>>> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Warmest Regards,
>>>>
>>>> <https://myrepublic.com.sg/>
>>>> *Walter Klomp*
>>>> Head of Voice & Systems
>>>> MyRepublic Limited
>>>> T: +65 6816 1120
>>>> F: +65 6717 2031
>>>>
>>>> MyRepublic Limited
>>>> 11 Lorong 3 Toa Payoh Block B
>>>> <https://www.google.com/maps/search/11+Lorong+3+Toa+Payoh+Block+B?entry=gmail&source=g>
>>>> Jackson Square
>>>> #04-11/15 Singapore 319579
>>>>
>>>> myrepublic.com.sg
>>>> Follow us on: Twitter <https://twitter.com/myrepublic> | Facebook
>>>> <https://facebook.com/myrepublicsg> | LinkedIn
>>>> <https://www.linkedin.com/company/myrepublic>
>>>>
>>>>
>>>>
>>>> The contents of this email and any attachments are confidential and may
>>>> also be privileged. You must not disseminate the contents of this email and
>>>> any attachments without permission of the sender. If you have received this
>>>> email by mistake, please delete all copies and inform the sender
>>>> immediately. You may refer to our company's Privacy Policy here
>>>> <https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/>
>>>> .
>>>
>>> --
>
> Warmest Regards,
>
> <https://myrepublic.com.sg/>
> *Walter Klomp*
> Head of Voice & Systems
> MyRepublic Limited
> T: +65 6816 1120
> F: +65 6717 2031
>
> MyRepublic Limited
> 11 Lorong 3 Toa Payoh Block B Jackson Square
> #04-11/15 Singapore 319579
>
> myrepublic.com.sg
> Follow us on: Twitter <https://twitter.com/myrepublic> | Facebook
> <https://facebook.com/myrepublicsg> | LinkedIn
> <https://www.linkedin.com/company/myrepublic>
>
>
>
> The contents of this email and any attachments are confidential and may
> also be privileged. You must not disseminate the contents of this email and
> any attachments without permission of the sender. If you have received this
> email by mistake, please delete all copies and inform the sender
> immediately. You may refer to our company's Privacy Policy here
> <https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/>.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20191123/3a3a436f/attachment-0002.html>