Not able to push DLR from kannel to Client

Dear All,

I am getting dlr from operator & i am seeing it's stored correctly under my dlr table in sql box, but same is not pushed to client.

Below I have explained connectivity flow & also provided the completed configuration of each box

Please help me to resolve DLR issue.


Regards,
Rohit S Singh
************************************************************************
***********Below is the E2E Connectivity Flow********************
************************************************************************
Client <------TRX----->KANNEL(where i have BEARERBOX, SMSBOX, SQLBOX, openSMPPBOX) <--------TRX------> End Operator

Client (No DLR's received on client)<-----------> KANNEL(DLR Reached in Kannel & stored correctly) <--------------> DLR Send From Opertor

************************************************************************
***************************Kannel.Conf*******************************
************************************************************************
group = core
admin-port = 13000
admin-password = ********
status-password = ********
log-file = "/etc/kannel/logs/bearerbox.log"
log-level = 0
access-log = "/etc/kannel/logs/access.log"
smsbox-port = 13001
store-type = spool
store-location = "/etc/kannel/logs/store"
smsbox-max-pending = 100
sms-resend-retry = 1
dlr-storage = mysql

group = smsbox
bearerbox-host = localhost
bearerbox-port = 13001
sendsms-port = 13131
sendsms-chars = "0123456789+ "
log-file = "/etc/kannel/logs/smsbox.log"
log-level = 0
access-log = "/etc/kannel/logs/access.log"
mo-recode = true

# SMPP - KAT
group = smsc
smsc = smpp
smsc-id = omo_smpp1
host = *.*.*.*
port = 5000
transceiver-mode = yes
smsc-username = ********
smsc-password = *****
msg-id-type = 0
alt-charset = "ASCII"
system-type = "SMPP"
log-file = "/etc/kannel/logs/omo_KTM.log"
log-level = 0


# SENDSMS-USER
group = sendsms-user
default-smsc = none
username = playsms1
password = playsms1
max-messages = 6
concatenation = true

# SMS SERVICE





group = mysql-connection
id = sqlbox-db
host = localhost
username = *****
password = ******
database = kannel_db
 
# DLR SETUP
#mysql connection
group = mysql-connection
id = mydlr
host = localhost
username = ******
password = ********
database = kannel_db
 
group = dlr-db
id = mydlr
table = dlr
field-smsc=smsc
field-timestamp=ts
field-destination=destination
field-source=source
field-service=service
field-url=url
field-mask=mask
field-status=status
field-boxc-id=boxc

************************************************************************
********************openSMPPBox.Conf****************************
************************************************************************
group = core
dlr-storage = mysql

group = opensmppbox
opensmppbox-id = abcd
opensmppbox-port = 3000
bearerbox-host = localhost
bearerbox-port = 13002
log-level = 0
log-file = /etc/kannel/logs/opensmppbox.log
our-system-id = chim1
route-to-smsc = omo_smpp1
smpp-logins = "/etc/kannel/smpplogins.txt"
use-systemid-as-smsboxid = 1

group = mysql-connection
id = mydlr
host = localhost
username = *******
password = *******
database = kannel_db
max-connections = 1

group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
************************************************************************
*************************SqlBox.Conf*********************************
************************************************************************
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13002
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/etc/kannel/logs/sqlbox.log"
log-level = 0

group = mysql-connection
id = sqlbox-db
host = localhost
username = ********
password = *********
database = kannel_db