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