[asterisk-bugs] [JIRA] (ASTERISK-29056) Increase reg_server column size for ps_contacts table realtime

[Friendly Automation (JIRA)]

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

Friendly Automation commented on ASTERISK-29056:
------------------------------------------------

Change 14901 merged by George Joseph:
realtime: Increased reg_server character size

[https://gerrit.asterisk.org/c/asterisk/+/14901|https://gerrit.asterisk.org/c/asterisk/+/14901]

> Increase reg_server column size for ps_contacts table realtime
> --------------------------------------------------------------
>
>                 Key: ASTERISK-29056
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29056
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Resources/General
>    Affects Versions: 17.6.0
>            Reporter: sungtae kim
>            Assignee: sungtae kim
>            Severity: Minor
>
> Currently, the ps_contacts table's reg_server column in realtime database type is varchar(20).
> This is fine for normal cases, but if the hostname is longer than 20, it returns error and then failed to register the contact address of the peer.
> Normally, 20 characters limitation for the hostname is fine, but with the cloud env, it is easy to have a longer hostname than 20.
> So, it is better to change it to have a bigger character size.
> {noformat}
> [Aug 31 10:42:12] WARNING[16899]: res_odbc.c:538 ast_odbc_print_errors: SQL Execute returned an error: 22001: [ma-3.1.4][5.7.25-google-log]Data too long for column 'reg_server' at row 1
> [Aug 31 10:42:12] WARNING[16899]: res_odbc.c:433 ast_odbc_prepare_and_execute: SQL Execute error -1!
> [Aug 31 10:42:12] DEBUG[16899]: res_odbc.c:817 ast_odbc_release_obj: Releasing ODBC handle 0x558c15665b40 into pool
> [Aug 31 10:42:12] DEBUG[16899]: sorcery.c:2020 sorcery_wizard_create: Sorcery wizard 'config' does not support creation
> [Aug 31 10:42:12] ERROR[16899]: res_pjsip_registrar.c:776 register_aor_core: Unable to bind contact 'sip:101 at 127.0.0.1:6680;transport=UDP;rinstance=53d944e021099036' to AOR '101'
> [Aug 31 10:42:13] DEBUG[15793]: res_pjsip/pjsip_distributor.c:394 find_dialog: Could not find matching transaction for Request msg OPTIONS/cseq=10 (rdata0x7f3428017418)
> [Aug 31 10:42:13] DEBUG[15793]: res_pjsip/pjsip_distributor.c:472 ast_sip_get_distributor_serializer: Calculated serializer pjsip/distributor-0000001e to use for Request msg OPTIONS/cseq=10 (rdata0x7f3428017418)
> {noformat}



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