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

[Mark Michelson (JIRA)]

Mark Michelson created ASTERISK-23639:
-----------------------------------------

             Summary: 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.1.1, 12.1.0, 12.0.0
            Reporter: Mark Michelson


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)