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
