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 jam...@gmail.com 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 sangpr...@gmail.comwrote: 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 sangpr...@gmail.comwrote: 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
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
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 p...@locosms.gr 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 p...@locosms.gr 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 sangpr...@gmail.com 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
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 p...@locosms.gr 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 p...@locosms.gr 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 sangpr...@gmail.com 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 rene.klu...@chimit.nl 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 On Fri, Nov 12, 2010 at 1:52 PM, Rene Kluwen rene.klu...@chimit.nl wrote: This patch should solve the issue. -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Rene Kluwen 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
Re: users Digest, Vol 51, Issue 63
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 On Fri, Nov 12, 2010 at 1:52 PM, Rene Kluwen rene.klu...@chimit.nl wrote: This patch should solve the issue. -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Rene Kluwen 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.grwww.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.grwww.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.grwww.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
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.grwww.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 p...@locosms.gr 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.grwww.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, Are you saying one has to url-encode before passing data into msgdata and udhdata? Please confirm. -- Regards Kenny 2010/11/19 Alejandro Guerrieri alejandro.guerri...@gmail.com 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 p...@locosms.gr 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.grwww.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 gwij...@gmail.com To: users@kannel.org 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
It should work fine now, I've tested it :) 2010/11/19 Kenny ken.bell...@gmail.com Alex...that's fantastic. :) Willy.. have you tested this with wappush? Am going to do that presently. -- Regards Kenny 2010/11/19 Alejandro Guerrieri alejandro.guerri...@gmail.com 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 ken.bell...@gmail.com 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 alejandro.guerri...@gmail.com 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 p...@locosms.gr 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.grwww.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
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 ken.bell...@gmail.com Alex...that's fantastic. :) Willy.. have you tested this with wappush? Am going to do that presently. -- Regards Kenny 2010/11/19 Alejandro Guerrieri alejandro.guerri...@gmail.com 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 ken.bell...@gmail.com 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 alejandro.guerri...@gmail.com 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 p...@locosms.gr 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.grwww.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