Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Sorry for the late reply, it's midnight here :) Not yet brother, yesterday I
tested with reguler text and found the SQLBox didn't URL-Encoded the text. I
will try to test it out ASAP.
sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/
On Nov 19, 2010, at 6:48 PM, Alejandro Guerrieri wrote:
> It should work fine now, I've tested it :)
>
> 2010/11/19 Kenny
> Alex...that's fantastic. :)
>
> Willy.. have you tested this with wappush? Am going to do that presently.
>
> --
> Regards
> Kenny
>
>
>
> 2010/11/19 Alejandro Guerrieri
> With the latest version, yes. It's mentioned on the UPGRADE file:
>
>
> * IMPORTANT NOTICE *
>
> If you're upgrading from a version BEFORE 2010-11-11 (0.7.x and
> lower), please note that the format for the msgdata and udhdata
> columns is now url-encoded. That probably means that if you use
> inserts on send_sms to send MT, YOU WILL NEED TO MODIFY YOUR
> CODE TO URLENCODE THE MESSAGES FIRST.
>
> Regards,
>
> Alex
>
> 2010/11/19 Kenny
>
> Alex, Are you saying one has to url-encode before passing data into msgdata
> and udhdata? Please confirm.
>
>
> --
> Regards
> Kenny
>
>
>
> 2010/11/19 Alejandro Guerrieri
>
> Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
> issue.
>
> I'll try to reproduce the error locally and let you know what I find.
>
> Are you using latest sqlbox and kannel?
>
> Regards,
>
> Alex
>
>
> On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>
> Willie.
>
> Thank u,
> the patch is not commited
> I tested with the patch but still get
>
> 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
> 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191020 done date:1011191020 sta' at line 1
> 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191120 done date:1011191020 sta' at line 1
>
> ...
>
> Alejandro can you comment on that?
>
> Is there a way out.
>
> Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto έγραψε:
>> static Octstr *get_string_value_or_return_null(Octstr *str) { static Octstr
>> *nul = NULL;
>> if (str == NULL) { return octstr_create("NULL"); } if
>> (octstr_compare(str, octstr_imm("")) == 0) { return
>> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
>> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
>> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
>> octstr_append_char(nul, 0x00); } octstr_replace(str, nul, octstr_imm("\0"));
>> return octstr_format("\'%S\'", str); }
>
>
> Dr. Peter Kontopoulos
> CTO
>
> LOCOTEL SA
> 2, Parnassou St.
> 10561 Athens, GREECE
> T: +30 210 3258 350 F: +30 210 3258 359
> www.locotel.gr & www.locosms.gr
>
>
> Email Disclaimer
> The information in this email is confidential and is intended solely for the
> addressee(s). If you have received this transmission in error, and you are
> not an intended recipient, be aware that any disclosure, copying,
> distribution or use of this transmission or its contents is prohibited.
> Furthermore, you are kindly requested to send us back the original message at
> the address portmas...@locotel.gr, and delete the message from your system
> immediately.
> Internet communications are not secure and therefore LOCOTEL SA does not
> accept legal responsibility for the contents of this message and for any
> damage whatsoever that is caused by viruses being passed. Any views or
> opinions presented are solely those of the author and do not necessarily
> represent those of LOCOTEL SA.
> Thank you,
> LOCOTEL SA
> Think Before you Print
>
>
>
>
>
Re: SMSC Rejected DLR shouldn't be saved in the DLR storage
Title: Re: SMSC Rejected DLR shouldn't be saved in the DLR storage Hello Mohammed, it is so you can find out there was an ERROR submitting the SM. How else would you know? Think of it as error message. Kannel must match it in the dlr mechanism or else you would not be able to retrieve the status of said failed SM. Think of the record as an error message. If you don't want these, exclude 16 from your dlr mask. BTW. i have a feeling this does not belong on the developer list, but on users. Friday, November 19, 2010, 2:24:18 AM, you wrote: I user dlr-mask = 31 ( kannel stable release 64-bits 1.4.3) Hello people, thanks so much for your great answers, but my problem is not with understanding the DLR mechanism in Kannel, I already know that, but my question is: Why kannel stores DLRs in the DLR table for the SMS-Rejected MTs (status = 16)? When the SMSC rejects an MT then it will forget about it and it won't send any DLR for for that MT in the future, so Kannel shouldn't insert a record into the DLR table? right? -- Best regards, Thomas mailto:tho...@ist.schuldig.de
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
It should work fine now, I've tested it :)
2010/11/19 Kenny
> Alex...that's fantastic. :)
>
> Willy.. have you tested this with wappush? Am going to do that presently.
>
> --
> Regards
> Kenny
>
>
>
> 2010/11/19 Alejandro Guerrieri
>
>> With the latest version, yes. It's mentioned on the UPGRADE file:
>>
>>
>> * IMPORTANT NOTICE *
>>
>> If you're upgrading from a version BEFORE 2010-11-11 (0.7.x and
>> lower), please note that the format for the msgdata and udhdata
>> columns is now url-encoded. That probably means that if you use
>> inserts on send_sms to send MT, YOU WILL NEED TO MODIFY YOUR
>> CODE TO URLENCODE THE MESSAGES FIRST.
>>
>> Regards,
>>
>> Alex
>>
>> 2010/11/19 Kenny
>>
>> Alex, Are you saying one has to url-encode before passing data into
>>> msgdata and udhdata? Please confirm.
>>>
>>>
>>> --
>>> Regards
>>> Kenny
>>>
>>>
>>>
>>> 2010/11/19 Alejandro Guerrieri
>>>
>>> Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
issue.
I'll try to reproduce the error locally and let you know what I find.
Are you using latest sqlbox and kannel?
Regards,
Alex
On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>
> Willie.
>
> Thank u,
> the patch is not commited
> I tested with the patch but still get
>
> 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms
> received
> 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
> SQL syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191020 done date:1011191020 sta' at line 1
> 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
> SQL syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191120 done date:1011191020 sta' at line 1
>
> ...
>
> Alejandro can you comment on that?
>
> Is there a way out.
>
> Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto
> έγραψε:
>
> static Octstr *get_string_value_or_return_null(Octstr *str) { static
> Octstr *nul = NULL;
> if (str == NULL) { return octstr_create("NULL"); }
> if (octstr_compare(str, octstr_imm("")) == 0) { return
> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
> octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
> octstr_imm("\0")); return octstr_format("\'%S\'", str); }
>
> --
>
>
> *Dr. Peter Kontopoulos*
> CTO
>
> *LOCOTEL SA*
> 2, Parnassou St.
> 10561 Athens, GREECE
> *T:* +30 210 3258 350 *F:* +30 210 3258 359
> www.locotel.gr & www.locosms.gr
> --
>
>
> Email Disclaimer
> The information in this email is confidential and is intended solely
> for the addressee(s). If you have received this transmission in error, and
> you are not an intended recipient, be aware that any disclosure, copying,
> distribution or use of this transmission or its contents is prohibited.
> Furthermore, you are kindly requested to send us back the original message
> at the address portmas...@locotel.gr, and delete the message from your
> system immediately.
> Internet communications are not secure and therefore LOCOTEL SA does
> not accept legal responsibility for the contents of this message and for
> any
> damage whatsoever that is caused by viruses being passed. Any views or
> opinions presented are solely those of the author and do not necessarily
> represent those of LOCOTEL SA.
> Thank you,
> LOCOTEL SA
> *Think Before you Print*
>
>>>
>>
>
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Alex...that's fantastic. :)
Willy.. have you tested this with wappush? Am going to do that presently.
--
Regards
Kenny
2010/11/19 Alejandro Guerrieri
> With the latest version, yes. It's mentioned on the UPGRADE file:
>
>
> * IMPORTANT NOTICE *
>
> If you're upgrading from a version BEFORE 2010-11-11 (0.7.x and
> lower), please note that the format for the msgdata and udhdata
> columns is now url-encoded. That probably means that if you use
> inserts on send_sms to send MT, YOU WILL NEED TO MODIFY YOUR
> CODE TO URLENCODE THE MESSAGES FIRST.
>
> Regards,
>
> Alex
>
> 2010/11/19 Kenny
>
> Alex, Are you saying one has to url-encode before passing data into msgdata
>> and udhdata? Please confirm.
>>
>>
>> --
>> Regards
>> Kenny
>>
>>
>>
>> 2010/11/19 Alejandro Guerrieri
>>
>> Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
>>> issue.
>>>
>>> I'll try to reproduce the error locally and let you know what I find.
>>>
>>> Are you using latest sqlbox and kannel?
>>>
>>> Regards,
>>>
>>> Alex
>>>
>>>
>>> On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>>>
Willie.
Thank u,
the patch is not commited
I tested with the patch but still get
2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
date:1011191020 done date:1011191020 sta' at line 1
2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
date:1011191120 done date:1011191020 sta' at line 1
...
Alejandro can you comment on that?
Is there a way out.
Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto
έγραψε:
static Octstr *get_string_value_or_return_null(Octstr *str) { static
Octstr *nul = NULL;
if (str == NULL) { return octstr_create("NULL"); }
if (octstr_compare(str, octstr_imm("")) == 0) { return
octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
octstr_imm("\0")); return octstr_format("\'%S\'", str); }
--
*Dr. Peter Kontopoulos*
CTO
*LOCOTEL SA*
2, Parnassou St.
10561 Athens, GREECE
*T:* +30 210 3258 350 *F:* +30 210 3258 359
www.locotel.gr & www.locosms.gr
--
Email Disclaimer
The information in this email is confidential and is intended solely for
the addressee(s). If you have received this transmission in error, and you
are not an intended recipient, be aware that any disclosure, copying,
distribution or use of this transmission or its contents is prohibited.
Furthermore, you are kindly requested to send us back the original message
at the address portmas...@locotel.gr, and delete the message from your
system immediately.
Internet communications are not secure and therefore LOCOTEL SA does not
accept legal responsibility for the contents of this message and for any
damage whatsoever that is caused by viruses being passed. Any views or
opinions presented are solely those of the author and do not necessarily
represent those of LOCOTEL SA.
Thank you,
LOCOTEL SA
*Think Before you Print*
>>>
>>>
>>
>
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
With the latest version, yes. It's mentioned on the UPGRADE file:
* IMPORTANT NOTICE *
If you're upgrading from a version BEFORE 2010-11-11 (0.7.x and
lower), please note that the format for the msgdata and udhdata
columns is now url-encoded. That probably means that if you use
inserts on send_sms to send MT, YOU WILL NEED TO MODIFY YOUR
CODE TO URLENCODE THE MESSAGES FIRST.
Regards,
Alex
2010/11/19 Kenny
> Alex, Are you saying one has to url-encode before passing data into msgdata
> and udhdata? Please confirm.
>
>
> --
> Regards
> Kenny
>
>
>
> 2010/11/19 Alejandro Guerrieri
>
> Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
>> issue.
>>
>> I'll try to reproduce the error locally and let you know what I find.
>>
>> Are you using latest sqlbox and kannel?
>>
>> Regards,
>>
>> Alex
>>
>>
>> On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>>
>>>
>>> Willie.
>>>
>>> Thank u,
>>> the patch is not commited
>>> I tested with the patch but still get
>>>
>>> 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
>>> 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
>>> SQL syntax; check the manual that corresponds to your MySQL server version
>>> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
>>> date:1011191020 done date:1011191020 sta' at line 1
>>> 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
>>> SQL syntax; check the manual that corresponds to your MySQL server version
>>> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
>>> date:1011191120 done date:1011191020 sta' at line 1
>>>
>>> ...
>>>
>>> Alejandro can you comment on that?
>>>
>>> Is there a way out.
>>>
>>> Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto
>>> έγραψε:
>>>
>>> static Octstr *get_string_value_or_return_null(Octstr *str) { static
>>> Octstr *nul = NULL;
>>> if (str == NULL) { return octstr_create("NULL"); } if
>>> (octstr_compare(str, octstr_imm("")) == 0) { return
>>> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
>>> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
>>> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
>>> octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
>>> octstr_imm("\0")); return octstr_format("\'%S\'", str); }
>>>
>>> --
>>>
>>>
>>> *Dr. Peter Kontopoulos*
>>> CTO
>>>
>>> *LOCOTEL SA*
>>> 2, Parnassou St.
>>> 10561 Athens, GREECE
>>> *T:* +30 210 3258 350 *F:* +30 210 3258 359
>>> www.locotel.gr & www.locosms.gr
>>> --
>>>
>>>
>>> Email Disclaimer
>>> The information in this email is confidential and is intended solely for
>>> the addressee(s). If you have received this transmission in error, and you
>>> are not an intended recipient, be aware that any disclosure, copying,
>>> distribution or use of this transmission or its contents is prohibited.
>>> Furthermore, you are kindly requested to send us back the original message
>>> at the address portmas...@locotel.gr, and delete the message from your
>>> system immediately.
>>> Internet communications are not secure and therefore LOCOTEL SA does not
>>> accept legal responsibility for the contents of this message and for any
>>> damage whatsoever that is caused by viruses being passed. Any views or
>>> opinions presented are solely those of the author and do not necessarily
>>> represent those of LOCOTEL SA.
>>> Thank you,
>>> LOCOTEL SA
>>> *Think Before you Print*
>>>
>>
>>
>
Re: DLR request is "prohibited" so...?
Hi, You can get some info with respect to whether SMS was accepted or rejected by the SMSc, using dlr-mask 24. But you can never know if the SMS was actually delivered to the destination without DLRs. If your SMSc "prohibits" DLRs you better change SMSc. BR, Nikos - Original Message - From: "I Gede Wijaya" To: Sent: Friday, November 19, 2010 11:05 AM Subject: DLR request is "prohibited" so...? Halo again list, How could I get the sent sms status, if SMSC "prohibited" in using DLR request? Like my thread before, the SMSC will send many error code based on their spec. And those error will appear on bb log. And I only just play around with gw/smsc/smpp_pdu.c and gw/smsc/smpp_pdu.h to make the message more meaningful for me. For now, I'm using php to send the sms to /cgi-bin/sendsms, but I still don't know how to capture the sent status in script without using DLR request (success or custom error code) Thanks in advanced
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Alex, Are you saying one has to url-encode before passing data into msgdata
and udhdata? Please confirm.
--
Regards
Kenny
2010/11/19 Alejandro Guerrieri
> Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
> issue.
>
> I'll try to reproduce the error locally and let you know what I find.
>
> Are you using latest sqlbox and kannel?
>
> Regards,
>
> Alex
>
>
> On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>
>>
>> Willie.
>>
>> Thank u,
>> the patch is not commited
>> I tested with the patch but still get
>>
>> 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
>> 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
>> SQL syntax; check the manual that corresponds to your MySQL server version
>> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
>> date:1011191020 done date:1011191020 sta' at line 1
>> 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
>> SQL syntax; check the manual that corresponds to your MySQL server version
>> for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
>> date:1011191120 done date:1011191020 sta' at line 1
>>
>> ...
>>
>> Alejandro can you comment on that?
>>
>> Is there a way out.
>>
>> Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto έγραψε:
>>
>> static Octstr *get_string_value_or_return_null(Octstr *str) { static
>> Octstr *nul = NULL;
>> if (str == NULL) { return octstr_create("NULL"); } if
>> (octstr_compare(str, octstr_imm("")) == 0) { return
>> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
>> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
>> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
>> octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
>> octstr_imm("\0")); return octstr_format("\'%S\'", str); }
>>
>> --
>>
>>
>> *Dr. Peter Kontopoulos*
>> CTO
>>
>> *LOCOTEL SA*
>> 2, Parnassou St.
>> 10561 Athens, GREECE
>> *T:* +30 210 3258 350 *F:* +30 210 3258 359
>> www.locotel.gr & www.locosms.gr
>> --
>>
>>
>> Email Disclaimer
>> The information in this email is confidential and is intended solely for
>> the addressee(s). If you have received this transmission in error, and you
>> are not an intended recipient, be aware that any disclosure, copying,
>> distribution or use of this transmission or its contents is prohibited.
>> Furthermore, you are kindly requested to send us back the original message
>> at the address portmas...@locotel.gr, and delete the message from your
>> system immediately.
>> Internet communications are not secure and therefore LOCOTEL SA does not
>> accept legal responsibility for the contents of this message and for any
>> damage whatsoever that is caused by viruses being passed. Any views or
>> opinions presented are solely those of the author and do not necessarily
>> represent those of LOCOTEL SA.
>> Thank you,
>> LOCOTEL SA
>> *Think Before you Print*
>>
>
>
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
issue.
I'll try to reproduce the error locally and let you know what I find.
Are you using latest sqlbox and kannel?
Regards,
Alex
On Fri, Nov 19, 2010 at 11:24 AM, Peter wrote:
>
> Willie.
>
> Thank u,
> the patch is not commited
> I tested with the patch but still get
>
> 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
> 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191020 done date:1011191020 sta' at line 1
> 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
> date:1011191120 done date:1011191020 sta' at line 1
>
> ...
>
> Alejandro can you comment on that?
>
> Is there a way out.
>
> Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto έγραψε:
>
> static Octstr *get_string_value_or_return_null(Octstr *str) { static Octstr
> *nul = NULL;
> if (str == NULL) { return octstr_create("NULL"); } if
> (octstr_compare(str, octstr_imm("")) == 0) { return
> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
> octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
> octstr_imm("\0")); return octstr_format("\'%S\'", str); }
>
> --
>
>
> *Dr. Peter Kontopoulos*
> CTO
>
> *LOCOTEL SA*
> 2, Parnassou St.
> 10561 Athens, GREECE
> *T:* +30 210 3258 350 *F:* +30 210 3258 359
> www.locotel.gr & www.locosms.gr
> --
>
>
> Email Disclaimer
> The information in this email is confidential and is intended solely for
> the addressee(s). If you have received this transmission in error, and you
> are not an intended recipient, be aware that any disclosure, copying,
> distribution or use of this transmission or its contents is prohibited.
> Furthermore, you are kindly requested to send us back the original message
> at the address portmas...@locotel.gr, and delete the message from your
> system immediately.
> Internet communications are not secure and therefore LOCOTEL SA does not
> accept legal responsibility for the contents of this message and for any
> damage whatsoever that is caused by viruses being passed. Any views or
> opinions presented are solely those of the author and do not necessarily
> represent those of LOCOTEL SA.
> Thank you,
> LOCOTEL SA
> *Think Before you Print*
>
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Willie.
Thank u,
the patch is not commited
I tested with the patch but still get
2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ''id:1365419169 sub:001
dlvrd:001 submit date:1011191020 done date:1011191020 sta' at line 1
2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ''id:1365419169 sub:001
dlvrd:001 submit date:1011191120 done date:1011191020 sta' at line 1
...
Alejandro can you comment on that?
Is there a way out.
Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto
έγραψε:
> static Octstr *get_string_value_or_return_null(Octstr *str) { static
> Octstr *nul = NULL;
> if (str == NULL) { return octstr_create("NULL"); }
> if (octstr_compare(str, octstr_imm("")) == 0) { return
> octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"),
> octstr_imm("")); octstr_replace(str, octstr_imm("\'"),
> octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create("");
> octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
> octstr_imm("\0")); return octstr_format("\'%S\'", str); }
Dr. Peter Kontopoulos
CTO
LOCOTEL SA
2, Parnassou St.
10561 Athens, GREECE
T: +30 210 3258 350 F: +30 210 3258 359
www.locotel.gr & www.locosms.gr
Email Disclaimer
The information in this email is confidential and is intended solely for
the addressee(s). If you have received this transmission in error, and
you are not an intended recipient, be aware that any disclosure,
copying, distribution or use of this transmission or its contents is
prohibited. Furthermore, you are kindly requested to send us back the
original message at the address portmas...@locotel.gr, and delete the
message from your system immediately.
Internet communications are not secure and therefore LOCOTEL SA does not
accept legal responsibility for the contents of this message and for any
damage whatsoever that is caused by viruses being passed. Any views or
opinions presented are solely those of the author and do not necessarily
represent those of LOCOTEL SA.
Thank you,
LOCOTEL SA
Think Before you Print
Re: users Digest, Vol 51, Issue 63
t;>>>> Sent: Friday, 12 November, 2010 13:45 > >>>>>>> To: 'Willy Mularto'; 'Kannel Users' > >>>>>>> Subject: RE: SQLBox INSERT INTO MySQL Bug > >>>>>>> > >>>>>>> It's not the ' character that is not escaped. Probably you are > getting a > >>>>>>> '\x00' byte in your delivery receipt. > >>>>>>> I had the same issue with a client. > >>>>>>> > >>>>>>> == Rene > >>>>>>> > >>>>>>> -Original Message- > >>>>>>> From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] > On Behalf > >>>>>>> Of Willy Mularto > >>>>>>> Sent: Friday, 12 November, 2010 02:00 > >>>>>>> To: Kannel Users > >>>>>>> Subject: SQLBox INSERT INTO MySQL Bug > >>>>>>> > >>>>>>> > >>>>>>> I found some errors in the log like this > >>>>>>> > >>>>>>> "ERROR: MYSQL: You have an error in your SQL syntax; check the > manual that > >>>>>>> corresponds to your MySQL server version for the right syntax to > use near > >>>>>>> ''id:1127445986 sub:001 dlvrd:001 submit date:1011120752 done > >>>>>>> date:1011120752 sta' at line 1" > >>>>>>> > >>>>>>> I think SQLBox failed to escape the ' character when inserting new > row. Is > >>>>>>> there any patch against this error? Thanks. > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> sangprabv > >>>>>>> sangpr...@gmail.com > >>>>>>> http://www.petitiononline.com/froyo/ > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> Dr. Peter Kontopoulos > >>>> CTO > >>>> > >>>> LOCOTEL SA > >>>> 2, Parnassou St. > >>>> 10561 Athens, GREECE > >>>> T: +30 210 3258 350 F: +30 210 3258 359 > >>>> www.locotel.gr & www.locosms.gr > >>>> > >>>> > >>>> > >>>> > >>>> Email Disclaimer > >>>> The information in this email is confidential and is intended solely > for the addressee(s). If you have received this transmission in error, and > you are not an intended recipient, be aware that any disclosure, copying, > distribution or use of this transmission or its contents is prohibited. > Furthermore, you are kindly requested to send us back the original message > at the address portmas...@locotel.gr, and delete the message from your > system immediately. > >>>> Internet communications are not secure and therefore LOCOTEL SA does > not accept legal responsibility for the contents of this message and for any > damage whatsoever that is caused by viruses being passed. Any views or > opinions presented are solely those of the author and do not necessarily > represent those of LOCOTEL SA. > >>>> Thank you, > >>>> LOCOTEL SA > >>>> Think Before you Print > >>>> > >>>> > >>> > >>> > >>> > >>> > >>> Dr. Peter Kontopoulos > >>> CTO > >>> > >>> LOCOTEL SA > >>> 2, Parnassou St. > >>> 10561 Athens, GREECE > >>> T: +30 210 3258 350 F: +30 210 3258 359 > >>> www.locotel.gr & www.locosms.gr > >>> > >>> > >>> > >>> Email Disclaimer > >>> The information in this email is confidential and is intended solely > for the addressee(s). If you have received this transmission in error, and > you are not an intended recipient, be aware that any disclosure, copying, > distribution or use of this transmission or its contents is prohibited. > Furthermore, you are kindly requested to send us back the original message > at the address portmas...@locotel.gr, and delete the message from your > system immediately. > >>> Internet communications are not secure and therefore LOCOTEL SA does > not accept legal responsibility for the contents of this message and for any > damage whatsoever that is caused by viruses being passed. Any views or > opinions presented are solely those of the author and do not necessarily > represent those of LOCOTEL SA. > >>> Thank you, > >>> LOCOTEL SA > >>> Think Before you Print > >>> > >>> > >> > >> > > > > > > > > Dr. Peter Kontopoulos > > CTO > > > > LOCOTEL SA > > 2, Parnassou St. > > 10561 Athens, GREECE > > T: +30 210 3258 350 F: +30 210 3258 359 > > www.locotel.gr & www.locosms.gr > > > > > > Email Disclaimer > > The information in this email is confidential and is intended solely for > the addressee(s). If you have received this transmission in error, and you > are not an intended recipient, be aware that any disclosure, copying, > distribution or use of this transmission or its contents is prohibited. > Furthermore, you are kindly requested to send us back the original message > at the address portmas...@locotel.gr, and delete the message from your > system immediately. > > Internet communications are not secure and therefore LOCOTEL SA does not > accept legal responsibility for the contents of this message and for any > damage whatsoever that is caused by viruses being passed. Any views or > opinions presented are solely those of the author and do not necessarily > represent those of LOCOTEL SA. > > Thank you, > > LOCOTEL SA > > Think Before you Print > > -- next part -- > An HTML attachment was scrubbed... > URL: < > http://www.kannel.org/pipermail/users/attachments/20101119/bb235748/attachment.html > > > > -- > > ___ > users mailing list > users@kannel.org > http://www.kannel.org/mailman/listinfo/users > > > End of users Digest, Vol 51, Issue 63 > * >
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
http://www.mail-archive.com/de...@kannel.org/ http://www.mail-archive.com/users@kannel.org/ sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 19, 2010, at 4:26 PM, Peter wrote: > Hi, > excuse my ignorance but i do not know where the devel archives are in the svn > (is it something like .../sqlbox/devel?), > where do i find the patch and how to apply it. Is it possible to guide me on > that? > why this patch was not commited into trunk yet? > Best regards > > Στις 19-11-2010, ημέρα Παρ, και ώρα 07:34 +0700, ο/η Willy Mularto έγραψε: >> Rene has the patch for the issue. Please check the devel archives. >> >> >> >> >> >> >> >> sangprabv >> sangpr...@gmail.com >> http://www.petitiononline.com/froyo/ >> >> >> >> On Nov 19, 2010, at 1:19 AM, Alejandro Guerrieri wrote: >> >>> Hrm, no, that DLR doesn't even include single quotes, that's an artifact >>> from the log. >>> >>> >>> >>> >>> On Thu, Nov 18, 2010 at 6:51 PM, Peter wrote: >>> Alejandro, >>> I send you the requested dump plus typical log files >>> >>> ... >>> >>> >>> >>> Στις 18-11-2010, ημέρα Πεμ, και ώρα 18:31 +0100, ο/η Alejandro Guerrieri >>> έγραψε: >>> >>> It's probably an issue with single quotes on dlr text. Can you provide a full pdu dump for the DLR? Regards, Alex On Thu, Nov 18, 2010 at 6:21 PM, Peter wrote: Dear friends, I found that in the last patch still reproduces 2010-11-18 18:29:01 [10182] [3] DEBUG: smsbox_to_bearerbox: sms received 2010-11-18 18:29:01 [10182] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit date:1011181629 done date:1011181629 sta' at line 1 2010-11-18 18:29:09 [10182] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit date:1011181729 done date:1011181629 sta' at line 1 Can you verify that this is a problem of null (or something else?). In this case dlrs are received by our application using smssend ==>> smsbox ==>>sqlbox==>>bearer box but records are not inserted in mysql sent-sms table. Please check. Best regards Peter Kontopoulos Στις 14-11-2010, ημέρα Κυρ, και ώρα 19:45 +0700, ο/η Willy Mularto έγραψε: > I have used the latest SVN to work with Kannel early 2009 CVS version (1 > version before 1.4.3 was released). I found it still reproduce my > previous error. I think I need to use the same Kannel SVN as well. So I > re apply patch from Rene :) > > > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri wrote: > >> Sure, let me give you a couple of hints: >> >> >> * url-encode msgdata and udhdata, for example: >> >> >> udh = %06%05%04%0B%84%23%F0 >> msgdata = %1B%06%01%AE%02%05%6A... >> >> >> * You'll probably need to set alt_dcs = 1 >> >> >> Hope it helps, >> >> >> Alex >> >> On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto >> wrote: >> Will play with it tonight and hope those errors disapear and hopefully >> no need to use sendsms to send wap push anymore. Many thanks to Alex, >> Rene and all Kannel project+addons developers. >> >> >> >> >> >> >> sangprabv >> sangpr...@gmail.com >> http://www.petitiononline.com/froyo/ >> >> >> >> >> >> On Nov 12, 2010, at 9:03 PM, Alejandro Guerrieri wrote: >> >>> Yes, it url-encodes msgdata and udhdata when saving, and url-decodes >>> when reading. >>> >>> >>> It also allows wap pushes to work btw. >>> >>> >>> Regards, >>> >>> >>> Alex >>> >>> On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen >>> wrote: >>> Does it also encode normal text messages? Because those are the case, >>> here. >>> >>> >>> >>> == Rene >>> >>> >>> >>> From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] >>> Sent: Friday, 12 November, 2010 14:06 >>> To: Rene Kluwen >>> Cc: Willy Mularto; Kannel Users >>> Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug >>> >>> >>> >>> >>> >>> Can you try the latest revision? We applied a patch yesterday that >>> url-encodes msgdata and udhdata, I guess it should fix this issue as >>> well. >>> >>> >>> >>> Regards, >>> >>> >>> >>> >>> Alex >>>
Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug
Hi, excuse my ignorance but i do not know where the devel archives are in the svn (is it something like .../sqlbox/devel?), where do i find the patch and how to apply it. Is it possible to guide me on that? why this patch was not commited into trunk yet? Best regards Στις 19-11-2010, ημέρα Παρ, και ώρα 07:34 +0700, ο/η Willy Mularto έγραψε: > Rene has the patch for the issue. Please check the devel archives. > > > > > > > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > > > On Nov 19, 2010, at 1:19 AM, Alejandro Guerrieri wrote: > > > > > Hrm, no, that DLR doesn't even include single quotes, that's an > > artifact from the log. > > > > > > > > > > > > > > On Thu, Nov 18, 2010 at 6:51 PM, Peter wrote: > > > > Alejandro, > > I send you the requested dump plus typical log files > > > > ... > > > > > > > > Στις 18-11-2010, ημέρα Πεμ, και ώρα 18:31 +0100, ο/η > > Alejandro Guerrieri έγραψε: > > > > > > > > > > > It's probably an issue with single quotes on dlr text. > > > > > > > > > Can you provide a full pdu dump for the DLR? > > > > > > > > > Regards, > > > > > > > > > Alex > > > On Thu, Nov 18, 2010 at 6:21 PM, Peter > > > wrote: > > > > > > Dear friends, > > > > > > I found that in the last patch still reproduces > > > > > > 2010-11-18 18:29:01 [10182] [3] DEBUG: > > > smsbox_to_bearerbox: sms received > > > 2010-11-18 18:29:01 [10182] [4] ERROR: MYSQL: You > > > have an error in your SQL syntax; check the manual > > > that corresponds to your MySQL server version for > > > the right syntax to use near ''id:1219071490 > > > sub:001 dlvrd:001 submit date:1011181629 done > > > date:1011181629 sta' at line 1 > > > 2010-11-18 18:29:09 [10182] [4] ERROR: MYSQL: You > > > have an error in your SQL syntax; check the manual > > > that corresponds to your MySQL server version for > > > the right syntax to use near ''id:1219071490 > > > sub:001 dlvrd:001 submit date:1011181729 done > > > date:1011181629 sta' at line 1 > > > > > > Can you verify that this is a problem of null (or > > > something else?). > > > > > > In this case dlrs are received by our application > > > using > > > smssend ==>> smsbox ==>>sqlbox==>>bearer box > > > > > > but records are not inserted in mysql sent-sms > > > table. > > > > > > Please check. > > > Best regards > > > Peter Kontopoulos > > > > > > Στις 14-11-2010, ημέρα Κυρ, και ώρα 19:45 +0700, > > > ο/η Willy Mularto έγραψε: > > > > > > > > > > > > > I have used the latest SVN to work with Kannel > > > > early 2009 CVS version (1 version before 1.4.3 > > > > was released). I found it still reproduce my > > > > previous error. I think I need to use the same > > > > Kannel SVN as well. So I re apply patch from > > > > Rene :) > > > > > > > > > > > > > > > > > > > > > > > > sangprabv > > > > sangpr...@gmail.com > > > > http://www.petitiononline.com/froyo/ > > > > > > > > > > > > > > > > On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri > > > > wrote: > > > > > > > > > > > > > Sure, let me give you a couple of hints: > > > > > > > > > > > > > > > * url-encode msgdata and udhdata, for > > > > > example: > > > > > > > > > > > > > > > udh = %06%05%04%0B%84%23%F0 > > > > > msgdata = %1B%06%01%AE%02%05%6A... > > > > > > > > > > > > > > > * You'll probably need to set alt_dcs = 1 > > > > > > > > > > > > > > > Hope it helps, > > > > > > > > > > > > > > > Alex > > > > > > > > > > On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto > >
DLR request is "prohibited" so...?
Halo again list, How could I get the sent sms status, if SMSC "prohibited" in using DLR request? Like my thread before, the SMSC will send many error code based on their spec. And those error will appear on bb log. And I only just play around with gw/smsc/smpp_pdu.c and gw/smsc/smpp_pdu.h to make the message more meaningful for me. For now, I'm using php to send the sms to /cgi-bin/sendsms, but I still don't know how to capture the sent status in script without using DLR request (success or custom error code) Thanks in advanced
Re: SQLBox Sent SMS
So is this an update to SQLBOX? Because I just compiled from the latest svn source, and still having same issue.. Or should i be compiling kannel from latest? Regards, James On Fri, Nov 19, 2010 at 2:53 PM, Alejandro Guerrieri < alejandro.guerri...@gmail.com> wrote: > All patches Renee proposed were already commited afaik. > > Regards, > > Alex > > > On Fri, Nov 19, 2010 at 7:58 AM, James E wrote: > >> Hi Will, >> >> It is SMPP DLR, cant see any error. >> >> Rene, do you have the patch available? Or is it going to be committed to >> the latest svn soon? >> >> Regards, >> J >> >> On Fri, Nov 19, 2010 at 1:42 PM, Willy Mularto wrote: >> >>> Is there any error log? Is it SMPP DLR? If yes then maybe you need a >>> patch provided by Rene. Or you can find it in the devel list archives. >>> >>> >>> >>> >>> sangprabv >>> sangpr...@gmail.com >>> http://www.petitiononline.com/froyo/ >>> >>> >>> On Nov 19, 2010, at 1:30 PM, James E wrote: >>> >>> Kannel sqlbox version `1.5.0'. >>> Kannel 1.5 (Kannel bearerbox version `svn-r4871'.) >>> >>> J >>> >>> >>> On Fri, Nov 19, 2010 at 1:24 PM, Willy Mularto wrote: >>> May we know your Kannel and SQLBox version? sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 19, 2010, at 1:15 PM, James E wrote: > Hi, > > I am just wondering if anyone else is experiencing this issue. > > When we send an sms via sqlbox (send_sms table) the sms gets sent fine, and the MT message is placed in sent_sms. > > However, on random occasions, no DLR info will be inserted into the sent_sms table, but there is a DLR in the kannel access logs. > > Also, if I send the same sms again, it works 100%. > > Regards, > J >>> >>> >> >
