Re: Routing DLR to ESME using OpenSMPPBox

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 <[email protected]> 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<smpp1> 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 <[email protected]> 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 <[email protected]> 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<smpp1> 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 = xxxx
>>> 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