[Users] ERROR: permissions: address_reload(): Database problem

[Kelvin Williams]

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 at 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 at 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 at gaia ~]$ su -

Password:

[root at gaia ~]# openserctl start

database engine 'PGSQL' loaded

Control engine 'FIFO' loaded

 

Starting OpenSER : INFO: started (pid: 20550)

[root at gaia ~]#

 

-----Original Message-----
From: Juha Heinanen [mailto:jh at tutpro.com] 
Sent: Saturday, June 16, 2007 1:43 PM
To: Kelvin Williams
Cc: users at 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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070617/ee3588f9/attachment.htm