[Spce-user] Fwd: ngcp-fraud-auto-lock

[Richard Fuchs]

Hi,

Can you enter your mysql console and post the output of the following
commands, substituting $ID for the account ID of your subscriber?

> select * from billing.contracts where id = $ID;

> select * from billing.contract_balances where contract_id = $ID;

> select * from billing.billing_mappings m, billing.billing_profiles p
where p.id = m.billing_profile_id and m.contract_id = $ID;

Thanks


On 03/21/13 11:43, Alejandro Sanchez Gimenez wrote:
> Hi again!!
> 
> I´m still blocked at this point. I can´t get fraud auto-lock working. In
> my test configuration I have in my billing profile:
> 
> Fraud Monthly Limit: 1 (this is "one cent", as I understand from
> documentation)
> Fraund Monthly Lock: incoming and outgoing
> 
> I have only one catch-all fee for this billing profile, where init rate
> is 15 (cents), so in the first call, the account reaches its limit. I
> can see cdrs for the subscriber working correctly, with correct data in
> duration and charges. For example, for the subscriber´s first call:
> 
> duration: 00:05
> charges: 0.15€
> 
> At this point I execute "ngcp-fraud-auto-lock" but the subscriber can
> still make and receive calls. Where could be the problem? Rating is also
> working properly, because I have also tested with interval free
> time/cash and I get correct data.
> 
> Thanks a lot.
> 
> 
> ------------------------------------------------------------------------
> *De: *"Alejandro Sanchez Gimenez" <alesg at coit.es>
> *Para: *spce-user at lists.sipwise.com
> *Enviados: *Martes, 26 de Febrero 2013 12:59:41
> *Asunto: *ngcp-fraud-auto-lock
> 
> Hi all!!
> 
> I have read it is possible to change the cronjob ngcp-fraud-auto-lock to
> be executed more than once a day. Would it be any problem if it is
> executed for exmple each five minutes? Could the system play any
> announcement if the subscriber´s balance is about to expire?
> 
> Thanks a lot!!
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 900 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130321/e36cefe0/attachment-0001.asc>