RE: SQLBox not compatible with smppbox version cvs 20081222

Please find configuration below:

 

module.d/smppbox.conf

#

# The smppbox configuration.

# Mainly similar to bearerbox core group.

#

# default-smsc defines which smsc-id should be used for all

# MT messages that have no ESME routing applied. You may define

# this to a generic route.

#

group = smppbox

admin-port = 13005

admin-password = xxx

#status-password = xxx

#admin-allow-ip =

#admin-deny-ip =

bearerbox-host = localhost

bearerbox-dcs = utf-8

smppbox-port = 2305

system-id = "KSMSC"

log-file = "/var/log/kannel/smppbox.log"

log-level = 3

access-log = "/var/log/kannel/smpp_access.log"

store-file = "/var/log/kannel/kannel_smppbox.store"

 

 

sqlbox_smpp.conf

 

#MYSQL CONNECTION GROUP

 

group = mysql-connection

id = sqlbox-db

port = 3306

host = localhost

username = xxxx

password = xxxx

database = kannel

max-connections = 1

 

 

group = sqlbox

id = sqlbox-db

smsbox-id = SQLSMSC

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/sqlboxsmpp.log"

log-level = 0

 

 

 

core.conf

 

#CORE GROUP SETUP

 

group = core

admin-port = 13000

smsbox-port = 13001

wapbox-port = 13002

admin-password = xx

wdp-interface-name = "*"

#status-password = xx

#admin-deny-ip = ""

admin-allow-ip = "*.*.*.*"

log-file = "/var/log/kannel/bbox.log"

log-level = 3

#log-level = 0

#box-deny-ip = "*.*.*.*"

#box-allow-ip = 127.0.0.1

box-allow-ip = "127.0.0.1"

access-log = "/var/log/kannel/bearerbox_access.log"

store-file = "/var/log/kannel/rms.store"

include = "/home/rms/config/dlr-mysql.conf"

 

sqlbox.conf

 

#MYSQL CONNECTION GROUP

 

group = mysql-connection

id = sqlbox-db

port = 3306

host = localhost

username = xxxx

password = xxxx

database = kannel

max-connections = 1

 

 

group = sqlbox

id = sqlbox-db

smsbox-id = SQLBOX

bearerbox-host = localhost

bearerbox-port = ""

smsbox-port = 13004

smsbox-port-ssl = false

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = "/var/log/kannel/sqlbox.log"

log-level = 0

 

We’re running on a 32-bit Centos 5 OS.

Regards,

Farida N. Bedwei

 

Senior Software Architect

Rancard Solutions Ltd.

web: www.rancardmobility.com <http://www.rancardmobility.com/> 

mobile: +233.24.425.5654 / +233.207.984.347

office: +233.289.529.573

  _____  

From: Alejandro Guerrieri [mailto:[email protected]] 
Sent: Wednesday, December 24, 2008 10:33 AM
To: Farida N. Bedwei
Cc: [email protected]
Subject: Re: SQLBox not compatible with smppbox version cvs 20081222

 

Please send complete configuration files for the three programs (remove
passwords and outside smsc information if any). I'll try to reproduce the
problem.

 

Regards,

--

Alejandro Guerrieri

[email protected]

 

 

 

El 24/12/2008, a las 9:50, Farida N. Bedwei escribió:





Hi,

 

I pulled from CVS the latest version of SQLBox and kannel and run it with
smppbox version 20081222.  Although all boxes start up correctly, when I
attempt to send a message via smppbox, sqlbox shuts down with the error
below:

 

 

2008-12-23 13:57:11 [307] [7] INFO: Connected to bearerbox at localhost port
13001.

2008-12-23 13:57:11 [307] [7] DEBUG: Started thread 8

(sqlbox.c:bearerbox_to_smsbox)

2008-12-23 13:57:11 [307] [7] DEBUG: smsbox_to_bearerbox: got boxc_id
<KSMSC> from <127.0.0.1>

2008-12-23 13:57:11 [307] [8] DEBUG: Thread 8

(sqlbox.c:bearerbox_to_smsbox) maps to pid 307.

2008-12-23 13:57:19 [307] [7] ERROR: Msg packet was invalid.

2008-12-23 13:57:19 [307] [7] ERROR: Failed to unpack data!

2008-12-23 13:57:20 [307] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
still running

2008-12-23 13:57:20 [307] [0] DEBUG: Thread 7 (sqlbox.c:function) still
running

2008-12-23 13:57:20 [307] [0] DEBUG: Thread 8

(sqlbox.c:bearerbox_to_smsbox) still running

2008-12-23 13:57:20 [307] [0] DEBUG: Immutable octet strings: 54.

 

Is there a patch available which addresses this problem?

 

Regards,

 

 

Farida N. Bedwei

 

Senior Software Architect

Rancard Solutions Ltd.

web: www.rancardmobility.com <http://www.rancardmobility.com/> 

mobile: +233.24.425.5654 / +233.207.984.347

office: +233.289.529.573