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