[asterisk-bugs] [JIRA] (ASTERISK-17537) Wrong Column Value When Using res_config_pgsql

[Sean Bright (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-17537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Bright updated ASTERISK-17537:
-----------------------------------

    Assignee: dread  (was: Sean Bright)
      Status: Waiting for Feedback  (was: Open)

Are you able to reproduce this on Asterisk 13+?

> Wrong Column Value When Using res_config_pgsql
> ----------------------------------------------
>
>                 Key: ASTERISK-17537
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-17537
>             Project: Asterisk
>          Issue Type: Bug
>          Components: Resources/res_config_pgsql
>    Affects Versions: 1.8.3
>            Reporter: dread
>            Assignee: dread
>            Severity: Minor
>
> When realtime peer unregistred, asterisk update sip_user table with wrong value
> UPDATE asterisk_sip_users_tbl SET ipaddr = '(null)', port = '(null)', regseconds = '1299753779', defaultuser = '3001', useragent = '', lastms = '0', fullcontact = '' WHERE name = '3001'
> '(null)' is not NULL. 
> after peer unregistred 
> sip show peers show:
> Name/username              Host                                    Dyn Forcerport ACL Port     Status     Realtime
> 3001/3001                  (Unspecified)                            D       A  0        UNKNOWN    Cached RT



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