[asterisk-bugs] [JIRA] (ASTERISK-23351) [patch]Updating realtime sippeers using res_config_pgsql backend fails when 'port' column is null

[zvision (JIRA)]

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

zvision edited comment on ASTERISK-23351 at 3/20/14 10:00 AM:
--------------------------------------------------------------

Which patch version did you try? The one for 1.8 or 12?

I have just tried the v12 patch with the following command:
patch -p0 -i res_config_pgsql.diff

and got no problems with SVN branch 12.

Please make sure to use the patch posted on Review Board.


was (Author: zvision):
Which patch version did you try? The one for 1.8 or 12?

I have just tried the v12 patch with the following command:
patch -p0 -i res_config_pgsql.diff

and got no problems with SVN branch 12.

> [patch]Updating realtime sippeers using res_config_pgsql backend fails when 'port' column is null
> -------------------------------------------------------------------------------------------------
>
>                 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
>         Attachments: patch.txt
>
>
> 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 was sent by Atlassian JIRA
(v6.2#6252)