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
