I tried changing the database from MySQL to SQLite3. Then I tried to use Zoiper to register using the registered pjsip number. Problems arise when unregistered devices. Data on ps_contacts is not automatically deleted when the device is unregistered, but the contact on the endpoints will disappear after 1 minute. I have tried changing the minimum expiration value to 5 in ps_aors as an example, but it has no effect. When I activate :
core set debug 1
core set verbose 3
And register new device for example using sipNumber 1004, it show :
Added contact 'sip:1004@192.168.100.52:52422;transport=UDP;rinstance=af2f6c3e9b721646' to AOR '1004' with expiration of 60 seconds
When I unregistered that device, it show :
Removed contact 'sip:1004@192.168.100.52:52422;transport=UDP;rinstance=af2f6c3e9b721646' from AOR '1004' due to request
But still in the ps_contacts that data still exist.
Anybody can help ?
Sqlite3 isn’t something that has really been tested against realtime like that, so it may not be compatible in the way that we need to use it. You are in uncharted/untested territory.
thank for your answer. I decide to use mysql again as realtime database. I found out, that sqlite3 file too much complicated cause database locked when I running asterisk and my backend. Thank you very much for answered my question.