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

Usually this is due to a version mismatch.

Try to install the same version of smsbox that comes with kannel in the
addons folder.

 

== Rene

 

 

From: [email protected] [mailto:[email protected]] On Behalf
Of cgchen
Sent: zaterdag 5 januari 2013 14:58
To: [email protected]
Subject: debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3

 

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 = localhost

username = abcabc

password = abcabc

database = abcabc