I am running ser 0.8.12 and serweb_2004-01-04/
Serweb accounting works fine for xten softphones, but ciscos atas records are not shown. Any ideas on how to modify the serweb select query to show them ?
The difference seems to be the aditional ";user=phone" on the sip_from, sip_to, and to_uri fields for atas
example acc table record for cisco ata 186
sip:8840@voip.brujula.net;user=phone;tag=2306858... sip:00541148029550@voip.brujula.net;user=phone 200 ACK sip:00541148029550@200.68.120.81 sip:00541148029550@217.199.177.150 sip:8840@voip.brujula.net;user=phone sip:00541148029550@voip.brujula.net;user=phone 146901752@200.126.199.228 8840 voip.brujula.net 2306858569 n/a 2004-08-21 19:14:48 20040821161448
serweb accounting.php
$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, ". "unix_timestamp(t2.time)-unix_timestamp(t1.time) ". "as seconds ".
"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"; $mc_res=mySQL_query($q);
Thanks for the info Jaime Garcia