subject:"Re\: question about postgresql dlr storage"

Re: question about postgresql dlr storage

2015-08-04 Thread spameden

2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com:

 Hi Marcin

 Seems you are getting the problem due to the ' on text Victoria's. Even
 though you are urlencoding it, it seems it is being taken as a field
 delimiter and not part of the text. I'm thinking on two options:

 -) Try to escape it with \' or \\'

 -) You might want to replace any ' within any field with ´ or  `
 (right/left sided apostrophe)  before urlencoding the fields.


I think Marcin spot a bug when you're receiving returning DLR data with '
(apostroph) it won't be escaped / urlencoded properly that's why there is
an error.
Would be nice to reproduce this bug somehow.


 Regards

 Alvaro


 |-|
 Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
 celular y Nextel
 en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
 y GPRS online
   Visitenos en www.perusms.com

 On Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk 
 m.matyaszc...@ogicom.pl wrote:

 Hello

 we have a problem with Postgresql DLR storage which looks like a bug:
 when we try to send sms with source field containing ' character we've
 got an error:

 2015-04-02 10:18:51 CEST STATEMENT:  INSERT INTO dlr (smsc, ts,
 source, destination, service, url, mask, boxc, status)
 VALUES ('smpp3', '', 'Victoria's', '+488', 'xx',
 '
 http://.domain.pl/dlr2.php?id=110725920source=XXXt=%ti=%id=%dD=%DA=%AF=%F
 ',
 '31', '', '0');

 2015-04-02 10:21:51 CEST ERROR:  syntax error at or near s at
 character 147

 We urlencode all fields and sms is submitted ok to kannel, problem
 appears in dlr's insert query only. We use kannel 1.5.

 regards
 Marcin Matyaszczyk

Re: question about postgresql dlr storage

2015-08-04 Thread Marcin Matyaszczyk

Hello

The sms is submited like this:

http://localhost:13013/cgi-bin/sendsms?username=usernamepassword=passto=%2B485text=SMS+test+40from=Victoria%27ssmsc=smpp1tmobiledlr-mask=31priority=0dlr-url=http%3A%2F%2Fsmsc.host.pl%2Fdlr2.php%3Fid%3D145092731%26source%3Dred%26t%3D%25t%26i%3D%25i%26d%3D%25d%26D%3D%25D%26A%3D%25A%26F%3D%25F

All fields are urlencoded,  problem is with insert query for dlr result
(we think that the string source is not escaped properly before insert
to db).

Pozdrawiam,
  Marcin Matyaszczyk
  Administrator

Ogicom “Spider” Sp. z o.o. S.K.A., (61-131) Poznan, ul. Abpa Baraniaka
88, REGON 634407251, NIP 781-17-20-476, Sad Rejonowy Poznan Nowe Miasto
i Wilda w Poznaniu, VIII Wydzial Gospodarczy Krajowego Rejestru
Sadowego, KRS 410900,  kapital zakladowy: 429 000 PLN.

W dniu 04.08.2015 o 09:13, Jacek Raczkiewicz pisze:
 I think in postgres you need to escape single quote by doubling it:
 Victoria's - Victoria''s
 
 2015-08-04 9:08 GMT+02:00 spameden spame...@gmail.com
 mailto:spame...@gmail.com:
 
 
 
 2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com
 mailto:cornejo.alv...@gmail.com:
 
 Hi Marcin
 
 Seems you are getting the problem due to the ' on text
 Victoria's. Even though you are urlencoding it, it seems it is
 being taken as a field delimiter and not part of the text. I'm
 thinking on two options:
 
 -) Try to escape it with \' or \\' 
 
 -) You might want to replace any ' within any field with ´ or  `
 (right/left sided apostrophe)  before urlencoding the fields.
 
 
 I think Marcin spot a bug when you're receiving returning DLR data
 with ' (apostroph) it won't be escaped / urlencoded properly that's
 why there is an error.
 Would be nice to reproduce this bug somehow. 
 
 
 Regards
 
 Alvaro
 
 
 |-|
 Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde
 cualquier celular y Nextel
 en el Perú, México y en mas de 180 paises. Use aplicaciones 2
 vias via SMS y GPRS online
   Visitenos en www.perusms.com http://www.perusms.com
 
 On Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk
 m.matyaszc...@ogicom.pl mailto:m.matyaszc...@ogicom.pl wrote:
 
 Hello
 
 we have a problem with Postgresql DLR storage which looks
 like a bug:
 when we try to send sms with source field containing '
 character we've
 got an error:
 
 2015-04-02 10:18:51 CEST STATEMENT:  INSERT INTO dlr
 (smsc, ts,
 source, destination, service, url, mask, boxc,
 status)
 VALUES ('smpp3', '', 'Victoria's', '+488
 tel:%2B488', 'xx',
 
 'http://.domain.pl/dlr2.php?id=110725920source=XXXt=%ti=%id=%dD=%DA=%AF=%F',
 '31', '', '0');
 
 2015-04-02 10:21:51 CEST ERROR:  syntax error at or near s at
 character 147
 
 We urlencode all fields and sms is submitted ok to kannel,
 problem
 appears in dlr's insert query only. We use kannel 1.5.
 
 regards
 Marcin Matyaszczyk

Re: question about postgresql dlr storage

2015-08-04 Thread Jacek Raczkiewicz

I think in postgres you need to escape single quote by doubling it:
Victoria's - Victoria''s

2015-08-04 9:08 GMT+02:00 spameden spame...@gmail.com:



 2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com:

 Hi Marcin

 Seems you are getting the problem due to the ' on text Victoria's. Even
 though you are urlencoding it, it seems it is being taken as a field
 delimiter and not part of the text. I'm thinking on two options:

 -) Try to escape it with \' or \\'

 -) You might want to replace any ' within any field with ´ or  `
 (right/left sided apostrophe)  before urlencoding the fields.


 I think Marcin spot a bug when you're receiving returning DLR data with '
 (apostroph) it won't be escaped / urlencoded properly that's why there is
 an error.
 Would be nice to reproduce this bug somehow.


 Regards

 Alvaro


 |-|
 Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
 celular y Nextel
 en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
 SMS y GPRS online
   Visitenos en www.perusms.com

 On Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk 
 m.matyaszc...@ogicom.pl wrote:

 Hello

 we have a problem with Postgresql DLR storage which looks like a bug:
 when we try to send sms with source field containing ' character we've
 got an error:

 2015-04-02 10:18:51 CEST STATEMENT:  INSERT INTO dlr (smsc, ts,
 source, destination, service, url, mask, boxc, status)
 VALUES ('smpp3', '', 'Victoria's', '+488', 'xx',
 '
 http://.domain.pl/dlr2.php?id=110725920source=XXXt=%ti=%id=%dD=%DA=%AF=%F
 ',
 '31', '', '0');

 2015-04-02 10:21:51 CEST ERROR:  syntax error at or near s at
 character 147

 We urlencode all fields and sms is submitted ok to kannel, problem
 appears in dlr's insert query only. We use kannel 1.5.

 regards
 Marcin Matyaszczyk

Re: question about postgresql dlr storage

2015-08-04 Thread Alexander Malysh

Hi,

it should be converted to use prepared statements instead of plain sql string.

Patches are welcome…

Alex

 Am 04.08.2015 um 09:19 schrieb Marcin Matyaszczyk m.matyaszc...@ogicom.pl:
 
 Hello
 
 The sms is submited like this:
 
 http://localhost:13013/cgi-bin/sendsms?username=usernamepassword=passto=%2B485text=SMS+test+40from=Victoria%27ssmsc=smpp1tmobiledlr-mask=31priority=0dlr-url=http%3A%2F%2Fsmsc.host.pl%2Fdlr2.php%3Fid%3D145092731%26source%3Dred%26t%3D%25t%26i%3D%25i%26d%3D%25d%26D%3D%25D%26A%3D%25A%26F%3D%25F
 
 All fields are urlencoded,  problem is with insert query for dlr result
 (we think that the string source is not escaped properly before insert
 to db).
 
 Pozdrawiam,
  Marcin Matyaszczyk
  Administrator
 
 Ogicom “Spider” Sp. z o.o. S.K.A., (61-131) Poznan, ul. Abpa Baraniaka
 88, REGON 634407251, NIP 781-17-20-476, Sad Rejonowy Poznan Nowe Miasto
 i Wilda w Poznaniu, VIII Wydzial Gospodarczy Krajowego Rejestru
 Sadowego, KRS 410900,  kapital zakladowy: 429 000 PLN.
 
 W dniu 04.08.2015 o 09:13, Jacek Raczkiewicz pisze:
 I think in postgres you need to escape single quote by doubling it:
 Victoria's - Victoria''s
 
 2015-08-04 9:08 GMT+02:00 spameden spame...@gmail.com
 mailto:spame...@gmail.com:
 
 
 
2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com
mailto:cornejo.alv...@gmail.com:
 
Hi Marcin
 
Seems you are getting the problem due to the ' on text
Victoria's. Even though you are urlencoding it, it seems it is
being taken as a field delimiter and not part of the text. I'm
thinking on two options:
 
-) Try to escape it with \' or \\' 
 
-) You might want to replace any ' within any field with ´ or  `
(right/left sided apostrophe)  before urlencoding the fields.
 
 
I think Marcin spot a bug when you're receiving returning DLR data
with ' (apostroph) it won't be escaped / urlencoded properly that's
why there is an error.
Would be nice to reproduce this bug somehow. 
 
 
Regards
 
Alvaro
 

 |-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde
cualquier celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2
vias via SMS y GPRS online
  Visitenos en www.perusms.com http://www.perusms.com
 
On Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk
m.matyaszc...@ogicom.pl mailto:m.matyaszc...@ogicom.pl wrote:
 
Hello
 
we have a problem with Postgresql DLR storage which looks
like a bug:
when we try to send sms with source field containing '
character we've
got an error:
 
2015-04-02 10:18:51 CEST STATEMENT:  INSERT INTO dlr
(smsc, ts,
source, destination, service, url, mask, boxc,
status)
VALUES ('smpp3', '', 'Victoria's', '+488
tel:%2B488', 'xx',

 'http://.domain.pl/dlr2.php?id=110725920source=XXXt=%ti=%id=%dD=%DA=%AF=%F',
'31', '', '0');
 
2015-04-02 10:21:51 CEST ERROR:  syntax error at or near s at
character 147
 
We urlencode all fields and sms is submitted ok to kannel,
problem
appears in dlr's insert query only. We use kannel 1.5.
 
regards
Marcin Matyaszczyk

Re: question about postgresql dlr storage

2015-08-03 Thread Alvaro Cornejo

Hi Marcin

Seems you are getting the problem due to the ' on text Victoria's. Even
though you are urlencoding it, it seems it is being taken as a field
delimiter and not part of the text. I'm thinking on two options:

-) Try to escape it with \' or \\'

-) You might want to replace any ' within any field with ´ or  `
(right/left sided apostrophe)  before urlencoding the fields.

Regards

Alvaro

|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
  Visitenos en www.perusms.com

On Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk m.matyaszc...@ogicom.pl
wrote:

 Hello

 we have a problem with Postgresql DLR storage which looks like a bug:
 when we try to send sms with source field containing ' character we've
 got an error:

 2015-04-02 10:18:51 CEST STATEMENT:  INSERT INTO dlr (smsc, ts,
 source, destination, service, url, mask, boxc, status)
 VALUES ('smpp3', '', 'Victoria's', '+488', 'xx',
 '
 http://.domain.pl/dlr2.php?id=110725920source=XXXt=%ti=%id=%dD=%DA=%AF=%F
 ',
 '31', '', '0');

 2015-04-02 10:21:51 CEST ERROR:  syntax error at or near s at
 character 147

 We urlencode all fields and sms is submitted ok to kannel, problem
 appears in dlr's insert query only. We use kannel 1.5.

 regards
 Marcin Matyaszczyk

Re: question about postgresql dlr storage

Re: question about postgresql dlr storage

Re: question about postgresql dlr storage

Re: question about postgresql dlr storage

Re: question about postgresql dlr storage

5 matches

Site Navigation

Mail list logo

Footer information