[SR-Users] Presence PUBLISH error

[Marino Mileti]

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

[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

Post by Marino Mileti
Hi guys,
with Kamailio 4.1.6 standard configuration and dbtext as db module,
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.
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
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[Marino Mileti]

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-***@public.gmane.org

Data: 6-ott-2014 18.17

A: "Marino Mileti"<marino.mileti-1Ph4/***@public.gmane.org>, "Kamailio (SER) - Users Mailing List"<sr-users-cR8azDVoa3IcDhw6gZKtMWD2FQJk+8+***@public.gmane.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-cR8azDVoa3IcDhw6gZKtMWD2FQJk+8+***@public.gmane.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