[Spce-user] Duplicate entries in Mysql Kamailio Location table "CE-2.8"

[andreas tseiko]

Dear Daniel,
The requested files have been attached.
Best regards.

> Date: Thu, 2 Jan 2014 10:28:10 +0100
> From: dgrotti at sipwise.com
> To: spce-user at lists.sipwise.com
> Subject: Re: [Spce-user] Duplicate entries in Mysql Kamailio Location table "CE-2.8"
> 
> Hi Andreas,
> 
> the Sip Trace and the Proxy Log.
> Thanks,
> Daniel
> 
> 
> On 01/02/2014 10:22 AM, andreas tseiko wrote:
> > Dear Daniel,
> > 
> > 1)
> > root at sip:/# dpkg -l | grep "kamailio"
> > ii  kamailio                                   3.3+ngcp2.8.1            
> >    very fast and configurable SIP proxy
> > ii  kamailio-mysql-modules                     3.3+ngcp2.8.1            
> >    MySQL database connectivity module for Kamailio
> > ii  kamailio-presence-modules                  3.3+ngcp2.8.1            
> >    SIMPLE presence modules for Kamailio
> > ii  kamailio-tls-modules                       3.3+ngcp2.8.1            
> >    contains the TLS kamailio transport module
> > ii  kamailio-utils-modules                     3.3+ngcp2.8.1            
> >    Provides a set utility functions for Kamailio
> > ii  kamailio-xml-modules                       3.3+ngcp2.8.1            
> >    XML based extensions for Kamailio's Management Interface
> > ii  ngcp-templates-ce-kamailio                 2.8.10                  
> >     Configuration templates for Kamailio configuration in NGCP platforms
> > root at sip:/#
> > 2)
> > CSipSimple
> > 3)
> > What you need is a trace which contains register messages of a
> > subscriber that will trigger this symptom?
> > Or the proxy log  file lines that refer to this sub?
> > 
> > Thanks Andreas
> >  
> > 
> >> Date: Thu, 2 Jan 2014 10:07:48 +0100
> >> From: dgrotti at sipwise.com
> >> To: spce-user at lists.sipwise.com
> >> Subject: Re: [Spce-user] Duplicate entries in Mysql Kamailio Location
> > table "CE-2.8"
> >>
> >> Hi Andreas,
> >> looks strange, we had some issues loke that but not with all the same
> >> columns.
> >> Can you provide us with the following informations ?
> >>
> >>
> >> 1. Kamailio Version: dpkg -l | grep "kamailio"
> >>
> >> 2. Type of SIP client
> >>
> >> 3. REGISTER Transaction of the callID, I would like to see the REGISTER
> >> message inside.
> >>
> >>
> >> Thanks,
> >> Daniel
> >>
> >>
> >>
> >>
> >> On 01/02/2014 09:50 AM, andreas tseiko wrote:
> >> > Dear All,
> >> >
> >> >
> >> >
> >> > We noticed that some subscriber contacts are written into location table
> >> > more than once while referring to exactly the same values in all
> >> > columns. Only the "ID" column has different value. A relevant sample has
> >> > been attached.
> >> >
> >> > The maximum number of duplicated entries per contact is 4 as the value
> >> > we have initially entered in
> >> > config.yml *"max_registrations_per_subscriber: 4"* .
> >> >
> >> > The issue is that this parameter should allow a subscriber to be
> >> > registered via four different IP addresses or ports and not this
> >> > reported issue.
> >> >
> >> > Is this problem relays to a wrong configuration or not?
> >> >
> >> > Do you have experience similar issue in the past?
> >> >
> >> > This platform is in production mode, any help will be appreciated.
> >> >
> >> > Best regards.
> >> >
> >> >
> >> >
> >> > _______________________________________________
> >> > Spce-user mailing list
> >> > Spce-user at lists.sipwise.com
> >> > http://lists.sipwise.com/listinfo/spce-user
> >> >
> >>
> >> _______________________________________________
> >> Spce-user mailing list
> >> Spce-user at lists.sipwise.com
> >> http://lists.sipwise.com/listinfo/spce-user
> > 
> > 
> > _______________________________________________
> > Spce-user mailing list
> > Spce-user at lists.sipwise.com
> > http://lists.sipwise.com/listinfo/spce-user
> > 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140102/fd362dd9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: register1111c.pcap
Type: application/octet-stream
Size: 100920 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140102/fd362dd9/attachment-0001.pcap>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kamailio proxy register.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 11910 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140102/fd362dd9/attachment-0001.xlsx>