[Serusers] SERWEB accounting displays no calls

[Ronald Ramos]

Hi All,

I have configured ser to use mysql accounting, and I can see it being
log on mysql.

But when I tried looking at all my calls using SERWEB, the accounting
just display no calls.

I looked at config.php and $table_accounting is acc, what do I need to
change on the accounting.php?

Below is the query part of accounting.php what is the value of t1 and t2
on that script?



        $q="select t1.to_uri, t1.sip_to, t1.sip_callid, t1.time, ".
                "t1.fromtag as invft, t2.fromtag as byeft, t2.totag as
byett, ".
 
"sec_to_time(unix_timestamp(t2.time)-unix_timestamp(t1.time)) ".
                        "as length ".
                "from ".$config->table_accounting." t1, ".
                        $config->table_accounting." t2 ".
                "where t1.username='".$auth->auth["uname"]."' and ".
                        "t1.domain='".$config->realm."' and ".
                        "t1.sip_callid=t2.sip_callid and ".
                        "t1.sip_method='INVITE' and t2.sip_method='BYE'
".
                "order by t1.time desc";

Thank you

Ronald