RE: sqlbox, smsbox-route and dlr rerouting help!

[Rene Kluwen]

1. Yes, it differs if you send messages via smsbox or sqlbox

2. I think they changed behaviour bearerbox to require an ACK at the moment that delayed writing was introduced (if I am not mistaken).

 

Rene Kluwen

Chimit

 

-----Original Message-----
From: Alex Kinch [mailto:[EMAIL PROTECTED]
Sent: dinsdag 2 mei 2006 21:20
To: Rene Kluwen
Cc: users@kannel.org
Subject: Re: sqlbox, smsbox-route and dlr rerouting help!

Sorry, my misunderstanding! But I seem to remember being able to run sqlbox on a previous build of Kannel (quite a while back) without any problems. But then I was sending messages via smsbox, not sqlbox.

 

Alex

 

On 5/2/06, Rene Kluwen <[EMAIL PROTECTED]> wrote:

Sorry... let me correct this...

I do know what is going wrong...

sqlbox doesn't do message ack-ing nor DLR requests...

It is a missing feature...

 

So only the messages are acked that are being relayed through smsbox.

 

Rene Kluwen

Chimit

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Kinch
Sent: dinsdag 2 mei 2006 19:26
To: users@kannel.org
Subject: sqlbox, smsbox-route and dlr rerouting help!

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

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)"