[OpenSIPS-Devel] [ opensips-Bugs-2863743 ] permissions module: address table columns

[SourceForge.net]

Bugs item #2863743, was opened at 2009-09-21 19:29
Message generated for change (Comment added) made by norm_brandinger
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2863743&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Norm Brandinger (norm_brandinger)
Assigned to: Nobody/Anonymous (nobody)
Summary: permissions module: address table columns

Initial Comment:
The address table isn't created with the default columns used by the permissions module (mysql).

The problem columns are:

ip_col: the default column name is "ip", however the script creates "ip_addr".

proto_col:  the default for column name is "proto", however this column is not created.

from_col: the default column name is "pattern", however this column is not created.

info_col: the default column name is: "context_info", however this column is not created.

It appears that these columns can be created as char or varchar types with some reasonable length attributes.  The module maintainer would probably know the best type/lengths to use for these columns.


----------------------------------------------------------------------

>Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-09-21 20:15

Message:
make dbschema appears to have fixed things up nicely, thank you.

----------------------------------------------------------------------

Comment By: Irina-Maria Stanescu (ironmissy)
Date: 2009-09-21 20:04

Message:
Hi Norm,

The database schema for the address table has been changed. Try make
dbschema and then create the table again.

Regards,
Irina Stanescu

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2863743&group_id=232389