[OpenSIPS-Users] Error in module permission with db_text

Bogdan-Andrei Iancu bogdan at voice-system.ro
Fri Jan 15 17:15:13 CET 2010


Hi Leonid,

Looks like there is a compatibility bug between permission and db_text 
modules when comes to DB data types....Give me couple of days to sort 
this out.

In the mean while, if you want to use db_text for permissions, please 
use the attached patch.

Thanks and regards,
Bogdan


Леонид Наседкин wrote:
> Hi there.
> I'm trying to use permission module with db_text, and it's not 
> working, and I can't understand what's wrong.
> Opensips 1.6.1 svnrevision: 2:6509
>
> In opensips.cfg:
> loadmodule "db_text.so"
> modparam("db_text", "db_mode", 0)
> loadmodule "permissions.so"
> modparam("permissions","db_url", "text:///etc/opensips/dbtext")
>
> In /etc/opensips/dbtext/address:
> id(int,auto) grp(int) ip(str) mask(int) port(int) proto(str) 
> pattern(str,null) context_info(str,null)
> 10:1:10.100.0.0:23:5060:udp::
> 20:1:10.110.0.0:23:5060:udp::
> 30:1:10.120.0.0:23:5060:udp::
>
> LOG:
>
> DBG:core:init_mod: initializing module permissions
> DBG:permissions:mod_init: initializing...
> WARNING:permissions:parse_config_file: file not found: 
> /etc/opensips/permissions.allow
> WARNING:permissions:mod_init: default allow file 
> (/etc/opensips/permissions.allow) not found => empty rule set
> WARNING:permissions:parse_config_file: file not found: 
> /etc/opensips/permissions.deny
> WARNING:permissions:mod_init: default deny file 
> (/etc/opensips/permissions.deny) not found => empty rule set
> DBG:core:find_mod_export: found <db_bind_api> in module db_text 
> [/usr/lib/opensips/modules/]
> DBG:core:db_bind_mod: using db bind api for db_text
> INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext/
> DBG:db_text:dbt_cache_get_db: looking for db /etc/opensips/dbtext/!
> DBG:db_text:dbt_cache_get_db: new db!
> DBG:db_text:dbt_load_file: request for table [version]
> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
> DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//version]
> DBG:db_text:dbt_table_new: mtime is 1263556066
> DBG:db_text:dbt_load_file: column[0] is STR!
> DBG:db_text:dbt_load_file: column[1] is INT!
> DBG:db_text:dbt_query: new res with 1 cols
> DBG:db_text:dbt_result_new: new res with 1 cols
> DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b044
> DBG:core:db_allocate_columns: allocate 16 bytes for result columns at 
> 0x816aedc
> DBG:core:db_allocate_rows: allocate 28 bytes for result rows and 
> values at 0x816b090
> DBG:core:db_free_columns: freeing result columns at 0x816aedc
> DBG:core:db_free_rows: freeing 1 rows
> DBG:core:db_free_row: freeing row values at 0x816b098
> DBG:core:db_free_rows: freeing rows at 0x816b090
> DBG:core:db_free_result: freeing result set at 0x816b044
> DBG:db_text:dbt_load_file: request for table [address]
> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
> DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//address]
> DBG:db_text:dbt_table_new: mtime is 1263558311
> DBG:db_text:dbt_load_file: column[0] is INT!
> DBG:db_text:dbt_load_file: column[1] is INT!
> DBG:db_text:dbt_load_file: column[2] is STR!
> DBG:db_text:dbt_load_file: column[3] is INT!
> DBG:db_text:dbt_load_file: column[4] is INT!
> DBG:db_text:dbt_load_file: column[5] is STR!
> DBG:db_text:dbt_load_file: column[6] is STR!
> DBG:db_text:dbt_load_file: column[7] is STR!
> DBG:db_text:dbt_query: new res with 8 cols
> DBG:db_text:dbt_result_new: new res with 8 cols
> DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b004
> DBG:core:db_allocate_columns: allocate 128 bytes for result columns at 
> 0x8186b68
> DBG:core:db_allocate_rows: allocate 504 bytes for result rows and 
> values at 0x8186bf4
> DBG:permissions:reload_address_table: number of rows in address table: 3
> ERROR:permissions:reload_address_table: database problem
> DBG:core:db_free_columns: freeing result columns at 0x8186b68
> DBG:core:db_free_rows: freeing 3 rows
> DBG:core:db_free_row: freeing row values at 0x8186c0c
> DBG:core:db_free_row: freeing row values at 0x8186cac
> DBG:core:db_free_row: freeing row values at 0x8186d4c
> DBG:core:db_free_rows: freeing rows at 0x8186bf4
> DBG:core:db_free_result: freeing result set at 0x816b004
> CRITICAL:permissions:init_address: reload of address table failed
> ERROR:permissions:mod_init: failed to initialize the allow_address 
> function
> ERROR:core:init_mod: failed to initialize module permissions
> ERROR:core:main: error while initializing modules
> DBG:db_text:destroy: destroy ...
>
>
> -- 
> WBR, Leonid Nasedkin
> icq: 256816
> skype: leonidnasedkin
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro

-------------- next part --------------
A non-text attachment was scrubbed...
Name: permission.patch
Type: text/x-diff
Size: 1164 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20100115/560415e7/attachment.patch 


More information about the Users mailing list