Have you also check max connection allowed, etc? Try to set spool directive in SQLBox, by default it create 10 concurrent connections.
Willy Mularto [email protected] On Mar 15, 2013, at 1:36 PM, Arturo SAnchez <[email protected]> wrote: > 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] >> >> > >
