Hi. You need to use kannel from svn as well.
Don't need to use ./bootstrap for sqlbox. The process is simple $ svn co https://svn.kannel.org/gateway/trunk $ cd trunk $ ./configure --with-mysql $ make $ make install $ cd addons/sqlbox $ ./configure --with-kannel=/usr/local/include/kannel $ make $ make install if you want to install into /usr use --prefix=/usr don't forget to remove actual kannel from the debian because it's outdated and can break your installation. 2012/8/27 Adan Canales <adan...@gmail.com> > Hi again and thanks for your help. > > I reinstall everything from scratch. I´m running an ubuntu version 12.04 > lts and this time I installed kannel from deb packages using apt-get > install kannel and installed fine. I checked the libxml2 was install fine. > > Then download SQLBOX sources using sv co > https://svn.kannel.org/sqlbox/trunk sqlbox and download the sqlbox > sources fine > > The cd sqlbox and try to run ./bootstrap and gave me some missing > libraries warnings so I installed automake, libtool, bison and libxml2-dev > and try to run again and this is what I have now: > > root@smsbkserver:~/sqlbox# ./bootstrap > + set -e > + amvers=no > + automake-1.11 --version > + amvers=-1.11 > + test -1.11 = no > + libtoolize=no > + glibtoolize --version > + libtoolize --version > + libtoolize=libtoolize > + test libtoolize = no > + set +x > + test ! -d autotools > + libtoolize --copy --force > libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR, `autotools'. > libtoolize: copying file `autotools/ltmain.sh' > libtoolize: You should add the contents of the following files to > `aclocal.m4': > libtoolize: `/usr/share/aclocal/libtool.m4' > libtoolize: `/usr/share/aclocal/ltoptions.m4' > libtoolize: `/usr/share/aclocal/ltversion.m4' > libtoolize: `/usr/share/aclocal/ltsugar.m4' > libtoolize: `/usr/share/aclocal/lt~obsolete.m4' > libtoolize: Consider adding `AC_CONFIG_MACRO_DIR([m4])' to configure.inand > libtoolize: rerunning libtoolize, to keep the correct libtool macros > in-tree. > libtoolize: Consider adding `-I m4' to ACLOCAL_AMFLAGS in Makefile.am. > + test -f ltmain.sh > + aclocal-1.11 -I autotools > + autoconf > + autoheader > + automake-1.11 --add-missing --copy > configure.in:95: installing `autotools/config.guess' > configure.in:95: installing `autotools/config.sub' > configure.in:92: installing `autotools/install-sh' > configure.in:92: installing `autotools/missing' > gw/Makefile.am: installing `autotools/depcomp' > Makefile.am:3: wildcard grep -l '<!DOCTYPE ' doc/*.xml: non-POSIX variable > name > Makefile.am:3: (probably a GNU make extension) > Makefile.am:10: wildcard doc/*.png: non-POSIX variable name > Makefile.am:10: (probably a GNU make extension) > Makefile.am:13: wildcard doc/*.fig: non-POSIX variable name > Makefile.am:13: (probably a GNU make extension) > Makefile.am:71: shell rpm --eval '%_rpmdir': non-POSIX variable name > Makefile.am:71: (probably a GNU make extension) > root@smsbkserver:~/sqlbox# > > I don´t know what else to do?? :( Thanks in advance. > > Kind regards > > Adan > > > 2012/8/26 spameden <spame...@gmail.com> > >> are you sure kannel was installed successfully? >> >> try recompiling and reinstalling kannel.. >> >> >> 2012/8/27 Adan Canales <adan...@gmail.com> >> >>> Hi again: >>> >>> this is what I did >>> >>> adan@smsserver:~/trunk/addons/sqlbox$ ./configure >>> --with-kannel-dir=/usr/local/include/kannel >>> >>> and the results: >>> >>> Configuring Kannel and DB dependancies ... >>> checking for Ct-Lib support... no >>> checking for FreeTDS Ct-Lib support... no >>> checking for gw-config... no >>> checking for Kannel include files in... /usr >>> checking for "/usr/include/kannel/gw-config.h"... no >>> checking for Kannel include files in... /usr/local >>> checking for "/usr/local/include/kannel/gw-config.h"... yes >>> checking for cfg_create in -lgwlib... no >>> >>> configure: error: Kannel gwlib is required! >>> adan@smsserver:~/trunk/addons/sqlbox$ >>> >>> this is the display from the /include/kannel directory >>> >>> >>> adan@smsserver:~$ cd /usr >>> adan@smsserver:/usr$ cd local >>> adan@smsserver:/usr/local$ cd include >>> adan@smsserver:/usr/local/include$ cd kannel >>> *adan@smsserver:/usr/local/include/kannel$ ls >>> gw gw-config.h gwlib wap* >>> adan@smsserver:/usr/local/include/kannel$ >>> >>> adan@smsserver:/usr/local/include/kannel$ cd gwlib >>> adan@smsserver:/usr/local/include/kannel/gwlib$ ls >>> accesslog.h dbpool_p.h gw-prioqueue.h list.h protected.h >>> cfg.def dict.h gw-rwlock.h log.h regex.h >>> cfg.h fdset.h gwthread.h md5.h semaphore.h >>> charset.h gwassert.h gw_uuid.h mime.h socket.h >>> conn.h gw-getopt.h gw_uuid_types.h octstr.h ssl.h >>> counter.h gwlib.h html-entities.def parse.h thread.h >>> date.h gwmem.h http.h pcre.h utils.h >>> dbpool.h gwpoll.h latin1_to_gsm.h pki.h xmlrpc.h >>> >>> I don´t know what else to try ?? >>> >>> >>> >>> >>> >>> 2012/8/25 spameden <spame...@gmail.com> >>> >>>> sorry, you need to do it this way in sqlbox: >>>> >>>> ./configure --with-kannel-dir=/usr/local/include/kannel >>>> >>>> 2012/8/26 <adan...@gmail.com> >>>> >>>> I did it, kannel is in that directory then i did configure with those >>>>> options and says: >>>>> Configure: error: Kannel gwlib is required! >>>>> >>>>> Could it be the version of kannel? >>>>> Enviado desde mi dispositivo BlackBerry® >>>>> ------------------------------ >>>>> *From: * spameden <spame...@gmail.com> >>>>> *Date: *Sun, 26 Aug 2012 02:38:36 +0400 >>>>> *To: *Adan Canales<adan...@gmail.com> >>>>> *Subject: *Re: users Digest, Vol 72, Issue 68 >>>>> >>>>> did you install kannel? >>>>> >>>>> if you do ./configure; make; make install in the kannel directory it'd >>>>> be installed into /usr/local >>>>> >>>>> so you might need to do this in sqlbox: >>>>> >>>>> ./configure --with-kannel=/usr/local; make; make install >>>>> >>>>> 2012/8/26 Adan Canales <adan...@gmail.com> >>>>> >>>>>> I actually didit again, I recompile everything but still the error, >>>>>> Kannel gwlib is required! >>>>>> >>>>>> when I configure sqlbox, how to install devel libraries? im using >>>>>> ubuntu 12.04 lts >>>>>> >>>>>> thanks >>>>>> >>>>>> 2012/8/25 spameden <spame...@gmail.com> >>>>>> >>>>>>> You need to compile kannel before configuring and compiling sqlbox. >>>>>>> >>>>>>> >>>>>>> 2012/8/26 Adan Canales <adan...@gmail.com> >>>>>>> >>>>>>>> I discover this >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> when try again ./configure --with-kannel-dir=/usr/local >>>>>>>> >>>>>>>> How to install this? >>>>>>>> >>>>>>>> Thanks in advance >>>>>>>> >>>>>>>> Adan >>>>>>>> >>>>>>>> 2012/8/25 spameden <spame...@gmail.com> >>>>>>>> >>>>>>>>> are you sure 192.168.42.105 accepts connections from your host >>>>>>>>> with your credentials? >>>>>>>>> >>>>>>>>> you can check it via mysql command line interface >>>>>>>>> >>>>>>>>> >>>>>>>>> 2012/8/26 Adan Canales <adan...@gmail.com> >>>>>>>>> >>>>>>>>>> Alvaro: >>>>>>>>>> >>>>>>>>>> Bearerbox and SMSbox runs just fine and connected to mysql, even >>>>>>>>>> I tested phpmyadmin and connect as well, so Mysql runs fine but no >>>>>>>>>> sqlbox >>>>>>>>>> >>>>>>>>>> Thanks >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> # >>>>>>>>>> # THIS IS A SAMPLE CONFIGURATION FOR SMS KANNEL >>>>>>>>>> # >>>>>>>>>> # Modified by Donald Jackson based on the original smskannel.conf >>>>>>>>>> by >>>>>>>>>> # Kalle Marjola for Kannel project 2001, 2004 >>>>>>>>>> >>>>>>>>>> #--------------------------------------------- >>>>>>>>>> # CORE >>>>>>>>>> # >>>>>>>>>> # There is only one core group and it sets all basic settings >>>>>>>>>> # of the bearerbox (and system). You should take extra notes on >>>>>>>>>> # configuration variables like 'store-file' (or 'store-dir'), >>>>>>>>>> # 'admin-allow-ip' and 'access.log' >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> group = core >>>>>>>>>> admin-port = 13000 >>>>>>>>>> smsbox-port = 13001 >>>>>>>>>> admin-password = bar >>>>>>>>>> dlr-storage = mysql >>>>>>>>>> #status-password = foo >>>>>>>>>> #admin-deny-ip = "*.*.*.*" >>>>>>>>>> admin-allow-ip = "*.*.*.*" >>>>>>>>>> #admin-allow-ip = "127.0.0.1" >>>>>>>>>> #log-file = "c:\kannel.log" >>>>>>>>>> #log-level = 4 >>>>>>>>>> box-deny-ip = "*.*.*.*" >>>>>>>>>> box-allow-ip = "127.0.0.1" >>>>>>>>>> #unified-prefix = "+358,00358,0;+,00" >>>>>>>>>> #access-log = "c:\access.log" >>>>>>>>>> store-type = file >>>>>>>>>> store-location = "/home/adan/store" >>>>>>>>>> #ssl-server-cert-file = "cert.pem" >>>>>>>>>> #ssl-server-key-file = "key.pem" >>>>>>>>>> #ssl-certkey-file = "mycertandprivkeyfile.pem" >>>>>>>>>> >>>>>>>>>> #---- mysql connection >>>>>>>>>> group = mysql-connection >>>>>>>>>> id = mydlr >>>>>>>>>> host = 127.0.0.1 >>>>>>>>>> username = adan >>>>>>>>>> password = pituca0499 >>>>>>>>>> database = kannel >>>>>>>>>> max-connections = 5 >>>>>>>>>> >>>>>>>>>> #----- DLR table structure >>>>>>>>>> group = dlr-db >>>>>>>>>> id = mydlr >>>>>>>>>> table = dlr >>>>>>>>>> field-smsc = smsc >>>>>>>>>> field-timestamp = ts >>>>>>>>>> field-destination = destination >>>>>>>>>> field-source = source >>>>>>>>>> field-service = service >>>>>>>>>> field-url = url >>>>>>>>>> field-mask = mask >>>>>>>>>> field-status = status >>>>>>>>>> field-boxc-id = boxc >>>>>>>>>> >>>>>>>>>> #--------------------------------------------- >>>>>>>>>> # SMSC CONNECTIONS >>>>>>>>>> # >>>>>>>>>> # SMSC connections are created in bearerbox and they handle SMSC >>>>>>>>>> specific >>>>>>>>>> # protocol and message relying. You need these to actually >>>>>>>>>> receive and send >>>>>>>>>> # messages to handset, but can use GSM modems as virtual SMSCs >>>>>>>>>> >>>>>>>>>> #---- Conexion a Claro >>>>>>>>>> group = smsc >>>>>>>>>> smsc = smpp >>>>>>>>>> smsc-id = 53010 >>>>>>>>>> host = 190.148.68.22 >>>>>>>>>> port = 8209 >>>>>>>>>> transceiver-mode = false >>>>>>>>>> smsc-username = trantrxhn >>>>>>>>>> smsc-password = tranhn >>>>>>>>>> system-type = smpp >>>>>>>>>> interface-version = 34 >>>>>>>>>> source-addr-ton = 1 >>>>>>>>>> source-addr-npi = 1 >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> #--------------------------------------------- >>>>>>>>>> # SMSBOX SETUP >>>>>>>>>> # >>>>>>>>>> # Smsbox(es) do higher-level SMS handling after they have been >>>>>>>>>> received from >>>>>>>>>> # SMS centers by bearerbox, or before they are given to bearerbox >>>>>>>>>> for delivery >>>>>>>>>> >>>>>>>>>> group = smsbox >>>>>>>>>> #smsbox-id = 1 >>>>>>>>>> bearerbox-host = 127.0.0.1 >>>>>>>>>> sendsms-port = 13013 >>>>>>>>>> log-file = smsbox.log >>>>>>>>>> log-level = 3 >>>>>>>>>> #access-log = "/tmp/access.log" >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> #--------------------------------------------- >>>>>>>>>> # SEND-SMS USERS >>>>>>>>>> # >>>>>>>>>> # These users are used when Kannel smsbox sendsms interface is >>>>>>>>>> used to >>>>>>>>>> # send PUSH sms messages, i.e. calling URL like >>>>>>>>>> # >>>>>>>>>> http://kannel.machine:13013/cgi-bin/sendsms?username=tester&password=foobar. >>>>>>>>>> .. >>>>>>>>>> >>>>>>>>>> group = sendsms-user >>>>>>>>>> username = tester >>>>>>>>>> password = foobar >>>>>>>>>> default-smsc = claro >>>>>>>>>> #user-deny-ip = "" >>>>>>>>>> user-allow-ip = "*.*.*.*" >>>>>>>>>> >>>>>>>>>> #--------------------------------------------- >>>>>>>>>> # SERVICES >>>>>>>>>> # >>>>>>>>>> # These are 'responses' to sms PULL messages, i.e. messages >>>>>>>>>> arriving from >>>>>>>>>> # handsets. The response is based on message content. Only one >>>>>>>>>> sms-service is >>>>>>>>>> # applied, using the first one to match. >>>>>>>>>> >>>>>>>>>> group = sms-service >>>>>>>>>> keyword = default >>>>>>>>>> #keyword-regex = .* >>>>>>>>>> catch-all = yes >>>>>>>>>> max-messages = 0 >>>>>>>>>> get-url = " >>>>>>>>>> http://192.168.174.132/php/index.php?user=%n&pass=jose&celular=%q&sms=%a&marcacion=%Q&%i&%I&%d&%D%&%A&%n&%O&%f >>>>>>>>>> " >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> group = sqlbox >>>>>>>>>> id = mysqlbox >>>>>>>>>> smsbox-id = sqlbox >>>>>>>>>> bearerbox-host = localhost >>>>>>>>>> bearerbox-port = 13001 >>>>>>>>>> smsbox-port = 13005 >>>>>>>>>> smsbox-port-ssl = false >>>>>>>>>> sql-log-table = sent_sms >>>>>>>>>> sql-insert-table = send_sms >>>>>>>>>> log-level = 0 >>>>>>>>>> log-file = "/home/adan/kannel-sqlbox.log" >>>>>>>>>> >>>>>>>>>> group = mysql-connection >>>>>>>>>> id = mysqlbox >>>>>>>>>> host = 127.0.0.1 >>>>>>>>>> username = adan >>>>>>>>>> password = pituca0499 >>>>>>>>>> database = kannel >>>>>>>>>> >>>>>>>>>> 2012/8/25 Alvaro Cornejo <cornejo.alv...@gmail.com> >>>>>>>>>> >>>>>>>>>>> Hi >>>>>>>>>>> >>>>>>>>>>> Have you installed mysql devel sources / have you run >>>>>>>>>>> ./configure with >>>>>>>>>>> --with-mysql? >>>>>>>>>>> >>>>>>>>>>> Regards >>>>>>>>>>> >>>>>>>>>>> Alvaro >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> |-----------------------------------------------------------------------------------------------------------------| >>>>>>>>>>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde >>>>>>>>>>> cualquier >>>>>>>>>>> celular y Nextel >>>>>>>>>>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 >>>>>>>>>>> vias via >>>>>>>>>>> SMS y GPRS online >>>>>>>>>>> Visitenos en www.perusms.NET www.smsglobal.com.mxy >>>>>>>>>>> www.pravcom.com >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Sat, Aug 25, 2012 at 1:00 AM, Adan Canales <adan...@gmail.com> >>>>>>>>>>> wrote: >>>>>>>>>>> > Hello there: >>>>>>>>>>> > >>>>>>>>>>> > I have the following error: >>>>>>>>>>> > >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] INFO: Starting to log to file >>>>>>>>>>> > /home/adan/kannel-sqlbox.log level 0 >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] INFO: Added logfile >>>>>>>>>>> > `/home/adan/kannel-sqlbox.log' with lev el `0'. >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] ERROR: MYSQL: can not connect >>>>>>>>>>> to database! >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] ERROR: MYSQL: Unknown MySQL >>>>>>>>>>> server host >>>>>>>>>>> > '192.168.42.105' (0 ) >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: SQLBOX: MySQL: database >>>>>>>>>>> pool has no >>>>>>>>>>> > connections! >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: >>>>>>>>>>> > /usr/local/sbin/sqlbox(gw_backtrace+0xae) [0x426b3e] >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: >>>>>>>>>>> /usr/local/sbin/sqlbox(gw_panic+0x165) >>>>>>>>>>> > [0x426cb5] >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: >>>>>>>>>>> > /usr/local/sbin/sqlbox(sqlbox_init_mysql+0x34c) [0x4 0b7ac] >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: >>>>>>>>>>> /usr/local/sbin/sqlbox(main+0x2eb) >>>>>>>>>>> > [0x40958b] >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: >>>>>>>>>>> > /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x ed) >>>>>>>>>>> [0x7f95b8ef876d] >>>>>>>>>>> > 2012-08-24 23:55:32 [8051] [0] PANIC: /usr/local/sbin/sqlbox() >>>>>>>>>>> [0x40980d] >>>>>>>>>>> > >>>>>>>>>>> > I have installed MySQL workbench and I can connect to the >>>>>>>>>>> database, and I >>>>>>>>>>> > have searched internet for help with no success. Can anyone >>>>>>>>>>> help me please? >>>>>>>>>>> > Thanks in advance >>>>>>>>>>> > >>>>>>>>>>> > This is my configuration: >>>>>>>>>>> > >>>>>>>>>>> > group = sqlbox >>>>>>>>>>> > id = sqlbox-db >>>>>>>>>>> > smsbox-id = sqlbox >>>>>>>>>>> > bearerbox-host = localhost >>>>>>>>>>> > bearerbox-port = 13001 >>>>>>>>>>> > smsbox-port = 13005 >>>>>>>>>>> > smsbox-port-ssl = false >>>>>>>>>>> > sql-log-table = sent_sms >>>>>>>>>>> > sql-insert-table = send_sms >>>>>>>>>>> > log-level = 0 >>>>>>>>>>> > log-file = "/home/adan/kannel-sqlbox.log" >>>>>>>>>>> > >>>>>>>>>>> > group = mysql-connection >>>>>>>>>>> > id = sqlbox-db >>>>>>>>>>> > host = 192.168.42.105 >>>>>>>>>>> > username = root >>>>>>>>>>> > password = password >>>>>>>>>>> > database = kannel >>>>>>>>>>> > ~ >>>>>>>>>>> > >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Adan Canales >>>>>>>>>> Desarrollo Web y Movil >>>>>>>>>> www.acghonduras.com >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Adan Canales >>>>>>>> Desarrollo Web y Movil >>>>>>>> www.acghonduras.com >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Adan Canales >>>>>> Desarrollo Web y Movil >>>>>> www.acghonduras.com >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >>> >>> -- >>> Adan Canales >>> Desarrollo Web y Movil >>> www.acghonduras.com >>> >>> >>> >> > > > -- > Adan Canales > Desarrollo Web y Movil > www.acghonduras.com > > >
