[Users] Permissions and UnixODBC incompatability

Lenir lenirsantiago at yahoo.com
Sat Feb 18 03:34:07 CET 2006


Hey guys,

 

The permissions module doesn't work with unixodbc module, but it works fine
with mysql or postgres. Here's the debut output:

 

 0(0) DEBUG: init_mod: permissions

 0(0) permissions - initializing

 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.allow

 0(0) Default allow file (/usr/local/etc/openser/permissions.allow) not
found => empty rule set

 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.deny

 0(0) Default deny file (/usr/local/etc/openser/permissions.deny) not found
=> empty rule set

 0(0) find_mod_export: found <db_use_table> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_init> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_close> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_query> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_raw_query> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_free_result> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_insert> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_delete> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_update> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) find_mod_export: found <db_replace> in module unixodbc
[/usr/local/lib/openser/modules/unixodbc.so]

 0(0) db_init: Connection
'unixodbc://username:password@xx.xx.xx.xx/sybasetds' not found in pool

 0(0) DEBUG:unixodbc:build_conn_str: connection string is
<DSN=sybasetds;UID=username;PWD=password;> 0(0)
DEBUG:unixodbc:new_connection: connection succeeded with reply
<DSN=sybasetds;UID=username;PWD=password;>

 0(0) DEBUG: register_fifo_cmd: new command (trusted_reload) registered

 0(0) DEBUG: register_fifo_cmd: new command (trusted_dump) registered

 0(0) unixsock_register_cmd: New command (trusted_reload) registered

 0(0) unixsock_register_cmd: New command (trusted_dump) registered

 0(0) Number of rows in trusted table: 3

 0(0) ERROR: permissions: trusted_reload(): Database problem

 0(0) pool_remove: Removing connection from the pool

 0(0) init_trusted(): Reload of trusted table failed

 0(0) Error while initializing allow_trusted function

 

Here's the trusted table, all columns are varchar

src_ip  proto from_pattern


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

 216.82.124.34 any NULL


 216.82.124.35 any NULL


 216.82.124.62 any NULL

Regards,

 

Lenir

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20060217/9bb77804/attachment.htm 


More information about the Users mailing list