[Serusers] SERWEB accounting displays no calls
Karel Kozlik
kozlik at kufr.cz
Thu May 13 08:59:38 CEST 2004
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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
More information about the sr-users
mailing list