Hi, after applying the patch i get this error. Don't know why i am getting this? If possible can you share with me ur sqlbox folder compressed?
///// [root@ip-97-74-197-164 ~]# /usr/local/sbin/sqlbox sqlbox.conf 2013-01-02 19:33:21 [23828] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2013-01-02 19:33:21 [23828] [0] DEBUG: Kannel sqlbox version `svn-r5014'. Build `Dec 30 2012 22:32:28', compiler `4.1.2 20080704 (Red Hat 4.1.2-51)'. System Linux, release 2.6.18-274.12.1.el5, version #1 SMP Tue Nov 29 13:37:46 EST 2011, machine x86_64. Hostname ip-97-74-197-164.ip.secureserver.net, IP 127.0.0.1. Libxml version 2.6.26. Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008. Compiled with MySQL 5.5.27, using MySQL 5.5.27. Using native malloc. 2013-01-02 19:33:21 [23828] [0] INFO: Starting to log to file /var/log/kannel/kannel-sqlbox.log level 0 2013-01-02 19:33:21 [23828] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2013-01-02 19:33:21 [23828] [0] INFO: MYSQL: Connected to server at localhost. 2013-01-02 19:33:21 [23828] [0] INFO: MYSQL: server version 5.5.27, client version 5.5.27. 2013-01-02 19:33:21 [23828] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2013-01-02 19:33:21 [23828] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 23828. 2013-01-02 19:33:21 [23828] [1] DEBUG: Connecting to <127.0.0.1> 2013-01-02 19:33:21 [23828] [1] INFO: Connected to bearerbox at localhost port 13001. 2013-01-02 19:33:21 [23828] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2013-01-02 19:33:21 [23828] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 23828. *** glibc detected *** /usr/local/sbin/sqlbox: double free or corruption (!prev): 0x000000001a0a9a80 *** ======= Backtrace: ========= /lib64/libc.so.6[0x399ea7245f] /lib64/libc.so.6(cfree+0x4b)[0x399ea728bb] /usr/local/sbin/sqlbox[0x40b428] /usr/local/sbin/sqlbox[0x41f983] /lib64/libpthread.so.0[0x399f20673d] /lib64/libc.so.6(clone+0x6d)[0x399ead44bd] ======= Memory map: ======== 00400000-00445000 r-xp 00000000 08:03 6310529 /usr/local/sbin/sqlbox 00645000-00646000 rw-p 00045000 08:03 6310529 /usr/local/sbin/sqlbox 00646000-006e2000 rw-p 00646000 00:00 0 19fba000-1a0c0000 rw-p 19fba000 00:00 0 [heap] 401a7000-401a8000 ---p 401a7000 00:00 0 401a8000-40ba8000 rw-p 401a8000 00:00 0 41fe4000-41fe5000 ---p 41fe4000 00:00 0 41fe5000-429e5000 rw-p 41fe5000 00:00 0 399e600000-399e61c000 r-xp 00000000 08:03 1261763 /lib64/ld-2.5.so 399e81c000-399e81d000 r--p 0001c000 08:03 1261763 /lib64/ld-2.5.so 399e81d000-399e81e000 rw-p 0001d000 08:03 1261763 /lib64/ld-2.5.so 399ea00000-399eb4e000 r-xp 00000000 08:03 1261721 /lib64/libc-2.5.so 399eb4e000-399ed4e000 ---p 0014e000 08:03 1261721 /lib64/libc-2.5.so 399ed4e000-399ed52000 r--p 0014e000 08:03 1261721 /lib64/libc-2.5.so 399ed52000-399ed53000 rw-p 00152000 08:03 1261721 /lib64/libc-2.5.so 399ed53000-399ed58000 rw-p 399ed53000 00:00 0 399ee00000-399ee02000 r-xp 00000000 08:03 1261779 /lib64/libdl-2.5.so 399ee02000-399f002000 ---p 00002000 08:03 1261779 /lib64/libdl-2.5.so 399f002000-399f003000 r--p 00002000 08:03 1261779 /lib64/libdl-2.5.so 399f003000-399f004000 rw-p 00003000 08:03 1261779 /lib64/libdl-2.5.so 399f200000-399f216000 r-xp 00000000 08:03 1261764 /lib64/libpthread-2.5.so 399f216000-399f415000 ---p 00016000 08:03 1261764 /lib64/libpthread-2.5.so 399f415000-399f416000 r--p 00015000 08:03 1261764 /lib64/libpthread-2.5.so 399f416000-399f417000 rw-p 00016000 08:03 1261764 /lib64/libpthread-2.5.so 399f417000-399f41b000 rw-p 399f417000 00:00 0 399f600000-399f682000 r-xp 00000000 08:03 1261758 /lib64/libm-2.5.so 399f682000-399f881000 ---p 00082000 08:03 1261758 /lib64/libm-2.5.so 399f881000-399f882000 r--p 00081000 08:03 1261758 /lib64/libm-2.5.so 399f882000-399f883000 rw-p 00082000 08:03 1261758 /lib64/libm-2.5.so 399fa00000-399fa14000 r-xp 00000000 08:03 1261675 /lib64/libz.so.1.2.3 399fa14000-399fc13000 ---p 00014000 08:03 1261675 /lib64/libz.so.1.2.3 399fc13000-399fc14000 rw-p 00013000 08:03 1261675 /lib64/libz.so.1.2.3 399fe00000-399fe15000 r-xp 00000000 08:03 1261786 /lib64/libselinux.so.1 399fe15000-39a0015000 ---p 00015000 08:03 1261786 /lib64/libselinux.so.1 39a0015000-39a0017000 rw-p 00015000 08:03 1261786 /lib64/libselinux.so.1 39a0017000-39a0018000 rw-p 39a0017000 00:00 0 39a0200000-39a023b000 r-xp 00000000 08:03 1261681 /lib64/libsepol.so.1 39a023b000-39a043b000 ---p 0003b000 08:03 1261681 /lib64/libsepol.so.1 39a043b000-39a043c000 rw-p 0003b000 08:03 1261681 /lib64/libsepol.so.1 39a043c000-39a0446000 rw-p 39a043c000 00:00 0 39a0600000-39a0607000 r-xp 00000000 08:03 1261745 /lib64/librt-2.5.so 39a0607000-39a0807000 ---p 00007000 08:03 1261745 /lib64/librt-2.5.so 39a0807000-39a0808000 r--p 00007000 08:03 1261745 /lib64/librt-2.5.so 39a0808000-39a0809000 rw-p 00008000 08:03 1261745 /lib64/librt-2.5.so 39a0a00000-39a0a15000 r-xp 00000000 08:03 1261690 /lib64/libnsl-2.5.so 39a0a15000-39a0c14000 ---p 00015000 08:03 1261690 /lib64/libnsl-2.5.so 39a0c14000-39a0c15000 r--p 00014000 08:03 1261690 /lib64/libnsl-2.5.so 39a0c15000-39a0c16000 rw-p 00015000 08:03 1261690 /lib64/libnsl-2.5.so 39a0c16000-39a0c18000 rw-p 39a0c16000 00:00 0 39a1a00000-39a1a02000 r-xp 00000000 08:03 1261670 /lib64/libkeyutils-1.2.so 39a1a02000-39a1c01000 ---p 00002000 08:03 1261670 /lib64/libkeyutils-1.2.so 39a1c01000-39a1c02000 rw-p 00001000 08:03 1261670 /lib64/libkeyutils-1.2.so 39a1e00000-39a1e0d000 r-xp 00000000 08:03 1261778 /lib64/libgcc_s-4.1.2-20080825.so.1 39a1e0d000-39a200d000 ---p 0000d000 08:03 1261778 /lib64/libgcc_s-4.1.2-20080825.so.1 39a200d000-39a200e000 rw-p 0000d000 08:03 1261778 /lib64/libgcc_s-4.1.2-20080825.so.1 39a2200000-39a232d000 r-xp 00000000 08:03 1261686 /lib64/libcrypto.so.0.9.8e 39a232d000-39a252c000 ---p 0012d000 08:03 1261686 /lib64/libcrypto.so.0.9.8e 39a252c000-39a254d000 rw-p 0012c000 08:03 1261686 /lib64/libcrypto.so.0.9.8e 39a254d000-39a2551000 rw-p 39a254d000 00:00 0 39a2a00000-39a2a02000 r-xp 00000000 08:03 1261574 /lib64/libcom_err.so.2.1 39a2a02000-39a2c01000 ---p 00002000 08:03 1261574 /lib64/libcom_err.so.2.1 39a2c01000-39a2c02000 rw-p 00001000 08:03 1261574 /lib64/libcom_err.so.2.1 39a5a00000-39a5ae6000 r-xp 00000000 08:03 6115561 /usr/lib64/libstdc++.so.6.0.8 39a5ae6000-39a5ce5000 ---p 000e6000 08:03 6115561 /usr/lib64/libstdc++.so.6.0.8 39a5ce5000-39a5ceb000 r--p 000e5000 08:03 6115561 /usr/lib64/libstdc++.so.6.0.8 39a5ceb000-39a5cee000 rw-p 000eb000 08:03 6115561 /usr/lib64/libstdc++.so.6.0.8 39a5cee000-39a5d00000 rw-p 39a5cee000 00:00 0 3f4ee00000-3f4ee46000 r-xp 00000000 08:03 1261894 /lib64/libssl.so.0.9.8e 3f4ee46000-3f4f046000 ---p 00046000 08:03 1261894 /lib64/libssl.so.0.9.8e 3f4f046000-3f4f04c000 rw-p 00046000 08:03 1261894 /lib64/libssl.so.0.9.8e 3f4f200000-3f4f208000 r-xp 00000000 08:03 6116407 /usr/lib64/libkrb5support.so.0.1 3f4f208000-3f4f407000 ---p 00008000 08:03 6116407 /usr/lib64/libkrb5support.so.0.1 3f4f407000-3f4f408000 rw-p 00007000 08:03 6116407 /usr/lib64/libkrb5support.so.0.1 3f4fa00000-3f4fa2c000 r-xp 00000000 08:03 6116410 /usr/lib64/libgssapi_krb5.so.2.2 3f4fa2c000-3f4fc2c000 ---p 0002c000 08:03 6116410 /usr/lib64/libgssapi_krb5.so.2.2 3f4fc2c000-3f4fc2e000 rw-p 0002c000 08:03 6116410 /usr/lib64/libgssapi_krb5.so.2.2 3f4fe00000-3f4fe92000 r-xp 00000000 08:03 6116409 /usr/lib64/libkrb5.so.3.3 3f4fe92000-3f50091000 ---p 00092000 08:03 6116409 /usr/lib64/libkrb5.so.3.3 3f50091000-3f50095000 rw-p 00091000 08:03 6116409 /usr/lib64/libkrb5.so.3.3 3f50200000-3f50224000 r-xp 00000000 08:03 6116408 /usr/lib64/libk5crypto.so.3.1 3f50224000-3f50423000 ---p 00024000 08:03 6116408 /usr/lib64/libk5crypto.so.3.1 3f50423000-3f50425000 rw-p 00023000 08:03 6116408 /usr/lib64/libk5crypto.so.3.1 3f50600000-3f50611000 r-xp 00000000 08:03 1261893 /lib64/libresolv-2.5.so 3f50611000-3f50811000 ---p 00011000 08:03 1261893 /lib64/libresolv-2.5.so 3f50811000-3f50812000 r--p 00011000 08:03 1261893 /lib64/libresolv-2.5.so 3f50812000-3f50813000 rw-p 00012000 08:03 1261893 /lib64/libresolv-2.5.so 3f50813000-3f50815000 rw-p 3f50813000 00:00 0 3fb7800000-3fb7933000 r-xp 00000000 08:03 9011236 /usr/lib64/libxml2.so.2.6.26 3fb7933000-3fb7b33000 ---p 00133000 08:03 9011236 /usr/lib64/libxml2.so.2.6.26 3fb7b33000-3fb7b3c000 rw-p 00133000 08:03 9011236 /usr/lib64/libxml2.so.2.6.26 3fb7b3c000-3fb7b3d000 rw-p 3fb7b3c000 00:00 0 2aaaac000000-2aaaac030000 rw-p 2aaaac000000 00:00 0 2aaaac030000-2aaab0000000 ---p 2aaaac030000 00:00 0 2ac508d5c000-2ac508d5f000 rw-p 2ac508d5c000 00:00 0 2ac508d73000-2ac508fc7000 r-xp 00000000 08:03 6508645 /usr/lib64/mysql/libmysqlclient.so.18.0.0 2ac508fc7000-2ac5091c6000 ---p 00254000 08:03 6508645 /usr/lib64/mysql/libmysqlclient.so.18.0.0 2ac5091c6000-2ac509247000 rw-p 00253000 08:03 6508645 /usr/lib64/mysql/libmysqlclient.so.18.0.0 2ac509247000-2ac509255000 rw-p 2ac509247000 00:00 0 2ac509255000-2ac50925f000 r-xp 00000000 08:03 1261680 /lib64/libnss_files-2.5.so 2ac50925f000-2ac50945e000 ---p 0000a000 08:03 1261680 /lib64/libnss_files-2.5.so 2ac50945e000-2ac50945f000 r--p 00009000 08:03 1261680 /lib64/libnss_files-2.5.so 2ac50945f000-2ac509460000 rw-p 0000a000 08:03 1261680 /lib64/libnss_files-2.5.so 7fff837cd000-7fff837e2000 rw-p 7ffffffe9000 00:00 0 [stack] 7fff837fd000-7fff83800000 r-xp 7fff837fd000 00:00 0 [vdso] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vsyscall] Aborted ////// ________________________________ From: spameden <spame...@gmail.com> To: michael osakede <ire...@yahoo.com> Cc: "users@kannel.org" <users@kannel.org>; Stipe Tolj <st...@kannel.org> Sent: Wednesday, January 2, 2013 4:29 PM Subject: Re: SQLBOX + sqlbox multi-record queries You need to modify specific files mentioned in this patch. read this - http://en.wikipedia.org/wiki/Diff#Unified_format Just read .patch file and do step-by-step editing relevant lines of the corresponding files. i.e. diff -rbu sqlbox-standalone/gw/sqlbox.c sqlbox-standalone-ajg-1.0/gw/sqlbox.c --- sqlbox-standalone/gw/sqlbox.c 2007-10-05 13:54:02.000000000 -0300 +++ sqlbox-standalone-ajg-1.0/gw/sqlbox.c 2008-02-27 19:35:23.000000000 -0200 @@ -86,6 +86,7 @@ static Octstr *box_allow_ip; static Octstr *box_deny_ip; static Octstr *global_sender; +static long limit_per_cycle; #ifndef HAVE_MYSQL #ifndef HAVE_PGSQL means you need to open gw/sqlbox.c, find lines around 86 and add static long limit_per_cycle; 2013/1/2 michael osakede <ire...@yahoo.com>: > Hi, > > What i need is a step by step to apply this patch. > What command do i use, from which directory? > > A step by step guide for CentOS will be nice > > Michael > > ________________________________ > From: spameden <spame...@gmail.com> > To: michael osakede <ire...@yahoo.com> > Cc: "users@kannel.org" <users@kannel.org>; Stipe Tolj <st...@kannel.org> > Sent: Wednesday, January 2, 2013 4:22 PM > Subject: Re: SQLBOX + sqlbox multi-record queries > > I implemented this based on the link you gave, it's very easy to patch > against current SVN revision, if you will had problems let me know, > I'll post my patch. > > 2013/1/2 michael osakede <ire...@yahoo.com>: >> Hi, >> >> Right now sqlbox processes one row at a time. >> >> Can anyone help with a patch or code replacement for sqlbox_mysql.c that >> can >> help me push messages are 10-1000 messages per query? >> >> i saw this link >> http://www.magicom-bcn.net/kannel/sqlbox-standalone-multi-20080227.patch >> but no luck implementing this. >> >> Any help welcomed. >> >> Michael > >
