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=#
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] ~]$ su -
Password:
[EMAIL PROTECTED] ~]# openserctl start
database engine 'PGSQL' loaded
Control engine 'FIFO' loaded
Starting OpenSER : INFO: started (pid: 20550)
[EMAIL PROTECTED] ~]#
-----Original Message-----
From: Juha Heinanen [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 16, 2007 1:43 PM
To: Kelvin Williams
Cc: [email protected]
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
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
