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:
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