[Spce-user] something wrong with my billing and cdr module

Sat Apr 18 10:16:13 EDT 2020

I made 2 Calls, this i the logs
the rate-o-mat.log don't change
What can I do ??
cdr.log
Apr 18 13:53:16 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 1251 us.
Apr 18 13:53:16 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:53:26 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 477 us.
Apr 18 13:53:26 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:53:36 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 598 us.
Apr 18 13:53:36 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:53:46 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 540 us.
Apr 18 13:53:46 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:53:56 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 684 us.
Apr 18 13:53:56 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:54:06 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 821 us.
Apr 18 13:54:06 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:54:16 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 1247 us.
Apr 18 13:54:16 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:54:26 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 1 CDRs was 42842 us.
Apr 18 13:54:26 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 23.341581 CDR/sec
Apr 18 13:55:19 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 5480 us.
Apr 18 13:55:19 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:55:29 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 4253 us.
Apr 18 13:55:29 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:55:39 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 0 CDRs was 3952 us.
Apr 18 13:55:39 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 0.000000 CDR/sec
Apr 18 13:55:49 vs4476 (info) mediator[959]: mediator.c:442 [main]: Runtime
for loop processing 1 callids and generating 1 CDRs was 26150 us.
Apr 18 13:55:49 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
CDR creation rate 38.240918 CDR/sec

rate-o-mat.log
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Trying to connect
to billing db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Successfully
connected to duplication db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Trying to connect
to provisioning db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Successfully
connected to provisioning db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Trying to connect
to accounting db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Successfully
connected to accounting db...
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: local cdr time
balance column model loaded
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: local cdr
relation column model loaded
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: local cdr tag
column model loaded
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: local cdr cash
balance column model loaded
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Up and running.
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR ID
132
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Batch of 0 CDRs
completed. 0 CDRs rated overall so far.
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: There were 1
failed CDRs, sleep 30
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR ID
132
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Batch of 0 CDRs
completed. 0 CDRs rated overall so far.
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: There were 1
failed CDRs, sleep 30
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR ID
132

Le sam. 18 avr. 2020 à 13:45, Walter Klomp <walter at myrepublic.net> a écrit :

> But keep it running and make some calls. For some reason either your
> mediator or rate-o-mat stops. You need to catch that.
>
> On Sat, 18 Apr 2020 at 21:44, florent goue <florentgoue at gmail.com> wrote:
>
>> Hi Walter
>> Thanks for your reply
>> this morning there was nothing in the cdr.log
>> After I restarted the cdr was generated at 10:58:46.
>>
>> Here is what is in the logs this morning:
>>
>> :~# tail -f /var/log/ngcp/rate-o-mat.log
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR
>> ID 132
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Batch of 0 CDRs
>> completed. 0 CDRs rated overall so far.
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: There were 1
>> failed CDRs, sleep 30
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR
>> ID 132
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Batch of 0 CDRs
>> completed. 0 CDRs rated overall so far.
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: There were 1
>> failed CDRs, sleep 30
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: Grabbed 1 CDRs
>> Apr 18 10:27:44 vs4476 (info) ngcp-rate-o-mat[955]: INFO: 1/1 - rate CDR
>> ID 132
>>
>>
>> # tail -f /var/log/ngcp/cdr.log
>> Apr 18 10:58:46 vs4476 (info) mediator[959]: mediator.c:442 [main]:
>> Runtime for loop processing 1 callids and generating 1 CDRs was 23891 us.
>> Apr 18 10:58:46 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
>> CDR creation rate 41.856766 CDR/sec
>> Apr 18 10:58:59 vs4476 (info) mediator[959]: mediator.c:442 [main]:
>> Runtime for loop processing 1 callids and generating 0 CDRs was 7714 us.
>> Apr 18 10:58:59 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
>> CDR creation rate 0.000000 CDR/sec
>> Apr 18 10:59:09 vs4476 (info) mediator[959]: mediator.c:442 [main]:
>> Runtime for loop processing 1 callids and generating 1 CDRs was 27715 us.
>> Apr 18 10:59:09 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
>> CDR creation rate 36.081544 CDR/sec
>> Apr 18 11:04:52 vs4476 (info) mediator[959]: mediator.c:442 [main]:
>> Runtime for loop processing 1 callids and generating 0 CDRs was 1424 us.
>> Apr 18 11:04:52 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
>> CDR creation rate 0.000000 CDR/sec
>> Apr 18 11:05:02 vs4476 (info) mediator[959]: mediator.c:442 [main]:
>> Runtime for loop processing 1 callids and generating 1 CDRs was 49847 us.
>> Apr 18 11:05:02 vs4476 (info) mediator[959]: mediator.c:443 [main]: Total
>> CDR creation rate 20.061388 CDR/sec
>>
>>
>> thx
>>
>>
>>
>> Le sam. 18 avr. 2020 à 13:15, Walter Klomp <walter at myrepublic.net> a
>> écrit :
>>
>>> Check if your mediator script doesn’t die or rate-o-mat.  You can check
>>> the logs in /var/log/ngcp/CDR.log and rate-o-mat.log.  I’m guessing
>>> something is broken in your rating logic.
>>>
>>> On Sat, 18 Apr 2020 at 20:02, florent goue <florentgoue at gmail.com>
>>> wrote:
>>>
>>>> Hi I need your help according to my billing and cdr module
>>>>
>>>> I am a new sipwise user.
>>>> I installed version 8.3.3 on my lab. (I get the same problem with the
>>>> 7.5.6 version)
>>>> I set up fees as follows:
>>>>
>>>> #Source PatternDestination PatternMatch ModeDirectionBilling Zone
>>>> 1001 ^111[2-5]\d{6}$ ^111[2-5]\d{6}$ Regular expression - longest
>>>> pattern out Appels intra
>>>>
>>>> <https://185.10.16.240:1443/billing/3/fees/1001/edit?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> <https://185.10.16.240:1443/billing/3/fees/1001/delete?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> 1002 ^111[2-5]\d{6}$ ^111[6-7]\d{4}$ Regular expression - longest
>>>> pattern out Appels extra
>>>>
>>>> <https://185.10.16.240:1443/billing/3/fees/1002/edit?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> <https://185.10.16.240:1443/billing/3/fees/1002/delete?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> 1008 ^111[2-5]\d{4,6}$ @conference\.local$ Regular expression -
>>>> longest pattern out appels vers le systems
>>>>
>>>> <https://185.10.16.240:1443/billing/3/fees/1008/edit?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> <https://185.10.16.240:1443/billing/3/fees/1008/delete?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> 1009 ^111[2-5]\d{4,6}$ @voicebox\.local$ Regular expression - longest
>>>> pattern out appels vers le systems
>>>>
>>>> <https://185.10.16.240:1443/billing/3/fees/1009/edit?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> <https://185.10.16.240:1443/billing/3/fees/1009/delete?back=https%3A%2F%2F185.10.16.240%3A1443%2Fbilling%2F3%2Ffees>
>>>> 1010 ^111[2-5]\d{4,6}$ @vsc\.local$ Regular expression - longest
>>>> pattern out appels vers le systems
>>>>
>>>> My problem:
>>>> Call tests between two clients in the same SIP domain.
>>>> the number 2001200 at domain1 calls the number 2003300 at domain1
>>>> Communication goes smoothly
>>>> But when I look in the subscriber 2001200 at domain1's  call history ,
>>>> the call is not rated and the billing zone does not appear.
>>>> moreover the cdr file is not generated.
>>>> When I restart the server and consult the call history again, billing
>>>> for calls now appears with the billing zone.
>>>> the old cdr is generated.
>>>> This same process begins again when I make a new call.
>>>>
>>>> Can someone help me to understand what's wrong.
>>>>
>>>> Thanks
>>>> Florent GOUE
>>>>
>>>>
>>>> --
>>>> 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/20200418/61b363c7/attachment-0002.html>