Re: [Serusers] SERWEB accounting displays no calls

Hi Ronald, check records in MySQL if contains right value in domain atribute. Also check if are there two records with same sip_callid, but first with sip_method='INVITE' and second with sip_method='BYE'

Karel

Ronald Ramos wrote:

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

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers