debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3

cgchen <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
Hi

I've been trying to integrate sqlbox with kannel. Kannel 1.5.0 is installed through the downloaded deb package as per installation guide and kannel-sqlbox 0.7.2-3 is installed through apt-get install on Debian Wheezy.

My problem is that when smsbox is connected directly to the bearerbox, everything works fine but when I added sqlbox in the middle of the 2, all the processes starts up fine as usual but as soon as I send a msg, both the smsbox and sqlbox processes crashes instantly. Please see below for sqlbox logs:

 2013-01-05 22:38:18 [8658] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'.
2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: Connected to server at localhost.
2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: server version 5.1.66-0+squeeze1, client version 5.1.66.
2013-01-05 22:38:18 [8658] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox)
2013-01-05 22:38:18 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 8658.
2013-01-05 22:38:18 [8658] [1] INFO: Connected to bearerbox at 127.0.0.1 port 13001.
2013-01-05 22:38:18 [8658] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql)
2013-01-05 22:38:18 [8658] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 8658.
2013-01-05 22:38:19 [8658] [0] DEBUG: Started thread 3 (sqlbox.c:function)
2013-01-05 22:38:19 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to pid 8658.
2013-01-05 22:38:19 [8658] [3] INFO: Client connected from <127.0.0.1>
2013-01-05 22:38:19 [8658] [3] INFO: Connected to bearerbox at 127.0.0.1 port 13001.
2013-01-05 22:38:19 [8658] [3] DEBUG: Started thread 4 (sqlbox.c:bearerbox_to_smsbox)
2013-01-05 22:38:19 [8658] [3] DEBUG: smsbox_to_bearerbox: got boxc_id <smsbox1> from <127.0.0.1>
2013-01-05 22:38:19 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) maps to pid 8658.
2013-01-05 22:38:53 [8658] [3] DEBUG: smsbox_to_bearerbox: sms received
2013-01-05 22:38:53 [8658] [4] INFO: Connection closed by the box <127.0.0.1>
2013-01-05 22:38:53 [8658] [4] DEBUG: bearerbox_to_smsbox: connection to bearerbox died.
2013-01-05 22:38:53 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) terminates.
2013-01-05 22:38:53 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) terminates.
2013-01-05 22:38:53 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates.
2013-01-05 22:39:03 [8658] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) still running
2013-01-05 22:39:03 [8658] [0] DEBUG: Immutable octet strings: 62.


Does anybody know why this is happening or had any success with such setup and could provide any assistance is much appreciated.

Thanks in advance.

Here is my complete setup:

group = core
dlr-storage = internal
admin-port = 13000
admin-password = abcabc
status-password = abcabc
admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1;192.168.1.*"
smsbox-port = 13001
log-level = 0
log-file = "/var/log/kannel/bearerbox.log"
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1;192.168.1.*"

group = smsbox
smsbox-id = smsbox1
bearerbox-host = 127.0.0.1
bearerbox-port = 13003
sendsms-port = 13013
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
access-log = "/var/log/kannel/access.log"

group = sendsms-user
username = abcabc
password = abcabc

group = smsc
smsc = smpp
smsc-id = SMSC1
host = 11111
port = 11111
smsc-username = abcabc
smsc-password = abcabc
address-range = ""
system-type = ""
transceiver-mode = true

group = sms-service
keyword = default
accept-x-kannel-headers = true
max-messages = 100
assume-plain-text = true
catch-all = true

##sqlbox
group = sqlbox
id = sqlbox-db
smsbox-id = smsbox1
#smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = 127.0.0.1
bearerbox-port = 13001
smsbox-port = 13003
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

# Example MYSQL Connection
group = mysql-connection
id = sqlbox-db
host = localhostusername = abcabcpassword = abcabcdatabase = abcabc
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.