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 > > >
