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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users