[Spce-user] CDRs files are created empty.

[Joel Smith | VOZELIA]

Hi Matthew,

To make a long storry short, It wasn't really "broken". The thing is,
the first test-calls were done with a test-user registered with our
SIPWISE CE and the CDRs were exported OK. The rest of the tests were
done with incoming calls and no CDRs were created. So, really it was
my memory what was broken, not SIPWISE... Today after posting the new
thread I read an answer from Jon on a different thread about something
similar and that made me realise where the problem could be.

After enabling the export_incoming parameter and setting the acct_id
to 0 in MySQL to force the re-export of the CDRs, everything is fine.

Thanks again.

Regards,
Joel.


On Mon, Dec 10, 2012 at 5:02 PM, Matthew Ogden <matthew at tenacit.net> wrote:
> Hi,
>
> Just to clarify, what actually "broke" it?
>
> Kind REgards
>
>> -----Original Message-----
>> From: spce-user-bounces at lists.sipwise.com [mailto:spce-user-
>> bounces at lists.sipwise.com] On Behalf Of Joel Smith | VOZELIA
>> Sent: 10 December 2012 06:00 PM
>> To: Andreas Granig
>> Cc: spce-user at lists.sipwise.com
>> Subject: Re: [Spce-user] CDRs files are created empty.
>>
>> Thank you both Andreas and Jon.
>>
>> All CDRs have been correctly regenerated.
>>
>> Best regards,
>> Joel.
>>
>> On Mon, Dec 10, 2012 at 2:28 PM, Andreas Granig <agranig at sipwise.com>
>> wrote:
>> > Hi,
>> >
>> > On 12/10/2012 02:23 PM, Joel Smith | VOZELIA wrote:
>> >> mysql> select * from mark;
>> >> +----+------------------+--------+
>> >> | id | collector        | acc_id |
>> >> +----+------------------+--------+
>> >> |  1 | exporter-lastseq |   1770 |
>> >> |  2 | exporter-lastid  |    310 |
>> >> +----+------------------+--------+
>> >> 2 rows in set (0.00 sec)
>> >>
>> >> mysql>
>> >>
>> >> If I set exporter-lastid to 0 (or 1?) I assume the export script will
>> >> regenerate the CDRs.
>> >
>> > Setting it to "0" will work.
>> >
>> >> What is the exporter-lastseq for? Do I have to set it to 0 also?
>> >
>> > It defines the sequence number stamped into the file name of the
>> > export file (which increases by one with every file being exported).
>> > In most cases you can keep it as is, but it mainly depends on your
>> > external billing system (whether it keeps track of the sequence number
>> > to detect duplicate exports).
>> >
>> > Andreas
>> >
>> >
>> > _______________________________________________
>> > Spce-user mailing list
>> > Spce-user at lists.sipwise.com
>> > http://lists.sipwise.com/listinfo/spce-user
>> >
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> http://lists.sipwise.com/listinfo/spce-user