Re: Issue of DLR - URL with opensmppbox kannel

Provide your sqlbox.conf please On Thu, Feb 13, 2020, 4:32 PM Umair Baig wrote: > 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

Re: Issue of DLR - URL with opensmppbox kannel

Thanks it worked. *Thanks & Regards,* *UMAIR BAIG* *Sr.Manager* *Buzz: +91- 7738857063* *On Desk: 022-22007840* *SKYPE-ID -umair.baig2893* On Thu, Feb 13, 2020 at 8:28 PM Antony Stone < antony.st...@kannel.open.source.it> wrote: > On Thursday 13 February 2020 at

Issue of DLR - URL with opensmppbox kannel

I think url field should be varchar since it will store a urlencoded string so that smsbox will summon it by populating with its variables. > 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

Re: Issue of DLR - URL with opensmppbox kannel

On Thursday 13 February 2020 at 15:47:47, Umair Baig wrote: > 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. You can't put a URL into an integer field :) Try changing it to a varchar, and in my

Re: Issue of DLR - URL with opensmppbox kannel

your new_sms database? > > What I guess here is that the url column is just too short. > > > > == Rene > > > > *Van:* users *Namens *Umair Baig > *Verzonden:* donderdag 13 februari 2020 15:31 > *Aan:* users@kannel.org > *Onderwerp:* Issue of DLR - URL with

RE: Issue of DLR - URL with opensmppbox kannel

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 Namens Umair Baig Verzonden: donderdag 13 februari 2020 15:31 Aan: users@kannel.org Onderwerp: Issue of DLR - URL with opensmppbox kannel

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: