Hi, I have kamailio 4.2 with presence, auth, textdb activated.
The scenario is that Kamailio receives a SUBSCRIBE, sends 200ok then a NOTIFY. (like it should do)
The problem is what when I kill kamailio and run it again, it gives me this error: 0(30580) ERROR: db_text [dbt_tb.c:474]: dbt_table_check_row(): null value not allowed - field 17 0(30580) DEBUG: db_text [dbt_file.c:480]: dbt_load_file(): error at row=1 col=26 c=1 0(30580) ERROR: db_text [dbt_lib.c:307]: dbt_db_get_table(): could not load database from file [active_watchers] 0(30580) ERROR: db_text [dbt_base.c:460]: dbt_delete(): failed to load table <active_watchers>!
The field with null values is record_route, so if I put some value I manage to run kamailio.
my conf, maybe I missed some field?
#!define DBURL "text:///etc/kamailio/dbtext" #!ifdef WITH_PRESENCE modparam("presence", "db_url", DBURL) modparam("presence", "max_expires", 3600) modparam("presence", "server_address", "sip:10.0.37.1:5060" ) modparam("pua_reginfo", "default_domain", "10.0.37.1") modparam("pua_reginfo", "server_address", "sip:10.0.37.1") modparam("pua_reginfo", "outbound_proxy", "sip:10.0.37.1") modparam("pua_reginfo", "publish_reginfo", 1) modparam("pua", "db_mode", 2) modparam("pua", "hash_size", 11) modparam("pua", "db_url", DBURL) modparam("pua", "db_table", "pua") modparam("pua", "min_expires", 0) modparam("pua", "default_expires", 3600) modparam("pua", "update_period", 1000) modparam("pua", "dlginfo_increase_version", 1) modparam("pua", "reginfo_increase_version", 1) modparam("pua", "check_remote_contact", 0) modparam("pua", "fetch_rows", 1000) modparam("presence_xml", "db_url", DBURL) modparam("presence_xml", "force_active", 1) #!endif
Or as a workaround, can I reset the active_watchers table every time I start kamailio? because *kamdbctl create/drop/init* wipes all the other tables...
thanks a lot!
Alex
Hello,
it might be something specific to db_text module, which is a rather basic db storage engine -- it has to be checked. Can you try with another database type (e.g., sqlite, mysql, ...)?
Cheers, Daniel
On 24/03/15 10:43, Alexandru Raileanu wrote:
Hi, I have kamailio 4.2 with presence, auth, textdb activated.
The scenario is that Kamailio receives a SUBSCRIBE, sends 200ok then a NOTIFY. (like it should do)
The problem is what when I kill kamailio and run it again, it gives me this error: 0(30580) ERROR: db_text [dbt_tb.c:474]: dbt_table_check_row(): null value not allowed - field 17 0(30580) DEBUG: db_text [dbt_file.c:480]: dbt_load_file(): error at row=1 col=26 c=1 0(30580) ERROR: db_text [dbt_lib.c:307]: dbt_db_get_table(): could not load database from file [active_watchers] 0(30580) ERROR: db_text [dbt_base.c:460]: dbt_delete(): failed to load table <active_watchers>!
The field with null values is record_route, so if I put some value I manage to run kamailio.
my conf, maybe I missed some field?
#!define DBURL "text:///etc/kamailio/dbtext" #!ifdef WITH_PRESENCE modparam("presence", "db_url", DBURL) modparam("presence", "max_expires", 3600) modparam("presence", "server_address", "sip:10.0.37.1:5060 http://10.0.37.1:5060" ) modparam("pua_reginfo", "default_domain", "10.0.37.1") modparam("pua_reginfo", "server_address", "sip:10.0.37.1") modparam("pua_reginfo", "outbound_proxy", "sip:10.0.37.1") modparam("pua_reginfo", "publish_reginfo", 1) modparam("pua", "db_mode", 2) modparam("pua", "hash_size", 11) modparam("pua", "db_url", DBURL) modparam("pua", "db_table", "pua") modparam("pua", "min_expires", 0) modparam("pua", "default_expires", 3600) modparam("pua", "update_period", 1000) modparam("pua", "dlginfo_increase_version", 1) modparam("pua", "reginfo_increase_version", 1) modparam("pua", "check_remote_contact", 0) modparam("pua", "fetch_rows", 1000) modparam("presence_xml", "db_url", DBURL) modparam("presence_xml", "force_active", 1) #!endif
Or as a workaround, can I reset the active_watchers table every time I start kamailio? because *kamdbctl create/drop/init* wipes all the other tables...
thanks a lot!
Alex
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Ok thanks,
I will try with mysql I was thinking to give it a try, but since the value was missing I tought it's a record_route value saving problem
thanks! Alex
On Wed, Mar 25, 2015 at 7:40 AM, Daniel-Constantin Mierla <miconda@gmail.com
wrote:
Hello,
it might be something specific to db_text module, which is a rather basic db storage engine -- it has to be checked. Can you try with another database type (e.g., sqlite, mysql, ...)?
Cheers, Daniel
On 24/03/15 10:43, Alexandru Raileanu wrote:
Hi,I have kamailio 4.2 with presence, auth, textdb activated.
The scenario is that Kamailio receives a SUBSCRIBE, sends 200ok then a NOTIFY. (like it should do)
The problem is what when I kill kamailio and run it again, it gives me this error: 0(30580) ERROR: db_text [dbt_tb.c:474]: dbt_table_check_row(): null value not allowed - field 17 0(30580) DEBUG: db_text [dbt_file.c:480]: dbt_load_file(): error at row=1 col=26 c=1 0(30580) ERROR: db_text [dbt_lib.c:307]: dbt_db_get_table(): could not load database from file [active_watchers] 0(30580) ERROR: db_text [dbt_base.c:460]: dbt_delete(): failed to load table <active_watchers>!
The field with null values is record_route, so if I put some value I manage to run kamailio.
my conf, maybe I missed some field?
#!define DBURL "text:///etc/kamailio/dbtext" #!ifdef WITH_PRESENCE modparam("presence", "db_url", DBURL) modparam("presence", "max_expires", 3600) modparam("presence", "server_address", "sip:10.0.37.1:5060" ) modparam("pua_reginfo", "default_domain", "10.0.37.1") modparam("pua_reginfo", "server_address", "sip:10.0.37.1") modparam("pua_reginfo", "outbound_proxy", "sip:10.0.37.1") modparam("pua_reginfo", "publish_reginfo", 1) modparam("pua", "db_mode", 2) modparam("pua", "hash_size", 11) modparam("pua", "db_url", DBURL) modparam("pua", "db_table", "pua") modparam("pua", "min_expires", 0) modparam("pua", "default_expires", 3600) modparam("pua", "update_period", 1000) modparam("pua", "dlginfo_increase_version", 1) modparam("pua", "reginfo_increase_version", 1) modparam("pua", "check_remote_contact", 0) modparam("pua", "fetch_rows", 1000) modparam("presence_xml", "db_url", DBURL) modparam("presence_xml", "force_active", 1) #!endif
Or as a workaround, can I reset the active_watchers table every time I start kamailio? because *kamdbctl create/drop/init* wipes all the other tables...
thanks a lot!
Alex
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com
-
Alexandru Raileanu -
Daniel-Constantin Mierla