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