Thought so…. Try to upgrade ti 1.5.0 it uses prepared statements for MySQL, so if you have any special characters in your MySQL INSERT they will be escaped.
Den 14/10/2011 kl. 18.12 skrev Kolawole Dipo: > I am using version 1.4.3 > > --- On Fri, 14/10/11, Mads N. Vestergaard - CoolSMS A/S <m...@coolsms.com> > wrote: > > From: Mads N. Vestergaard - CoolSMS A/S <m...@coolsms.com> > Subject: Re: High level of failed messages in Kannel > To: "Tebbayo" <dipok...@yahoo.co.uk> > Cc: users@kannel.org > Date: Friday, 14 October, 2011, 18:09 > > Hi Tebbayo, > > I think this is an old bug. > > What version of kannel are you using ? > > Den 14/10/2011 kl. 18.05 skrev Tebbayo: > > > > > I have this Kannel Installation for sending SMS from a web interface (using > > PHP) to SMSC providers via SMPP eg Clickatel, Infobip MACH etc > > It works but I notice that messages fail at random and the number of failed > > messages increases quite quickly. Resulting in messages not being > > delivered. > > This has been a major Big Big pain for me for a while now. So I enabled > > access logs to see what was going on and this is what I got > > > > 2011-09-18 06:36:31 [5091] [11] ERROR: SMPP[Infobip]: got DLR but could not > > find message or was not interested in it id<2473931362> dst<2348055179232>, > > type<1> > > 2011-09-18 06:36:31 [5091] [11] WARNING: DLR[mysql]: DLR from SMSC<Infobip> > > for DST<2348077371729> not found. > > 2011-09-18 06:36:31 [5091] [11] ERROR: SMPP[Infobip]: got DLR but could not > > find message or was not interested in it id<2474940455> dst<2348077371729>, > > type<2> > > 2011-09-18 06:36:31 [5091] [11] WARNING: DLR[mysql]: DLR from SMSC<Infobip> > > for DST<2348073197754> not found. > > 2011-09-18 06:36:31 [5091] [11] ERROR: SMPP[Infobip]: got DLR but could not > > find message or was not interested in it id<2474395476> dst<2348073197754>, > > type<1> > > 2011-09-18 06:36:31 [5091] [11] WARNING: DLR[mysql]: DLR from SMSC<Infobip> > > for DST<2348122242914> not found. (Is this because the dlr-url was not > > specified for a message? ,not all messages have DLR URL specified) > > I also get this > > 2011-10-12 17:11:30 [12866] [16] WARNING: Cannot find SMSCConn for > > Message to <23480347343>, rejected. > > 2011-10-12 17:11:30 [12866] [16] WARNING: Message rejected by bearerbox, no > > router! > > And this > > 2011-09-18 08:08:52 [5091] [26] 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 'DAY!', '+2348066037710', 'sensei', > > 'http://myurl.com/deliveryreport.php?ty' at line 1 (I believe this to be a > > script error on that URL but why is Kannel reporting it? Also, I noticed > > that Delivery reports are not being processed quickly enough so they end up > > queuing up to massive amounts and slowing down services could that be due > > to this script error? ) > > > > This is just part of it. I get A LOT of this. (I have like 200MB of log!) > > attached is a screenshot of the http status > > http://old.nabble.com/file/p32652998/Capture.png > > > > I amount of numbers failure is unusual and I have a feeling it has to do > > with the configuration file. Below this post is a copy of the config file > > .There are 2 SMSCs each one to handle traffic for particular network prefix > > I did not setup this particular installation of Kannel but now I want to > > setup kannel afresh on a different server and I need to avoid all the > > problems experienced with this setup. > > I would be extremely and enormously grateful if you could look into this for > > me and see what is being done wrong with this installation so I can avoid it > > in the next. > > > > http://old.nabble.com/file/p32652998/smskannel.conf.txt smskannel.conf.txt > > > > > > -- > > View this message in context: > > http://old.nabble.com/High-level-of-failed-messages-in-Kannel-tp32652998p32652998.html > > Sent from the Kannel - User mailing list archive at Nabble.com. > > > > >
