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@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Karel Kozlik Sent: Thursday 13 May 2004 08:00 To: Ronald Ramos Cc: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@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

---