Dear Team, I am using kannel 1.4.3 .i will be send port(5000) wise message give me some suggestion.
On Fri, Nov 19, 2010 at 3:00 PM, <[email protected]> wrote: > Send users mailing list submissions tot > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.kannel.org/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug (Willy Mularto) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 19 Nov 2010 16:30:08 +0700 > From: Willy Mularto <[email protected]> > To: Peter <[email protected]> > Cc: Kannel Users <[email protected]> > Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > http://www.mail-archive.com/[email protected]/ > http://www.mail-archive.com/[email protected]/ > > > > sangprabv > [email protected] > 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 > >> [email protected] > >> 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 <[email protected]> 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 <[email protected]> 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 > >>>>> [email protected] > >>>>> 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 <[email protected]> > 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 > >>>>>> [email protected] > >>>>>> 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 < > [email protected]> wrote: > >>>>>>> Does it also encode normal text messages? Because those are the > case, here. > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> == Rene > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> From: Alejandro Guerrieri [mailto:[email protected]] > >>>>>>> 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 < > [email protected]> wrote: > >>>>>>> > >>>>>>> This patch should solve the issue. > >>>>>>> > >>>>>>> > >>>>>>> -----Original Message----- > >>>>>>> From: [email protected] [mailto:[email protected]] > 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: [email protected] [mailto:[email protected]] > 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 > >>>>>>> [email protected] > >>>>>>> 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 [email protected], 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 [email protected], 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 [email protected], 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 > [email protected] > http://www.kannel.org/mailman/listinfo/users > > > End of users Digest, Vol 51, Issue 63 > ************************************* >
