Summary:ASTERISK-17537: Wrong Column Value When Using res_config_pgsql
Reporter:dread (dread)Labels:
Date Opened:2011-03-10 04:50:05.000-0600Date Closed:2017-03-27 14:35:11
Versions:1.8.3 Frequency of
Description: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

Comments:By: Leif Madsen (lmadsen) 2011-03-31 12:22:29

res_config_odbc is more widely supported and tested. I would suggest you use that instead of res_config_pgsql directly if you're having any issues.

By: Sean Bright (seanbright) 2017-02-28 12:30:02.876-0600

Are you able to reproduce this on Asterisk 13+?

By: Sean Bright (seanbright) 2017-03-27 14:35:11.720-0500

I am not able to reproduce with Asterisk 13 from Git. Please re-open if you are able to reproduce.