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

[Daniel Grotti]

Hi Andreas,

This problem has been fixed on the latest kamailio package.
If you wanto to fix it you need to upgrade your machine to the latest
2.8 packages:

apt-get update
apt-get upgrade


If this is not worth, you can think to solve the problem by deleting
manually that duplicated entries in mysql, by adding a cron job for example.

Daniel



On 01/03/2014 10:33 AM, andreas tseiko wrote:
> Dear Daniel,
> 
> Could you please tell me which packages exactly I should upgrade and how?
> As I told you before this platform (CE-2.8) is in production mode and
> apart from this issue we have no problems.
> Do you mean that I have to upgrade from 2.8 to the latest?
> What else should  I have in mind before proceed with upgrade?
> 
> Best regards.
> 
>> Date: Fri, 3 Jan 2014 10:20:25 +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,
>>
>> 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
>> >
>>
>> _______________________________________________
>> 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
>