[Spce-user] CDRs files are created empty.

[Joel Smith | VOZELIA]

Hi everybody,

I'm having some issues with the creation of CDRs files. For some
reason they are always empty:

The last CDR file generated the 04/12/2012:

root at sipomv1:/home/jail/home/cdrexport/201212/04# cat
sipwise_004_20121204235501_0000001502.cdr
004,0000
8b95ef5133080048ee49802826a83701
root at sipomv1:/home/jail/home/cdrexport/201212/04#

Looking into the logs of that day:

root at sipomv1:/var/log/ngcp/old# zcat rate-o-mat.log-20121204.gz  |
grep -v "No new CDRs to rate"
Dec  4 10:21:10 sipomv1 rate-o-mat[1404]: rate cdr #300
Dec  4 10:21:10 sipomv1 rate-o-mat[1404]: 300 CDRs rated so far.
Dec  4 10:21:10 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 10:21:30 sipomv1 rate-o-mat[1404]: rate cdr #301
Dec  4 10:21:31 sipomv1 rate-o-mat[1404]: 301 CDRs rated so far.
Dec  4 10:21:31 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 10:22:51 sipomv1 rate-o-mat[1404]: rate cdr #302
Dec  4 10:22:51 sipomv1 rate-o-mat[1404]: 302 CDRs rated so far.
Dec  4 10:22:51 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:19:11 sipomv1 rate-o-mat[1404]: rate cdr #303
Dec  4 12:19:11 sipomv1 rate-o-mat[1404]: 303 CDRs rated so far.
Dec  4 12:19:11 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:19:21 sipomv1 rate-o-mat[1404]: rate cdr #304
Dec  4 12:19:22 sipomv1 rate-o-mat[1404]: 304 CDRs rated so far.
Dec  4 12:19:22 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:19:42 sipomv1 rate-o-mat[1404]: rate cdr #305
Dec  4 12:19:42 sipomv1 rate-o-mat[1404]: 305 CDRs rated so far.
Dec  4 12:19:42 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:20:12 sipomv1 rate-o-mat[1404]: rate cdr #306
Dec  4 12:20:12 sipomv1 rate-o-mat[1404]: 306 CDRs rated so far.
Dec  4 12:20:12 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:21:32 sipomv1 rate-o-mat[1404]: rate cdr #307
Dec  4 12:21:32 sipomv1 rate-o-mat[1404]: 307 CDRs rated so far.
Dec  4 12:21:32 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:24:52 sipomv1 rate-o-mat[1404]: rate cdr #308
Dec  4 12:24:52 sipomv1 rate-o-mat[1404]: 308 CDRs rated so far.
Dec  4 12:24:52 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:25:22 sipomv1 rate-o-mat[1404]: rate cdr #309
Dec  4 12:25:22 sipomv1 rate-o-mat[1404]: 309 CDRs rated so far.
Dec  4 12:25:22 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:27:32 sipomv1 rate-o-mat[1404]: rate cdr #310
Dec  4 12:27:32 sipomv1 rate-o-mat[1404]: 310 CDRs rated so far.
Dec  4 12:27:32 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
Dec  4 12:28:22 sipomv1 rate-o-mat[1404]: rate cdr #311
Dec  4 12:28:23 sipomv1 rate-o-mat[1404]: 311 CDRs rated so far.
Dec  4 12:28:23 sipomv1 rate-o-mat[1404]: Less than 5 new CDRs rated, sleep 10
root at sipomv1:/var/log/ngcp/old#

root at sipomv1:/var/log/ngcp/old# zcat cdr.log-20121204.gz
Dec  4 10:21:08 sipomv1 mediator[1957]: Overall 300 CDRs created so far.
Dec  4 10:21:21 sipomv1 mediator[1957]: Overall 301 CDRs created so far.
Dec  4 10:22:44 sipomv1 mediator[1957]: Overall 302 CDRs created so far.
Dec  4 12:19:08 sipomv1 mediator[1957]: Overall 303 CDRs created so far.
Dec  4 12:19:21 sipomv1 mediator[1957]: Overall 304 CDRs created so far.
Dec  4 12:19:34 sipomv1 mediator[1957]: Overall 305 CDRs created so far.
Dec  4 12:20:07 sipomv1 mediator[1957]: Overall 306 CDRs created so far.
Dec  4 12:21:31 sipomv1 mediator[1957]: Overall 307 CDRs created so far.
Dec  4 12:24:44 sipomv1 mediator[1957]: Overall 308 CDRs created so far.
Dec  4 12:25:17 sipomv1 mediator[1957]: Overall 309 CDRs created so far.
Dec  4 12:27:30 sipomv1 mediator[1957]: Overall 310 CDRs created so far.
Dec  4 12:28:14 sipomv1 mediator[1957]: Overall 311 CDRs created so far.
root at sipomv1:/var/log/ngcp/old#


Scenario:

- I have two SIP Peering Contracts, each with a its own billing plan.

- I have multiple peers each assigned to one of the contracts.

- My billing plans are exact copies of the default billing plan just
for testing purposes (only the name of the billing plan changes).


It looks like mediator and rate-o-mat are working, but the CDRs aren't
been written to files.

Any clues what other logs I can check or what can be the problem?


Thanks in advanced.


Regards,
Joel.