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