[Spce-user] Regarding billing fees and billing zones

[Oscar Rodriguez]

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 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/8291c2a5/attachment-0002.html>