Did you compiled sqlbox against the new kannel libs? If your sqlbox
was compiled against an older kannel version (e.g. before the meta-
data patch) it could cause such problems.
Regards,
--
Alejandro Guerrieri
[email protected]
On 10/07/2009, at 6:53, Alan McNatty wrote:
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
