are you sure kannel was installed successfully? try recompiling and reinstalling kannel..
2012/8/27 Adan Canales <[email protected]> > 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 <[email protected]> > >> sorry, you need to do it this way in sqlbox: >> >> ./configure --with-kannel-dir=/usr/local/include/kannel >> >> 2012/8/26 <[email protected]> >> >> 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 <[email protected]> >>> *Date: *Sun, 26 Aug 2012 02:38:36 +0400 >>> *To: *Adan Canales<[email protected]> >>> *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 <[email protected]> >>> >>>> 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 <[email protected]> >>>> >>>>> You need to compile kannel before configuring and compiling sqlbox. >>>>> >>>>> >>>>> 2012/8/26 Adan Canales <[email protected]> >>>>> >>>>>> I discover this >>>>>> >>>>>> >>>>>> >>>>>> when try again ./configure --with-kannel-dir=/usr/local >>>>>> >>>>>> How to install this? >>>>>> >>>>>> Thanks in advance >>>>>> >>>>>> Adan >>>>>> >>>>>> 2012/8/25 spameden <[email protected]> >>>>>> >>>>>>> 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 <[email protected]> >>>>>>> >>>>>>>> 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 <[email protected]> >>>>>>>> >>>>>>>>> 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.mx y >>>>>>>>> www.pravcom.com >>>>>>>>> >>>>>>>>> >>>>>>>>> On Sat, Aug 25, 2012 at 1:00 AM, Adan Canales <[email protected]> >>>>>>>>> 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 > > >
