[Spce-user] Restart Billing

Andrew Pogrebennyk apogrebennyk at sipwise.com
Wed May 2 11:35:59 EDT 2012


Hi,
To re-rate all CDRs you should rating_status to unrated in the cdr table:
mysql billing
update cdr set rating_status='unrated';

To re-export CDRs you have to set the exporter-lastid in the mark table
accordingly:
update mark set acc_id=1 where collector='exporter-lastid';

Please note that *all* CDRs with an ID above that value
will be re-exported, not only the re-rated ones. You may need to remove
your old exporter files:
rm -rf /home/jail/home/cdrexport/2012*

On 05/02/2012 04:18 PM, Voip Netkia wrote:
> Hello,
> 
> I wanted to know how to operate the billing without having to redo the
> entire server, because initially billed me, but I miss some errors bill,
> once it is assumed that errors are fixed as billing judgment and never
> come out, the charges, know her somehow or some command to get it
> working again ... I would love to start from scratch.
> 
> Well thank you all in advance. a greeting




More information about the Spce-user mailing list