[SR-Users] Presence PUBLISH error

[Daniel-Constantin Mierla]

hello,

It seems that the column type and value type are mismatching, but they 
can still be compatible.

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.

Cheers,
Daniel

On 06/10/14 15:14, Marino Mileti wrote:
> Hi guys,
>
> with Kamailio 4.1.6 standard configuration and dbtext as db module, 
> when server receives a publish message on the log there's:
>
> ERROR: db_text [dbt_base.c:391]: dbt_insert(): incompatible types v[5] 
> - c[7]!
> ERROR: presence [presentity.c:402]: update_presentity(): inserting new 
> record in database
> ERROR: presence [publish.c:464]: handle_publish(): when updating 
> presentity
>
> and the server reply with 500 Server Internal Error.
>
> My conf is standard I've only used DBURL to point to my dbtext files: 
> I've enable presence and presence_xml module
>
> # ----- presence params -----
> modparam("presence", "db_url", text:///opt/kamailio-orig/dbtext)
> modparam("presence", "db_table_lock_type", 0)
> modparam("presence_xml", "db_url", text:///opt/kamailio-orig/dbtext)
> modparam("presence_xml", "force_active", 1)
>
> Any idea?
>
> Marino
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141006/2349b72a/attachment.html>