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 = xxxx smsc-username = xxxx smsc-password = xxx system-type = "xxxx" 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 = xxxx password = xxxx 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 = xxxx password = xxxx 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 SMSC<ops> for DST<201068827073> 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 = 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, Amir