[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