Hi Leonid, An official fix is available on SVN trunk (rev 6534). I would really appreciate if you could give it a try and test - if ok, I will do the backport.
Thanks and regards, Bogdan Bogdan-Andrei Iancu wrote: > Ok, I will investigate to come up with an official fix. > > Thanks and regards, > Bogdan > > Леонид Наседкин wrote: > >> Hi Bogdan >> Thank you. Its working now. >> >> 2010/1/15 Bogdan-Andrei Iancu <[email protected] >> <mailto:[email protected]>> >> >> 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 >> >> ------------------------------------------------------------------------ >> >> -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
