Please, copy [email protected] as well.. 2012/8/26 spameden <[email protected]>
> 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 >> >> >> >
