Kannel re-queue infinitely the failing SMS
Hi, I use a MultiTech MultiConnect Cell 100 (MTC-H5-B03-KIT) as GSM modem. I'm using Kannel version 1.5.0 on a Debian x64 with PlaySMS 1.4. It works fine mostly now, but I currently got some CMS ERROR 38 on sending SMS (with some concatened), I think it comes because my PDU is giving a false receiver number that can't receive SMS, so it's user error. I've set sms-resend-retry = 1 in the config, I know there was a problem about that with concatened SMS (Kannel ignoring sms-resend-retry: http://www.kannel.org/pipermail/users/2010-January/009862.html), that's why I use the 1.5 that got the patch about that. Here is the log about those retries: 2016-10-11 16:53:45 [6609] [6] WARNING: Maximum retries for message exceeded, discarding it! 2016-10-11 16:53:45 [6609] [6] DEBUG: Set split msg status to 6 2016-10-11 16:53:45 [6629] [6] DEBUG: AT2[multic1]: detecting modem type 2016-10-11 16:53:45 [6629] [6] INFO: AT2[multic1]: opening device 2016-10-11 16:53:45 [6629] [6] DEBUG: AT2[multic1]: device opened. Telnet mode = 0 2016-10-11 16:53:46 [6629] [6] DEBUG: AT2[multic1]: device opened 2016-10-11 16:53:46 [6629] [6] INFO: AT2[multic1]: speed set to 115200 2016-10-11 16:53:46 [6629] [6] DEBUG: AT2[multic1]: --> ATZ^M 2016-10-11 16:53:46 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:46 [6629] [6] DEBUG: AT2[multic1]: --> AT^M 2016-10-11 16:53:47 [6629] [6] DEBUG: AT2[multic1]: <-- AT 2016-10-11 16:53:47 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:47 [6629] [6] DEBUG: AT2[multic1]: --> ^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: --> AT^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- AT 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: --> AT&F^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- AT&F 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: --> ATE0^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- ATE0 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: --> ATI^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- 332 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: found string <332>, using modem definition 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: --> AT+CSMS=?^M 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- +CSMS: (0,1) 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:49 [6629] [6] INFO: AT2[multic1]: Phase 2+ is supported 2016-10-11 16:53:49 [6629] [6] INFO: AT2[multic1]: Closing device 2016-10-11 16:53:49 [6629] [6] INFO: AT2[multic1]: opening device 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: device opened. Telnet mode = 0 2016-10-11 16:53:49 [6629] [6] DEBUG: AT2[multic1]: device opened 2016-10-11 16:53:49 [6629] [6] INFO: AT2[multic1]: Logging in 2016-10-11 16:53:50 [6629] [6] INFO: AT2[multic1]: init device 2016-10-11 16:53:50 [6629] [6] INFO: AT2[multic1]: speed set to 115200 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> ATZ^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- AT 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT&F^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- AT&F 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> ATE0^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- ATE0 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT+IFC=2,2^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT+CSCA=" +33660003000"^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT+CMGF=0^M 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:50 [6629] [6] DEBUG: AT2[multic1]: --> AT+CSMS=?^M 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- +CSMS: (0,1) 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:51 [6629] [6] INFO: AT2[multic1]: Phase 2+ is supported 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: --> AT+CSMS=1^M 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- +CSMS: 1,1,1 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: --> AT+CSQ;+CGDCONT=1,"IP","mmsbouygtel.com";+CSMS=1;#SGACTCFG=1,3,200^M 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- +CSQ: 17,0 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- +CSMS: 1,1,1 2016-10-11 16:53:51 [6629] [6] DEBUG: AT2[multic1]: <-- OK 2016-10-11 16:53:51 [6629] [6] INFO: AT2[multic1]: AT S
Re: SMS Reports
Please search mysql trigger or mysql indexing On Tuesday 11 October 2016, Web Services wrote: > Hi Vinayak, > > thanks for your reply > > can you please explain little more about this ? > > Thanks > > On Tue, Oct 11, 2016 at 4:06 PM, vinayak mv > wrote: > >> Better index the searching fields >> >> >> On Tuesday 11 October 2016, Web Services > > wrote: >> >>> Dear All, >>> >>> i want to discus an little issue which i face with my sms >>> server/application >>> >>> am using kannel 1.4.4 along with sqlbox and also i have develop full php >>> script for sending sms and check reports >>> >>> all things works fine but i have little issue with reports sync >>> >>> all reports comes from operator/smpp directly insert to my sql-box table >>> sent_sms and another my php script sync this reports to my reporting >>> database. >>> >>> but my php script take very long time to update my reports to my >>> reporting DB >>> >>> now my question is : how i can improve speed of my php script for sync >>> DB one solution which i have is upgrade server configuration any alternate >>> solution is valuable. >>> >>> please suggest if you have any alternate solution >>> >>> Thanks >>> >>> Deepak >>> >> >> >> -- >> Thanks & Regards, >> Vinayak >> >> == >> >> *Confucius* once said, >> "*Life is really simple, but we insist on making it complicated.*" >> >> *Leonardo da Vinci* once said, >> "*Simplicity is the ultimate sophistication.*" >> >> *Albert Einstein* once said, >> "*Everything should be made as simple as possible, but not simpler.*" >> >> >> >> > -- Thanks & Regards, Vinayak == *Confucius* once said, "*Life is really simple, but we insist on making it complicated.*" *Leonardo da Vinci* once said, "*Simplicity is the ultimate sophistication.*" *Albert Einstein* once said, "*Everything should be made as simple as possible, but not simpler.*"
Re: SMS Reports
Hi Vinayak, thanks for your reply can you please explain little more about this ? Thanks On Tue, Oct 11, 2016 at 4:06 PM, vinayak mv wrote: > Better index the searching fields > > > On Tuesday 11 October 2016, Web Services wrote: > >> Dear All, >> >> i want to discus an little issue which i face with my sms >> server/application >> >> am using kannel 1.4.4 along with sqlbox and also i have develop full php >> script for sending sms and check reports >> >> all things works fine but i have little issue with reports sync >> >> all reports comes from operator/smpp directly insert to my sql-box table >> sent_sms and another my php script sync this reports to my reporting >> database. >> >> but my php script take very long time to update my reports to my >> reporting DB >> >> now my question is : how i can improve speed of my php script for sync DB >> one solution which i have is upgrade server configuration any alternate >> solution is valuable. >> >> please suggest if you have any alternate solution >> >> Thanks >> >> Deepak >> > > > -- > Thanks & Regards, > Vinayak > > == > > *Confucius* once said, > "*Life is really simple, but we insist on making it complicated.*" > > *Leonardo da Vinci* once said, > "*Simplicity is the ultimate sophistication.*" > > *Albert Einstein* once said, > "*Everything should be made as simple as possible, but not simpler.*" > > > >
Re: SMS Reports
Better index the searching fields On Tuesday 11 October 2016, Web Services wrote: > Dear All, > > i want to discus an little issue which i face with my sms > server/application > > am using kannel 1.4.4 along with sqlbox and also i have develop full php > script for sending sms and check reports > > all things works fine but i have little issue with reports sync > > all reports comes from operator/smpp directly insert to my sql-box table > sent_sms and another my php script sync this reports to my reporting > database. > > but my php script take very long time to update my reports to my reporting > DB > > now my question is : how i can improve speed of my php script for sync DB > one solution which i have is upgrade server configuration any alternate > solution is valuable. > > please suggest if you have any alternate solution > > Thanks > > Deepak > -- Thanks & Regards, Vinayak == *Confucius* once said, "*Life is really simple, but we insist on making it complicated.*" *Leonardo da Vinci* once said, "*Simplicity is the ultimate sophistication.*" *Albert Einstein* once said, "*Everything should be made as simple as possible, but not simpler.*"
SMS Reports
Dear All, i want to discus an little issue which i face with my sms server/application am using kannel 1.4.4 along with sqlbox and also i have develop full php script for sending sms and check reports all things works fine but i have little issue with reports sync all reports comes from operator/smpp directly insert to my sql-box table sent_sms and another my php script sync this reports to my reporting database. but my php script take very long time to update my reports to my reporting DB now my question is : how i can improve speed of my php script for sync DB one solution which i have is upgrade server configuration any alternate solution is valuable. please suggest if you have any alternate solution Thanks Deepak