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