Oh Shamera, You gave me a hint, the problem was the port because the iptables rule I was using was wrong.
Thank you all guys! Sorry my bad. 2013/3/15 A Shamera Thusan Ranathunga < [email protected]> > Hi > > > > Is your mysql port is correct ? I sow in your configuration port is 3600. > But mysql default port is 3306. Pls. check > > > > > > Br, > > > --------------------------------------------------------------------------------------------------------- > Shamera Ranathunga |* com**viva* Technologies Ltd | Mobile : +94 750190030 > > > --------------------------------------------------------------------------------------------------------- > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Arturo SAnchez > *Sent:* Friday, March 15, 2013 12:07 PM > *To:* Willy Mularto > *Cc:* [email protected]; [email protected] > *Subject:* Re: sqlbox on remote address > > > > Willy, > > > > Yes that's the weird part. > > > > I can even use mysql client and nothing. I can use it for dlr storage but > no for sqlbox > > > > Someone can explain that? please. > > > > Thanks > > > > 2013/3/15 Willy Mularto <[email protected]> > > Have you grant your host in MySQL? > > > > > > Willy Mularto > > [email protected] > > > > On Mar 15, 2013, at 1:03 PM, Arturo SAnchez <[email protected]> wrote: > > > > Hello > > > > Yes I already have the port, I think is something more about coding. > That's why I cc devel > > ----- > > group = sqlbox > > id = sqlbox-db > > smsbox-id = sqlbox > > #global-sender = "" > > bearerbox-host = localhost > > bearerbox-port = 13001 > > smsbox-port = 13005 > > smsbox-port-ssl = false > > sql-log-table = sent_sms > > sql-insert-table = send_sms > > log-file = "/var/log/kannel/kannel-sqlbox.log" > > log-level = 0 > > #ssl-client-certkey-file = "" > > #ssl-server-cert-file = "" > > #ssl-server-key-file = "" > > #ssl-trusted-ca-file = "" > > > > # Database connection examples. Please uncomment as needed > > > > # MYSQL Connection > > group = mysql-connection > > id = sqlbox-db > > host = 1.2.3.4.5 > > username = username > > password = password > > database = kannel > > port = 3600 > > ----- > > Has someone experimented this before? is there a patch or something? > > > > Thanks > > > > 2013/3/14 Willy Mularto <[email protected]> > > If you are trying to connect SQLBox to another host make sure you have > define port directive in your SQLBox configuration: > …. > host = 1.2.3.4 > port = 3306 > …. > > > > Willy Mularto > [email protected] > > > On Mar 15, 2013, at 12:55 PM, Arturo SAnchez <[email protected]> wrote: > > > Hello All > > > > You know, I'm experimenting a weird situation. > > I want to use sqlbox and connect to LAN DB but I think this is when > sqlbox crashes. > > It's a simple remote host = 10.191.219.22X > > I can connect from this machine using the mysql client, actually it uses > the same DB for dlr storage > > Please let me know if someone has the same problem or how to solve it? > > I already added it on /etc/hosts and nothing worked, only works on > localhost though. > > > > I reviewed sqlbox_mysql.c on struct server_type *sqlbox_init_mysql(Cfg* > cfg) but I don't see nothing weird, maybe is somewhere else that you can > just connect to local socket. > > > > Thanks in advance > > > > --------------------- backtrace here ----------- > > bash-4.1# /usr/local/kannel/sbin/sqlbox -v 0 /etc/kannel/sqlbox.conf > > 2013-03-15 05:47:16 [25770] [0] INFO: Debug_lvl = 0, log_file = <none>, > log_lvl = 0 > > 2013-03-15 05:47:16 [25770] [0] DEBUG: Kannel sqlbox version `svn-r5031'. > > Build `Mar 14 2013 23:42:51', compiler `4.4.7 20120313 (Red Hat > 4.4.7-3)'. > > System Linux, release 2.6.32-279.22.1.el6.x86_64, version #1 SMP Wed Feb > 6 03:10:46 UTC 2013, machine x86_64. > > Hostname ip-10-191-219-227.ec2.internal, IP 10.191.219.227. > > Libxml version 2.7.6. > > Using OpenSSL 1.0.0-fips 29 Mar 2010. > > Compiled with MySQL 5.1.67, using MySQL 5.1.67. > > Using native malloc. > > > > 2013-03-15 05:47:16 [25770] [0] INFO: Starting to log to file > /var/log/kannel/kannel-sqlbox.log level 0 > > 2013-03-15 05:47:16 [25770] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > > > > > > 2013-03-15 05:48:19 [25770] [0] ERROR: MYSQL: can not connect to > database! > > 2013-03-15 05:48:19 [25770] [0] ERROR: MYSQL: Can't connect to MySQL > server on '10.191.219.228' (110) > > 2013-03-15 05:48:19 [25770] [0] PANIC: SQLBOX: MySQL: database pool has > no connections! > > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(gw_backtrace+0xae) [0x4285ce] > > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(gw_panic+0x145) [0x428725] > > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(sqlbox_init_mysql+0x34c) [0x40be0c] > > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(main+0x30d) [0x40b85d] > > 2013-03-15 05:48:19 [25770] [0] PANIC: > /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f2fd22b5cdd] > > 2013-03-15 05:48:19 [25770] [0] PANIC: /usr/local/kannel/sbin/sqlbox() > [0x40a4f9] > > > > > > > This e-mail and all material transmitted with it are for the use of the > intended recipient(s) ONLY and contains confidential and/or privileged > information. If you are not the intended recipient, please contact the > sender by reply e-mail and destroy all copies and the original message. Any > unauthorized review, use, disclosure, dissemination, forwarding, printing > or copying of this email or any action taken pursuant to the contents of > the present e-mail is strictly prohibited and is unlawful. The recipient > acknowledges that Comviva Technologies Limited or its management or > directors, are unable to exercise control or ensure the integrity over /of > the contents of the information contained in e-mail. Any views expressed > herein are those of the individual sender only and no binding nature of the > contents shall be implied or assumed unless the sender does so expressly > with due authority of Comviva Technologies Limited. E-mail and any contents > transmitted with it are prone to viruses and related defects despite all > efforts to avoid such by Comviva Technologies Limited. >
