[Serusers] Re: SQL Accounting - Problems

[Darren Nay]

Hello,

Is anyone able to help me with this??  If the developers of the "acc" module
are on this list can you please check this out?  It looks to me like it
might be a bug caused by new changes to the "acc" module.  This problem did
not exist in the stable release of SER 8.12.  Just in the CVS head.

The problem is that I can't use the stable release of SER 8.12 because I
need the new NAT Helper functionality of the CVS head.

If this is not a bug .. perhaps changes in the way that "acc" needs to be
configured?? .. then could you please explain what I am doing wrong?

Any help would be very much appreciated!  Thanks!

Darren Nay - dnay at libertyisp.com


----- Original Message -----
From: Darren Nay
To: Darren Nay ; serusers at lists.iptel.org
Sent: Monday, December 29, 2003 3:48 PM
Subject: Re: SQL Accounting - Problems


Regarding the message below that I posted earlier today.  I have some
additional info..

I have tested this same accounting config on version 8.12 stable release of
SER and it works fine.  Is there bug in the SQL "acc" module for 8.12 CVS
head?

Thanks!
Darren Nay

----- Original Message -----
From: Darren Nay
To: serusers at lists.iptel.org
Sent: Monday, December 29, 2003 11:51 AM
Subject: SQL Accounting - Problems


Hey All,

I am trying to get SQL accounting to work within SER, but I am having a
problem.  The data is not being saved into the database.

I've got the SER configured to use accounting.  I've compiled the "acc"
module with SQL support, and I believe that everything should be working..
However, I am getting the following errors in debug mode..

stateless - initializing
 0(5814) Warning: uac does not spread accross the whole hash table
Maxfwd module- initializing
acc - initializing
 0(5814) mod_init(): Database connection opened successfuly
textops - initializing
 0(5814) auth_db:mod_init(): Database connection opened successfuly
 0(0) INFO: udp_init: SO_RCVBUF is initially 8192
 0(0) INFO: udp_init: SO_RCVBUF is finally 262144
 2(5816) INFO: fifo process starting: 5816
 2(5816) SER: open_uac_fifo: fifo server up at /tmp/ser_fifo...
 2(5816) WARNING: no fifo_db_url given - fifo DB commands disabled!

This below is what I get when I make a call...

 0(5814) BUG:tm:register_tmcb: no transaction found
 0(5814) ERROR:acc:acc_onreq: cannot register additional callbacks
 0(5814) BUG:tm:register_tmcb: no transaction found
 0(5814) ERROR:acc:acc_onreq: cannot register additional callbacks

My call processing is working perfectly, but the accounting transactions
(call records) are not being saved into the database in the "acc" table.

Also, my userloc registrations are being saved to the database in the
"locations" table, and so I know that there isn't a problem with my mysql.so
module.  The database connectivity seems to be fine.

I have attached me ser.cfg as well.

If anyone knows why I am getting these errors, and why my accounting isn't
being saved to the "acc" table in the database then I would very much
appreciate the help!

Thanks!
Darren Nay - dnay at libertyisp.com