<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hmmm.<br>
<br>
well, heres an interesting issue then<br>
I have an additional column (src_ip) which I log using db_extra
("src_ip=$avp($srcIp);)<br>
It works. <br>
Well, mostly works. <br>
If I CANCEL an INVITE, I get the following error<br>
9(9231) ACC: call missed:
call_id=3c6d8d5f15f9-7a9jw7ca79xt@snom190........<br>
9(9231) submit_query: Unknown column 'src_ip' in 'field list'<br>
9(9231) db_insert: Error while submitting query<br>
Inspecting acc shows that the CANCEL got logged, but the INVITE didn't.<br>
However, INVITEs get logged for <i>all</i> other transactions.<br>
<br>
Anything obvious?<br>
<br>
Come to think of it, it looks like acc logs both the INVITE and the
CANCEL when the transaction is completed. Is this correct? Should it
work this way? Or should it log the INVITE once it passes it on, and
then log the CANCEL later?<br>
<br>
cheers<br>
<br>
<br>
<br>
Daniel-Constantin Mierla wrote:
<blockquote cite="mid4458B386.9030304@voice-system.ro" type="cite"><br>
<br>
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
<br>
<blockquote type="cite">I've added a couple of fields to the acc
table (and am logging additional information to them, e.g., src_ip,
some avps, etc.).
<br>
Is the order of the fields in acc relevant? i.e. if the modparam
statement has the fields listed in the order field1, field2, field3, do
the columns need to be in the same order?
<br>
</blockquote>
no, the order is not relevant.
<br>
<blockquote type="cite"><br>
I guess a bigger question is, does my adding columns to acc cause any
larger compatibility issues (ignore upgrading acc for a moment. also,
i know, i should have 'em in a different table, etc., etc.)???
<br>
</blockquote>
openser just writes in acc, there is no compatibility issue that
implies openser.
<br>
<br>
Cheers,
<br>
Daniel
<br>
<br>
<blockquote type="cite"><br>
cheers
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@openser.org">Users@openser.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://openser.org/cgi-bin/mailman/listinfo/users">http://openser.org/cgi-bin/mailman/listinfo/users</a>
<br>
</blockquote>
<br>
</blockquote>
</body>
</html>