[Devel] registrar/usrloc issue

[Ovidiu Sas]

how about cseq?

Let's say the network is down and the phone is trying to register.
The registration will time out and the cseq will increase.
The username, domain, contact and callid will remain the same and as a
result the db update will fail.


Regards,
Ovidiu Sas

On 3/6/07, Bogdan-Andrei Iancu <bogdan at voice-system.ro> wrote:
> 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
> >
>
>