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 = 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 > > >