DLRs queueing in Kannel after being injected in http smsc

Hi,
we are currently working on a kannel system that is using two kannel instances with two sqlbox instances and an php http router in the middle.

client –> opensmppbox –> sqlbox1 –> bearerbox1 –> http-router –> smsbox2 –> sqlbox2 –> bearerbox2 –> smsc

We’ve done everything according to the book. Made several adjustments along the way to fasten things up. And all was working nicely until our client got a higher traffic from his smpp client and our supplier failed to deliver some dlrs. He later delivered them via cms file but they never went through our kannel system. All of a sudden the traffic got slow, and dlrs started queuing up. Since we did a whole system revamp at that time we though that it was due to configuration. So we tried several things in order to get it fixed. At the end i found this post:
https://www.mail-archive.com/users@kannel.org/msg30978.html

It turned out to be a problem in dlr tables. I didn’t set the indexes in dlr tables since they were created by the kannel and opensmppbox. Well, the second i set the indexes on dlr tables, traffic started flowing again.

So tip of the day:

HAVE YOUR TABLES INDEXED. DLR TABLES SHOULD HAVE TS AND URL FIELDS SET AS INDEXES.

I hope this helps someone.

Published by Iva Korlevic

I'm a web programmer that started working with web pages in 2008 by programming simple HTML/CSS webpages. I finished Faculty of electrical engineering in April 2010 and started working in Inchoo in May 2010. During the time in Inchoo I worked on Zend applications, Magento stores and a few Wordpress projects. I left Inchoo in January 2012 and worked for a couple of months in Gauss Informatika as Zend teacher and team leader. In May 2012 I left Gauss Informatika and joined the team at NTH Media. For next 6 months I worked on various mobile and Wordpress projects. In the February 2013 together with MArin Blazevic I opened Proodos. I'm still continuing my work as Zend and Magento programmer. In summer 2015 I also started to work for Webbite Media GMBH and on 19th August 2015 I passed Magento Certification Exam and am now Magento Certified Developer.

Leave a comment

Your email address will not be published. Required fields are marked *