sqlbox, smsbox-route and dlr rerouting help!

Alex Kinch Tue, 02 May 2006 10:26:17 -0700

Hi,

Hopefully someone can solve this mystery for me. I'm using sqlbox compiled into cvs-20060424, using MySQL 4.1.18. Incoming messages weren't being routed into sqlbox, so I added:

group = smsbox-route
smsbox-id = smsbox
smsc-ids = "(smsc1);(smsc2)"

(smsc1) and (smsc2) being the names of some SMPP connections. Everything is fine now, however when delivery reports come back in some of them go into sqlbox but appear not to be ack'd by sqlbox - or for some other reason remain in the Kannel store. Anything between 50-200 DLRs make it to sqlbox before it seems to hit a limit and no more come in to the table. None of the DLR entries in sqlbox seem to go any further so the DLR URL is not called either.

I do notice throughout the log the following entries for both (smsc1) and (smsc2) as well:

INFO: DLR rerouting for smsc id (smsc1) disabled

I have been speaking to Rene (Kluwen) and working through this issue with him, but neither of us are really too sure what is going wrong. Maybe Stipe or someone could advise me if these problems may be caused by something to do with lack of DLR rerouting, and if so, how do I enable the rerouting?

Kannel.conf is below. Thanks in advance!

Alex

------

group = core
admin-port = 13000
wapbox-port = 13002
admin-port-ssl = no
smsbox-port = 13001
admin-password = *REMOVED*
status-password = *REMOVED*
admin-deny-ip = *REMOVED*
admin-allow-ip = *REMOVED*
log-file = "/home/kannel/logs/kannel.log"
log-level = 0
box-deny-ip = *REMOVED*
box-allow-ip = *REMOVED*
unified-prefix = "+44,0044,44,0"
store-file = "/home/kannel/logs/kannel.store"
dlr-storage = mysql
wdp-interface-name = "*"

# SQL BOX CONFIG

group = mysql-connection
id = dlr-db
host = localhost
username = *REMOVED*
password = *REMOVED*
database = *REMOVED*
max-connections = 5

group = mysql-connection
id = sqlbox-db
host = localhost
username = *REMOVED*
password = *REMOVED*
database = *REMOVED*
max-connections = 10

group = dlr-db
id = dlr-db
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = "">field-mask = mask
field-status = status
field-boxc-id = boxc

# SQL BOX CONFIG

group = sqlbox
# id corresponds to id in group = mysql-connection.
# this is analogous to id in group = dlr-db
id = sqlbox-db
# smsbox-id indicates the box where SQL-injected messages appear to be coming fr
smsbox-id = sqlbox
# bearerbox host to connect to
bearerbox-host = localhost
# smsbox port to be listening on
smsbox-port = 13005
smsbox-port-ssl = false
# sql-log-table is the table used to log all sent messages
sql-log-table = sent_sms
# sql-insert-table is the table that is monitored for new messages to send
sql-insert-table = send_sms
# global sender: If no sender is specified in sql-insert-table then this
# value is used.
global-sender = 06121
log-file = "/home/kannel/logs/sqlbox.log"
log-level = 0
ssl-client-certkey-file = ""
ssl-server-cert-file = ""
ssl-server-key-file = ""
ssl-trusted-ca-file = ""

# SMSC CONNECTIONS

group = smsc
smsc = smpp
smsc-id = (smsc1)
allowed-smsc-id = (smsc1);(smsc1)_01
host = *REMOVED*
port = *REMOVED*
transceiver-mode = true
system-type = *REMOVED*
interface-version = 33
smsc-username = *REMOVED*
smsc-password = *REMOVED*
source-addr-autodetect = true
dest-addr-ton = 1
dest-addr-npi = 1
msg-id-type = 0x01
alt-charset = HPROMAN8

group = smsc
smsc = smpp
smsc-id = (smsc2)
allowed-smsc-id = (smsc2)
host = *REMOVED*
port = *REMOVED*
interface-version = 34
transceiver-mode = true
system-type = *REMOVED*
smsc-username = *REMOVED*
smsc-password = *REMOVED*
source-addr-ton = 0
source-addr-npi = 0
msg-id-type = 0x01

# SMSBOX SETUP

group = smsbox
bearerbox-host = localhost
# the following is a sqlbox extension!!
bearerbox-is-sqlbox = true
smsbox-id = smsbox
sendsms-port = 13013
sendsms-port-ssl = no
#sendsms-chars = "0123456789 +-"
log-file = "/home/kannel/logs/smsbox.log"
access-log = "/home/kannel/logs/smsbox_access.log"
log-level = 0

# SEND-SMS USERS

group = sendsms-user
username = *REMOVED*
password = *REMOVED*
user-deny-ip = *REMOVED*
user-allow-ip = *REMOVED*

# SERVICES

group = sms-service
keyword = default
get-url = "">catch-all = true
max-messages = 0
accepted-smsc = *REMOVED*

group = sms-service
keyword = stop
get-url = "">max-messages = 0
accepted-smsc = *REMOVED*

group = sms-service
keyword = default
get-url = "">catch-all = true
max-messages = 0
accepted-smsc = (smsc2)

group = smsbox-route
smsbox-id = smsbox
smsc-ids = "(smsc1);(smsc2)"

sqlbox, smsbox-route and dlr rerouting help!

Reply via email to