Re: SQLBox 0.7.2 not compatible with kannel version cvs-20090706

Thanks Alejandro.

Sorry user issue - I had the bulk standard Ubuntu package installed as 
well... Removed, re-built and now working.

Thanks very much.

Cheers,
Alan

Alejandro Guerrieri wrote:
> 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
> 


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