hello
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).
The sms is submited like this :
http://localhost:13013/cgi-bin/sendsms?username=username&password=pass&to=%2B485&text=SMS+test+40&
Marcin Matyaszczyk writes:
> we have a problem with Postgresql DLR storage, 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",
Hi
dlr-url should also be urlencoded. In your example the + sign should also
be urlencode since + is the urlencode value of the space char.
Regards
Alvaro
|-|
Envíe y Reciba Datos y m
Hello
Thanks for answer. We urlencode all fields and sms is submitted ok to
kannel, problem appears when we get dlr (insert query).
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
Hi
You need to urlenconde your field values when submitting to kannel.
"Victoria's"
should be "Victoria%27s"
Regards
Alvaro
|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y
Hello
we have a problem with Postgresql DLR storage, 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',