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

Reply via email to