Re: question about postgresql dlr storage

2015-07-27 Thread Marcin Matyaszczyk
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&

Re: question about postgresql dlr storage

2015-07-27 Thread Kalle Niemitalo
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",

Re: question about postgresql dlr storage

2015-07-15 Thread Alvaro Cornejo
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

Re: question about postgresql dlr storage

2015-07-15 Thread Marcin Matyaszczyk
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

Re: question about postgresql dlr storage

2015-07-10 Thread Alvaro Cornejo
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

question about postgresql dlr storage

2015-07-09 Thread Marcin Matyaszczyk
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',