Re: Issue of DLR - URL with opensmppbox kannel

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 <[email protected]> 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 <[email protected]> *Namens *Umair Baig
> *Verzonden:* donderdag 13 februari 2020 15:31
> *Aan:* [email protected]
> *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/>
>
>
>