Ps_contacts getting deleted while using realtime database

Hi,

I am trying to use realtime pjsip configuration with MySQL database connected with odbc.

When a user(sip phone) registers to asterisk contact is getting deleted. See the below logs.

== WebSocket connection from ‘xxx.xxxx.xxx.xxx:52639’ for protocol ‘sip’ accepted using version ‘13’
– Added contact ‘sips:sipML5@xxx.xxxx.xxx.xxx:52639;transport=ws;rtcweb-breaker=no’ to AOR ‘sipML5’ with expiration of 200 seconds
– Contact sipML5/sips:sipML5@xxx.xxxx.xxx.xxx:52639;transport=ws;rtcweb-breaker=no is now Unknown.
== Endpoint sipML5 is now Reachable
== Contact sipML5/sips:sipML5@xxx.xxxx.xxx.xxx:52639;transport=ws;rtcweb-breaker=no has been deleted
== Endpoint sipML5 is now Unreachable

Here are my realtime configurations:

  1. Sorcery.conf (To load both from db realtime and config file as well)

[res_pjsip]
endpoint=realtime,ps_endpoints
auth=realtime,ps_auths
aor=realtime,ps_aors
domain_alias=realtime,ps_domain_aliases
contact=realtime,ps_contacts

auth=config,pjsip.conf,criteria=type=auth
domain_alias=config,pjsip.conf,criteria=type=domain_alias
global=config,pjsip.conf,criteria=type=global
system=config,pjsip.conf,criteria=type=system
transport=config,pjsip.conf,criteria=type=transport
aor=config,pjsip.conf,criteria=type=aor
endpoint=config,pjsip.conf,criteria=type=endpoint
contact=realtime,registrator

[res_pjsip_endpoint_identifier_ip]
identify=realtime,ps_endpoint_id_ips
identify=config,pjsip.conf,criteria=type=identify

[res_pjsip_outbound_publish]
outbound-publish=config,pjsip.conf,criteria=type=outbound-publish

[res_pjsip_outbound_registration]
registration=config,pjsip.conf,criteria=type=registration

  1. extconfig.conf

[settings]
ps_endpoints=>odbc,asterisk
ps_auths=>odbc,asterisk
ps_aors=>odbc,asterisk
ps_domain_aliases=>odbc,asterisk
ps_endpoint_id_ips=>odbc,asterisk
ps_contacts=>odbc,asterisk

If I remove contact from realtime, they are not getting deleted. How can I persist contacts to DB. Are there any misconfigurations in my conf files.