Re: My sqlbox delivery report problem
Hi, Can i have remote view ??? *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Jan 21, 2015 at 5:10 AM, Geni Areng geniar...@gmail.com wrote: Could some body help me, please. I am stucked with this problem. Even I used fakesms, my sqlbox still stopped to update its dlr status at the 51th. Are there something in the sqlbox config I miss? Senin, 19 Januari 2015, Geni Areng geniar...@gmail.com menulis: Hi list, My sqlbox only updated the delivery report status for the 1st until the 50th message. But it didn't update for the rest (51th - ...). Below is my kannel.conf: group = core dlr-storage = mysql admin-port = 13000 admin-password = secret status-password = secret wdp-interface-name = * log-file = /var/log/kannel/bearerbox.log log-level = 0 smsbox-port = 13001 box-allow-ip = 127.0.0.1 # SMSC Fake group = smsc smsc = fake smsc-id = FAKE port = 1 group = smsc smsc = at host = localhost smsc-id = telkomsel modemtype = wavecom device = /dev/ttyS0 speed = 115200 my-number = +628123456789 connect-allow-ip = 127.0.0.1 sms-center = +628110 group = modems id = WAVECOM name = wavecom detect-string = WAVECOM init-string=ATZ init-string=ATQ0 V1 E1 S0=0 C1 D2 +FCLASS=0 init-string=AT+CNMI=2,1,2,1,0;+CMEE=1 group = smsbox bearerbox-host = localhost sendsms-port = 13013 sendsms-chars = 0123456789+ global-sender = +628123456789 log-file = /var/log/kannel/smsbox.log log-level = 0 access-log = /var/log/kannel/access.log group = smsbox-route smsbox-id = sqlbox smsc-id = telkomsel group = sendsms-user username = kannel password = secret default-smsc = telkomsel max-messages = 10 concatenation = true group = sms-service keyword = default accept-x-kannel-headers = true max-messages = 0 assume-plain-text = true group = mysql-connection id = mydlr host = localhost username = kannel password = secret database = kannel max-connections = 1 # DLR table structure group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc sqlbox.conf: group = sqlbox id = sqlbox-db smsbox-id = sqlbox bearerbox-host = localhost bearerbox-port = 13001 sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/kannel-sqlbox.log log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = root password = secret database = kannel Thanks for any help.
Re: Minimum Requirement for getting 1000 message per second
Hi Everyone, with 2 cores , 2 GB Ram 20 GB H.D.D. In a virtual Machine with 512 Kbps ILL. I am getting 550 TPS with my Live (Mobile) Operator. 2 Sessions with 250+ tps each My Settings: 1. SMS APP SQLBOX Bearerbox 2. Kannel sql box log level =3 3. log file is placed in a partition with ext2 4. Dlr are placed in mysql table. 5. Spool folder is placed in ext2 6. Mysql 5.5 7. Centos 6.6 8. 1 Sqlbox 9. 2 mysql connections in kannel sqlbox With the above I am getting 550+ TPS. I want to try with 4 cores, 2+ Sqlboxes. Sqlbox performance Smsboxes as smsboxes have to hit a webpage, open mysql ,run query close connection. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 16, 2015 at 7:14 PM, Ammar Ali ammarali3...@gmail.com wrote: Hi David Szanto, I'm also testing with multiple SQLBoxes. This is the my configuration: *Application---BBox---Multiple SQLBoxes---SMSBoxMultiple SMSC (Fake)* But I'm not getting better performance. Thanks in advance. *Ammar Ali* *Framp Technology* *Pune (Maharashtra)* On Fri, Jan 16, 2015 at 7:05 PM, David Szanto dsza...@genasys.com wrote: Hi Ammar! I suggest you check the load in the SQLBox, BearerBox, MySQL and SMSBox. Our experience is that Mysql tends to slow things down a lot. Another enhancement we've had success with has been having 3-6 SMSBox instances running and connected to the bearerbox, and HAProxy on top distributing messages among them. SMSBoxes are very scalable, and can even be set on separate machines. Ideally, something like: Application+SMSBOX Bearerbox+Backends(ex:Mysql) SMSC Yet, you must check where is the actual bottleneck. On our experience it was MySQL. Finally, and again on our experience, Bearerbox will load CPU as it gets overworked, but RAM will be consumed only as long as messages are in queue (in RAM), Ex: pending DLR without DDBB backend (managed in memory) Hope this helps Cheers, David Szanto El 16/01/15 a las 13:24, Ammar Ali escribió: Hello Everyone, I had started kannel sms gateway before past 2 days. When I was started kannel then tested my application, it shows me 500-800 messages second speed but now I'm getting 200-300 Max messages/second. And the main problem is that it is not increased above 300. Can you suggest me that what is the main bottleneck in whole system setup. Because currently I'm connecting Fake SMSC connections. Thanks in advance *Ammar Ali* *Framp Technology* *Pune (Maharashtra)* On Fri, Jan 16, 2015 at 5:29 PM, Christopher Burke christopher.bu...@simulity.com wrote: Hey, If you’re attempting to optimise the solution, you’ll probably want to look at a testbed. Check out https://github.com/twitter/cloudhopper-smpp which is a Java SMPP implementation. I use this and on my 2012 Macbook Pro (2.6ghz i7/8GB RAM/512GB SSD) I get 4.8k submit/sec over 10 sessons when I use Netty 6. Perhaps you can setup another box using the ch-smpp impl for listening (they’ve got performance code/configuration examples in the test/../demo dirs, and have your Kannel submit to it. On the configuration you currently have, you should expect 200-300 msg/sec using Kannel, I’ve never seen it submit much faster than that but admittedly I find understanding Java code a bit easier so I work with ch-smpp more now. Cheers, *Christopher Burke *http://simulity.com Office: +44 (0) 1248 679 281 Fax: +44 (0) 1248 660 323 Skype:krslynx *UK *Unit 8, Ash Court, Parc Menai, Bangor, Gwynedd, LL57 4DF, Wales, UK *Malaysia *Level 30, The Gardens North Tower, Mid Valley City, Lingkaran Syed Putra, 59200, Kuala Lumpur, Malaysia NOTICE: This message contains privileged confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message, you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error, please notify Simulity Labs immediately. Any views expressed in this message are those of the individual sender except where the sender specifically states them to be the view of Simulity Labs On 16 January 2015 at 11:13:34, Mohammed Saleem (mohammedsl...@gmail.com) wrote: Hi Then specs you have is more than enough to send even 10k SMS / second with correct configurations. But the bottleneck is the network speed and the allowed TPS from the operator. On Jan 16, 2015 1:40 PM, Ammar Ali ammarali3...@gmail.com wrote: Hello Currently, I have 4 GB RAM, Intel 24 Core Processor and 120 GB HDD but I'm not getting this TPS (300-500) in a second. Kannel bearerbox version `1.4.4'. Build `Dec 31 2014 18:29:22', compiler `4.4.7 20120313 (Red Hat 4.4.7-11)'. System Linux, release 2.6.32-042stab094.7, version #1 SMP
Re: Minimum Requirement for getting 1000 message per second
Hi, use dlr-storage as mysql db. On 1/17/15, Ammar Ali ammarali3...@gmail.com wrote: Hey, I have one more serious issue. Kannel Bearerbox consumes 28% of My total RAM. So Can you suggest me where is actual issue in my whole setup? *Ammar Ali* *Framp Technologies* *Pune (Maharashtra)* On Fri, Jan 16, 2015 at 11:20 PM, RK Krishnas r...@krishnasoft.in wrote: Hi Everyone, with 2 cores , 2 GB Ram 20 GB H.D.D. In a virtual Machine with 512 Kbps ILL. I am getting 550 TPS with my Live (Mobile) Operator. 2 Sessions with 250+ tps each My Settings: 1. SMS APP SQLBOX Bearerbox 2. Kannel sql box log level =3 3. log file is placed in a partition with ext2 4. Dlr are placed in mysql table. 5. Spool folder is placed in ext2 6. Mysql 5.5 7. Centos 6.6 8. 1 Sqlbox 9. 2 mysql connections in kannel sqlbox With the above I am getting 550+ TPS. I want to try with 4 cores, 2+ Sqlboxes. Sqlbox performance Smsboxes as smsboxes have to hit a webpage, open mysql ,run query close connection. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 16, 2015 at 7:14 PM, Ammar Ali ammarali3...@gmail.com wrote: Hi David Szanto, I'm also testing with multiple SQLBoxes. This is the my configuration: *Application---BBox---Multiple SQLBoxes---SMSBoxMultiple SMSC (Fake)* But I'm not getting better performance. Thanks in advance. *Ammar Ali* *Framp Technology* *Pune (Maharashtra)* On Fri, Jan 16, 2015 at 7:05 PM, David Szanto dsza...@genasys.com wrote: Hi Ammar! I suggest you check the load in the SQLBox, BearerBox, MySQL and SMSBox. Our experience is that Mysql tends to slow things down a lot. Another enhancement we've had success with has been having 3-6 SMSBox instances running and connected to the bearerbox, and HAProxy on top distributing messages among them. SMSBoxes are very scalable, and can even be set on separate machines. Ideally, something like: Application+SMSBOX Bearerbox+Backends(ex:Mysql) SMSC Yet, you must check where is the actual bottleneck. On our experience it was MySQL. Finally, and again on our experience, Bearerbox will load CPU as it gets overworked, but RAM will be consumed only as long as messages are in queue (in RAM), Ex: pending DLR without DDBB backend (managed in memory) Hope this helps Cheers, David Szanto El 16/01/15 a las 13:24, Ammar Ali escribió: Hello Everyone, I had started kannel sms gateway before past 2 days. When I was started kannel then tested my application, it shows me 500-800 messages second speed but now I'm getting 200-300 Max messages/second. And the main problem is that it is not increased above 300. Can you suggest me that what is the main bottleneck in whole system setup. Because currently I'm connecting Fake SMSC connections. Thanks in advance *Ammar Ali* *Framp Technology* *Pune (Maharashtra)* On Fri, Jan 16, 2015 at 5:29 PM, Christopher Burke christopher.bu...@simulity.com wrote: Hey, If you’re attempting to optimise the solution, you’ll probably want to look at a testbed. Check out https://github.com/twitter/cloudhopper-smpp which is a Java SMPP implementation. I use this and on my 2012 Macbook Pro (2.6ghz i7/8GB RAM/512GB SSD) I get 4.8k submit/sec over 10 sessons when I use Netty 6. Perhaps you can setup another box using the ch-smpp impl for listening (they’ve got performance code/configuration examples in the test/../demo dirs, and have your Kannel submit to it. On the configuration you currently have, you should expect 200-300 msg/sec using Kannel, I’ve never seen it submit much faster than that but admittedly I find understanding Java code a bit easier so I work with ch-smpp more now. Cheers, *Christopher Burke *http://simulity.com Office: +44 (0) 1248 679 281 Fax: +44 (0) 1248 660 323 Skype:krslynx *UK *Unit 8, Ash Court, Parc Menai, Bangor, Gwynedd, LL57 4DF, Wales, UK *Malaysia *Level 30, The Gardens North Tower, Mid Valley City, Lingkaran Syed Putra, 59200, Kuala Lumpur, Malaysia NOTICE: This message contains privileged confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message, you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error, please notify Simulity Labs immediately. Any views expressed in this message are those of the individual sender except where the sender specifically states them to be the view of Simulity Labs On 16 January 2015 at 11:13:34, Mohammed Saleem ( mohammedsl...@gmail.com) wrote: Hi Then specs you have is more than enough to send even 10k SMS / second with correct configurations. But the bottleneck
Re: Receiving multi-part messages over two binds...
Hi, As of My Knowledge, Kannel updates the dlr as soon as it received the 1st dlr itself. You will see an warning that dlr not found when the 2nd dlr report comes in. Mysql-Databse for dlr. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Jan 14, 2015 at 6:15 PM, Tapan Kumar Thapa tapan.thapa2...@gmail.com wrote: I am not an kannel expert but have you tried below. 1. Add both connectivity under single kannel instance. 2. Give same smsc-id to both connectivity under kannel (smsc-id = ) Check if this resolves your issue. On Wed, Jan 14, 2015 at 6:10 PM, Joe Power joe.po...@puca.com wrote: Hi folks, I have inherited a working Kannel platform with binds into multiple operators. I don't have much experience in configuring Kannel, but have seen what works on the existing platform. I have discovered an issue we have with multi-part messages from one of the operators we are connected to. The operator has 2 SMSCs with a shared SS7 stack (so they are effectively clustered as I understand it). As MO messages can come into either SMSC we have a separate bind into each one. However, when a multi-part MO message comes in, the individual parts can be handled by either SMSC. If a one part comes into one SMSC and is sent over its bind and the other part comes into the other SMSC and is sent over its bind then Kannel, as it is currently configured, won't match the two parts and concatenate them. What is currently happening is that Kannel is waiting for the other part(s) sent over the other bind and eventually times out and sends what it has. My questions are as follows: - 1 Is it possible to configure Kannel to treat both binds as connected to the one organisation and concatenate multi-part messages regardless of which of the two binds the parts come in on ? 2 If the above isn't possible, are there any other options to resolve the issue ? 3 What would the config file for such a configuration look like ? Any help appreciated. Regards, Joe.
Re: Authenticate incoming SMS
Hi Tapan, Please let me know how can we make Opensmppbox drop in comming sms to a Particular Data Base Table. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Tue, Jan 13, 2015 at 11:31 AM, Tapan Kumar Thapa tapan.thapa2...@gmail.com wrote: You can try this.. OPENSMPPBOX-BEARERBOX-SMSBOX-INVOKECUSTOMHTTPURL(In your custom HTTP code, make some logic for charging etc). On Tue, Jan 13, 2015 at 11:27 AM, Juned Khan jkhan6...@gmail.com wrote: Alvaro, thank you so much for response. How do I move incoming SMS to any file or db temporarily ? I mean in opensmppbox what parameter I have to set to do this, at what point I can get this incoming SMSs ? Regards Juned Khan / Network Engineer +91 9974740823/ juned.k...@inextrix.com iNextrix Technologies Pvt Ltd. www.inextrix.com http://htmlsig.com/www.inextrix.com [image: Facebook] https://www.facebook.com/junedkhan23 [image: Twitter] https://twitter.com/juned23 [image: Google Plus] https://plus.google.com/+JunedKhan [image: Linkedin] http://htmlsig.com/in.linkedin.com/in/junedk This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. Company Name is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company. On Tue, Jan 13, 2015 at 2:00 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi You have to doit at your app level. Kannel nor opensmpp are able to do that. As a hint, move all incomming sms to a temp file/table/db and have a script that do the validations you need and then fw the sms to the corresponding user. Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Mon, Jan 12, 2015 at 8:05 AM, Juned Khan jkhan6...@gmail.com wrote: Hi All, I have setup kannel along with opensmppbox, I want to authenticate incoming SMS for billing purpose i.e if that user has allowed to receive SMS from particular prefixes then SMS should be routed else not. How do I achieve this? is there any way to run any script(any language) before routing SMS to recipient in opensmppbox? Any hint or advice will be appreciated :) Regards Juned Khan / Network Engineer
Re: How to Improve Performance of SQLBox
Hi Leandro, Installed mysql community edition 6.5 but same result. 10 tps per session.. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Jan 5, 2015 at 7:53 PM, Tenorio, Leandro lean...@fliadt.com wrote: Hi, If both are on the same physical machine its not hardware nor O.S. have you tried MySQL community repository, you can get it from http://dev.mysql.com/downloads/repo/yum/ *From:* RK Krishnas [mailto:r...@krishnasoft.in] *Sent:* Monday, January 05, 2015 12:30 AM *To:* Tenorio, Leandro *Subject:* Re: How to Improve Performance of SQLBox Hi Virtual machine is installed on the same physical system. I am getting 150 tps from virtual machine. So I think no question of Lan switch. On Jan 5, 2015 2:24 AM, Tenorio, Leandro lean...@fliadt.com wrote: Change LAN board, cable and switch port. -- *From: * RK Krishnas r...@krishnasoft.in *Date: * January 3, 2015 12:42:14 PM *Subject: * Re: How to Improve Performance of SQLBox *To: * Tenorio, Leandro lean...@fliadt.com *CC: * spameden spame...@gmail.com, Aditya Khanna aditya.khanna111...@gmail.com, kannel users@kannel.org users@kannel.org Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *RK Krishnas *Sent:* Thursday, January 01, 2015 9:32 AM *To:* spameden *Cc:* Aditya Khanna; kannel users@kannel.org *Subject:* Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection
Re: How to Improve Performance of SQLBox
Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *RK Krishnas *Sent:* Thursday, January 01, 2015 9:32 AM *To:* spameden *Cc:* Aditya Khanna; kannel users@kannel.org *Subject:* Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw
Re: How to Improve Performance of SQLBox
Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: Happy NEW YEAR Kannel community
Dear Kannel Team, My Heartfull wishes for you. Thanking you all the time. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 2014-12-31 21:26 GMT+05:30 Alvaro Cornejo cornejo.alv...@gmail.com: Hi All I'll like to take a minute to thanks Kannel team and its community for their hard work during this 2014 and wish them and their families the best for this 2015. Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com
Re: How to Increase Performance of Outbound Messages
Hi Mr Khanna, I am struggling hard to increase my tps. 10 tps per session is what we have been restricted to. If u are able to solve it. Pls post your method. Thanks On Dec 1, 2014 3:10 PM, Aditya Khanna aditya.khanna111...@gmail.com wrote: Hello John, Thank you for your reply. What should be suitable value of this variable in SMSC group? Current I set value to 1000. Thanks Aditya Khanna On Mon, Dec 1, 2014 at 1:41 PM, John alero johnale...@gmail.com wrote: H, This is basic thing i.e How to Increase Performance of Outbound Messages Use: max-pending-submits= in your smsc configuration On Mon, Dec 1, 2014 at 1:31 PM, Aditya Khanna aditya.khanna111...@gmail.com wrote: Hello Everyone, When I'm sending message in bulk then I'm not getting a satisfactory performance using kannel. My current status is: outbound (5.42,4.22,2.81) msg/sec I'm also connecting multiple SMSC's connections. So please suggest me that how to increase this. I'm waiting for your response. Thanks, Aditya Khanna
Re: Kannel 1.5 on a 64-bit OS
Yes, I am working on 64 bit centos 6.5 from past 1 year. No issues at all. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Tue, Nov 11, 2014 at 12:00 AM, Lamasuta Franck f.lamas...@cobratelematics.com wrote: Hi all, We are running Kannel 1.5 on a server with RHEL4 (32 bits) and we are using the SMPP, CIMD2 and HTTP interfaces. We would like to upgrade the server to RHEL 6.4 (64 bits). Is Kannel fully compatible with a 64-bit OS? Regards, Franck
Re: Routing failed, re queued. Problem with sending SMS
HI, SMPP CONNECTION CONFIG SETTINGS FOR TX RX SEPARATELY. ###TX:: group=smsc smsc=smpp smsc-id=SMSC1 allowed-smsc-id=SMSC1 port = host = host.ip.address smsc-username = smppout smsc-password = smppout system-type = interface-version = 0x34 inquire-link-interval = 60 ###RX:: group=smsc smsc=smpp smsc-id=SMSC1 allowed-smsc-id=SMSC1 receive-port = host = host.ip.address smsc-username = smppout smsc-password = smppout system-type = interface-version = 0x34 inquire-link-interval = 60 *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Nov 7, 2014 at 6:44 PM, Pablo Gus pablo...@gmail.com wrote: Thanks for the answers, Alvaro, every time when the error occurs the SMSC connections seem to be UP and running (at least, there is no disconnection). We have 3 SMSC and each one have a smsc-id and a allowed-smsc configuration like the following: group=smsc smsc=smpp smsc-id=SMSC1 allowed-smsc-id=SMSC1 ... [more config] group=smsc smsc=smpp smsc-id=SMSC2 allowed-smsc-id=SMSC2 ... [more config] group=smsc smsc=smpp smsc-id=SMSC3 allowed-smsc-id=SMSC3 ... [more config] So in this case I do not think it is a misconfiguration error because there is no ambiguity with the allowed SMSCs, also when we send SMS to kannel we always indicate a valid SMSC-ID. If you see some error here, please let me know. Rajeev, do you have some example to configurate Rx and Tx separately? Also I checked the kannel page and I see that the 1.4.4 version is out. May be this version has a fix for this bug that you mentioned with the transceiver mode. Maybe we must go to 1.4.4 instead of 1.5.0. What do you think about this? Thanks again! Regards, Pablo. 2014-11-07 4:57 GMT-02:00 RK Krishnas r...@krishnasoft.in: Hi Every one, Problem may be you might have connected in transceiver mode. There is a bug we noticed that when ever there is a reconnection of single session in transceiver mode, the rx connects but the tx wont connect. So Initially try with tx rx seperately. Let me know the working. We faced same issue for 3 months solved it by 2 seperate sessions of tx rx. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Nov 7, 2014 at 2:17 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi This usually means kannel does not find a smsc available to route the sms to. - Check that your connections are all up and that they don't disconnect. - Check that you sent the messages with the correct smsc-id. You might have some messages routed a non existent route or have denied/allowed smsc misconfigured Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Thu, Nov 6, 2014 at 2:43 PM, Pablo Gus pablo...@gmail.com wrote: Hi all, We are having some issues with Kannel v1.5.0. At some moment the application is not able to send more messages, it can receive but it can't send more SMS. Tracing some info in the log we can see the following behaviour: kannel.log 2014-11-06 14:22:13 [20038] [1] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'. 2014-11-06 14:22:19 [20038] [14] DEBUG: send_msg: sending msg to box: 127.0.0.1 2014-11-06 14:22:19 [20038] [14] DEBUG: boxc_sender: sent message to 127.0.0.1 2014-11-06 14:22:19 [20038] [13] DEBUG: boxc_receiver: got ack 2014-11-06 14:22:19 [20038] [13] DEBUG: boxc_receiver: sms received 2014-11-06 14:22:19 [20038] [13] DEBUG: send_msg: sending msg to box: 127.0.0.1 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: time to sleep 30.00 secs. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: gwlist_len = 1 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: time to sleep 30.00 secs. sms-box.log 2014-11-06 14:22:19 [20091] [3] DEBUG: Stored UUID 5b62ad94-02ea
Re: Routing failed, re queued. Problem with sending SMS
Hi Every one, Problem may be you might have connected in transceiver mode. There is a bug we noticed that when ever there is a reconnection of single session in transceiver mode, the rx connects but the tx wont connect. So Initially try with tx rx seperately. Let me know the working. We faced same issue for 3 months solved it by 2 seperate sessions of tx rx. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Nov 7, 2014 at 2:17 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi This usually means kannel does not find a smsc available to route the sms to. - Check that your connections are all up and that they don't disconnect. - Check that you sent the messages with the correct smsc-id. You might have some messages routed a non existent route or have denied/allowed smsc misconfigured Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Thu, Nov 6, 2014 at 2:43 PM, Pablo Gus pablo...@gmail.com wrote: Hi all, We are having some issues with Kannel v1.5.0. At some moment the application is not able to send more messages, it can receive but it can't send more SMS. Tracing some info in the log we can see the following behaviour: kannel.log 2014-11-06 14:22:13 [20038] [1] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'. 2014-11-06 14:22:19 [20038] [14] DEBUG: send_msg: sending msg to box: 127.0.0.1 2014-11-06 14:22:19 [20038] [14] DEBUG: boxc_sender: sent message to 127.0.0.1 2014-11-06 14:22:19 [20038] [13] DEBUG: boxc_receiver: got ack 2014-11-06 14:22:19 [20038] [13] DEBUG: boxc_receiver: sms received 2014-11-06 14:22:19 [20038] [13] DEBUG: send_msg: sending msg to box: 127.0.0.1 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: time to sleep 30.00 secs. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: gwlist_len = 1 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: handling message (0x7f4344001670 vs 0x7f4344001670) 2014-11-06 14:22:19 [20038] [12] DEBUG: Routing failed, re-queued. 2014-11-06 14:22:19 [20038] [12] DEBUG: sms_router: time to sleep 30.00 secs. sms-box.log 2014-11-06 14:22:19 [20091] [3] DEBUG: Stored UUID 5b62ad94-02ea-446e-8fa3-32a3cee3fc0e 2014-11-06 14:22:19 [20091] [3] DEBUG: message length 147, sending 1 messages 2014-11-06 14:22:19 [20091] [3] DEBUG: Status: 202 Answer: Sent. 2014-11-06 14:22:19 [20091] [3] DEBUG: Delayed reply - wait for bearerbox Since the moment in which kannel gives routing failed error, the send-sms service for a particular SMSC stops working and we must restart that SMSC to operate again correctly. I will appreciate any contribution to this issue. Thanks in advance. Regards, Pablo.
Re: How to Improve Performance of SQLBox
Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com : *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: Disconnect Connection Between BearerBox And SqlBox
hi, We had Similar Issue. Can you send me the smstext in the queue at the time of crash. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Sat, Nov 1, 2014 at 5:04 PM, Aditya Khanna aditya.khanna111...@gmail.com wrote: Hello Everyone, I'm new with Kannel SMS Gateway. When I'm establishing connection between BearerBox, SMSBox and SqlBox. BearerBox and SMSBox connected successfully but BearerBox and SqlBox not connected permanently. In SqlBox Terminal Window, it shows me some error: Build `Nov 1 2014 03:02:34', compiler `4.4.7 20120313 (Red Hat 4.4.7-3)'. System Linux, release 2.6.18-028stab107.1, version #1 SMP Wed Apr 17 19:10:55 MSD 2013, machine x86_64. Hostname ip-166-62-16-78.ip.secureserver.net, IP 166.62.16.78. Libxml version 2.7.6. Using OpenSSL 1.0.0-fips 29 Mar 2010. Compiled with MySQL 5.5.37, using MySQL 5.5.37. Using native malloc. 2014-11-01 04:07:28 [8059] [0] INFO: Starting to log to file sqlbox.log level 0 2014-11-01 04:07:28 [8059] [0] INFO: Added logfile `sqlbox.log' with level `0'. 2014-11-01 04:07:28 [8059] [0] INFO: MYSQL: Connected to server at 127.0.0.1. 2014-11-01 04:07:28 [8059] [0] INFO: MYSQL: server version 5.5.37-cll, client version 5.5.37. 2014-11-01 04:07:28 [8059] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2014-11-01 04:07:28 [8059] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 8059. 2014-11-01 04:07:28 [8059] [1] DEBUG: Connecting to 127.0.0.1 2014-11-01 04:07:28 [8059] [1] INFO: Connected to bearerbox at 127.0.0.1 port 15000. 2014-11-01 04:07:28 [8059] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2014-11-01 04:07:28 [8059] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 8059. 2014-11-01 04:09:08 [8059] [2] ERROR: Connection closed by the bearerbox. 2014-11-01 04:09:08 [8059] [2] DEBUG: bearerbox_to_sql: connection to bearerbox died. 2014-11-01 04:09:08 [8059] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) terminates. 2014-11-01 04:09:08 [8059] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. 2014-11-01 04:09:09 [8059] [0] DEBUG: Immutable octet strings: 63. This is my sqlbox.conf file: group = sqlbox id = sqlbox-db smsbox-id = mysmsbox global-sender = bearerbox-host = localhost bearerbox-port = 15001 smsbox-port = 15002 smsbox-port-ssl = false sql-log-table = sqlbox_sent_sms sql-insert-table = sqlbox_send_sms log-file = sqlbox.log log-level = 0 #--- group = mysql-connection id = sqlbox-db host=127.0.0.1 port = 3306 username = root password = database = bulk_sms #max-connections = 1 #--- Please resolve this issue as soon as possible. Your reply will be appreciate. Thanks, Aditya Khanna
Re: Receiving French characters from Kannel -smsbox
Hi Moses, 1. Are you on Live Server ? 2. Are the sms comming to short or long code if so, they are received by ur bearbox from smsc forwarded to smsbox right ? 3. Are you storing the sms from php file to db 4. In db ur having issue regarding french characters right ??? *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Oct 30, 2014 at 1:36 AM, MOSES KARIUKI kariuk...@gmail.com wrote: Hi All, I am having problems receiving French characters from smsc. Messages received are processed by smsbox and stored to db via a php script called receivesms.php. This is my config: group = smsbox bearerbox-host = localhost sendsms-port = 13013 #global-sender = 13013 smsbox-id = box1 log-file = /var/log/kannel/smsbox.log log-level = 0 mo-recode=true group = smsc smsc = smpp smsc-id = chaitel alt-charset = utf-8 in my receivesms.php which receives messages from smsbox, I am doing urldecode($SMSTEXT) But when the mobile sends déjà, I get D?j? in the db. The db and its tables are UTF-8 encoded. Pliz assist. Thanks, Moses
Re: SQLBox UTF-8 Encoding
HI, have you url-enoded the sms text before inserting into sqlbox send_sms table ??? *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Oct 27, 2014 at 6:35 PM, MOSES KARIUKI kariuk...@gmail.com wrote: Hi Team, I am trying to send a text / sms that has French Characters (Test déjà) using sqlbox but the text always gets corrupted. I have checked and I can insert the same to my postgres database that has utf-8 encoding. I have also tried setting coding=2 and charset='UTF-8' in send SMS but no luck. Please assist. Thanks, MK
Re: SQLBox UTF-8 Encoding
Hi, Please clearly specify the process. I'm Confused at tbl_outgoing send_sms. where how are you inserting sms in to which table. All sms has to be url encoded before inserting into sqlbox send_sms table for unicode sms coding has to be 2. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Oct 27, 2014 at 7:05 PM, MOSES KARIUKI kariuk...@gmail.com wrote: Hi Rajeev, When I do this : INSERT into tbl_outgoing (msg_text) values ( 'test déjà'); it works fine. but when I do: INSERT INTO send_sms (charset,coding,momt, sender, receiver,dlr_url) VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url') this ,Test+d%C3%A9j%C3%A0, is the value that is inserted in SENT_SMS table of sql box. I am doing a direct insert using sql code. Thanks, Moses On Mon, Oct 27, 2014 at 4:17 PM, RK Krishnas r...@krishnasoft.in wrote: HI, have you url-enoded the sms text before inserting into sqlbox send_sms table ??? *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Oct 27, 2014 at 6:35 PM, MOSES KARIUKI kariuk...@gmail.com wrote: Hi Team, I am trying to send a text / sms that has French Characters (Test déjà) using sqlbox but the text always gets corrupted. I have checked and I can insert the same to my postgres database that has utf-8 encoding. I have also tried setting coding=2 and charset='UTF-8' in send SMS but no luck. Please assist. Thanks, MK
kannel low tps store size increasing
hi, I am running kannel with following specs: Kannel bearerbox version `svn-r5106'. Build `Oct 2 2014 19:17:57', compiler `4.4.7 20120313 (Red Hat 4.4.7-4)'. System Linux, release 2.6.32-431.29.2.el6.x86_64, version #1 SMP Tue Sep 9 21:36:05 UTC 2014, machine x86_64. Hostname .yy, IP yyy..xxx.aaa. Libxml version 2.7.6. Using OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.5.40, using MySQL 5.5.40. Using native malloc. Status: running, uptime 0d 0h 26m 38s WDP: received 0 (0 queued), sent 0 (0 queued) SMS: received 0 (0 queued), sent 2660 (0 queued), store size 1145 SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (3.34,2.98,1.66) msg/sec DLR: received 5096, sent 0 DLR: inbound (6.96,5.98,3.19) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 44099 queued, using mysql storage Box connections: smsbox:sqlbox, IP 127.0.0.1 (1143 queued), (on-line 0d 0h 26m 37s) smsbox:smsbox1, IP 127.0.0.1 (0 queued), (on-line 0d 0h 26m 36s) Hardware Config: HP POLIANT SEVER with 1 TB HDD, 2 GB RAM, e13320 v2 processor Kannel structure: sqlboxbearerboxOperator Problem: Server is hosted at our office premises Only dlr ack messages are going in to store, Tps is limiting to 20 sms/sec when i check store-status, All record are of DLR-MO Only. Please suggest me a better solution to overcome the issue. If I send 1000 sms, All 1000 sms's sent with 20 tps all DLR-MO are going to store first are updated by sqlbox at 5 sms per second. *Rajeev Krishna* Operations Manager Krishnas Software Technologies VIJAYAWADA INDIA www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888
Re: Message identifier for returning DLR
1. smsbox must up running 2. in insert statement`boxc_id` should be smsbox-id Example INSERT INTO `smpp_send_sms` ( `sql_id`, `momt`, `sender`, `receiver`, `msgdata`, `u_id`, `smsc_id`, `sms_type`, `dlr_mask`, `dlr_url`, * `boxc_id`* ) VALUES ( `sql_id, 'MT', ss_sender_id, ss_tonum, msg, u_id, ay, '2', '63', dlr_url, *'smsbox1*' ); *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Tue, Sep 30, 2014 at 7:52 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Check sms routing group /smsc-id it should match that of the route used Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Mon, Sep 29, 2014 at 5:02 PM, ha...@aeon.pk ha...@aeon.pk wrote: Hi, My DLRs are being buffered at Kannel and not hitting the URL specified in dlr_url paratmeter in SQLBOX while sending SMS. Can someone please help to figure out what's wrong? I am using following statement: INSERT INTO `kannel`.`send_sms` (momt,charset,coding,sender,receiver,msgdata,smsc_id,sms_type,dlr_mask,dlr_url) VALUES ('MT','','','03xxyyy','03aabbb','Hello. This is test DLR message.','my-smsc','2','63',' http://127.0.0.1/testdlr/dlr.php?dlrid=3status=%d') The DLR is received by kannel/bearerbox successfully but kannel status window shows it as buffered. It never hits the URL specified. Is there some CGI parameter I am missing? The dlr.php file is on the right path specified in the URL. Regards, Hamza On Fri, Jun 13, 2014 at 11:41 PM, [Digital^Dude] ® millennium@gmail.com wrote: In your sendsms url just append dlr-url e.g. http://kannel.host.com:/sendsms.cgi?user...dlr-mask=xdlr-url=[url encoded form of url] As you receive a dlr response, this dlr-url will be hit. Assuming your dlr-url was the following: http://another.host.com/myapi.py?status=%dmID=123tStamp= You can grep for mID=123 and view its status in the web server logs of another.host.com
Re: getting max 10 tps from single smpp session
Hi, I dont know how to do that. From morning i Connected kannel to nowsms as Upstream. Same 10 tps per session total of 30 tps. Both Machines are on local lan only. I Changed Nowsms smpp server to async mode. Now sms shows 200 tps with single sesiion from kannel. All 100 sms are transferred in 5 seconds. But Kannel server is showing 10 tps only. It is Storing them to store file. later slowly processing the requests @ 10 tps. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Tue, Sep 30, 2014 at 6:50 PM, ha...@aeon.pk ha...@aeon.pk wrote: Did you check system resources if either of them is choking? Have some monitoring of CPU idle time, Memory/RAM and network pipe. Regards, H On Tue, Sep 30, 2014 at 10:55 AM, RK Krishnas r...@krishnasoft.in wrote: Hi, I am Rajeev, I am using Kannel from past 2 years. I am having 2 servers of kannel with following specs: Kannel bearerbox version `svn-r5106'. Build `Sep 30 2014 01:09:31', compiler `4.4.7 20120313 (Red Hat 4.4.7-4)'. System Linux, release 2.6.32-431.20.3.el6.x86_64, version #1 SMP Thu Jun 19 21:14:45 UTC 2014, machine x86_64. Hostname xx.x, IP xxx.xxx.xxx.xxx. Libxml version 2.7.6. Using OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.5.38, using MySQL 5.5.38. Using native malloc. 1. at Digital Ocean VPS(SINGLE CORE 512 MB RAM 20GB HDD) 2. My Office Premises (hp proliant Intel® Xeon® E3-1220 v2 (4 core, 3.4 GHz, 8MB), 1TB 4 GB RAM. My Problem: VPS is giving me a total of 150 tps with 4 sessions. But my office server is giving me max 30 tps with (4 sessions above). Max 10 tps from each session. I installed kannel on as many as 6 diff servers in vps, there I am getting 150 tps at any vps. But I am restricted to 10 tps per session max 30tps from my office server. kannel config, version, mysql all are same in all machines. Kannel config: group = core admin-port = 13000 smsbox-port = 13001 admin-password = 12345 #status-password = foo #admin-deny-ip = #admin-allow-ip = log-file = /var/log/kannel/log.log log-level = 2 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 #unified-prefix = +358,00358,0;+,00 #access-log = /tmp/access.log #store-file = /var/log/kannel/kannel.store #store-type=file #store-location=/var/log/kannel/kannelspool #ssl-server-cert-file = cert.pem #ssl-server-key-file = key.pem #ssl-certkey-file = mycertandprivkeyfile.pem dlr-storage=mysql store-type = spool store-location = /var/log/kannel/spool/ smsbox-max-pending=1 #- # SMSC CONNECTIONS ##aman promo sid trx 1 group = smsc smsc = smpp smsc-id = amanps host=00 port = transceiver-mode = true #receive-port= smsc-username=abcd smsc-password=abcd system-type=VMA #system-id=9 allowed-smsc-id = 111222 #denied-smsc-id = 2;4;5;6;7;8;9;10 enquire-link-interval=120 #reconnect-delay = 10 validityperiod = 32123 interface-version=34 max-pending-submits=1 #- # SMSBOX SETUP # # Smsbox(es) do higher-level SMS handling after they have been received from # SMS centers by bearerbox, or before they are given to bearerbox for delivery group = smsbox smsbox-id=smsbox1 bearerbox-host = 127.0.0.1 sendsms-port = 13013 global-sender = 13013 #sendsms-chars = 0123456789 +- #log-file = /tmp/smsbox.log #log-level = 0 #access-log = /tmp/access.log #mysql connection group = mysql-connection id = sqlbox-db host = 00 username = kannel password = kannel database =kannel max-connections = 5 # DLR SETUP #mysql connection group = mysql-connection id = mydlr host = x username = kannel password = kannel database = kannel max-connections = 5 group = dlr-db id = mydlr table=smpp_dlr field-smsc=smsc field-timestamp=ts field-destination=destination field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc Please help me in this issue. Thanks.
Fwd: getting max 10 tps from single smpp session
Hi, I am Rajeev, I am using Kannel from past 2 years. I am having 2 servers of kannel with following specs: Kannel bearerbox version `svn-r5106'. Build `Sep 30 2014 01:09:31', compiler `4.4.7 20120313 (Red Hat 4.4.7-4)'. System Linux, release 2.6.32-431.20.3.el6.x86_64, version #1 SMP Thu Jun 19 21:14:45 UTC 2014, machine x86_64. Hostname xx.x, IP xxx.xxx.xxx.xxx. Libxml version 2.7.6. Using OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.5.38, using MySQL 5.5.38. Using native malloc. 1. at Digital Ocean VPS(SINGLE CORE 512 MB RAM 20GB HDD) 2. My Office Premises (hp proliant Intel® Xeon® E3-1220 v2 (4 core, 3.4 GHz, 8MB), 1TB 4 GB RAM. My Problem: VPS is giving me a total of 150 tps with 4 sessions. But my office server is giving me max 30 tps with (4 sessions above). Max 10 tps from each session. I installed kannel on as many as 6 diff servers in vps, there I am getting 150 tps at any vps. But I am restricted to 10 tps per session max 30tps from my office server. kannel config, version, mysql all are same in all machines. Kannel config: group = core admin-port = 13000 smsbox-port = 13001 admin-password = 12345 #status-password = foo #admin-deny-ip = #admin-allow-ip = log-file = /var/log/kannel/log.log log-level = 2 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 #unified-prefix = +358,00358,0;+,00 #access-log = /tmp/access.log #store-file = /var/log/kannel/kannel.store #store-type=file #store-location=/var/log/kannel/kannelspool #ssl-server-cert-file = cert.pem #ssl-server-key-file = key.pem #ssl-certkey-file = mycertandprivkeyfile.pem dlr-storage=mysql store-type = spool store-location = /var/log/kannel/spool/ smsbox-max-pending=1 #- # SMSC CONNECTIONS ##aman promo sid trx 1 group = smsc smsc = smpp smsc-id = amanps host=00 port = transceiver-mode = true #receive-port= smsc-username=abcd smsc-password=abcd system-type=VMA #system-id=9 allowed-smsc-id = 111222 #denied-smsc-id = 2;4;5;6;7;8;9;10 enquire-link-interval=120 #reconnect-delay = 10 validityperiod = 32123 interface-version=34 max-pending-submits=1 #- # SMSBOX SETUP # # Smsbox(es) do higher-level SMS handling after they have been received from # SMS centers by bearerbox, or before they are given to bearerbox for delivery group = smsbox smsbox-id=smsbox1 bearerbox-host = 127.0.0.1 sendsms-port = 13013 global-sender = 13013 #sendsms-chars = 0123456789 +- #log-file = /tmp/smsbox.log #log-level = 0 #access-log = /tmp/access.log #mysql connection group = mysql-connection id = sqlbox-db host = 00 username = kannel password = kannel database =kannel max-connections = 5 # DLR SETUP #mysql connection group = mysql-connection id = mydlr host = x username = kannel password = kannel database = kannel max-connections = 5 group = dlr-db id = mydlr table=smpp_dlr field-smsc=smsc field-timestamp=ts field-destination=destination field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc Please help me in this issue. Thanks.