Thanks Daniel, I'm trying to use sqlite (mysql is too "heavy" for my environment) but usually I receive a lot of commit failed because database is locked (especially in presentity.c and publish.c) Is there any way to manage, maybe i've missed some sqlite configuration parameters?
----Messaggio originale---- Da: mico...@gmail.com Data: 6-ott-2014 18.17 A: "Marino Mileti"<marino.mil...@alice.it>, "Kamailio (SER) - Users Mailing List"<sr-users@lists.sip-router.org> Ogg: Re: [SR-Users] Presence PUBLISH error 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@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
_______________________________________________ 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