[Users] ERROR: permissions: address_reload(): Database problem

[Kelvin Williams]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070616/b3ad245c/attachment.htm>