[sr-dev] usrloc db contact field length

[Jon Bonilla (Manwe)]

Hi all

I've recently seen error messages in the kamailio log regarding the mysql
driver not being able to store the registration:

"ERROR: db_mysql [km_dbase.c:122]: driver error on query: Data too long for
column 'contact' at row 1"


I've checked that my location table is VARCHAR(255)  but some device Contact
fields are longer than that.

A couple of examples:

Contact:
<sip:0049555555555555 at XXX.XXX.XXX.XXX:2048;line=vkb2a7l8>;reg-id=1;q=1.0;+sip.instance="<urn:uuid:be1d1sdf-683b-fffb-844c-00041323A4F5>";audio;mobility="fixed";duplex="full";description="snom360";actor="principal";events="dialog";methods="INVITE,ACK,CANCEL,BYE,REFER,OPTIONS,NOTIFY,SUBSCRIBE,PRACK,MESSAGE,INFO'


Contact:
<sip:004966666666666 at XXX.YYY.YYY.YYY:2048;line=vkb2a7l8>;q=1;expires=3600;pub-gruu="sip:0049666666666666 at sip.mydomain.org;gr=urn:uuid:be1d15ba-gggb-40eb-gggc-05551323A4F5";temp-gruu="sip:uloc-51666af5-23ec-86149e-8c466689 at sip.mydomain.org;gr";+sip.instance="<urn:uuid:be1dddba-683b-40eb-555c-00078823A4F5>";reg-id=1


I'll have to increase the field size in my installations. I'd like to know if
this is something to be pulled upstream and in that case what would be the
desired size.



cheers,

Jon