hi, We had Similar Issue. Can you send me the smstext in the queue at the time of crash.
*Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Sat, Nov 1, 2014 at 5:04 PM, Aditya Khanna <aditya.khanna111...@gmail.com > wrote: > Hello Everyone, > > I'm new with Kannel SMS Gateway. > > When I'm establishing connection between BearerBox, SMSBox and SqlBox. > BearerBox and SMSBox connected successfully but BearerBox and SqlBox not > connected permanently. > > In SqlBox Terminal Window, it shows me some error: > > Build `Nov 1 2014 03:02:34', compiler `4.4.7 20120313 (Red Hat 4.4.7-3)'. > System Linux, release 2.6.18-028stab107.1, version #1 SMP Wed Apr 17 > 19:10:55 MSD 2013, machine x86_64. > Hostname ip-166-62-16-78.ip.secureserver.net, IP 166.62.16.78. > Libxml version 2.7.6. > Using OpenSSL 1.0.0-fips 29 Mar 2010. > Compiled with MySQL 5.5.37, using MySQL 5.5.37. > Using native malloc. > > 2014-11-01 04:07:28 [8059] [0] INFO: Starting to log to file sqlbox.log > level 0 > 2014-11-01 04:07:28 [8059] [0] INFO: Added logfile `sqlbox.log' with level > `0'. > 2014-11-01 04:07:28 [8059] [0] INFO: MYSQL: Connected to server at > 127.0.0.1. > 2014-11-01 04:07:28 [8059] [0] INFO: MYSQL: server version 5.5.37-cll, > client version 5.5.37. > 2014-11-01 04:07:28 [8059] [0] DEBUG: Started thread 1 > (sqlbox.c:sql_to_bearerbox) > 2014-11-01 04:07:28 [8059] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > maps to pid 8059. > 2014-11-01 04:07:28 [8059] [1] DEBUG: Connecting to <127.0.0.1> > 2014-11-01 04:07:28 [8059] [1] INFO: Connected to bearerbox at 127.0.0.1 > port 15000. > 2014-11-01 04:07:28 [8059] [1] DEBUG: Started thread 2 > (sqlbox.c:bearerbox_to_sql) > 2014-11-01 04:07:28 [8059] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > maps to pid 8059. > 2014-11-01 04:09:08 [8059] [2] ERROR: Connection closed by the bearerbox. > 2014-11-01 04:09:08 [8059] [2] DEBUG: bearerbox_to_sql: connection to > bearerbox died. > 2014-11-01 04:09:08 [8059] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > terminates. > 2014-11-01 04:09:08 [8059] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > terminates. > 2014-11-01 04:09:09 [8059] [0] DEBUG: Immutable octet strings: 63. > > This is my sqlbox.conf file: > > group = sqlbox > id = sqlbox-db > smsbox-id = mysmsbox > global-sender = "" > bearerbox-host = localhost > bearerbox-port = 15001 > smsbox-port = 15002 > smsbox-port-ssl = false > sql-log-table = sqlbox_sent_sms > sql-insert-table = sqlbox_send_sms > log-file = "sqlbox.log" > log-level = 0 > > > #------------------------------------------------------------------------------- > > group = mysql-connection > id = sqlbox-db > host="127.0.0.1" > port = 3306 > username = "root" > password = "" > database = "bulk_sms" > #max-connections = "1" > > > #------------------------------------------------------------------------------- > > Please resolve this issue as soon as possible. > > Your reply will be appreciate. > > > Thanks, > Aditya Khanna > > > > >
