Realtime pgsql sipuser - Wrong password

Hi all,

created a tables as in the source Asterisk 11.4.0, CDR writes fine, but when you try to user authorization fails.

This is our current entry in sip_conf:

call_centre_production=# select * from sip_conf; -[ RECORD 1 ]-----+--------------------------------- id | 1 name | 123 accountcode | amaflags | callgroup | callerid | 123 canreinvite | yes context | operators defaultip | dtmfmode | rfc2833 fromuser | fromdomain | host | dynamic insecure | language | mailbox | md5secret | 202cb962ac59075b964b07152d234b70 ==> md5(123) nat | auto_force_rport,auto_comedia permit | deny | mask | pickupgroup | port | qualify | yes restrictcid | rtptimeout | rtpholdtimeout | secret | 123 type | friend username | 123 allow | !all,alaw musiconhold | regseconds | 0 ipaddr | regexten | cancallforward | yes lastms | 0 defaultuser | fullcontact | regserver | useragent | callbackextension |

We tried different configurations of md5secret and secret fields (event with both empty md5secret and secret), all with same result:

[Apr 1 05:00:07] NOTICE[22569]: chan_sip.c:27829 handle_request_register: Registration from 'sip:123@192.168.20.10' failed for '10.10.10.103:5060' - Wrong password

[quote]ubuntu*CLI> realtime show pgsql status
Connected to call_centre_production@127.0.0.1, port 5432 with username mili for 13 days, 18 hours, 23 minutes, 57 seconds.[/quote]

By the way authorisation users with sip.conf file is ok.

[quote]my-codecs ; a template for my preferred codecs
disallow=all
allow=ilbc
allow=g729
allow=gsm
allow=g723
allow=ulaw
; Or, more simply:
;allow=!all,ilbc,g729,gsm,g723,ulaw

alaw-phone ; and another one for alaw-only
;disallow=all
;allow=alaw
; Again, more simply:
allow=!all,alaw

basic-options ; a template
dtmfmode=rfc2833
;context=from-office
transport=udp
type=friend
qualify=yes

nat
nat=auto_force_rport,auto_comedia
;nat=yes,force_rport
directmedia=no
host=dynamic

webrtc
sipml5
host=dynamic
encryption = yes
avpf = yes
icesupport = yes
videosupport=no
transport=udp,wss,ws

operator1
callerid=Operator1 <10001>
secret=123
context=operators[/quote]

Thanks in advanced!

my error in the extconfig.conf

sippeers => pgsql,general,sip_conf

where general section name in res_pgsql.conf