SQLBox 0.7.2 not compatible with kannel version cvs-20090706

Hi all,

I have just been testing sqlbox with a modem for monitoring purposes. 
Without the sqlbox (bearerbox-port = 13003 in the smsbox config) it 
works fine. I'd like to get sqlbox working - my first attempt but I'm 
having some problems with msg unpacking...

When I configure sqlbox between smsbox and bearerbox I find the following.

1) Via smsbox HTTP interface

GET 
http://localhost:13013/cgi-bin/sendsms?user=sw&pass=ws&to=xxx&text=usb+modem

It is received fine by smsbox but the sqlbox logs show:

2009-07-10 16:37:21 [6357] [3] ERROR: Packet too short while unpacking Msg.
2009-07-10 16:37:21 [6357] [3] ERROR: Msg packet was invalid.
2009-07-10 16:37:21 [6357] [3] ERROR: Failed to unpack data!

Nothing appears in the sqlbox DB and nothing arrives at bearerbox

2) Drop a MT into the send_sms DB table

insert into send_sms (momt,sender,receiver,msgdata,sms_type) values 
('MT','+64xxxxxxxxx','xxxx', 'Hello, World',2);

The message is sent out fine (forwarded to bearerbox no problem). 
Delivered by modem to short-code.

3) MT's crash sqlbox and smsbox when handed from bearerbox to sqlbox .. 
and message remains in store file.

2009-07-10 16:43:40 [6357] [4] DEBUG: bearerbox_to_smsbox: connection to 
bearerbox died.
2009-07-10 16:43:40 [6357] [4] DEBUG: Thread 4 
(sqlbox.c:bearerbox_to_smsbox) terminates.
2009-07-10 16:43:40 [6357] [3] DEBUG: Thread 3 (sqlbox.c:function) 
terminates.
2009-07-10 16:43:40 [6357] [2] ERROR: Packet too short while unpacking Msg.
2009-07-10 16:43:40 [6357] [2] ERROR: Msg packet was invalid.
2009-07-10 16:43:40 [6357] [2] ERROR: Failed to unpack data!
2009-07-10 16:43:40 [6357] [2] DEBUG: bearerbox_to_sql: connection to 
bearerbox died.
2009-07-10 16:43:40 [6357] [2] DEBUG: Thread 2 
(sqlbox.c:bearerbox_to_sql) terminates.
2009-07-10 16:43:40 [6357] [1] DEBUG: Thread 1 
(sqlbox.c:sql_to_bearerbox) terminates.

Config files attached. Any suggestions welcome.

Cheers,
Alan



I found Jean-Claude's email regarding gw/msg.h .. but I don't follow it.

gw/msg.h
+ line 179: Msg *msg_unpack_wrapper(Octstr *os);

but this appears?

-- 
Alan McNatty, Wellington, New Zealand
Catalyst IT Limited <http://www.catalyst.net.nz/>
DDI: +64 4 8032201

# Core stuff
group = core
admin-port = 13000
admin-password = bar
admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1"
log-file = "/var/log/kannel/bearerbox.log"
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
log-level=0
smsbox-port=13001
dlr-storage=internal
store-type = file
store-location = /var/log/kannel/store

# SMSbox stuff
group = smsbox
bearerbox-host = 127.0.0.1
# for SQLBOX testing
bearerbox-port = 13003
log-file = "/var/log/kannel/smsbox.log"
access-log = "/var/log/kannel/access.log"
global-sender=+64xxxxxxxxx
log-level=0
sendsms-port=13013

# Don't reply - just log
group = sms-service
keyword = default
text = ""
omit-empty = true

group = sendsms-user
username = sw
password = ws

group = smsc
smsc = at
modemtype = sierra
device = /dev/ttyUSB3
log-level = 0
speed=9600
keepalive = 10

group = modems
id = sierra
detect-string = "Sierra Wireless"
detect-string2 = "Model: C885"
name = "Sierra Wireless USB Modem"
init-string = "AT+CNMI=2,1,2,2,0"
reset-string = "ATZ"
message-storage = "SM"
enable-mms=true

group = sqlbox
id = pg-sqlbox
bearerbox-host = localhost
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/sqlbox.log"
log-level = 0
global-sender="+64xxxxxxxxx"

group = pgsql-connection
id = pg-sqlbox
host = localhost
port = 5432
username = foo
password = bar
database = kannel
max-connections = 1