[OpenSIPS-Users] Error in module permission with db_text
Leonid Nasedkin
leonidnasedkin at gmail.com
Tue Feb 2 13:12:02 CET 2010
Hi, Bogdan.
I have got one more error with module db_text.
loadmodule "avpops.so"
modparam("avpops","db_url","text:///etc/opensips/dbtext/")
modparam("avpops","avp_table","usr_preferences")
modparam("avpops","use_domain",0)
modparam("avpops","uuid_column","uuid")
modparam("avpops","username_column","username")
modparam("avpops","domain_column","domain")
modparam("avpops","attribute_column","attribute")
modparam("avpops","type_column","type")
modparam("avpops","value_column","value")
...
avp_db_load("mediaproxy-RU","$avp(s:mediaproxy_ip)")
...
usr_preferences:
id(int,auto) uuid(str) username(str) domain(str) attribute(str) type(int)
value(str) last_modified(double,null)
10:mediaproxy-DEFAULT:mediaproxy-DEFAULT:domain:mediaproxy_ip:0:value:0
20:mediaproxy-RU:mediaproxy-RU:domain:mediaproxy_ip:0:value:0
And I see in log:
Feb 2 12:03:51 dev-sip /usr/sbin/opensips[19536]:
DBG:db_text:dbt_load_file: loading file
[/etc/opensips/dbtext//usr_preferences]
Feb 2 12:03:51 dev-sip /usr/sbin/opensips[19536]: ERROR:db_text:dbt_query:
table does not exist!
Feb 2 12:03:51 dev-sip /usr/sbin/opensips[19536]:
ERROR:avpops:ops_dbload_avps: db_load failed
2010/1/26 Bogdan-Andrei Iancu <bogdan at voice-system.ro>
> Hi Leonid,
>
> Thanks for testing - I uploaded the fix on the 1.6 branch also.
>
>
> Regards,
> Bogdan
>
> Леонид Наседкин wrote:
>
>> Hi, Bogdan.
>> Its working now. Thanks.
>> 2010/1/26 Bogdan-Andrei Iancu <bogdan at voice-system.ro <mailto:
>> bogdan at voice-system.ro>>
>>
>>
>> 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 <bogdan at voice-system.ro
>> <mailto:bogdan at voice-system.ro>
>> <mailto:bogdan at voice-system.ro
>> <mailto:bogdan at voice-system.ro>>>
>>
>> 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 <http://www.voice-system.ro>
>>
>>
>>
>>
>>
>> --
>> WBR, Leonid Nasedkin
>> cell: +7 923 731 0077
>> icq: 256816
>> skype: leonidnasedkin
>>
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
--
WBR, Leonid Nasedkin
cell: +7 923 731 0077
icq: 256816
skype: leonidnasedkin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100202/b05a048a/attachment-0001.htm
More information about the Users
mailing list