My new OpenSER server will not load the permissions
module. I built this box from source downloaded from the openser.org site
three days ago (openser-1.2.1-tls_src.tar.gz), and populated my PostgreSQL
database with the scripts/postgresqldb.sh script included with the source.
I’m setting up permissions.so like:
loadmodule
"permissions.so"
modparam("permissions",
"db_url", "postgres://<<snip>>")
modparam("permissions",
"db_mode", 0)
modparam("permissions",
"trusted_table", "trusted")
modparam("permissions",
"ip_addr_col", "src_ip")
modparam("permissions",
"default_allow_file",
"/usr/local/etc/openser/permissions.allow")
modparam("permissions",
"default_deny_file",
"/usr/local/etc/openser/permissions.deny")
When I attempt to start
openser with the permissions module, I receive the following in the log:
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: permissions - initializing
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: Default allow file (/usr/local/etc/openser/permissions.allow)
not found => empty rule set
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: Default deny file
(/usr/local/etc/openser/permissions.deny) not found => empty rule set
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: permissions:init_addresses(): Invalid table
version 2 - expected 3
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: Error while initializing allow_address function
Jun 14 19:13:21 gaia
/usr/local/sbin/openser[21948]: init_mod(): Error while initializing module
permissions
I have verified the table is in the database:
openser=# select * from trusted;
id | src_ip | proto | from_pattern | tag
----+--------+-------+--------------+-----
(0 rows)
I was instructed to increment the version of the
table in the database, and I did using the information from the log (changing
the version to 3) and still received the same error. The version table
had the following for trusted when it was installed (from script):
openser=# select * from version where table_name =
'trusted';
table_name | table_version
------------+---------------
trusted
| 4
(1 row)
Any light that someone could shed on this for me
would be greatly appreciated.
Many thanks,
Kw