[Devel] Re: [Users] Permissions and UnixODBC incompatability

[Daniel-Constantin Mierla]

Hello,

On 02/18/06 04:34, Lenir wrote:
>
> 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
>
looking in the code, it seems that the module did not accept NULL values 
in columns. Juha just committed on cvs some changes, it seems to be 
related to this issue. See:
http://openser.org/pipermail/devel/2006-February/002015.html

Cheers,
Daniel

> Regards,
>
> Lenir
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>