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

[Daniel Grotti]

Andreas,

please upgrade the kamailio packages.
This problem should be solved with the latest version.

Daniel


On 01/02/2014 01:50 PM, andreas tseiko wrote:
> Dear Daniel,
> 
> Please find attached the requested file as text.
> 
> Best regards.
> 
>> Date: Thu, 2 Jan 2014 13:19:27 +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"
>>
>> Andreas,
>> the pcap is empty or malformed.
>>
>> Daniel
>>
>>
>> On 01/02/2014 01:13 PM, andreas tseiko wrote:
>> > 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
>> >
>> >
>> > _______________________________________________
>> > 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
>