<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
hello,<br>
<br>
It seems that the column type and value type are mismatching, but
they can still be compatible.<br>
<br>
The fact is that db_text was not designed to handle large data
values, so not tested with presence. Eventually you may want use
sqlite (or other db module) instead or go into db_text and update as
needed.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 06/10/14 15:14, Marino Mileti wrote:<br>
</div>
<blockquote cite="mid:148e599155c.marino.mileti@alice.it"
type="cite">Hi guys,<br>
<br>
with Kamailio 4.1.6 standard configuration and dbtext as db
module, when server receives a publish message on the log there's:<br>
<br>
ERROR: db_text [dbt_base.c:391]: dbt_insert(): incompatible types
v[5] - c[7]!<br>
ERROR: presence [presentity.c:402]: update_presentity(): inserting
new record in database<br>
ERROR: presence [publish.c:464]: handle_publish(): when updating
presentity<br>
<br>
and the server reply with 500 Server Internal Error.<br>
<br>
My conf is standard I've only used DBURL to point to my dbtext
files: I've enable presence and presence_xml module<br>
<br>
# ----- presence params -----<br>
modparam("presence", "db_url", text:///opt/kamailio-orig/dbtext)<br>
modparam("presence", "db_table_lock_type", 0)<br>
modparam("presence_xml", "db_url",
text:///opt/kamailio-orig/dbtext)<br>
modparam("presence_xml", "force_active", 1)<br>
<br>
Any idea?<br>
<br>
Marino<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>