[Serusers] acc module bug ??

[Java Rockx]

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