Summary:ASTERISK-23639: PJSIP Realtime: Alembic migration needed in order to widen some string columns
Reporter:Mark Michelson (mmichelson)Labels:
Date Opened:2014-04-17 14:57:30Date Closed:2014-04-24 09:40:03
Status:Closed/CompleteComponents:Contrib/General Resources/res_pjsip
Versions:12.0.0 12.1.0 12.1.1 Frequency of
Description: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.
Comments:By: Matt Jordan (mjordan) 2014-04-17 16:08:59.926-0500

Agreed on these being 255 characters.