[SR-Users] Inser Delayed in MySQL

[Gus Monti]

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 at lists.sip-router.org
[mailto:sr-users-bounces at 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_an
d_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 at Homerdb02 ~]# kamailio -v

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

 

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

Red Hat Enterprise Linux Server release 6.4 (Santiago)

 

[root at 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 at 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 at 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 -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20131029/20a32d2f/attachment-0001.html>