Re: [sr-dev] usrloc db contact field length

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 _______________________________________________ sr-dev mailing list sr-dev(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev