<div dir="ltr"><div><div><div><div>Ok thanks,<br><br></div>I will try with mysql<br></div>I was thinking to give it a try, but since the value was missing I tought it's a record_route value saving problem<br><br></div>thanks!<br></div>Alex<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 25, 2015 at 7:40 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
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, ...)?<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 24/03/15 10:43, Alexandru Raileanu
wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>Hi, <br>
</div>
I have kamailio 4.2<br>
</div>
with presence, auth, textdb activated. <br>
<br>
The scenario is that Kamailio receives a SUBSCRIBE,
sends 200ok then a NOTIFY. (like it should do)<br>
<br>
</div>
The problem is what when I kill kamailio and run it
again, it gives me this error: <br>
0(30580) ERROR: db_text [dbt_tb.c:474]:
dbt_table_check_row(): null value not allowed - field
17<br>
0(30580) DEBUG: db_text [dbt_file.c:480]:
dbt_load_file(): error at row=1 col=26 c=1<br>
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>!<br>
<br>
</div>
The field with null values is record_route, so if I put
some value I manage to run kamailio. <br>
<br>
</div>
<br>
</div>
my conf, maybe I missed some field?<br>
<br>
#!define DBURL "text:///etc/kamailio/dbtext"<br>
#!ifdef WITH_PRESENCE<br>
modparam("presence", "db_url", DBURL)<br>
modparam("presence", "max_expires", 3600)<br>
modparam("presence", "server_address", "sip:<a href="http://10.0.37.1:5060" target="_blank">10.0.37.1:5060</a>"
)<br>
modparam("pua_reginfo", "default_domain", "10.0.37.1")<br>
modparam("pua_reginfo", "server_address", <a>"sip:10.0.37.1"</a>)<br>
modparam("pua_reginfo", "outbound_proxy", <a>"sip:10.0.37.1"</a>)<br>
modparam("pua_reginfo", "publish_reginfo", 1)<br>
modparam("pua", "db_mode", 2)<br>
modparam("pua", "hash_size", 11)<br>
modparam("pua", "db_url", DBURL)<br>
modparam("pua", "db_table", "pua")<br>
modparam("pua", "min_expires", 0)<br>
modparam("pua", "default_expires", 3600)<br>
modparam("pua", "update_period", 1000)<br>
modparam("pua", "dlginfo_increase_version", 1)<br>
modparam("pua", "reginfo_increase_version", 1)<br>
modparam("pua", "check_remote_contact", 0)<br>
modparam("pua", "fetch_rows", 1000)<br>
modparam("presence_xml", "db_url", DBURL)<br>
modparam("presence_xml", "force_active", 1)<br>
#!endif<br>
<br>
</div>
<div>Or as a workaround, can I reset the active_watchers table
every time I start kamailio? because <b>kamdbctl
create/drop/init</b> wipes all the other tables...<br>
</div>
<div><br>
</div>
thanks a lot!<br>
<br>
</div>
Alex<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</font></span></div>
</blockquote></div><br></div>