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 <chriskamutu...@gmail.com> > 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 <r...@mobbis.am> 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 <chriskamutu...@gmail.com> >>>> 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
