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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-- Daniel-Constantin Mierla http://www.asipto.com