[asterisk-bugs] [JIRA] (ASTERISK-23351) realtime sip peers update fails

[Matt Jordan (JIRA)]

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

Matt Jordan commented on ASTERISK-23351:
----------------------------------------

We require a complete debug log to help triage the issue. This document will provide instructions on how to collect debugging logs from an Asterisk machine for the purpose of helping bug marshals troubleshoot an issue: https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information

Please make sure you have sip debugging enabled as well.
                
> realtime sip peers update fails
> -------------------------------
>
>                 Key: ASTERISK-23351
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23351
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_pgsql
>    Affects Versions: 12.0.0
>         Environment: debian on raspberry pi
>            Reporter: jmls
>            Severity: Minor
>
> when using postgres with sip realtime, an update fails when a port number is '' . The actual error is below:
> [Feb 23 11:37:47] ERROR[32292] res_config_pgsql.c: PostgreSQL RealTime: Query Failed: UPDATE sippeers SET fullcontact = '', lastms = '0', useragent = '', regserver = '', regseconds = '0', port = '', ipaddr = '' WHERE name = '<name>'
> [Feb 23 11:37:47] ERROR[32292] res_config_pgsql.c: PostgreSQL RealTime: Query Failed because: ERROR:  invalid input syntax for integer: ""
> LINE 1: ...nt = '', regserver = '', regseconds = '0', port = '', ipaddr...
>                                                              ^
>  (PGRES_FATAL_ERROR)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira