[Spce-user] Duplicate entries in Mysql Kamailio Location table "CE-2.8"
andreas tseiko
a.tseiko at hotmail.com
Fri Jan 3 06:00:49 EST 2014
Dear Daniel,
We have done the requested upgrade successfully (no errors) but the reported issue still exists.We have typed command dpkg -l | grep "kamailio" to see the output and we noticed that only ngcp-templates-ce-kamailio has been changed from 2.8.10 to 2.8.15.
root at sip:/etc/ngcp-config# dpkg -l | grep "kamailio"ii kamailio 3.3+ngcp2.8.1 very fast and configurable SIP proxyii kamailio-mysql-modules 3.3+ngcp2.8.1 MySQL database connectivity module for Kamailioii kamailio-presence-modules 3.3+ngcp2.8.1 SIMPLE presence modules for Kamailioii kamailio-tls-modules 3.3+ngcp2.8.1 contains the TLS kamailio transport moduleii kamailio-utils-modules 3.3+ngcp2.8.1 Provides a set utility functions for Kamailioii kamailio-xml-modules 3.3+ngcp2.8.1 XML based extensions for Kamailio's Management Interfaceii ngcp-templates-ce-kamailio 2.8.15 Configuration templates for Kamailio configuration in NGCP platformsroot at sip:/etc/ngcp-config#
Does it means that we have to do something more or that the update was completed successfully but it wasn't possible to solve the problem?
Best regards.
> Date: Fri, 3 Jan 2014 10:42:03 +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,
>
> 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
> >
>
> _______________________________________________
> 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/20140103/a2199067/attachment-0001.html>
More information about the Spce-user
mailing list