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

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