[sr-dev] usrloc db contact field length

[Daniel-Constantin Mierla]

Hello,

probably we have to increase as well if there are such long values, but, 
iirc, the contact column stores only the URI from contact header, isn't 
it like that?

Cheers,
Daniel

On 8/5/13 1:31 PM, Jon Bonilla (Manwe) wrote:
> 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
>
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda