[Serusers] serweb accounting for cisco ata 186

[Jaime G. Ghirelli]

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 at voip.brujula.net;user=phone>;tag=2306858...
<sip:00541148029550 at voip.brujula.net;user=phone>  200  ACK
sip:00541148029550 at 200.68.120.81  sip:00541148029550 at 217.199.177.150
sip:8840 at voip.brujula.net;user=phone
sip:00541148029550 at voip.brujula.net;user=phone
146901752 at 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

http://voip.brujula.net