Re: [Users] Permissions and UnixODBC incompatability

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