[Serusers] SERWEB accounting displays no calls

[steve]

Hi,
I see this as well, in the acc table in MySQL I have the invite and the ack
but no bye.

A trace on ser sees the bye message come via ser but it does not get written
to the database.

The domain is correct in the table.

I have basically copied the accounting section from the ser admin guide.

I have fixed this now by adding this to the if (method=="BYE" ||
method=="CANCEL") {   statement as below

if (loose_route()) {
        if (method=="BYE" || method=="CANCEL") {
         setflag(1);
        log (1, "Accounting flag on\n");
        setflag(1);
        };
                t_relay();
                break;
        };


Hope this helps..


Just need to get missed calls going now..

> -----Original Message-----
> From: serusers-bounces at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Karel Kozlik
> Sent: Thursday 13 May 2004 08:00
> To: Ronald Ramos
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] SERWEB accounting displays no calls
> 
> 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
> > 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 
> ______________________________________________________________
> __________
> This message has been checked for all known viruses by the 
> CitC Virus Scanning Service powered by SkyLabs. For further 
> information visit http://www.citc.it
> 
> ___
>