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@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@XXX.YYY.YYY.YYY:2048;line=vkb2a7l8>;q=1;expires=3600;pub-gruu="sip:0049666666666666@sip.mydomain.org;gr=urn:uuid:be1d15ba-gggb-40eb-gggc-05551323A4F5";temp-gruu="sip:uloc-51666af5-23ec-86149e-8c466689@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