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 <[email protected]> wrote: > It should route automatically. > > Could you share your logs? > > > > *From:* users [mailto:[email protected]] *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 >
