This is and old issue that I still have around here ...
-Kamailio 1.5.1 (svn) -PostgreSQL database -Database created with "kamdbctl create", so just clean - in kamailio.cfg: [...] loadmodule "uri_db.so" modparam("uri_db", "db_url", "postgres://openser:XXXXX@localhost:5435/voip3") modparam("uri_db", "db_table", "uri") modparam("uri_db", "user_column", "username") modparam("uri_db", "domain_column", "domain") modparam("uri_db", "uriuser_column", "uri_user") modparam("uri_db", "use_uri_table", 0) modparam("uri_db", "use_domain", 0) [...]
May 24 10:22:27 [23631] INFO:core:init_mod: initializing module auth_db May 24 10:22:27 [23631] INFO:core:init_mod: initializing module uri_db May 24 10:22:27 [23631] ERROR:uri_db:mod_init: Invalid table version of the subscriber table May 24 10:22:27 [23631] ERROR:core:init_mod: failed to initialize module uri_db May 24 10:22:27 [23631] ERROR:core:main: error while initializing modules
And I don't undestand why ... because subscriber table it's on version 6, that is what uri_db checks ...
[uri_db_mod.c] /* Check table version */ ver = uridb_db_ver(&db_url, &db_table); if (ver < 0) { LM_ERR("Error while querying table version\n"); return -1; } else { if (use_uri_table) { if (ver != URI_TABLE_VERSION) { LM_ERR("Invalid table version of the uri table\n"); return -1; } } else { if (ver != SUBSCRIBER_TABLE_VERSION) { LM_ERR("Invalid table version of the subscriber table\n"); return -1; } } } [uri_db_mod.c]
and SUBSCRIBER_TABLE_VERSION has value 6
is there something I'm doing wrong?, last time I compile myself this I was forced to comment that block of code on the uri_db sources.