Hi Daniel. Thanks for your response. Looking at the link you sent me, at the end of it, 7. Limitations, sec 2. By default MySQL doesn’t support….

7. Limitations

• 1. Only one capturing mode on RAW socket is supported: IPIP or monitoring/mirroring port. Don't activate both at the same time.
• 2. By default MySQL doesn't support INSERT DELAYED for partitioning table. You can patch MySQL (http://bugs.mysql.com/bug.php?id=50393)
• 3. Mirroring port capturing works only on Linux.

In order to patch it, what the steps by steps to do it (http://bugs.mysql.com/bug.php?id=50393) I don’t understand what I have to do here. Sorry for my little knowledge in this matter.

Thanks,

Gus

From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla
Sent: Tuesday, October 29, 2013 2:16 PM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Inser Delayed in MySQL

Hello,

maybe the documentation is old, you should be able to do it via sipcapture module parameter:

- http://kamailio.org/docs/modules/devel/modules/sipcapture.html#sipcapture.p.db_insert_mode

Cheers,
Daniel

On 10/29/13 9:29 PM, Gus Monti wrote:

Hi,

I can see that we are missing a lot of Sip messages in or db, so, checking Homer FAQ there is a way to compile MySql with Insert Delayed for partitioning table.

The problem is that I don’t understand how to recompile MySql and make the necessary changes.

The URL is https://code.google.com/p/homer/wiki/FAQ#Q:_I_have_a_lot_of_SIP_traffic_and_some_SIP_messages_are_missing

The question is, can you send me a step by step how to do this? I really appreciate your help.

I have CentOS 6.4:

[root@Homerdb02 ~]# kamailio -v

version: kamailio 4.1.0-dev9 (x86_64/linux) f8f3d3

[root@Homerdb02 ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.4 (Santiago)

[root@Homerdb02 ~]# uname -a

Linux Homerdb02 2.6.32-358.18.1.el6.x86_64 #1 SMP Fri Aug 2 17:04:38 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux

[root@Homerdb02 ~]# mysql -V

mysql  Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1

Thanks,

Gus

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Trainings - Berlin, Nov 25-28
  - more details about Kamailio trainings at http://www.asipto.com -