Re: Help, SQLBOX gwlib not found when running ./configure

[spameden]

Hi.

If you're on debian you need to install libmysqlclient16-dev for 5.1 MySQL
or libmysqlclient18-dev for MySQL 5.5.

on centos - mysql-devel.



2012/8/28 Adan Canales 

> Hi again: I did everything from scracth and now I can fnd Mysql Server,
> this is getting me crazy, this is what I have in my.cnf file which is in
> /etc/mysql/my.cnf
>
> user= mysql
> pid-file= /var/run/mysqld/mysqld.pid
> socket = /var/run/mysqld/mysqld.sock
> port = 3306
> basedir = /usr
> datadir = /var/lib/mysql
> tmpdir  = /tmp
> lc-messages-dir = /usr/share/mysql
> skip-external-locking
>
> I supposed mysql is on /usr then, am I right?
>
> When try to compile kannel with mysql doesn't find the directory in any
> combination: see the log:
>
> root@smsbkserver:~# cd trunk
> root@smsbkserver:~/trunk# ./configure --with-mysql
> checking svn checkout revision... 4991
>
> Configuring for Kannel gateway version svn-r4991 ...
>
> Running system checks ...
> checking build system type... x86_64-unknown-linux-gnu
> checking host system type... x86_64-unknown-linux-gnu
> checking for gcc... gcc
> checking whether the C compiler works... yes
> checking for C compiler default output file name... a.out
> checking for suffix of executables...
> checking whether we are cross compiling... no
> checking for suffix of object files... o
> checking whether we are using the GNU C compiler... yes
> checking whether gcc accepts -g... yes
> checking for gcc option to accept ISO C89... none needed
> checking for gcc option to accept ISO C99... -std=gnu99
> checking for a BSD-compatible install... /usr/bin/install -c
> checking for ranlib... ranlib
> checking for bison... bison -y
> checking for flex... no
> checking for lex... no
> checking for ar... ar
> checking for convert... /usr/bin/convert
> checking for perl... /usr/bin/perl
> checking for inline... inline
> checking for special C compiler options needed for large files... no
> checking for _FILE_OFFSET_BITS value needed for large files... no
> checking how to run the C preprocessor... gcc -std=gnu99 -E
> checking for grep that handles long lines and -e... /bin/grep
> checking for egrep... /bin/grep -E
> checking for ANSI C header files... yes
> checking for sys/types.h... yes
> checking for sys/stat.h... yes
> checking for stdlib.h... yes
> checking for string.h... yes
> checking for memory.h... yes
> checking for strings.h... yes
> checking for inttypes.h... yes
> checking for stdint.h... yes
> checking for unistd.h... yes
> checking size of short... 2
> checking size of int... 4
> checking size of long... 8
> checking size of long long... 8
> checking for log in -lm... yes
> checking for accept in -lsocket... no
> checking for inet_ntoa in -lnsl... yes
> checking for inet_ntop in -lresolv... yes
> checking for inet_ntop in -lbind... no
> checking for pthread_exit in -lpthread... yes
> checking for ANSI C header files... (cached) yes
> checking sys/ioctl.h usability... yes
> checking sys/ioctl.h presence... yes
> checking for sys/ioctl.h... yes
> checking sys/time.h usability... yes
> checking sys/time.h presence... yes
> checking for sys/time.h... yes
> checking for sys/types.h... (cached) yes
> checking for unistd.h... (cached) yes
> checking sys/poll.h usability... yes
> checking sys/poll.h presence... yes
> checking for sys/poll.h... yes
> checking pthread.h usability... yes
> checking pthread.h presence... yes
> checking for pthread.h... yes
> checking getopt.h usability... yes
> checking getopt.h presence... yes
> checking for getopt.h... yes
> checking syslog.h usability... yes
> checking syslog.h presence... yes
> checking for syslog.h... yes
> checking zlib.h usability... no
> checking zlib.h presence... no
> checking for zlib.h... no
> checking execinfo.h usability... yes
> checking execinfo.h presence... yes
> checking for execinfo.h... yes
> checking for stdlib.h... (cached) yes
> checking sys/socket.h usability... yes
> checking sys/socket.h presence... yes
> checking for sys/socket.h... yes
> checking sys/sockio.h usability... no
> checking sys/sockio.h presence... no
> checking for sys/sockio.h... no
> checking netinet/in.h usability... yes
> checking netinet/in.h presence... yes
> checking for netinet/in.h... yes
> checking for net/if.h... yes
> checking sys/ucontext.h usability... yes
> checking sys/ucontext.h presence... yes
> checking for sys/ucontext.h... yes
> checking for ld used by GCC... /usr/bin/ld
> checking if the linker (/usr/bin/ld) is GNU ld... yes
> checking for shared library run path origin... done
> checking for iconv... yes
> checking for working iconv... yes
> checking for iconv declaration...
>  extern size_t iconv (iconv_t cd, char * *inbuf, size_t
> *inbytesleft, char * *outbuf, size_t *outbytesleft);
> checking for gettimeofday... yes
> checking for select... yes
> checking for socket... yes
> checking for strdup... yes
> checking for getopt_long... yes
> checking for localtime_r... yes
> checking for gmtime_r..

UNSUBSCRIBE

[NOSI / DAS - Jorge Monteiro]

UNSUBSCRIBE

[Description: Description: Description: Descrição: logo_nosi2]
 NOSI / DAS - Jorge Monteiro




AVISO DE CONFIDENCIALIDADE:
Esta mensagem, assim como os ficheiros eventualmente anexos, é confidencial e 
reservada apenas ao conhecimento da(s) pessoa(s) nela indicada(s) como 
destinatária(s). Se não é o seu destinatário, ou se lhe foi enviada por erro, 
solicitamos que não faça qualquer uso do respectivo conteúdo e proceda à sua 
destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE:
A segurança da transmissão de informação por via electrónica não pode ser 
garantida pelo remetente, o qual, em consequência, não se responsabiliza por 
qualquer facto susceptível de afectar a sua integridade.
CONFIDENTIALITY NOTICE:
This message, as well as existing attached files, is confidential and intended 
exclusively for the individual(s) named as addressees. If you are not the 
intended recipient, or if it was sent to you by error, you are kindly requested 
not to make any use of its contents and to proceed to the destruction of the 
message, thereby notifying the sender.
DISCLAIMER:
The sender of this message can not ensure the security of its electronical 
transmission and consequently does not accept liability for any fact which may 
interfere with the integrity of its content.
<>

Setting fixed mask for SMPPBOX or Bearerbox

[ha...@aeon.pk]

Hi,

I have a client requiring connectivity over SMPP. I assume I can entertain
him via following configuration:

OPERATOR SMSC <--> BEARERBOX <--> SMPPBOX <--> CLIENT APPLICATON

However, I do not want to let the client set the MASK of outgoing SMS he
sends. Instead, I want to keep that mask control with me. Is there any way
to handle this? Some configuation in either SMPPBOX or BEARERBOX that could
force outgoing SMS masking? Or some other method of connection?

Regards,

Re: Setting fixed mask for SMPPBOX or Bearerbox

[spameden]

You probably need to modify opensmppbox source and force it there

2012/8/28 ha...@aeon.pk 

> Hi,
>
> I have a client requiring connectivity over SMPP. I assume I can entertain
> him via following configuration:
>
> OPERATOR SMSC <--> BEARERBOX <--> SMPPBOX <--> CLIENT APPLICATON
>
> However, I do not want to let the client set the MASK of outgoing SMS he
> sends. Instead, I want to keep that mask control with me. Is there any way
> to handle this? Some configuation in either SMPPBOX or BEARERBOX that could
> force outgoing SMS masking? Or some other method of connection?
>
> Regards,
>
>

Re: Setting fixed mask for SMPPBOX or Bearerbox

[ha...@aeon.pk]

That's a bit too complex for me.

Is there a way I can force SMPPBOX traffic to some application as an HTTP
call? So basically SMPPBOX will act as a protocol converter from SMPP to
HTTP. I already have the following setup for bulk messaging:

BULK SMS APPLICATION <--> SQLBOX <--> BEARERBOX <--> OPERATOR SMSC

Masking is already being taken care of, by the bulk application, so it will
solve all my issues.


Thanks for the help!





On Tue, Aug 28, 2012 at 4:41 PM, spameden  wrote:

> You probably need to modify opensmppbox source and force it there
>
> 2012/8/28 ha...@aeon.pk 
>
> Hi,
>>
>> I have a client requiring connectivity over SMPP. I assume I can
>> entertain him via following configuration:
>>
>> OPERATOR SMSC <--> BEARERBOX <--> SMPPBOX <--> CLIENT APPLICATON
>>
>> However, I do not want to let the client set the MASK of outgoing SMS he
>> sends. Instead, I want to keep that mask control with me. Is there any way
>> to handle this? Some configuation in either SMPPBOX or BEARERBOX that could
>> force outgoing SMS masking? Or some other method of connection?
>>
>> Regards,
>>
>>
>
>

Re: Help, SQLBOX gwlib not found when running ./configure

[Adan Canales]

Thanks you, it works for mysql and kannel. Now I have this warning:

config.status: creating gw/Makefile
config.status: creating rpm/sqlbox.spec
config.status: creating sb-config.h
config.status: sb-config.h is unchanged
config.status: executing depfiles commands
config.status: executing libtool commands
configure: WARNING: unrecognized options: --with-kannel

License information ...
++
| License:   |
| This software is subject to the Kannel Software License, available |
| in this distribution in the file LICENSE. By continuing this   |
| installation process, you are bound by the terms of this license   |
| agreement. If you do not agree with the terms of this license, you |
| must abort the installation process at this point. |
||
|  The Kannel Group  |
++

Thank you for using Kannel.
root@smsbkserver:~/trunk/addons/sqlbox#

root@smsbkserver:~/trunk/addons/sqlbox# make
make  all-recursive
make[1]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox»
Making all in gw
make[2]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox/gw»
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox.o -MD -MP -MF .deps/sqlbox.Tpo -c -o sqlbox.o sqlbox.c
sqlbox.c: En la función ‘run_sqlbox’:
sqlbox.c:450:10: aviso: conversión de puntero a entero de tamaño diferente
[-Wpointer-to-int-cast]
sqlbox.c: En la función ‘wait_for_connections’:
sqlbox.c:490:13: aviso: conversión a puntero desde un entero de tamaño
diferente [-Wint-to-pointer-cast]
sqlbox.c: En la función ‘sqlboxc_run’:
sqlbox.c:616:12: aviso: conversión de puntero a entero de tamaño diferente
[-Wpointer-to-int-cast]
mv -f .deps/sqlbox.Tpo .deps/sqlbox.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_mssql.o -MD -MP -MF .deps/sqlbox_mssql.Tpo -c -o sqlbox_mssql.o
sqlbox_mssql.c
mv -f .deps/sqlbox_mssql.Tpo .deps/sqlbox_mssql.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_mysql.o -MD -MP -MF .deps/sqlbox_mysql.Tpo -c -o sqlbox_mysql.o
sqlbox_mysql.c
mv -f .deps/sqlbox_mysql.Tpo .deps/sqlbox_mysql.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_pgsql.o -MD -MP -MF .deps/sqlbox_pgsql.Tpo -c -o sqlbox_pgsql.o
sqlbox_pgsql.c
mv -f .deps/sqlbox_pgsql.Tpo .deps/sqlbox_pgsql.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_sdb.o -MD -MP -MF .deps/sqlbox_sdb.Tpo -c -o sqlbox_sdb.o
sqlbox_sdb.c
mv -f .deps/sqlbox_sdb.Tpo .deps/sqlbox_sdb.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_sqlite.o -MD -MP -MF .deps/sqlbox_sqlite.Tpo -c -o
sqlbox_sqlite.o sqlbox_sqlite.c
mv -f .deps/sqlbox_sqlite.Tpo .deps/sqlbox_sqlite.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_sqlite3.o -MD -MP -MF .deps/sqlbox_sqlite3.Tpo -c -o
sqlbox_sqlite3.o sqlbox_sqlite3.c
mv -f .deps/sqlbox_sqlite3.Tpo .deps/sqlbox_sqlite3.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_oracle.o -MD -MP -MF .deps/sqlbox_oracle.Tpo -c -o
sqlbox_oracle.o sqlbox_oracle.c
mv -f .deps/sqlbox_oracle.Tpo .deps/sqlbox_oracle.Po
gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
-D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
-MT sqlbox_sql.o -MD -MP -MF .deps/sqlbox_sql.Tpo -c -o sqlbox_sql.o
sqlbox_sql.c
mv -f .deps/sqlbox_sql.Tpo .deps/sqlb

Re: Help, SQLBOX gwlib not found when running ./configure

[spameden]

Sorry, it was a mistype from my end:

./configure --with-kannel-dir=/usr/local/include/kannel

2012/8/28 Adan Canales 

> Thanks you, it works for mysql and kannel. Now I have this warning:
>
> config.status: creating gw/Makefile
> config.status: creating rpm/sqlbox.spec
> config.status: creating sb-config.h
> config.status: sb-config.h is unchanged
> config.status: executing depfiles commands
> config.status: executing libtool commands
> configure: WARNING: unrecognized options: --with-kannel
>
> License information ...
> ++
> | License:   |
> | This software is subject to the Kannel Software License, available |
> | in this distribution in the file LICENSE. By continuing this   |
> | installation process, you are bound by the terms of this license   |
> | agreement. If you do not agree with the terms of this license, you |
> | must abort the installation process at this point. |
> ||
> |  The Kannel Group  |
> ++
>
> Thank you for using Kannel.
> root@smsbkserver:~/trunk/addons/sqlbox#
>
> root@smsbkserver:~/trunk/addons/sqlbox# make
> make  all-recursive
> make[1]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox»
> Making all in gw
> make[2]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox/gw»
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox.o -MD -MP -MF .deps/sqlbox.Tpo -c -o sqlbox.o sqlbox.c
> sqlbox.c: En la función ‘run_sqlbox’:
> sqlbox.c:450:10: aviso: conversión de puntero a entero de tamaño diferente
> [-Wpointer-to-int-cast]
> sqlbox.c: En la función ‘wait_for_connections’:
> sqlbox.c:490:13: aviso: conversión a puntero desde un entero de tamaño
> diferente [-Wint-to-pointer-cast]
> sqlbox.c: En la función ‘sqlboxc_run’:
> sqlbox.c:616:12: aviso: conversión de puntero a entero de tamaño diferente
> [-Wpointer-to-int-cast]
> mv -f .deps/sqlbox.Tpo .deps/sqlbox.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_mssql.o -MD -MP -MF .deps/sqlbox_mssql.Tpo -c -o sqlbox_mssql.o
> sqlbox_mssql.c
> mv -f .deps/sqlbox_mssql.Tpo .deps/sqlbox_mssql.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_mysql.o -MD -MP -MF .deps/sqlbox_mysql.Tpo -c -o sqlbox_mysql.o
> sqlbox_mysql.c
> mv -f .deps/sqlbox_mysql.Tpo .deps/sqlbox_mysql.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_pgsql.o -MD -MP -MF .deps/sqlbox_pgsql.Tpo -c -o sqlbox_pgsql.o
> sqlbox_pgsql.c
> mv -f .deps/sqlbox_pgsql.Tpo .deps/sqlbox_pgsql.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_sdb.o -MD -MP -MF .deps/sqlbox_sdb.Tpo -c -o sqlbox_sdb.o
> sqlbox_sdb.c
> mv -f .deps/sqlbox_sdb.Tpo .deps/sqlbox_sdb.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_sqlite.o -MD -MP -MF .deps/sqlbox_sqlite.Tpo -c -o
> sqlbox_sqlite.o sqlbox_sqlite.c
> mv -f .deps/sqlbox_sqlite.Tpo .deps/sqlbox_sqlite.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_sqlite3.o -MD -MP -MF .deps/sqlbox_sqlite3.Tpo -c -o
> sqlbox_sqlite3.o sqlbox_sqlite3.c
> mv -f .deps/sqlbox_sqlite3.Tpo .deps/sqlbox_sqlite3.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600
> -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2 -I/usr/include/mysql
> -MT sqlbox_oracle.o -MD -MP -MF .deps/sqlbox_oracle.Tpo -c -o
> sqlbox_oracle.o sqlbox_oracle.c
> mv -f .deps/sqlbox_oracle.Tpo .deps/sqlbox_oracle.Po
> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw   

Re: dlr-url call on sqlbox

[Ravindra Gupta // Viva]

Dear Rene

We have successfully configured SQLBOX on our Linux server, I have some
query as given below.

1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue like
kannel.


On Wed, Aug 8, 2012 at 9:13 PM, Rene Kluwen  wrote:

> Sorry… Now I see what is happening.
>
> You should comment out line 597 of the original gw/sqlbox.c as well.
>
> ** **
>
> == Rene
>
> ** **
>
> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> *Sent:* Wednesday, 08 August, 2012 15:51
> *To:* Rene Kluwen
> *Cc:* us...@vm1.kannel.org
> *Subject:* Re: dlr-url call on sqlbox
>
> ** **
>
> ** **
>
> Dear Rene,
>
> ** **
>
> We have commented the code in sqlbox.c file and found the row in sent_sms
> table.
>
> ** **
>
> */*  if (msg_type(msg) == sms) {*
>
> *debug("sqlbox", 0, "smsbox_to_bearerbox: sms received");*
>
> *   msg_escaped = msg_duplicate(msg);*
>
> *gw_sql_save_msg(msg_escaped, octstr_imm("MT")); *
>
> *   msg_destroy(msg_escaped);*
>
> *}  */*
>
> ** **
>
> */*  if (msg_type(msg) == sms) {x", 0, "smsbox_to_bearerbox: sms
> received");*
>
> *msg_escaped = msg_duplicate(msg);*
>
> *gw_sql_save_msg(msg_escaped, octstr_imm("MT")); *
>
> *   msg_destroy(msg_escaped);*
>
> *}*
>
> **/*
>
> ** **
>
> *mysql**> select count(*) from sent_sms;*
>
> *+--+*
>
> *| count(*) |*
>
> *+--+*
>
> *|   10 | *
>
> *+--+*
>
> *1 row in set (0.00 sec)*
>
> * *
>
> ** **
>
> ** **
>
> On Wed, Aug 8, 2012 at 6:14 PM, Rene Kluwen  wrote:
> 
>
> Hello Ravindra,
>
>  
>
> 1.   The sent_sms table is a log table. It records all sms messages
> that have been sent, either through a connected smsbox or via an insert
> in send_sms. Entries are never deleted. If you don’t need a log of your
> sms messages, you can comment out the line “gw_sql_save_msg(msg,
> octstr_imm("MT"));” in the gw/sqlbox.c file.
>
> 2.   If you don’t need them, you can just delete everything from the
> sent_sms table, for instance in a cron table. Or otherwise, see 1.
>
> 3.   sqlbox doesn’t manage an internal queue. If you need information
> about the sqlbox queue size, just apply a “select count(*) from send_sms”
> and it will give you the number of messages still in the queue.
>
> 4.   There’s several options. If you don’t need a log of the messages
> that are sent, comment out the line that saves sent messages (see 1.).
> Also, if you want to increase speed of inserting messages in send_sms, you
> can look at the mysql syntax “INSERT… DELAYED”. This is what your client
> program should do. Another thing is to adjust the SQLBOX_MYSQL_SELECT_QUERY
> query in gw/sql_mysql.h. You can increase LIMIT 0,1 to a bigger value. I
> never bothered to test this out on high volumes. So please feel free to
> test and share your experiences in the list.
> Also there’s a number of things you can do to increase mysql speed, which
> is beyond the scope of this mailinglist.
>
>  
>
>  
>
> Hope this helps,
>
>  
>
> Rene
>
>  
>
> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> *Sent:* Wednesday, 08 August, 2012 09:34
>
>
> *To:* Rene Kluwen
> *Cc:* us...@vm1.kannel.org
> *Subject:* Re: dlr-url call on sqlbox
>
>  
>
> Dear Rene,
>
>  
>
> While working on sqlbox, I have come across some queries :- 
>
>1. When we insert on send_sms table, it invokes and sends it to
>sent_sms which further submits it to the Operator and it deletes the entry
>from send_sms. However when we receive the deliver_sm from operator, it 
> doesn't
>deletes the entry from sent_sms table.
>2. If the above scenario continues it would increase the size of
>sent_sms table and will affect the mysql performance.
>3. How we will manage queue in sqlbox, is there any patch available
>which will give us the queue related information.
>4. How to increase insertion speed to send_sms tables or sent_sms
>table.  
>
> ** **
>
> On Wed, Aug 1, 2012 at 6:24 PM, Rene Kluwen  wrote:
> 
>
> I don’t understand quite what you mean with your questions.
>
> But to answer:
>
>  
>
> 1.   Yes, you can send bulk sms through smsbox. It should work better
> than sending them via smsbox.
>
> 2.   Performance issues are dependant of a number of things. Check
> the complete chain (smsbox -> sqlbox -> mysql -> bearerbox -> smsc).
> Usually sqlbox is not the cause.
>
>  
>
> == Rene
>
>  
>
> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> *Sent:* Wednesday, 01 August, 2012 12:29
> *To:* Rene Kluwen
> *Cc:* us...@vm1.kannel.org
>
>
> *Subject:* Re: dlr-url call on sqlbox
>
>  
>
>  
>
> Dear Rene,
>
>  
>
> Thanks for your response.
>
>  
>
> We have successfully configured SQLBOX in our server.
>
>  

Re: Help, SQLBOX gwlib not found when running ./configure

[Adan Canales]

Hi again:

I could compile and install kannel and mysql, now the bearerbox runs fine
but this is the error message I got when run SQLBOX:

root@smsbkserver:~# /usr/local/sbin/sqlbox /usr/local/kannel/sqlbox2.conf
2012-08-29 00:46:48 [3483] [0] INFO: Debug_lvl = -1, log_file = ,
log_lvl = 0
2012-08-29 00:46:48 [3483] [0] DEBUG: Kannel sqlbox version `svn-r4991M'.
Build `Aug 28 2012 00:50:09', compiler `4.6.3'.
System Linux, release 3.2.0-23-generic, version #36-Ubuntu SMP Tue Apr 10
20:39:51 UTC 2012, machine x86_64.
Hostname smsbkserver, IP 127.0.1.1.
Libxml version 2.7.8.
Compiled with MySQL 5.5.24, using MySQL 5.5.24.
Using native malloc.

2012-08-29 00:46:48 [3483] [0] INFO: Starting to log to file
/home/adan/kannel-sqlbox.log level 0
2012-08-29 00:46:48 [3483] [0] INFO: Added logfile
`/home/adan/kannel-sqlbox.log' with level `0'.
2012-08-29 00:46:48 [3483] [0] ERROR: MYSQL: can not connect to database!
2012-08-29 00:46:48 [3483] [0] ERROR: MYSQL: Unknown MySQL server host
'192.168.1.101' (0)
2012-08-29 00:46:48 [3483] [0] PANIC: SQLBOX: MySQL: database pool has no
connections!
2012-08-29 00:46:48 [3483] [0] PANIC:
/usr/local/sbin/sqlbox(gw_backtrace+0xae) [0x426b3e]
2012-08-29 00:46:48 [3483] [0] PANIC:
/usr/local/sbin/sqlbox(gw_panic+0x165) [0x426cb5]
2012-08-29 00:46:48 [3483] [0] PANIC:
/usr/local/sbin/sqlbox(sqlbox_init_mysql+0x34c) [0x40b7ac]
2012-08-29 00:46:48 [3483] [0] PANIC: /usr/local/sbin/sqlbox(main+0x2eb)
[0x40958b]
2012-08-29 00:46:48 [3483] [0] PANIC:
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7fe5d792476d]
2012-08-29 00:46:48 [3483] [0] PANIC: /usr/local/sbin/sqlbox() [0x40980d]
root@smsbkserver:~#

thanks again

2012/8/28 spameden 

> Sorry, it was a mistype from my end:
>
> ./configure --with-kannel-dir=/usr/local/include/kannel
>
>
> 2012/8/28 Adan Canales 
>
>> Thanks you, it works for mysql and kannel. Now I have this warning:
>>
>> config.status: creating gw/Makefile
>> config.status: creating rpm/sqlbox.spec
>> config.status: creating sb-config.h
>> config.status: sb-config.h is unchanged
>> config.status: executing depfiles commands
>> config.status: executing libtool commands
>> configure: WARNING: unrecognized options: --with-kannel
>>
>> License information ...
>> ++
>> | License:   |
>> | This software is subject to the Kannel Software License, available |
>> | in this distribution in the file LICENSE. By continuing this   |
>> | installation process, you are bound by the terms of this license   |
>> | agreement. If you do not agree with the terms of this license, you |
>> | must abort the installation process at this point. |
>> ||
>> |  The Kannel Group  |
>> ++
>>
>> Thank you for using Kannel.
>> root@smsbkserver:~/trunk/addons/sqlbox#
>>
>> root@smsbkserver:~/trunk/addons/sqlbox# make
>> make  all-recursive
>> make[1]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox»
>> Making all in gw
>> make[2]: se ingresa al directorio «/home/adan/trunk/addons/sqlbox/gw»
>> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2
>> -I/usr/include/mysql -MT sqlbox.o -MD -MP -MF .deps/sqlbox.Tpo -c -o
>> sqlbox.o sqlbox.c
>> sqlbox.c: En la función ‘run_sqlbox’:
>> sqlbox.c:450:10: aviso: conversión de puntero a entero de tamaño
>> diferente [-Wpointer-to-int-cast]
>> sqlbox.c: En la función ‘wait_for_connections’:
>> sqlbox.c:490:13: aviso: conversión a puntero desde un entero de tamaño
>> diferente [-Wint-to-pointer-cast]
>> sqlbox.c: En la función ‘sqlboxc_run’:
>> sqlbox.c:616:12: aviso: conversión de puntero a entero de tamaño
>> diferente [-Wpointer-to-int-cast]
>> mv -f .deps/sqlbox.Tpo .deps/sqlbox.Po
>> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2
>> -I/usr/include/mysql -MT sqlbox_mssql.o -MD -MP -MF .deps/sqlbox_mssql.Tpo
>> -c -o sqlbox_mssql.o sqlbox_mssql.c
>> mv -f .deps/sqlbox_mssql.Tpo .deps/sqlbox_mssql.Po
>> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2
>> -I/usr/include/mysql -MT sqlbox_mysql.o -MD -MP -MF .deps/sqlbox_mysql.Tpo
>> -c -o sqlbox_mysql.o sqlbox_mysql.c
>> mv -f .deps/sqlbox_mysql.Tpo .deps/sqlbox_mysql.Po
>> gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2
>> -D_XOPEN_SOURCE=600 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2
>> -D_XOPEN_SOURC