Issue of DLR - URL with opensmppbox kannel

Hello All,

I have configured opensmppbox and I am trying to submit sms using mysql as
dlr storage.
When I receive sms it gets delivered but dlr does not get inserted into dlr
table instead I get an error message in opensmppbox logs saying the below.

2020-02-13 19:21:14 [15724] [2] ERROR: MYSQL: mysql_stmt_execute() failed:
`Data truncated for column 'url' at row 1'
2020-02-13 19:21:14 [15724] [2] ERROR: DLR: MYSQL: Error while adding dlr
entry for DST<+9177XXXXXX>

I am not sure why url data is not coming when sms is being received and
field dlr-url in the log file is always empty.

my opensmppbox conf

#configuration
group = core
dlr-storage = mysql

###################################
group = mysql-connection
id = dlr-db
host = 127.0.0.1
port = 3303
username = opensmppbox
password = "XXXXX"
database = new_sms
max-connections = 20

###################################
group = dlr-db
id = dlr-db
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
###################################

group = opensmppbox
bearerbox-host = 127.0.0.1
bearerbox-port = 13001
opensmppbox-id = smppbox1
opensmppbox-port = 2775
log-file = /usr/opensmppbox.log
log-level = 0
our-system-id =smpp
use-systemid-as-smsboxid = true
route-to-smsc = Test001
# New accounts
smpp-logins = /usr/smpplogin.txt

*Thanks & Regards,*


*UMAIR BAIG*
*Sr.Manager*
*Buzz: +91- 7738857063*
*On Desk: 022-22007840*
*SKYPE-ID -umair.baig2893*

  <http://mobilogi.com/>