[Devel] registrar/usrloc issue

[Ovidiu Sas]

Hi,


If I have a user registered and I try to re-register the same user on
top of the existing registration, I have the following error:

submit_query: Duplicate entry
'line-6--sip:line-6 at 192.168.2.102:5060;transport=udp' for key 2
db_insert: Error while submitting query
db_insert_ucontact(): Error while inserting contact
ERROR:usrloc:insert_ucontact: failed to insert in database

The in memory location table is showing two registrations, but the
location database is not updated:
        AOR:: line-6
                Contact:: sip:line-6 at 192.168.2.102:5060;transport=udp Q=
                        Expires:: 575
                        Callid::
00036be7-b1240007-7f2e7bf5-340423fb at 192.168.2.102
                        Cseq:: 530
                        User-agent:: Cisco-CP7960G/8.0
                        State:: CS_SYNC
                        Flags:: 0
                        Cflag:: 0
                        Socket:: udp:192.168.2.22:5060
                        Methods:: 4294967295
                Contact:: sip:line-6 at 192.168.2.102:5060;transport=udp Q=
                        Expires:: 3584
                        Callid::
00036be7-b1240007-2af7c4c8-77777b7e at 192.168.2.102
                        Cseq:: 102
                        User-agent:: Cisco-CP7960G/8.0
                        State:: CS_SYNC
                        Flags:: 0
                        Cflag:: 0
                        Socket:: udp:192.168.2.22:5060
                        Methods:: 4294967295

If I restart openser, I will loose the second binding due to the fact
that was not saved into the database.

'/opt/sbin/openserctl ul show' after restart:
        AOR:: line-6
                Contact:: sip:line-6 at 192.168.2.102:5060;transport=udp Q=
                        Expires:: 397
                        Callid::
00036be7-b1240007-7f2e7bf5-340423fb at 192.168.2.102
                        Cseq:: 530
                        User-agent:: Cisco-CP7960G/8.0
                        State:: CS_SYNC
                        Flags:: 0
                        Cflag:: 0
                        Socket:: udp:192.168.2.22:5060
                        Methods:: 4294967295

The phone will consider itself registered for an hour, but the binding
will expire sooner on the server due to old biding timeout.


Regards,
Ovidiu Sas