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

[klaus.lists at inode.at]

Hello Daniel,

thanks for the fix. Kamdbctl initialisation is now working fine with
Postgres, too.

However, I've found another problem - with KAMCTL now. This problem is
related to the re-written module LCR:

None of the options { show_gws | show_routes | dump_gws | dump_routes |
reload } can be used with the command 'kamctl lcr'


The DB request (options show_gws + show_routes) is pointing to the old
tables / relations that do no longer exist. This problem is independent of
the DB-Engine type.
An exemplary error message is:
hostA:/usr/local/etc/kamailio# kamctl lcr show_routes
lcr routes
ERROR:  relation "lcr" does not exist


The three other attributes seem to be not implemented in the script.
Following error messages are displayed after execution:

hostA:/usr/local/etc/kamailio# kamctl lcr dump_gws
/usr/local/sbin/kamctl: line 1134: lcr.dump_gws: command not found

hostA:/usr/local/etc/kamailio# kamctl lcr dump_routes
/usr/local/sbin/kamctl: line 1137: lcr.dump_lcrs: command not found

hostA:/usr/local/etc/kamailio# kamctl lcr reload
/usr/local/sbin/kamctl: line 1131: lcr.reload: command not found

regards,
Klaus Feichtinger


>   Hello,
>
> creating pgsql database should be fixed now. Thanks for reporting. Let
> me know if all goes ok for you.
>
> Cheers,
> Daniel
>
> On 9/30/10 10:19 AM, klaus.lists at inode.at wrote:
>> 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
>>
>>
>>
>> _______________________________________________
>> sr-dev mailing list
>> sr-dev at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
> --
> Daniel-Constantin Mierla
> http://www.asipto.com