[Spce-user] Regarding billing fees and billing zones

Sat Nov 23 07:39:56 EST 2019

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