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