Re: question about postgresql dlr storage
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
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
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
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
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
question about postgresql dlr storage
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
