[Devel] registrar/usrloc issue

[Bogdan-Andrei Iancu]

Hi Ovidiu,

This comes from the DB table constrains:
    UNIQUE KEY udc_loc (username, domain, contact)

I guess callid must be also added.

regards,
bogdan

Ovidiu Sas wrote:
> 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
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>