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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers