[sr-dev] Kamailio 3.1 testing - PGSQL initialisation problems

[klaus.lists at inode.at]

Hello,

I've heard your appeal to support testing the new pre-release 3.1 of
kamailio. So I started with compiling and installing it. My focus is / was
testing kamailio 3.1 with DB engine POSTGRESQL.

However, my testing phase was stopped very early, because "kamdbctl
create" was stopped by an error message related to creating the table
"lcr". AFAIK the tables / table names have changed, because Juha has
modified this module as discussed earlier in this list. Could this be the
reason why kamdbctl stopped? It seems that the script still knows only the
old relations within the DB.

The error message looks as follows:

voiceserver1:/usr/local/etc/kamailio# kamdbctl create
INFO: creating database openser ...
NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for
serial column "acc.id"
[...]
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dialplan_pkey" for table "dialplan"
ERROR:  relation "lcr" does not exist
ERROR:  relation "lcr" does not exist
ERROR:  relation "lcr_id_seq" does not exist
ERROR:  relation "lcr_id_seq" does not exist
ERROR: Grant privileges to standard tables failed!


I recommend CHECKING the initialisation script(s) for POSTGRESQL in
general. Because in the previous release 3.0.3 the problem / error with
wrong settings for column attributes especially for presence related
tables  (as discussed in spring this year - see
http://lists.sip-router.org/pipermail/sr-dev/2010-June/007896.html) is
still present!

regards,
Klaus Feichtinger