<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2734.1600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Regarding the message below that I posted earlier
today. I have some additional info..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2>Darren Nay</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dnay@libertyisp.com href="mailto:dnay@libertyisp.com">Darren Nay</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, December 29, 2003 11:51
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> SQL Accounting - Problems</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hey All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>stateless - initializing<BR> 0(5814)
Warning: uac does not spread accross the whole hash table<BR>Maxfwd module-
initializing<BR>acc - initializing<BR> 0(5814) mod_init(): Database
connection opened successfuly<BR>textops - initializing<BR> 0(5814)
auth_db:mod_init(): Database connection opened successfuly<BR> 0(0) INFO:
udp_init: SO_RCVBUF is initially 8192<BR> 0(0) INFO: udp_init: SO_RCVBUF
is finally 262144<BR> 2(5816) INFO: fifo process starting:
5816<BR> 2(5816) SER: open_uac_fifo: fifo server up at
/tmp/ser_fifo...<BR> 2(5816) WARNING: no fifo_db_url given - fifo DB
commands disabled!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This below is what I get when I make a
call...</DIV>
<DIV><BR> 0(5814) BUG:tm:register_tmcb: no transaction
found<BR> 0(5814) ERROR:acc:acc_onreq: cannot register additional
callbacks<BR> 0(5814) BUG:tm:register_tmcb: no transaction
found<BR> 0(5814) ERROR:acc:acc_onreq: cannot register additional
callbacks</DIV>
<DIV> </DIV>
<DIV>My call processing is working perfectly, but the accounting transactions
(call records) are not being saved into the database in the "acc" table.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>I have attached me ser.cfg as well.</DIV>
<DIV> </DIV>
<DIV>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!</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV>
<DIV>Darren Nay - <A
href="mailto:dnay@libertyisp.com">dnay@libertyisp.com</A></DIV>
<DIV></FONT> </DIV></BLOCKQUOTE></BODY></HTML>