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

[sungtae kim (JIRA)]

sungtae kim created ASTERISK-29056:
--------------------------------------

             Summary: 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
            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)