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@openser.org [mailto:users-bounces@openser.org] On Behalf Of Kelvin Williams
Sent: Saturday, June 16, 2007
12:56 PM
To:
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