[Serusers] acc module bug ??

[Java Rockx]

Thanks again Zeus.

Paul

--- Zeus Ng <zeus.ng at isquare.com.au> wrote:

> No bug in accounting module as per your problem. You are not getting them
> because your accounting format does not include those parameters. The
> default one will do. Check the README file for details.
> 
> Zeus
> 
> > -----Original Message-----
> > From: serusers-bounces at lists.iptel.org 
> > [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Java Rockx
> > Sent: Thursday, 30 September 2004 12:21 PM
> > To: ser users
> > Subject: [Serusers] acc module bug ??
> > 
> > 
> > Hello All.
> > 
> > I've got a question about the acc module accounting for 
> > missed calls. Right now missed call records are recorded the 
> > ser/missed_calls table in my MySQL database.
> > 
> > serweb does not show missed calls. I turned on SQL tracing 
> > and identified why serweb is not showing the records from the 
> > missed_calls table.
> > 
> > The SQL being executed is as follows:
> > 
> > (SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status  
> > FROM missed_calls t1
> > WHERE t1.username='1002' and t1.domain='mycompany.com' 
> > ) UNION (
> > SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status 
> > FROM missed_calls t1, aliases t2 
> > WHERE 'sip:1002 at mycompany.com'=t2.contact AND 
> > t2.username=t1.username AND 
> > t2.domain=t1.domain)
> > 
> > The problem that the missed_calls.username and 
> > missed_calls.domain columns are NULL which causes the query 
> > to return zero rows.
> > 
> > Is this a bug in the acc module, or have I forgotten to do 
> > something in ser.cfg?
> > 
> > My acc module params are as follows:
> > 
> > modparam("acc", "db_flag", 1)
> > modparam("acc", "db_missed_flag", 1)
> > modparam("acc", "log_fmt", "fisum")
> > modparam("acc", "report_ack", 1)
> > modparam("acc", "log_level", 1)
> > modparam("acc", "failed_transactions", 1)
> > modparam("acc", "report_cancels", 2)
> > modparam("acc", "db_url", "mysql://ser:pwd@sipdb01.mycompany.com/ser")
> > 
> > I'm using ser 0.8.99-dev6
> > 
> > Regards,
> > Paul
> > 
> > 
> > 		
> > _______________________________
> > Do you Yahoo!?
> > Declare Yourself - Register online to vote today! 
> > http://vote.yahoo.com
> > 
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
> > 
> 
> 



		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com