[Serusers] acc module bug ??

[Zeus Ng]

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
>