3 May
2006
3 May
'06
3:36 p.m.
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.).
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?
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.)???
cheers
3 May
3 May
3:43 p.m.
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
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.).
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?
no, the order is not relevant.
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.)???
openser just
writes in acc, there is no compatibility issue that implies
openser.
Cheers,
Daniel
cheers
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
4:24 p.m.
Hmmm.
well, heres an interesting issue then
I have an additional column (src_ip) which I log using db_extra
("src_ip=$avp($srcIp);)
It works.
Well, mostly works.
If I CANCEL an INVITE, I get the following error
9(9231) ACC: call missed:
call_id=3c6d8d5f15f9-7a9jw7ca79xt@snom190........
9(9231) submit_query: Unknown column 'src_ip' in 'field list'
9(9231) db_insert: Error while submitting query
Inspecting acc shows that the CANCEL got logged, but the INVITE didn't.
However, INVITEs get logged for /all/ other transactions.
Anything obvious?
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?
cheers
Daniel-Constantin Mierla wrote:
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
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.).
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?
no, the order is not relevant.
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.)???
openser
just writes in acc, there is no compatibility issue that
implies openser.
Cheers,
Daniel
cheers
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
4:36 p.m.
the missed_calls table must have same structure as acc table. The same
information is saved in both tables (similar to location and aliases
tables).
Cheers,
Daniel
On 05/03/2006 05:24 PM, Mahesh Paolini-Subramanya wrote:
Hmmm.
well, heres an interesting issue then
I have an additional column (src_ip) which I log using db_extra
("src_ip=$avp($srcIp);)
It works.
Well, mostly works.
If I CANCEL an INVITE, I get the following error
9(9231) ACC: call missed:
call_id=3c6d8d5f15f9-7a9jw7ca79xt@snom190........
9(9231) submit_query: Unknown column 'src_ip' in 'field list'
9(9231) db_insert: Error while submitting query
Inspecting acc shows that the CANCEL got logged, but the INVITE didn't.
However, INVITEs get logged for /all/ other transactions.
Anything obvious?
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?
cheers
Daniel-Constantin Mierla wrote:
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
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.).
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?
no, the order is not relevant.
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.)???
openser
just writes in acc, there is no compatibility issue that
implies openser.
Cheers,
Daniel
cheers
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
5:09 p.m.
aaargh.
i totally forgot about the missed_calls table.
thanx
cheers
p.s. why does the CANCEL still get logged to acc?
Daniel-Constantin Mierla wrote:
the missed_calls table must have same structure as acc
table. The same
information is saved in both tables (similar to location and aliases
tables).
Cheers,
Daniel
On 05/03/2006 05:24 PM, Mahesh Paolini-Subramanya wrote:
Hmmm.
well, heres an interesting issue then
I have an additional column (src_ip) which I log using db_extra
("src_ip=$avp($srcIp);)
It works. Well, mostly works. If I CANCEL an INVITE, I get the
following error
9(9231) ACC: call missed:
call_id=3c6d8d5f15f9-7a9jw7ca79xt@snom190........
9(9231) submit_query: Unknown column 'src_ip' in 'field list'
9(9231) db_insert: Error while submitting query
Inspecting acc shows that the CANCEL got logged, but the INVITE didn't.
However, INVITEs get logged for /all/ other transactions.
Anything obvious?
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?
cheers
Daniel-Constantin Mierla wrote:
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
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.).
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?
no, the order is not
relevant.
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.)???
openser just writes in acc, there is no compatibility issue that
implies openser.
Cheers,
Daniel
cheers
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
5:32 p.m.
Mahesh Paolini-Subramanya wrote:
aaargh.
i totally forgot about the missed_calls table.
thanx
cheers
p.s. why does the CANCEL still get logged to acc?
maybe you account failed transactions?
Daniel-Constantin Mierla wrote:
the missed_calls table must have same structure
as acc table. The same
information is saved in both tables (similar to location and aliases
tables).
Cheers,
Daniel
On 05/03/2006 05:24 PM, Mahesh Paolini-Subramanya wrote:
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users Hmmm.
well, heres an interesting issue then
I have an additional column (src_ip) which I log using db_extra
("src_ip=$avp($srcIp);)
It works. Well, mostly works. If I CANCEL an INVITE, I get the
following error
9(9231) ACC: call missed:
call_id=3c6d8d5f15f9-7a9jw7ca79xt@snom190........
9(9231) submit_query: Unknown column 'src_ip' in 'field list'
9(9231) db_insert: Error while submitting query
Inspecting acc shows that the CANCEL got logged, but the INVITE didn't.
However, INVITEs get logged for /all/ other transactions.
Anything obvious?
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?
cheers
Daniel-Constantin Mierla wrote:
On 05/03/2006 04:36 PM, Mahesh Paolini-Subramanya wrote:
> 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.).
> 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?
no, the order is not relevant.
>
> 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.)???
openser just writes in acc, there is no compatibility issue that
implies openser.
Cheers,
Daniel
>
> cheers
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6787
days inactive
6787
days old
5 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Klaus Darilion -
Mahesh Paolini-Subramanya