Re: Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Web Min 
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 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<+9177XX>
>
> 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 = "X"
> 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*
>
>   
>
>

Re: Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Umair Baig 
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 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 opinion 20 characters if way too
> small
> - the entries in my sms_dlr table are 153 characters long, for example.
>
>
> Antony.
>
> --
> When you find yourself arguing with an idiot,
> you should first of all make sure
> that the other person isn't doing the same thing.
>
>Please reply to the
> list;
>  please *don't* CC
> me.
>
>

Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Tolga Ulas 
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 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;

Re: Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Antony Stone 
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 opinion 20 characters if way too small 
- the entries in my sms_dlr table are 153 characters long, for example.


Antony.

-- 
When you find yourself arguing with an idiot,
you should first of all make sure
that the other person isn't doing the same thing.

   Please reply to the list;
 please *don't* CC me.

Re: Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Umair Baig 
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*

  



On Thu, Feb 13, 2020 at 8:07 PM Rene Kluwen  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  *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<+9177XX>
>
>
>
> 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 = "X"
> 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*
>
>
>
>   
>
>
>

RE: Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Rene Kluwen 
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

 

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<+9177XX>

 

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 = "X"
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

Issue of DLR - URL with opensmppbox kannel

2020-02-13 Thread Umair Baig 
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<+9177XX>

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 = "X"
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*