[SR-Users] Presence PUBLISH error

Marino Mileti marino.mileti at alice.it
Wed Oct 8 10:11:22 CEST 2014


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: miconda at gmail.com

Data: 6-ott-2014 18.17

A: "Marino Mileti"<marino.mileti at alice.it>, "Kamailio (SER) - Users Mailing List"<sr-users at 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 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/20141008/e55d1ad2/attachment.html>


More information about the sr-users mailing list