RE: [Serusers] acc module bug ??

-----Original Message----- From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@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@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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers