[asterisk-bugs] [JIRA] (ASTERISK-23639) PJSIP Realtime: Alembic migration needed in order to widen some string columns

[Kevin Harwell (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-23639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Harwell closed ASTERISK-23639.
------------------------------------

    Resolution: Fixed

> PJSIP Realtime: Alembic migration needed in order to widen some string columns
> ------------------------------------------------------------------------------
>
>                 Key: ASTERISK-23639
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23639
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General, Resources/res_pjsip
>    Affects Versions: 12.0.0, 12.1.0, 12.1.1
>            Reporter: Mark Michelson
>            Assignee: Kevin Harwell
>
> It has been observed that the string lengths on certain columns created through alembic for PJSIP are too short. Specifically, all columns that store URIs are currently bounded at 40 characters, but this can be too small.
> Known columns to update are
> Table ps_contacts:
>   column id
>   column uri
> Table ps_registrations:
>   column client_uri
>   column server_uri
> In addition, while an issue has not been observed yet, the user_agent column in the ps_contacts table may need to be lengthened as well.
> I recommend something large like 255 or something as the new length of the strings for the columns.



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