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