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