[asterisk-bugs] [JIRA] (ASTERISK-28022) res_pjsip realtime: uri column in ps_contacts table can be too short

[Friendly Automation (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-28022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=244638#comment-244638 ] 

Friendly Automation commented on ASTERISK-28022:
------------------------------------------------

Change 9995 merged by Joshua Colp:
alembic: increase uri column size

[https://gerrit.asterisk.org/9995|https://gerrit.asterisk.org/9995]

> res_pjsip realtime: uri column in ps_contacts table can be too short
> --------------------------------------------------------------------
>
>                 Key: ASTERISK-28022
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28022
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_pjsip
>    Affects Versions: 13.22.0, 15.5.0, 16.0.0
>         Environment: Debian 9.5 "stretch"
>            Reporter: Florian Floimair
>            Assignee: Florian Floimair
>            Severity: Minor
>              Labels: pjsip
>      Target Release: 13.23.0
>
>
> When mobile SIP clients register with Asterisk that use some sort of push notifications, the URI can get quite lengthy due to the additional push-service annotations (things like tokens, pn-type, etc.) contained in it.
> The current uri column in ps_contacts is 255 characters, but we have seen instances with Android devices (that have very long tokens) where the resulting URI was actually up to 280 characters long.
> As a result, the URI is truncated to the 255 characters allowed and outgoing calls to the endpoint are failing. Also re-registrations of the client do not match the previous contact entry since the comparison cannot result to "equal".
> I have prepared an alembic script that extends the uri column to twice the size.



--
This message was sent by Atlassian JIRA
(v6.2#6252)