| 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:30 | Date Closed: | 2014-04-24 09:40:03 |
| Priority: | Major | Regression? | No |
| Status: | Closed/Complete | Components: | Contrib/General Resources/res_pjsip |
| Versions: | 12.0.0 12.1.0 12.1.1 | Frequency of Occurrence | |
| Related Issues: | |||
| Environment: | Attachments: | ||
| 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. | ||