RE: [Users] ERROR: permissions: address_reload(): Database problem - Update

In testing, it appears anytime there is a record in the address table my module will not load. Are there any other tables that should be updated when updating address? kw _____ From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On Behalf Of Kelvin Williams Sent: Saturday, June 16, 2007 12:56 PM To: users(a)openser.org Subject: [Users] ERROR: permissions: address_reload(): Database problem My permissions module refuses to load due to a "database problem." OpenSER can access this database (as it does for other modules) and I have even went as far as defining the table in the module's parameters even though it is a default installation. Any help would be greatly appreciated. OpenSER version 1.2.1 with TLS Database: PostgreSQL Openser.cfg: loadmodule "permissions.so" modparam("permissions", "db_url", "postgres://<<snip>> ") modparam("permissions", "db_mode", 0) modparam("permissions", "trusted_table", "trusted") modparam("permissions", "address_table", "address") modparam("permissions", "grp_col", "grp") modparam("permissions", "ip_addr_col", "ip_addr") modparam("permissions", "mask_col", "mask") modparam("permissions", "port_col", "port") modparam("permissions", "default_allow_file", "/usr/local/etc/openser/permissions.allow") modparam("permissions", "default_deny_file", "/usr/local/etc/openser/permissions.deny") Database: openser=> select * from address; id | grp | ip_addr | mask | port ----+-----+-------------+------+------ 1 | 1 | <removed> | 32 | 5060 openser.log: Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: permissions - initializing Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: Default allow file (/usr/local/etc/openser/permissions.allow) not found => empty rule set Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: Default deny file (/usr/local/etc/openser/permissions.deny) not found => empty rule set Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: ERROR: permissions: address_reload(): Database problem Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: permissions:init_addresses(): Reload of address table failed Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: Error while initializing allow_address function Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]: init_mod(): Error while initializing module permissions