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