[Spce-user] rate-o-mat disabled. Not starting.
Dario D. Busso
dbusso at sipwise.com
Thu Jul 24 00:34:06 EDT 2014
Hi Theo,
what does report the rate-o-mat in the log file rate-o-mat.log?
Il 23/lug/2014 22:00 Theo <axessofficetheo at gmail.com> ha scritto:
>
> Hmm, the cdrs are back now, including the missing ones. No idea why they are now showing up?
>
> Just rate o mat that's not starting. As mentioned, we're not rating at this point so it's not affecting anything, but we want to start looking at rating calls through sipwise so we'd better get rate o mat going :-)?
>
>
> On Wed, Jul 23, 2014 at 9:56 PM, Theo <axessofficetheo at gmail.com> wrote:
>>
>> Hi
>>
>> I have updated 2.8 to the latest version. Rate o mat still fails to start for the same reason though?
>>
>>
>> On Wed, Jul 23, 2014 at 2:35 PM, Theo <axessofficetheo at gmail.com> wrote:
>>>
>>> Hi Daniel
>>>
>>> I will do so tonight when things are quiet and let you know if it fixed the issue. I am on the 2.8Lt version currently which truth-be-told has not been updated for a while so let's.
>>>
>>> Cheers
>>>
>>>
>>> On Wed, Jul 23, 2014 at 2:32 PM, Daniel Grotti <dgrotti at sipwise.com> wrote:
>>>>
>>>> Hi,
>>>> we had some issue for missing entries in billing_mapping, and we fixed some problem.
>>>> Please update to the latest release packages.
>>>>
>>>> Daniel
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 07/23/2014 02:26 PM, Theo wrote:
>>>>>
>>>>> I was close then with my amateur queries, but not close enough :-)
>>>>>
>>>>> So I reckon this is the issue?:
>>>>>
>>>>> 21 | 14 | 0 | 0 | 0 | 0 | 2013-04-01 00:00:00 | 2013-04-30 23:59:59 | NULL |
>>>>> | 24 | 14 | 0 | 0 | 0 | 0 | 2013-05-01 00:00:00 | 2013-05-31 23:59:59 | NULL |
>>>>> | 32 | 14 | 0 | 0 | 0 | 0 | 2013-06-01 00:00:00 | 2013-06-30 23:59:59 | NULL |
>>>>> | 37 | 14 | 0 | 0 | 0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59 | NULL |
>>>>> | 38 | 14 | 0 | 0 | 0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59 | NULL |
>>>>> | 44 | 14 | 0 | 0 | 0 | 0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59 | NULL |
>>>>> | 46 | 14 | 0 | 0 | 0 | 0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59 | NULL |
>>>>> | 48 | 14 | 0 | 0 | 0 | 0 | 2013-11-01 00:00:00 | 2013-11-30 23:59:59 | NULL |
>>>>> | 49 | 14 | 0 | 0 | 0 | 0 | 2013-12-01 00:00:00 | 2013-12-31 23:59:59 | NULL |
>>>>> | 52 | 14 | 0 | 0 | 0 | 0 | 2014-01-01 00:00:00 | 2014-01-31 23:59:59 | NULL |
>>>>> | 56 | 14 | 0 | 0 | 0 | 0 | 2014-03-01 00:00:00 | 2014-03-31 23:59:59 | NULL |
>>>>> | 58 | 14 | 0 | 0 | 0 | 0 | 2014-04-01 00:00:00 | 2014-04-30 23:59:59 | NULL |
>>>>> | 60 | 14 | 0 | 0 | 0 | 0 | 2014-05-01 00:00:00 | 2014-05-31 23:59:59 | NULL |
>>>>> | 62 | 14 | 0 | 0 | 0 | 0 | 2014-06-01 00:00:00 | 2014-06-30 23:59:59 | NULL |
>>>>> | 63 | 14 | 0 | 0 | 0 | 0 | 2014-07-01 00:00:00 | 2014-07-31 23:59:59 | NULL |
>>>>>
>>>>> Looks like Feb is missing. Question of course is: why is it missing? and what do I do about it? It's of no consequence right now because we don't use it for rating anyway but would love to understand the issue?
>>>>>
>>>>>
>>>>> On Wed, Jul 23, 2014 at 2:17 PM, Daniel Grotti <dgrotti at sipwise.com> wrote:
>>>>>>
>>>>>> Hi,
>>>>>> go to mysql:
>>>>>>
>>>>>>
>>>>>> > select * from accounting.cdr where id=401875\G;
>>>>>>
>>>>>> then:
>>>>>>
>>>>>> > select * from billing.contract_balances where contract_id=<cdr.source_account_id>;
>>>>>> > select * from billing.billing_mappings where contract_id=<cdr.source_account_id>;
>>>>>>
>>>>>> You should have a result from those.
>>>>>> If not, the contract is missing, which means that customer has no billing profile.
>>>>>>
>>>>>> Daniel
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 07/23/2014 02:10 PM, Theo wrote:
>>>>>>>
>>>>>>> Hi Daniel
>>>>>>>
>>>>>>> I set this up over a year ago, so possibly I did. I can't really think of a reason why I would have but will check that. In the meantime:
>>>>>>>
>>>>>>> Still struggling to get past my error.
>>>>>>>
>>>>>>> Error rating CDR batch: No contract balance for CDR 401875 found
>>>>>>>
>>>>>>> I have found the other posts regarding this issue but am not quite getting it. I understand this is related to the contract balance. My first step is to find out to which contract this belongs. I am not succeeding with that but that's mostly because I am not familiar enough with msql I am sure. Could someone help me with the exact steps to identify the contract id this belongs to?
>>>>>>>
>>>>>>> Incidentally we are not yet using the rating at all, but we do need the cdrs to show up in the webinterface. However, we intend switching on the rating soonish.
>>>>>>>
>>>>>>> Thanks a lot!
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Jul 23, 2014 at 2:06 PM, Daniel Grotti <dgrotti at sipwise.com> wrote:
>>>>>>>>
>>>>>>>> Hi,
>>>>>>>> Are you sure you didn't touch your config.yml file ?
>>>>>>>>
>>>>>>>> rateomat:
>>>>>>>> enable: 'no'
>>>>>>>> loopinterval: 10
>>>>>>>> splitpeakparts: 0
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Daniel
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 07/23/2014 11:41 AM, Theo wrote:
>>>>>>>>>
>>>>>>>>> Ok I found the rate o mat config file and it had: RATEOMAT_RUN=no
>>>>>>>>>
>>>>>>>>> which I changed to yes. Still have an error but at least it's attempting to start now. Will try and solve the error first, but why would this have been set to no? I cannot remember ever touching this file?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Jul 23, 2014 at 11:34 AM, Theo <axessofficetheo at gmail.com> wrote:
>>>>>>>>>>
>>>>>>>>>> Hi
>>>>>>>>>>
>>>>>>>>>> After a reboot of our system our cdrs are not generated. This would be because rate o mat is not running, but when trying to start I get:
>>>>>>>>>>
>>>>>>>>>> rate-o-mat disabled. Not starting.
>>>>>>>>>>
>>>>>>>>>> /var/log/ngcp/rate-o-mat.log is empty
>>>>>>>>>>
>>>>>>>>>> Any ideas?
>>>>>>>>>>
>>>>>>>>>> Thanks a lot in advance
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>>
>>>>>>>>> Spce-user mailing list
>>>>>>>>>
>>>>>>>>> Spce-user at lists.sipwise.com
>>>>>>>>>
>>>>>>>>> https://lists.sipwise.com/listinfo/spce-user
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Spce-user mailing list
>>>>>>>> Spce-user at lists.sipwise.com
>>>>>>>> https://lists.sipwise.com/listinfo/spce-user
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Spce-user mailing list
>>>>>> Spce-user at lists.sipwise.com
>>>>>> https://lists.sipwise.com/listinfo/spce-user
>>>>>>
>>>>>
>>>>
>>>
>>
>
More information about the Spce-user
mailing list