Re: sqlbox on remote address

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