Hello Rene, Firstly thanks for your response.
The length of my url field in dlr table is bigint(20) so I think this is enough. and the dlr table is empty as it fails to insert message due to the error above I believe. My dlr table structure CREATE TABLE `dlr` ( `id` bigint(20) UNSIGNED NOT NULL, `smsc` varchar(10) NOT NULL, `ts` varchar(40) NOT NULL, `destination` varchar(20) NOT NULL, `source` varchar(20) NOT NULL, `service` varchar(20) NOT NULL, `url` bigint(20) NOT NULL, `mask` int(11) NOT NULL, `status` int(11) NOT NULL, `boxc` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; *Thanks & Regards,* *UMAIR BAIG* *Sr.Manager* *Buzz: +91- 7738857063* *On Desk: 022-22007840* *SKYPE-ID -umair.baig2893* <http://mobilogi.com/> On Thu, Feb 13, 2020 at 8:07 PM Rene Kluwen <rene.klu...@chimit.nl> wrote: > 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/> > > >
