Re: Routing DLR to ESME using OpenSMPPBox

[Ruben Melikyan]

Hi,
According to provided log, it seems kannel does not find dlr record to process.
Returning to your configs It will be better to let CORE to handle dlr store and 
update process.
So, i suggest to remove dlr-storage=internal line from opensmppbox config and 
place it to core setup. 
Below is my working configs concerning dlr.

.
* core config
group= core
…….
…….
store-type= file
store-location= “your location here”/STORE
dlr-storage=spool
dlr-spool = “your location here”/DLR
.

Note: you do not need to create STORE and DLR flies in your location. Kannel 
will create them automatically on start.

Best regards,
Ruben Melikyan

> On 9 May 2022, at 05:48, christopher kamutumwa  
> wrote:
> 
> 
> Thank you ruben,
> added that line but still getting below in logs please advise
> 
> 2022-05-09 03:45:12 [20164] [11] INFO: We received an SMS message.
> 2022-05-09 03:45:12 [20164] [11] DEBUG: DLR[mysql]: Looking for DLR 
> smsc=smpp1, ts=a70c7834-3a07-43c0-9749-89cebfeedc85, dst=+260976198318, type=1
> 2022-05-09 03:45:12 [23636] [24] DEBUG: boxc_sender: sent message to 
> <127.0.0.1>
> 2022-05-09 03:45:12 [20164] [11] DEBUG: sql: SELECT `mask`, `service`, `url`, 
> `source`, `destination`, `boxcid` FROM `dlr` WHERE `smsc`=? AND `ts`=?  LIMIT 
> 1
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=mask buffer_type=253 
> max_length=0 length=4
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=service buffer_type=253 
> max_length=0 length=16
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=url buffer_type=253 
> max_length=0 length=2048
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=source buffer_type=253 
> max_length=0 length=32
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=destination buffer_type=253 
> max_length=0 length=32
> 2022-05-09 03:45:12 [20164] [11] DEBUG: column=boxcid buffer_type=253 
> max_length=0 length=16
> 2022-05-09 03:45:12 [20164] [11] WARNING: DLR[mysql]: DLR from SMSC 
> for DST<+260976198318> not found.
> 2022-05-09 03:45:12 [20164] [11] WARNING: msg_to_pdu failed, sending negative 
> ack
> 
>   Virus-free. www.avg.com
> 
>> On Sun, May 8, 2022 at 12:03 PM Ruben Melikyan  wrote:
>> Try to set in smsc config the following line:
>> reroute-dlr=true
>> 
>> Best regards,
>> Ruben Melikyan
>> 
 On 8 May 2022, at 10:32, christopher kamutumwa  
 wrote:
 
>>> 
>>> I have configured my servers to send from ESME to SMSC through OpenSMPPBox,
>>> i have applied the below flow
>>> ESME -->> OpenSMPPBox -->> SQLBox -->>Bearerbox -->> SMSC
>>> I have succeeded in sending the sms from ESME to the SMSC but my problem is
>>> related to the DLR.
>>> The Bearerbox actually received the DLR from the SMSC but it didn't route
>>> it to the ESME.
>>> 
>>> What is the required configurations that could resolve the above issue. i
>>> need to route the DLR to the ESME
>>> 
>>> Your help in this regard is highly appreciated and thanks in advance.i can 
>>> see entries in db when i send msg
>>> 
>>> Below are my config files and log error,
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: DLR[mysql]: Looking for DLR 
>>> smsc=smpp1, ts=1a11039a-901d-43e3-8f99-1b42fa14aacb, dst=+260976198318, 
>>> type=1
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: sql: SELECT `mask`, `service`, `url`, 
>>> `source`, `destination`, `boxcid` FROM `dlr` WHERE `smsc`=? AND `ts`=?  
>>> LIMIT 1
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=mask buffer_type=253 
>>> max_length=0 length=4
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=service buffer_type=253 
>>> max_length=0 length=16
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=url buffer_type=253 
>>> max_length=0 length=2048
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=source buffer_type=253 
>>> max_length=0 length=32
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=destination buffer_type=253 
>>> max_length=0 length=32
>>> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=boxcid buffer_type=253 
>>> max_length=0 length=16
>>> 2022-05-07 14:36:47 [3023] [7] WARNING: DLR[mysql]: DLR from SMSC 
>>> for DST<+260976198318> not found.
>>> 2022-05-07 14:36:47 [3023] [7] WARNING: msg_to_pdu failed, sending negative 
>>> ack
>>> *** Kannel.conf 
>>> #-
>>> # core setup
>>> 
>>> group = core
>>> admin-port = 13000
>>> smsbox-port = 13001
>>> wapbox-port = 13002
>>> admin-password = admin123
>>> status-password = status123
>>> wdp-interface-name = "*"
>>> log-file = "/usr/local/kannel/bearerbox.log"
>>> log-level = 3
>>> access-log = "/usr/local/kannel/bearerboxaccess.log"
>>> store-type = spool
>>> store-location = "/usr/local/kannel/store"
>>> store-dump-freq = 60
>>> #-
>>> # smsc setup
>>> 
>>> group = smsc
>>> smsc = smpp
>>> smsc-id = VFSMPP1
>>> host = "x.x.x.x"
>>> port = 
>>> smsc-username = egypt321
>>> smsc-password = egypt321
>>> system-type = "egypt321"
>>> address-range = ""
>>> dest-addr-ton=1
>>> dest-addr-npi=1
>>> 

Re: Routing DLR to ESME using OpenSMPPBox

[christopher kamutumwa]

Thank you ruben,
added that line but still getting below in logs please advise

2022-05-09 03:45:12 [20164] [11] INFO: We received an SMS message.
2022-05-09 03:45:12 [20164] [11] DEBUG: DLR[mysql]: Looking for DLR
smsc=smpp1, ts=a70c7834-3a07-43c0-9749-89cebfeedc85, dst=+260976198318,
type=1
2022-05-09 03:45:12 [23636] [24] DEBUG: boxc_sender: sent message to
<127.0.0.1>
2022-05-09 03:45:12 [20164] [11] DEBUG: sql: SELECT `mask`, `service`,
`url`, `source`, `destination`, `boxcid` FROM `dlr` WHERE `smsc`=? AND
`ts`=?  LIMIT 1
2022-05-09 03:45:12 [20164] [11] DEBUG: column=mask buffer_type=253
max_length=0 length=4
2022-05-09 03:45:12 [20164] [11] DEBUG: column=service buffer_type=253
max_length=0 length=16
2022-05-09 03:45:12 [20164] [11] DEBUG: column=url buffer_type=253
max_length=0 length=2048
2022-05-09 03:45:12 [20164] [11] DEBUG: column=source buffer_type=253
max_length=0 length=32
2022-05-09 03:45:12 [20164] [11] DEBUG: column=destination buffer_type=253
max_length=0 length=32
2022-05-09 03:45:12 [20164] [11] DEBUG: column=boxcid buffer_type=253
max_length=0 length=16
2022-05-09 03:45:12 [20164] [11] WARNING: DLR[mysql]: DLR from SMSC
for DST<+260976198318> not found.
2022-05-09 03:45:12 [20164] [11] WARNING: msg_to_pdu failed, sending
negative ack


Virus-free.
www.avg.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, May 8, 2022 at 12:03 PM Ruben Melikyan  wrote:

> Try to set in smsc config the following line:
> reroute-dlr=true
>
> Best regards,
> Ruben Melikyan
>
> On 8 May 2022, at 10:32, christopher kamutumwa 
> wrote:
>
> 
>
> I have configured my servers to send from ESME to SMSC through OpenSMPPBox,
> i have applied the below flow
> ESME -->> OpenSMPPBox -->> SQLBox -->>Bearerbox -->> SMSC
>
> I have succeeded in sending the sms from ESME to the SMSC but my problem is
> related to the DLR.
> The Bearerbox actually received the DLR from the SMSC but it didn't route
> it to the ESME.
>
> What is the required configurations that could resolve the above issue. i
> need to route the DLR to the ESME
>
> Your help in this regard is highly appreciated and thanks in advance.i can 
> see entries in db when i send msg
>
> Below are my config files and log error,
> 2022-05-07 14:36:47 [3023] [7] DEBUG: DLR[mysql]: Looking for DLR smsc=smpp1, 
> ts=1a11039a-901d-43e3-8f99-1b42fa14aacb, dst=+260976198318, type=1
> 2022-05-07 14:36:47 [3023] [7] DEBUG: sql: SELECT `mask`, `service`, `url`, 
> `source`, `destination`, `boxcid` FROM `dlr` WHERE `smsc`=? AND `ts`=?  LIMIT 
> 1
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=mask buffer_type=253 
> max_length=0 length=4
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=service buffer_type=253 
> max_length=0 length=16
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=url buffer_type=253 max_length=0 
> length=2048
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=source buffer_type=253 
> max_length=0 length=32
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=destination buffer_type=253 
> max_length=0 length=32
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=boxcid buffer_type=253 
> max_length=0 length=16
> 2022-05-07 14:36:47 [3023] [7] WARNING: DLR[mysql]: DLR from SMSC for 
> DST<+260976198318> not found.
> 2022-05-07 14:36:47 [3023] [7] WARNING: msg_to_pdu failed, sending negative 
> ack
>
> *** Kannel.conf 
> #-
> # core setup
>
> group = core
> admin-port = 13000
> smsbox-port = 13001
> wapbox-port = 13002
> admin-password = admin123
> status-password = status123
> wdp-interface-name = "*"
> log-file = "/usr/local/kannel/bearerbox.log"
> log-level = 3
> access-log = "/usr/local/kannel/bearerboxaccess.log"
> store-type = spool
> store-location = "/usr/local/kannel/store"
> store-dump-freq = 60
> #-
> # smsc setup
>
> group = smsc
> smsc = smpp
> smsc-id = VFSMPP1
> host = "x.x.x.x"
> port = 
> smsc-username = egypt321
> smsc-password = egypt321
> system-type = "egypt321"
> address-range = ""
> dest-addr-ton=1
> dest-addr-npi=1
> interface-version = 34
> enquire-link-interval = 25
> reconnect-delay = 15
> transceiver-mode = 1
> #max-pending-submits = 8
> throughput = 6
> #-
> # smsbox setup
>
> group = smsbox
> smsbox-id = smsbox1
> bearerbox-host = "127.0.0.1"
> sendsms-port = 13013
> sendsms-chars = "0123456789 +-"
> log-file = "/usr/local/kannel/smsbox.log"
> log-level = 3
> access-log = "/usr/local/kannel/smsboxaccess.log"
> mo-recode = true
> http-request-retry = 1000
> max-pending-requests = 33000
> #-
> # smsbox-route setup
>
> group = smsbox-route
> smsbox-id = smsc1
> smsc-id = VFSMPP1
> ###
>
> 

Re: Routing DLR to ESME using OpenSMPPBox

[Ruben Melikyan]

Try to set in smsc config the following line:
reroute-dlr=true

Best regards,
Ruben Melikyan

> On 8 May 2022, at 10:32, christopher kamutumwa  
> wrote:
> 
> 
> I have configured my servers to send from ESME to SMSC through OpenSMPPBox,
> i have applied the below flow
> ESME -->> OpenSMPPBox -->> SQLBox -->>Bearerbox -->> SMSC
> I have succeeded in sending the sms from ESME to the SMSC but my problem is
> related to the DLR.
> The Bearerbox actually received the DLR from the SMSC but it didn't route
> it to the ESME.
> 
> What is the required configurations that could resolve the above issue. i
> need to route the DLR to the ESME
> 
> Your help in this regard is highly appreciated and thanks in advance.i can 
> see entries in db when i send msg
> 
> Below are my config files and log error,
> 2022-05-07 14:36:47 [3023] [7] DEBUG: DLR[mysql]: Looking for DLR smsc=smpp1, 
> ts=1a11039a-901d-43e3-8f99-1b42fa14aacb, dst=+260976198318, type=1
> 2022-05-07 14:36:47 [3023] [7] DEBUG: sql: SELECT `mask`, `service`, `url`, 
> `source`, `destination`, `boxcid` FROM `dlr` WHERE `smsc`=? AND `ts`=?  LIMIT 
> 1
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=mask buffer_type=253 
> max_length=0 length=4
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=service buffer_type=253 
> max_length=0 length=16
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=url buffer_type=253 max_length=0 
> length=2048
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=source buffer_type=253 
> max_length=0 length=32
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=destination buffer_type=253 
> max_length=0 length=32
> 2022-05-07 14:36:47 [3023] [7] DEBUG: column=boxcid buffer_type=253 
> max_length=0 length=16
> 2022-05-07 14:36:47 [3023] [7] WARNING: DLR[mysql]: DLR from SMSC for 
> DST<+260976198318> not found.
> 2022-05-07 14:36:47 [3023] [7] WARNING: msg_to_pdu failed, sending negative 
> ack
> *** Kannel.conf 
> #-
> # core setup
> 
> group = core
> admin-port = 13000
> smsbox-port = 13001
> wapbox-port = 13002
> admin-password = admin123
> status-password = status123
> wdp-interface-name = "*"
> log-file = "/usr/local/kannel/bearerbox.log"
> log-level = 3
> access-log = "/usr/local/kannel/bearerboxaccess.log"
> store-type = spool
> store-location = "/usr/local/kannel/store"
> store-dump-freq = 60
> #-
> # smsc setup
> 
> group = smsc
> smsc = smpp
> smsc-id = VFSMPP1
> host = "x.x.x.x"
> port = 
> smsc-username = egypt321
> smsc-password = egypt321
> system-type = "egypt321"
> address-range = ""
> dest-addr-ton=1
> dest-addr-npi=1
> interface-version = 34
> enquire-link-interval = 25
> reconnect-delay = 15
> transceiver-mode = 1
> #max-pending-submits = 8
> throughput = 6
> #-
> # smsbox setup
> 
> group = smsbox
> smsbox-id = smsbox1
> bearerbox-host = "127.0.0.1"
> sendsms-port = 13013
> sendsms-chars = "0123456789 +-"
> log-file = "/usr/local/kannel/smsbox.log"
> log-level = 3
> access-log = "/usr/local/kannel/smsboxaccess.log"
> mo-recode = true
> http-request-retry = 1000
> max-pending-requests = 33000
> #-
> # smsbox-route setup
> 
> group = smsbox-route
> smsbox-id = smsc1
> smsc-id = VFSMPP1
> ###
> 
> *** OpenSMPPBox.conf **
> group = core
> dlr-storage = internal
> 
> group = opensmppbox
> bearerbox-host = 127.0.0.1
> bearerbox-port = 13005
> opensmppbox-id = opensmppbox1
> opensmppbox-port = 13003
> log-file = "/usr/local/kannel/smppbox.log"
> #log-level = 3
> our-system-id = Inaccess
> #route-to-smsc = cardboard
> smpp-logins = /usr/local/kannel/smpplogins.txt
> ###
> 
> *** smpplogins.txt***
> test testpw smsc1 *.*.*.*
> ###
> 
> *** SQLBox.conf ***
> group = sqlbox
> id = sqlbox-db
> smsbox-id = sqlbox
> global-sender = ""
> bearerbox-host = 127.0.0.1
> bearerbox-port = 13001
> smsbox-port = 13005
> smsbox-port-ssl = false
> sql-log-table = sent_sms
> sql-insert-table = send_sms
> log-file = "/usr/local/kannel/kannel-sqlbox.log"
> 
> # MYSQL Connection
> group = mysql-connection
> id = sqlbox-db
> host = localhost
> username = root
> password = root
> database = mysqlbox
> ###
> 
> 
> 
> Regards,
> 
>   Virus-free. www.avg.com

RE: Routing DLR to ESME using OpenSMPPBox

[Rene Kluwen]

It should route automatically.

Could you share your logs?

 

From: users [mailto:users-boun...@kannel.org] On Behalf Of Amir Mahmoud
Sent: maandag 28 oktober 2013 20:38
To: users
Subject: Routing DLR to ESME using OpenSMPPBox

 

Dears,

 

I have configured my servers to send from ESME to SMSC through OpenSMPPBox,
i have applied the below flow

ESME -- OpenSMPPBox -- SQLBox --Bearerbox -- SMSC

 

I have succeeded in sending the sms from ESME to the SMSC but my problem is
related to the DLR.

The Bearerbox actually received the DLR from the SMSC but it didn't route it
to the ESME.

 

What is the required configurations that could resolve the above issue. i
need to route the DLR to the ESME

 

Your help in this regard is highly appreciated and thanks in advance.

 

Below are my config files,

 

*** Kannel.conf 

#-

# core setup

 

group = core

admin-port = 13000

smsbox-port = 13001

wapbox-port = 13002

admin-password = admin123

status-password = status123

wdp-interface-name = *

log-file = /usr/local/kannel/bearerbox.log

log-level = 3

access-log = /usr/local/kannel/bearerboxaccess.log

store-type = spool

store-location = /usr/local/kannel/store

store-dump-freq = 60

#-

# smsc setup

 

group = smsc

smsc = smpp

smsc-id = VFSMPP1

host = x.x.x.x

port = 

smsc-username = egypt321

smsc-password = egypt321

system-type = egypt321

address-range = 

dest-addr-ton=1

dest-addr-npi=1

interface-version = 34

enquire-link-interval = 25

reconnect-delay = 15

transceiver-mode = 1

#max-pending-submits = 8

throughput = 6

#-

# smsbox setup

 

group = smsbox

smsbox-id = smsbox1

bearerbox-host = 127.0.0.1

sendsms-port = 13013

sendsms-chars = 0123456789 +-

log-file = /usr/local/kannel/smsbox.log

log-level = 3

access-log = /usr/local/kannel/smsboxaccess.log

mo-recode = true

http-request-retry = 1000

max-pending-requests = 33000

#-

# smsbox-route setup

 

group = smsbox-route

smsbox-id = smsc1

smsc-id = VFSMPP1

###

 

*** OpenSMPPBox.conf **

group = core

dlr-storage = internal

 

group = opensmppbox

bearerbox-host = 127.0.0.1

bearerbox-port = 13005

opensmppbox-id = opensmppbox1

opensmppbox-port = 13003

log-file = /usr/local/kannel/smppbox.log

#log-level = 3

our-system-id = Inaccess

#route-to-smsc = cardboard

smpp-logins = /usr/local/kannel/smpplogins.txt

###

 

*** smpplogins.txt***

test testpw smsc1 *.*.*.*

###

 

*** SQLBox.conf ***

group = sqlbox

id = sqlbox-db

smsbox-id = sqlbox

global-sender = 

bearerbox-host = 127.0.0.1

bearerbox-port = 13001

smsbox-port = 13005

smsbox-port-ssl = false

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = /usr/local/kannel/kannel-sqlbox.log

 

# MYSQL Connection

group = mysql-connection

id = sqlbox-db

host = localhost

username = root

password = root

database = mysqlbox

###

 

 

 

Regards,

Amir

Re: Routing DLR to ESME using OpenSMPPBox

[Amir Mahmoud]

Hello Rene,
Thanks a lot for you reply.

below is my configuration files followed by sample of the logs, please let
me know for any further details.

*Configuration Files*

*1)**Kannel.conf*

#-

# core setup



group = core

admin-port = 13000

smsbox-port = 13001

wapbox-port = 13002

admin-password = admin123456

status-password = admin123456

wdp-interface-name = *

log-file = /usr/local/kannel/bearerbox.log

log-level = 3

access-log = /usr/local/kannel/bearerboxaccess.log

store-type = spool

store-location = /usr/local/kannel/store

store-dump-freq = 60

#-

# smsc setup



group = smsc

smsc = smpp

smsc-id = VFSMPP1

host = x.x.x.x

port = 

smsc-username = 

smsc-password = xxx

system-type = 

address-range = 

dest-addr-ton=1

dest-addr-npi=1

interface-version = 34

enquire-link-interval = 25

reconnect-delay = 15

transceiver-mode = 1

#max-pending-submits = 8

throughput = 6

#-

# smsbox setup



group = smsbox

smsbox-id = smsbox1

bearerbox-host = 127.0.0.1

sendsms-port = 13013

sendsms-chars = 0123456789 +-

log-file = /usr/local/kannel/smsbox.log

log-level = 3

access-log = /usr/local/kannel/smsboxaccess.log

mo-recode = true

http-request-retry = 1000

max-pending-requests = 33000

#-

# smsbox-route setup



group = smsbox-route

smsbox-id = ops

smsc-id = VFSMPP1







*2)**OpenSMPPBox.conf*

#--

group = core

dlr-storage = mysql



group = opensmppbox

bearerbox-host = 127.0.0.1

bearerbox-port = 13005

opensmppbox-id = opensmppbox1

opensmppbox-port = 13003

log-file = /usr/local/kannel/smppbox.log

our-system-id = opensmppbox1

use-systemid-as-smsboxid = true

smpp-logins = /usr/local/kannel/smpplogins.txt

box-dlr-storage = mysql



group = mysql-connection
id = mydlr
host = localhost
username = 
password = 
database = kannel
max-connections = 2

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







*3)**smpplogins.txt*

ops testpw smsc1 *.*.*.*







*4)**SQLBox.conf*

#--

group = sqlbox

id = sqlbox-db

smsbox-id = sqlbox

global-sender = 

bearerbox-host = 127.0.0.1

bearerbox-port = 13001

smsbox-port = 13005

smsbox-port-ssl = false

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = /usr/local/kannel/kannel-sqlbox.log



# MYSQL Connection

group = mysql-connection

id = sqlbox-db

host = localhost

username = 

password = 

database = mysqlbox


Error Log Sample



2013-10-29 17:59:02 [29615] [1] DEBUG: DLR[mysql]: Looking for DLR
smsc=ops, ts=be18a733, dst=201068827073, type=1
2013-10-29 17:59:02 [29615] [1] DEBUG: sql: SELECT `mask`, `service`,
`url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND
`ts`=?  LIMIT 1
2013-10-29 17:59:02 [29615] [1] DEBUG: column=mask buffer_type=3
max_length=0 length=10
2013-10-29 17:59:02 [29615] [1] DEBUG: column=service buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=url buffer_type=253
max_length=0 length=255
2013-10-29 17:59:02 [29615] [1] DEBUG: column=source buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=destination
buffer_type=253 max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=boxc buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] WARNING: DLR[mysql]: DLR from
SMSCops for DST201068827073 not found.
2013-10-29 17:59:02 [29615] [1] WARNING: opensmppbox: msg_to_pdu: no
msg corresponding dlr, ignoring
2013-10-29 17:59:02 [29615] [1] WARNING: msg_to_pdu failed, sending
negative ack


On Tue, Nov 12, 2013 at 4:08 PM, Rene Kluwen rene.klu...@chimit.nl wrote:

 It should route automatically.

 Could you share your logs?



 *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *Amir
 Mahmoud
 *Sent:* maandag 28 oktober 2013 20:38
 *To:* users
 *Subject:* Routing DLR to ESME using OpenSMPPBox



 Dears,



 I have configured my servers to send from ESME to SMSC through
 OpenSMPPBox, i have applied the below flow

 ESME -- OpenSMPPBox -- SQLBox --Bearerbox -- SMSC



 I have succeeded in sending the sms from ESME to the SMSC but my problem
 is related to the DLR.

 The Bearerbox actually received the DLR from the SMSC but it didn't route
 it to the ESME.



 What is the required configurations that could resolve the above issue. i
 need to route the DLR to the ESME



 Your help in this regard is highly appreciated and thanks in advance.



 Below are my config files,



 *** Kannel.conf 

 #-

 # core setup



 group 

RE: Routing DLR to ESME using OpenSMPPBox

[Rene Kluwen]

Are there even any entries in your dlr table? They should have accumulated
by now.

What is the sql type of your ts and destination field? Is it at least 12
characters or more?

 

== Rene

 

 

From: Amir Mahmoud [mailto:amir.mahm...@egyptlinx.com] 
Sent: dinsdag 12 november 2013 17:25
To: Rene Kluwen
Cc: users
Subject: Re: Routing DLR to ESME using OpenSMPPBox

 

Hello Rene,

Thanks a lot for you reply.

 

below is my configuration files followed by sample of the logs, please let
me know for any further details.

 

Configuration Files

1)Kannel.conf

#-

# core setup

 

group = core

admin-port = 13000

smsbox-port = 13001

wapbox-port = 13002

admin-password = admin123456

status-password = admin123456

wdp-interface-name = *

log-file = /usr/local/kannel/bearerbox.log

log-level = 3

access-log = /usr/local/kannel/bearerboxaccess.log

store-type = spool

store-location = /usr/local/kannel/store

store-dump-freq = 60

#-

# smsc setup

 

group = smsc

smsc = smpp

smsc-id = VFSMPP1

host = x.x.x.x

port = 

smsc-username = 

smsc-password = xxx

system-type = 

address-range = 

dest-addr-ton=1

dest-addr-npi=1

interface-version = 34

enquire-link-interval = 25

reconnect-delay = 15

transceiver-mode = 1

#max-pending-submits = 8

throughput = 6

#-

# smsbox setup

 

group = smsbox

smsbox-id = smsbox1

bearerbox-host = 127.0.0.1

sendsms-port = 13013

sendsms-chars = 0123456789 +-

log-file = /usr/local/kannel/smsbox.log

log-level = 3

access-log = /usr/local/kannel/smsboxaccess.log

mo-recode = true

http-request-retry = 1000

max-pending-requests = 33000

#-

# smsbox-route setup

 

group = smsbox-route

smsbox-id = ops

smsc-id = VFSMPP1

 

 

 

2)OpenSMPPBox.conf

#--

group = core

dlr-storage = mysql

 

group = opensmppbox

bearerbox-host = 127.0.0.1

bearerbox-port = 13005

opensmppbox-id = opensmppbox1

opensmppbox-port = 13003

log-file = /usr/local/kannel/smppbox.log

our-system-id = opensmppbox1

use-systemid-as-smsboxid = true

smpp-logins = /usr/local/kannel/smpplogins.txt

box-dlr-storage = mysql

 

group = mysql-connection
id = mydlr
host = localhost
username = 
password = 
database = kannel
max-connections = 2

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

 

 

 

3)smpplogins.txt

ops testpw smsc1 *.*.*.*

 

 

 

4)SQLBox.conf

#--

group = sqlbox

id = sqlbox-db

smsbox-id = sqlbox

global-sender = 

bearerbox-host = 127.0.0.1

bearerbox-port = 13001

smsbox-port = 13005

smsbox-port-ssl = false

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = /usr/local/kannel/kannel-sqlbox.log

 

# MYSQL Connection

group = mysql-connection

id = sqlbox-db

host = localhost

username = 

password = 

database = mysqlbox

 

Error Log Sample

 

2013-10-29 17:59:02 [29615] [1] DEBUG: DLR[mysql]: Looking for DLR
smsc=ops, ts=be18a733, dst=201068827073, type=1
2013-10-29 17:59:02 [29615] [1] DEBUG: sql: SELECT `mask`, `service`,
`url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND
`ts`=?  LIMIT 1
2013-10-29 17:59:02 [29615] [1] DEBUG: column=mask buffer_type=3
max_length=0 length=10
2013-10-29 17:59:02 [29615] [1] DEBUG: column=service buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=url buffer_type=253
max_length=0 length=255
2013-10-29 17:59:02 [29615] [1] DEBUG: column=source buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=destination
buffer_type=253 max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] DEBUG: column=boxc buffer_type=253
max_length=0 length=40
2013-10-29 17:59:02 [29615] [1] WARNING: DLR[mysql]: DLR from
SMSCops for DST201068827073 not found.
2013-10-29 17:59:02 [29615] [1] WARNING: opensmppbox: msg_to_pdu: no
msg corresponding dlr, ignoring
2013-10-29 17:59:02 [29615] [1] WARNING: msg_to_pdu failed, sending negative
ack

 

On Tue, Nov 12, 2013 at 4:08 PM, Rene Kluwen rene.klu...@chimit.nl wrote:

It should route automatically.

Could you share your logs?

 

From: users [mailto:users-boun...@kannel.org] On Behalf Of Amir Mahmoud
Sent: maandag 28 oktober 2013 20:38
To: users
Subject: Routing DLR to ESME using OpenSMPPBox

 

Dears,

 

I have configured my servers to send from ESME to SMSC through OpenSMPPBox,
i have applied the below flow

ESME -- OpenSMPPBox -- SQLBox --Bearerbox -- SMSC

 

I have succeeded in sending the sms from ESME to the SMSC but my problem is
related to the DLR.

The Bearerbox actually received the DLR from the SMSC but it didn't route

Re: Routing DLR to ESME using OpenSMPPBox

[Amir Mahmoud]

The table is empty, and the type of both ts and destination columns is
varchar(40)


On Tue, Nov 12, 2013 at 6:34 PM, Rene Kluwen rene.klu...@chimit.nl wrote:

 Are there even any entries in your dlr table? They should have accumulated
 by now.

 What is the sql type of your ts and destination field? Is it at least 12
 characters or more?



 == Rene





 *From:* Amir Mahmoud [mailto:amir.mahm...@egyptlinx.com]
 *Sent:* dinsdag 12 november 2013 17:25
 *To:* Rene Kluwen
 *Cc:* users
 *Subject:* Re: Routing DLR to ESME using OpenSMPPBox



 Hello Rene,

 Thanks a lot for you reply.



 below is my configuration files followed by sample of the logs, please let
 me know for any further details.



 *Configuration Files*

 *1)**Kannel.conf*

 #-

 # core setup



 group = core

 admin-port = 13000

 smsbox-port = 13001

 wapbox-port = 13002

 admin-password = admin123456

 status-password = admin123456

 wdp-interface-name = *

 log-file = /usr/local/kannel/bearerbox.log

 log-level = 3

 access-log = /usr/local/kannel/bearerboxaccess.log

 store-type = spool

 store-location = /usr/local/kannel/store

 store-dump-freq = 60

 #-

 # smsc setup



 group = smsc

 smsc = smpp

 smsc-id = VFSMPP1

 host = x.x.x.x

 port = 

 smsc-username = 

 smsc-password = xxx

 system-type = 

 address-range = 

 dest-addr-ton=1

 dest-addr-npi=1

 interface-version = 34

 enquire-link-interval = 25

 reconnect-delay = 15

 transceiver-mode = 1

 #max-pending-submits = 8

 throughput = 6

 #-

 # smsbox setup



 group = smsbox

 smsbox-id = smsbox1

 bearerbox-host = 127.0.0.1

 sendsms-port = 13013

 sendsms-chars = 0123456789 +-

 log-file = /usr/local/kannel/smsbox.log

 log-level = 3

 access-log = /usr/local/kannel/smsboxaccess.log

 mo-recode = true

 http-request-retry = 1000

 max-pending-requests = 33000

 #-

 # smsbox-route setup



 group = smsbox-route

 smsbox-id = ops

 smsc-id = VFSMPP1







 *2)**OpenSMPPBox.conf*

 #--

 group = core

 dlr-storage = mysql



 group = opensmppbox

 bearerbox-host = 127.0.0.1

 bearerbox-port = 13005

 opensmppbox-id = opensmppbox1

 opensmppbox-port = 13003

 log-file = /usr/local/kannel/smppbox.log

 our-system-id = opensmppbox1

 use-systemid-as-smsboxid = true

 smpp-logins = /usr/local/kannel/smpplogins.txt

 box-dlr-storage = mysql



 group = mysql-connection
 id = mydlr
 host = localhost
 username = 
 password = 
 database = kannel
 max-connections = 2

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







 *3)**smpplogins.txt*

 ops testpw smsc1 *.*.*.*







 *4)**SQLBox.conf*

 #--

 group = sqlbox

 id = sqlbox-db

 smsbox-id = sqlbox

 global-sender = 

 bearerbox-host = 127.0.0.1

 bearerbox-port = 13001

 smsbox-port = 13005

 smsbox-port-ssl = false

 sql-log-table = sent_sms

 sql-insert-table = send_sms

 log-file = /usr/local/kannel/kannel-sqlbox.log



 # MYSQL Connection

 group = mysql-connection

 id = sqlbox-db

 host = localhost

 username = 

 password = 

 database = mysqlbox



 Error Log Sample



 2013-10-29 17:59:02 [29615] [1] DEBUG: DLR[mysql]: Looking for DLR
 smsc=ops, ts=be18a733, dst=201068827073, type=1
 2013-10-29 17:59:02 [29615] [1] DEBUG: sql: SELECT `mask`, `service`,
 `url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND
 `ts`=?  LIMIT 1
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=mask buffer_type=3
 max_length=0 length=10
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=service buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=url buffer_type=253
 max_length=0 length=255
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=source buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=destination
 buffer_type=253 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=boxc buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] WARNING: DLR[mysql]: DLR from
 SMSCops for DST201068827073 not found.
 2013-10-29 17:59:02 [29615] [1] WARNING: opensmppbox: msg_to_pdu: no
 msg corresponding dlr, ignoring
 2013-10-29 17:59:02 [29615] [1] WARNING: msg_to_pdu failed, sending
 negative ack



 On Tue, Nov 12, 2013 at 4:08 PM, Rene Kluwen rene.klu...@chimit.nl
 wrote:

 It should route automatically.

 Could you share your logs?



 *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *Amir
 Mahmoud
 *Sent:* maandag 28 oktober 2013 20:38
 *To:* users
 *Subject:* Routing DLR to ESME using OpenSMPPBox



 Dears,



 I have

Re: Routing DLR to ESME using OpenSMPPBox

[Amir Mahmoud]

No i don't, how could i troubleshoot the dlr record insertion to know
whether the problem is related to the insertion or not ?



On Tue, Nov 12, 2013 at 7:58 PM, Rene Kluwen rene.klu...@chimit.nl wrote:

 Then the problem seems to be whilst inserting the messages into the dlr
 table.

 Do you have a log entry of that as well?



 *From:* Amir Mahmoud [mailto:amir.mahm...@egyptlinx.com]
 *Sent:* dinsdag 12 november 2013 18:13

 *To:* Rene Kluwen
 *Cc:* users
 *Subject:* Re: Routing DLR to ESME using OpenSMPPBox



 The table is empty, and the type of both ts and destination columns is
 varchar(40)



 On Tue, Nov 12, 2013 at 6:34 PM, Rene Kluwen rene.klu...@chimit.nl
 wrote:

 Are there even any entries in your dlr table? They should have accumulated
 by now.

 What is the sql type of your ts and destination field? Is it at least 12
 characters or more?



 == Rene





 *From:* Amir Mahmoud [mailto:amir.mahm...@egyptlinx.com]
 *Sent:* dinsdag 12 november 2013 17:25
 *To:* Rene Kluwen
 *Cc:* users
 *Subject:* Re: Routing DLR to ESME using OpenSMPPBox



 Hello Rene,

 Thanks a lot for you reply.



 below is my configuration files followed by sample of the logs, please let
 me know for any further details.



 *Configuration Files*

 *1)**Kannel.conf*

 #-

 # core setup



 group = core

 admin-port = 13000

 smsbox-port = 13001

 wapbox-port = 13002

 admin-password = admin123456

 status-password = admin123456

 wdp-interface-name = *

 log-file = /usr/local/kannel/bearerbox.log

 log-level = 3

 access-log = /usr/local/kannel/bearerboxaccess.log

 store-type = spool

 store-location = /usr/local/kannel/store

 store-dump-freq = 60

 #-

 # smsc setup



 group = smsc

 smsc = smpp

 smsc-id = VFSMPP1

 host = x.x.x.x

 port = 

 smsc-username = 

 smsc-password = xxx

 system-type = 

 address-range = 

 dest-addr-ton=1

 dest-addr-npi=1

 interface-version = 34

 enquire-link-interval = 25

 reconnect-delay = 15

 transceiver-mode = 1

 #max-pending-submits = 8

 throughput = 6

 #-

 # smsbox setup



 group = smsbox

 smsbox-id = smsbox1

 bearerbox-host = 127.0.0.1

 sendsms-port = 13013

 sendsms-chars = 0123456789 +-

 log-file = /usr/local/kannel/smsbox.log

 log-level = 3

 access-log = /usr/local/kannel/smsboxaccess.log

 mo-recode = true

 http-request-retry = 1000

 max-pending-requests = 33000

 #-

 # smsbox-route setup



 group = smsbox-route

 smsbox-id = ops

 smsc-id = VFSMPP1







 *2)**OpenSMPPBox.conf*

 #--

 group = core

 dlr-storage = mysql



 group = opensmppbox

 bearerbox-host = 127.0.0.1

 bearerbox-port = 13005

 opensmppbox-id = opensmppbox1

 opensmppbox-port = 13003

 log-file = /usr/local/kannel/smppbox.log

 our-system-id = opensmppbox1

 use-systemid-as-smsboxid = true

 smpp-logins = /usr/local/kannel/smpplogins.txt

 box-dlr-storage = mysql



 group = mysql-connection
 id = mydlr
 host = localhost
 username = 
 password = 
 database = kannel
 max-connections = 2

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







 *3)**smpplogins.txt*

 ops testpw smsc1 *.*.*.*







 *4)**SQLBox.conf*

 #--

 group = sqlbox

 id = sqlbox-db

 smsbox-id = sqlbox

 global-sender = 

 bearerbox-host = 127.0.0.1

 bearerbox-port = 13001

 smsbox-port = 13005

 smsbox-port-ssl = false

 sql-log-table = sent_sms

 sql-insert-table = send_sms

 log-file = /usr/local/kannel/kannel-sqlbox.log



 # MYSQL Connection

 group = mysql-connection

 id = sqlbox-db

 host = localhost

 username = 

 password = 

 database = mysqlbox



 Error Log Sample



 2013-10-29 17:59:02 [29615] [1] DEBUG: DLR[mysql]: Looking for DLR
 smsc=ops, ts=be18a733, dst=201068827073, type=1
 2013-10-29 17:59:02 [29615] [1] DEBUG: sql: SELECT `mask`, `service`,
 `url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND
 `ts`=?  LIMIT 1
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=mask buffer_type=3
 max_length=0 length=10
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=service buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=url buffer_type=253
 max_length=0 length=255
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=source buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=destination
 buffer_type=253 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] DEBUG: column=boxc buffer_type=253
 max_length=0 length=40
 2013-10-29 17:59:02 [29615] [1] WARNING: DLR[mysql]: DLR from
 SMSCops for DST201068827073 not found.
 2013