Re: Not able to push DLR from kannel to Client

Dear Paulo, 

Thank you for your revert. I noticed that we are getting DLR from client and it's stuck in DLR table...once 40 dlr store in table and when 41th dlr is coming then 1st dlr is going out client. 

Retards, Rohit Singh


From: Paulo Correia <[email protected]>
Sent: Mon, 19 Jul 2021 20:15:44 GMT+0530
To: Rohit Singh <[email protected]>,  "[email protected]." <[email protected]>,  "[email protected]" <[email protected]>
Subject: Re: Not able to push DLR from kannel to Client

 



 


Hello Rohit,





First you need to validate that your client has sent the dlr-url parameter when sending the mt message request.

Check if you have the record on your DLR store table on mysql and the URL on it is a valid URL ... I've seen a lot of clients sending invalid URLs ...



Then check the status the client wants to be notified, also on the table ... He might have sent the wrong status mask.

Also check that the client has not firewalled you from accessing the DLR URL, also a top issue.





If everything else fails, put the log in debug and check the logs for errors and warnings.





Kind regards,




























Paulo Correia


Head
 of Development



telephone:+351210337760 fax: +351210337761 

email: [email protected] skype: pcorreia.g4m






_____________________________________________________________________________________________
CONFIDENTIALITY
This message, as well as existing attached files, may be confidential and privileged. Use or disclosure by anyone other than an intended recipient is not authorised.
If you have received this message by error, you are kindly requested to delete it and notify the sender. Thank you for your cooperation.






















From: users <[email protected]> on behalf of Rohit Singh <[email protected]>

Sent: 19 July 2021 12:53

To: [email protected]. <[email protected]>; [email protected] <[email protected]>

Subject: Re: Not able to push DLR from kannel to Client
 




CAUTION: External E-mail



Dear Team, 
Can any one help me with this? 







From: "Rohit Singh"<[email protected]>

Sent: Wed, 30 Jun 2021 20:46:37 GMT+0530

To: <[email protected].>

Subject: 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