What’s the output of show create table dlr in your new_sms database? What I guess here is that the url column is just too short.
== Rene Van: users <users-boun...@kannel.org> Namens Umair Baig Verzonden: donderdag 13 februari 2020 15:31 Aan: users@kannel.org Onderwerp: 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/>
