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