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 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 >