16 Jun
2007
16 Jun
'07
7:56 p.m.
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
16 Jun
16 Jun
8:18 p.m.
New subject: [Users] ERROR: permissions: address_reload(): Database problem - Update
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(a)openser.org [mailto:users-bounces@openser.org] On Behalf
Of Kelvin Williams
Sent: Saturday, June 16, 2007 12:56 PM
To: users(a)openser.org
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
17 Jun
17 Jun
7:22 p.m.
The database table is built as the database script intended. What could the
error be with Postgres?
openser=# \d address
Table "public.address"
Column | Type | Modifiers
---------+-----------------------+------------------------------------------
------------
id | integer | not null default
nextval('address_id_seq'::regclass)
grp | smallint | not null default 0::smallint
ip_addr | character varying(15) | not null default ''::character varying
mask | numeric(4,0) | not null default 32
port | smallint | not null default 0::smallint
Indexes:
"address_pkey" PRIMARY KEY, btree (id)
openser=# insert into address (grp, ip_addr, mask, port) values
(1,'192.168.1.1',32,5060);
INSERT 0 1
openser=# select * from address;
id | grp | ip_addr | mask | port
----+-----+-------------+------+------
2 | 1 | 192.168.1.1 | 32 | 5060
(1 row)
openser=#
[root@gaia openser]# openserctl start
database engine 'PGSQL' loaded
Control engine 'FIFO' loaded
Starting OpenSER :
ERROR: PID file /var/run/openser.pid does not exist -- OpenSER start failed
[root@gaia openser]# tail -f /var/log/openser.log
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: AUTH module -
initializing
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: AUTH_DB module -
initializing
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: AVPops - initializing
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: permissions -
initializing
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: Default allow file
(/usr/local/etc/openser/permissions.allow) not found => empty rule set
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: Default deny file
(/usr/local/etc/openser/permissions.deny) not found => empty rule set
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: ERROR: permissions:
address_reload(): Database problem
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]:
permissions:init_addresses(): Reload of address table failed
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: Error while
initializing allow_address function
Jun 17 12:18:35 gaia /usr/local/sbin/openser[20500]: init_mod(): Error while
initializing module permissions
openser=# delete from address;
DELETE 1
openser=# \q
[kelvin@gaia ~]$ su -
Password:
[root@gaia ~]# openserctl start
database engine 'PGSQL' loaded
Control engine 'FIFO' loaded
Starting OpenSER : INFO: started (pid: 20550)
[root@gaia ~]#
-----Original Message-----
From: Juha Heinanen [mailto:jh@tutpro.com]
Sent: Saturday, June 16, 2007 1:43 PM
To: Kelvin Williams
Cc: users(a)openser.org
Subject: [Users] ERROR: permissions: address_reload(): Database problem
Jun 16 12:45:15 gaia /usr/local/sbin/openser[2871]:
ERROR: permissions:
address_reload(): Database problem
this error occurs if checking of a row types and values fails. if your
ip address field is ok, then perhaps the error has something to do with
postgres.
-- juha
18 Jun
18 Jun
12:14 p.m.
On Sonntag, 17. Juni 2007, Kelvin Williams wrote:
The database table is built as the database script
intended. What could
the error be with Postgres?
openser=# \d address
[..]
This table is the same as in mysql, only the grp and port colums in mysql
are 'unsigned smallint' instead of 'smallint'. And i think this module
works
with mysql in 1.2.
Cheers,
Henning
6368
days inactive
6370
days old
4 comments
3 participants
participants (3)
-
Henning Westerholt -
jh＠tutpro.com -
Kelvin Williams