[Home]

Summary:ASTERISK-29056: Increase reg_server column size for ps_contacts table realtime
Reporter:sungtae kim (pchero)Labels:
Date Opened:2020-08-31 07:10:53Date Closed:2020-09-10 10:33:43
Priority:MinorRegression?
Status:Closed/CompleteComponents:Resources/General
Versions:17.6.0 Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description: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@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}
Comments:By: Asterisk Team (asteriskteam) 2020-08-31 07:10:54.984-0500

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. Please note that log messages and other files should not be sent to the Sangoma Asterisk Team unless explicitly asked for. All files should be placed on this issue in a sanitized fashion as needed.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

Please note that once your issue enters an open state it has been accepted. As Asterisk is an open source project there is no guarantee or timeframe on when your issue will be looked into. If you need expedient resolution you will need to find and pay a suitable developer. Asking for an update on your issue will not yield any progress on it and will not result in a response. All updates are posted to the issue when they occur.
By: Friendly Automation (friendly-automation) 2020-09-10 10:33:44.037-0500

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

[https://gerrit.asterisk.org/c/asterisk/+/14902|https://gerrit.asterisk.org/c/asterisk/+/14902]
By: Friendly Automation (friendly-automation) 2020-09-10 10:34:07.585-0500

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]
By: Friendly Automation (friendly-automation) 2020-09-10 10:35:04.118-0500

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

[https://gerrit.asterisk.org/c/asterisk/+/14903|https://gerrit.asterisk.org/c/asterisk/+/14903]
By: Friendly Automation (friendly-automation) 2020-09-10 10:39:04.587-0500

Change 14904 merged by Friendly Automation:
realtime: Increased reg_server character size

[https://gerrit.asterisk.org/c/asterisk/+/14904|https://gerrit.asterisk.org/c/asterisk/+/14904]
By: Friendly Automation (friendly-automation) 2020-09-10 11:04:49.340-0500

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

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