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@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
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....
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_...
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
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_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@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 -
Gus Monti