Re: dlr-storage = mysql makes kannel slow ?
Well, dlr's should be deleted from the db when you receive the final notification. Perhaps you should adjust the dlr-mask to not wait for dlr's you're not getting from the carrier. Regards, Alejandro On Thu, May 14, 2009 at 10:50 AM, jyotiranjan panda tell2jy...@gmail.comwrote: Hi, I am using kannel-1.4.3 with dlr-storage = mysql. I have noticed when I am using mysql storage, after 30,000 data in DB, kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec to upstream smsc, where as smsc TPS is 40. At that time ,If I am deleting the data in DB,then it's sending in normal speed. Please sugest how to improve the performance. Regards Jyoti Ranjan Panda
Re: dlr-storage = mysql makes kannel slow ?
Hi Alejandro, Let me explain my problem clearly. When I am sending bulk MTs to smsc, kannel starts stores them in db after getting the response of MTs and when dlr comes for respective MTs it search in the db and delete it from db. And when there is data of 20k/30k in db I noticed bearerbox starts decreasing the rate of sending messages to smsc. As the db size increases the rate of sending messages to the smsc is decreases. May be the problem arises due to the searching and deleting dlrs entry in the db. If I delete dlr entries from the db, bearerbox starts sending messages in absolute manner. I am using dlr-mask = 19. Regards, Jyoti Ranjan Panda On Thu, May 14, 2009 at 3:00 PM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Well, dlr's should be deleted from the db when you receive the final notification. Perhaps you should adjust the dlr-mask to not wait for dlr's you're not getting from the carrier. Regards, Alejandro On Thu, May 14, 2009 at 10:50 AM, jyotiranjan panda tell2jy...@gmail.comwrote: Hi, I am using kannel-1.4.3 with dlr-storage = mysql. I have noticed when I am using mysql storage, after 30,000 data in DB, kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec to upstream smsc, where as smsc TPS is 40. At that time ,If I am deleting the data in DB,then it's sending in normal speed. Please sugest how to improve the performance. Regards Jyoti Ranjan Panda
Re: dlr-storage = mysql makes kannel slow ?
do you have proper indexes on columns? Regards, - Original Message - From: jyotiranjan panda tell2jy...@gmail.com To: Alejandro Guerrieri alejandro.guerri...@gmail.com Cc: users@kannel.org Sent: 14 May 2009 10:49 Subject: Re: dlr-storage = mysql makes kannel slow ? Hi Alejandro, Let me explain my problem clearly. When I am sending bulk MTs to smsc, kannel starts stores them in db after getting the response of MTs and when dlr comes for respective MTs it search in the db and delete it from db. And when there is data of 20k/30k in db I noticed bearerbox starts decreasing the rate of sending messages to smsc. As the db size increases the rate of sending messages to the smsc is decreases. May be the problem arises due to the searching and deleting dlrs entry in the db. If I delete dlr entries from the db, bearerbox starts sending messages in absolute manner. I am using dlr-mask = 19. Regards, Jyoti Ranjan Panda On Thu, May 14, 2009 at 3:00 PM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Well, dlr's should be deleted from the db when you receive the final notification. Perhaps you should adjust the dlr-mask to not wait for dlr's you're not getting from the carrier. Regards, Alejandro On Thu, May 14, 2009 at 10:50 AM, jyotiranjan panda tell2jy...@gmail.comwrote: Hi, I am using kannel-1.4.3 with dlr-storage = mysql. I have noticed when I am using mysql storage, after 30,000 data in DB, kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec to upstream smsc, where as smsc TPS is 40. At that time ,If I am deleting the data in DB,then it's sending in normal speed. Please sugest how to improve the performance. Regards Jyoti Ranjan Panda
Re: dlr-storage = mysql makes kannel slow ?
If you are using InnoDB tables, make sure you have pre-allocated enough InnoDB space to make sure that it doesn't need to allocate while you are sending a batch. If you are using MyISAM tables make sure that you don't have too many indexes as this will cause some speed issues too. Thanks, Donald 2009/5/14 Alejandro Guerrieri alejandro.guerri...@gmail.com The part I don't get is, how do you get 20-30k dlr's unanswered? And, adding to what Cezary wrote, having an index con columns smsc and ts will speedup things for sure. Something like ALTER TABLE dlr ADD INDEX smscts(smsc, ts) Regards, Alejandro On Thu, May 14, 2009 at 11:49 AM, jyotiranjan panda tell2jy...@gmail.comwrote: Hi Alejandro, Let me explain my problem clearly. When I am sending bulk MTs to smsc, kannel starts stores them in db after getting the response of MTs and when dlr comes for respective MTs it search in the db and delete it from db. And when there is data of 20k/30k in db I noticed bearerbox starts decreasing the rate of sending messages to smsc. As the db size increases the rate of sending messages to the smsc is decreases. May be the problem arises due to the searching and deleting dlrs entry in the db. If I delete dlr entries from the db, bearerbox starts sending messages in absolute manner. I am using dlr-mask = 19. Regards, Jyoti Ranjan Panda On Thu, May 14, 2009 at 3:00 PM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Well, dlr's should be deleted from the db when you receive the final notification. Perhaps you should adjust the dlr-mask to not wait for dlr's you're not getting from the carrier. Regards, Alejandro On Thu, May 14, 2009 at 10:50 AM, jyotiranjan panda tell2jy...@gmail.com wrote: Hi, I am using kannel-1.4.3 with dlr-storage = mysql. I have noticed when I am using mysql storage, after 30,000 data in DB, kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec to upstream smsc, where as smsc TPS is 40. At that time ,If I am deleting the data in DB,then it's sending in normal speed. Please sugest how to improve the performance. Regards Jyoti Ranjan Panda -- Donald Jackson http://www.ddj.co.za/ donaldjster(a)gmail.com
Re: dlr-storage=mysql help
Patrick, The dlr storage is temporary. In other words, kannel stores the DLR's into the database only while they're being processed. Once a final (delivered or failed) state is reached, the row is deleted. If you want to keep the data, you should do so on the script that is called on the dlr-url. Hope it helps, Alejandro On Fri, Mar 6, 2009 at 10:17 AM, patrick meye patrick_m...@hotmail.frwrote: Hi all, i successfully settup my kannel gateway with one service,now i want to store my dlr in mysql data base,when i send sms to my service all is right but no data in my data base.Please can you help me??? Thanks!! ps: sorry i'm new and i just learn anglish. -- Découvrez tout ce que Windows Live a à vous apporter !http://www.microsoft.com/windows/windowslive/
Re: dlr-storage=mysql help
Or you can apply SQLBox to do this. Willy
Re: dlr-storage=mysql help
Hi, in 1.4.3 where is the sqlbox .and how can i use the sqlbox .and how can i set the configarations for sqlbox. On Fri, Mar 6, 2009 at 3:10 PM, sangprabv sangpr...@gmail.com wrote: Or you can apply SQLBox to do this. Willy -- Best Regards,
Re: dlr-storage=mysql help
SQLBox is an independent subsystem for Kannel. You may get it from here http://www.kannel.org/~aguerrieri/SqlBox/ Willy
RE: dlr with mysql
take a look in the dlr-url and dlr-mask parameter when you send a sms. basically, you have to put you dlr-mask to 31 to have all the dlr (your operator have to support as well), and all the dlr will be forward to the url defined by dlr-url (must be url encoded) hope it helps _ From: hafez ahmad [mailto:[EMAIL PROTECTED] Sent: lundi 21 avril 2008 11:41 To: users@kannel.org Subject: dlr with mysql Hi all, I want to use the DLR with mysql I set up all the needed configuration like the user guide, but I didn't receive anything, is the there anything else I must add it?, and when I must use the dlr-mask and dlr-url in the sendsms? thanks for help. _ Antivirus avast! http://www.avast.com : message Sortant sain. Base de donnees virale (VPS) : 080421-1, 21/04/2008 Analyse le : 21/04/2008 20:01:50 avast! - copyright (c) 1988-2008 ALWIL Software.
Re: DLR and MySQL
Did you add dlr-storage = mysql line to core group? On 8/7/07, Nicholas Amorim [EMAIL PROTECTED] wrote: Hello people! I'm new on this Kannel/SMS stuff, but I managed Kannel to work 100% with what I need (send SMS through a sms center using smpp). But I still got one problem, I set it all in kannel.conf to use mysql as a dlr storage, but the table still empty. Nothing seems to be wrong in the log. My conf below: group = mysql-connection id = mydlr host = localhost username = kannel password = somepassword database = dlr max-connections = 1 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 Nicholas Amorim. -- Best Regards, Tulga.G Senior Engineer of Technology Division G-Mobile Corporation Ulaanbaatar, Mongolia Tel: +976-11-311198 Fax: +976-11-311195 Web: http://www.g-mobile.mn
Re: DLR and MySQL
Yes, I configured mysql DLR storage too. but still empty. I think we have same problem :-) On 8/7/07, Nicholas Amorim [EMAIL PROTECTED] wrote: Yes. Actually, it recognizes the connection, just doesn't send nothing to the database. Neither mysql nor pgsql (I've also compiled with pgsql support). I'm going crazy, there isn't a single error message! In the logs, everything's normal, in the status recognizes a DLR with mysql (or pgsql). Any suggestions ? -- Best Regards, Tulga.G Senior Engineer of Technology Division G-Mobile Corporation Ulaanbaatar, Mongolia Tel: +976-11-311198 Fax: +976-11-311195 Web: http://www.g-mobile.mn
Re: dlr-url + mysql + reception
Why don't u start shared your kannel configuration to others? On 2/7/07, Tushar [EMAIL PROTECTED] wrote: Hi all, I am unable to get DLRs in mysql database and even not not able to set dlr-url…….and also unable to receive any messages in kanel. Plz somebody help me. Thanx and Regards, tushar
Re: dlr-url + mysql + reception
Hi, This is my configuration file: group = core admin-port=13000 smsbox-port = 13001 wapbox-port = 13002 admin-password = hungama wdp-interface-name = * log-file = /tmp/bearerbox.log log-level = 0 group = wapbox bearerbox-host = localhost log-file = /tmp/wapbox.log log-level = 0 syslog-level = none access-log = /tmp/wapaccess.log group = smsbox smsbox-id = dlrbox #admin-password = hungama bearerbox-host = localhost sendsms-port = 13131 log-file = /tmp/smsbox.log log-level = 0 access-log = /tmp/smsbox-access.log # Fake SMSC configuration #group = smsc #smsc = fake #smsc-id = FAKE #port = 1 #connect-allow-ip = 127.0.0.1 #SMSC SMPP group = smsc smsc = smpp host = 66.36.229.70 port = 7771 smsc-username =get smsc-password = set system-type = VMA address-range = #smsbox routing #group = smsbox-route #smsbox-id = dlrbox #shortcuts = 9870145145 #SMS service GROUP group = sms-service keyword = default get-url = http://www.google.com #SENDsms GROUP group = sendsms-user username = hungama password = hungama default-sender=PHPsms concatenation = true # SMSC Nokia CIMD2 #group = smsc #smsc = cimd2 #host = 172.25.48.20 #port = 9971 #smsc-username = my_user_wap #smsc-password = my_pass_wap #throughput = 10 #keepalive = 60 #no-dlr = false #group = ppg #ppg-url = /push/miep_normal #ppg-port = 7080 #ppg-allow-ip = 172.17.60.28 #concurrent-pushes = 100 #trusted-pi = true #service-name = ppg #ppg-smsbox-id = dlrbox #default-dlr-url = http://172.16.15.30/dls_notifications/notify.php; [^] #group = wap-push-user #wap-push-user = dimitris #ppg-username = my_user #ppg-password = my_pass Why don't u start shared your kannel configuration to others? On 2/7/07, Tushar [EMAIL PROTECTED] wrote: Hi all, I am unable to get DLRs in mysql database and even not not able to set dlr-url...and also unable to receive any messages in kanel. Plz somebody help me. Thanx and Regards, tushar
Re: dlr-url + mysql + reception
It seems you haven't set you dlr storage destination in your conf. And if you plan to use mysql as your dlr storage, you have to add/define dlr-db group and connection to the db. It might help to take a look at this URL: http://kannel.org/download/1.4.1/userguide-1.4.1/userguide.html#AEN452 http://kannel.org/download/1.4.1/userguide-1.4.1/userguide.html#AEN2826 Hope these links give you a hint... --tjatur On Wed, 2007-02-07 at 16:47 +0530, Tushar wrote: Hi, This is my configuration file: group = core admin-port=13000 smsbox-port = 13001 wapbox-port = 13002 admin-password = hungama wdp-interface-name = * log-file = /tmp/bearerbox.log log-level = 0 group = wapbox bearerbox-host = localhost log-file = /tmp/wapbox.log log-level = 0 syslog-level = none access-log = /tmp/wapaccess.log group = smsbox smsbox-id = dlrbox #admin-password = hungama bearerbox-host = localhost sendsms-port = 13131 log-file = /tmp/smsbox.log log-level = 0 access-log = /tmp/smsbox-access.log # Fake SMSC configuration #group = smsc #smsc = fake #smsc-id = FAKE #port = 1 #connect-allow-ip = 127.0.0.1 #SMSC SMPP group = smsc smsc = smpp host = 66.36.229.70 port = 7771 smsc-username =get smsc-password = set system-type = VMA address-range = #smsbox routing #group = smsbox-route #smsbox-id = dlrbox #shortcuts = 9870145145 #SMS service GROUP group = sms-service keyword = default get-url = http://www.google.com #SENDsms GROUP group = sendsms-user username = hungama password = hungama default-sender=PHPsms concatenation = true # SMSC Nokia CIMD2 #group = smsc #smsc = cimd2 #host = 172.25.48.20 #port = 9971 #smsc-username = my_user_wap #smsc-password = my_pass_wap #throughput = 10 #keepalive = 60 #no-dlr = false #group = ppg #ppg-url = /push/miep_normal #ppg-port = 7080 #ppg-allow-ip = 172.17.60.28 #concurrent-pushes = 100 #trusted-pi = true #service-name = ppg #ppg-smsbox-id = dlrbox #default-dlr-url = http://172.16.15.30/dls_notifications/notify.php; [^] #group = wap-push-user #wap-push-user = dimitris #ppg-username = my_user #ppg-password = my_pass Why don't u start shared your kannel configuration to others? On 2/7/07, Tushar [EMAIL PROTECTED] wrote: Hi all, I am unable to get DLRs in mysql database and even not not able to set dlr-url…….and also unable to receive any messages in kanel. Plz somebody help me. Thanx and Regards, tushar
Re: DLR and mySQL?
Hi Andrew. I suggest you search in archived emails list - http://www.mail-archive.com/users@kannel.org/ You will find many informations about this issues. []s AA 2006/11/29, andrew teo [EMAIL PROTECTED]: Hello!! I am interested in manipulating smses received through Kannel. The Kannel User Guide says that DLRs can be stored in mySQL. What exactly are the contents of the DLR? Do they include the actual contents of the sms as well? If they do not, is there any other way to get the full sms content and put it in mySQL? Also, what is the configuration to support this? Or have I overlooked some part of the user guide? Please help! Thanks!! -- View this message in context: http://www.nabble.com/DLR-and-mySQL--tf2724315.html#a7597202 Sent from the Kannel - User mailing list archive at Nabble.com. -- Abraços. Allison Almeida. -- [EMAIL PROTECTED] Analista Infra-Estrutura Prill Tecnologia.
RE: dlr-storage = mysql not supported?!?
Hi all, The solution is to add mysql support by re-making Kannel: ./configure --with-mysql --with-mysql-dir=/usr/local/mysql make make install Apparently a mysql-devel RPM is required however. I'm still trying to locate this for Solaris 8. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
RE: dlr-storage = mysql
Thanks guys, Yes I did specify --with-mysql but I have now successfully being able to configure the gateway with mysql and the problem was the --with-mysql finds mysql libs in /usr/local I located where my libs are and configured --with-mysql=pathToMyMySQLLibs ok. But now when I run ./bearerbox it stops and complains PANIC: DLR: DB: directive 'field-source' is not specified Where does this again come from? I checked the user's guide and other docs no explanation for this. can you help me on this. Cheers TM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Navjot Singh Sent: Wednesday, January 14, 2004 5:15 PM To: [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql did you specify the --with-mysql while running ./configure. are you sure kannel was successfully compiled with mysql? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Wednesday, January 14, 2004 7:52 PM To: [EMAIL PROTECTED] Subject: dlr-storage = mysql Hi guys Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported I changed the in the core group internal storage to mysql as clearly explained in kannel user's guide. I want to store status report and other things in my mysql database. I ./configured my kannel gateway with --with-enable-mysql Where am I missing the point? Help please. Thanks TM
RE: dlr-storage = mysql
do you have thisline field-source = source in your dlr-db group. make sure the same exists in table also. HTH navjot singh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Thursday, January 15, 2004 10:39 PM To: [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql Thanks guys, Yes I did specify --with-mysql but I have now successfully being able to configure the gateway with mysql and the problem was the --with-mysql finds mysql libs in /usr/local I located where my libs are and configured --with-mysql=pathToMyMySQLLibs ok. But now when I run ./bearerbox it stops and complains PANIC: DLR: DB: directive 'field-source' is not specified Where does this again come from? I checked the user's guide and other docs no explanation for this. can you help me on this. Cheers TM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Navjot Singh Sent: Wednesday, January 14, 2004 5:15 PM To: [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql did you specify the --with-mysql while running ./configure. are you sure kannel was successfully compiled with mysql? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Wednesday, January 14, 2004 7:52 PM To: [EMAIL PROTECTED] Subject: dlr-storage = mysql Hi guys Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported I changed the in the core group internal storage to mysql as clearly explained in kannel user's guide. I want to store status report and other things in my mysql database. I ./configured my kannel gateway with --with-enable-mysql Where am I missing the point? Help please. Thanks TM
RE: dlr-storage = mysql
Hi Navjot No I don't have this line field-source = source in my dlr-db group do I have to add it ? how do I use it is not in user's guide thanks TM -Original Message- From: Navjot Singh [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 6:45 AM To: Ted Mwakabaga; [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql do you have thisline field-source = source in your dlr-db group. make sure the same exists in table also. HTH navjot singh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Thursday, January 15, 2004 10:39 PM To: [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql Thanks guys, Yes I did specify --with-mysql but I have now successfully being able to configure the gateway with mysql and the problem was the --with-mysql finds mysql libs in /usr/local I located where my libs are and configured --with-mysql=pathToMyMySQLLibs ok. But now when I run ./bearerbox it stops and complains PANIC: DLR: DB: directive 'field-source' is not specified Where does this again come from? I checked the user's guide and other docs no explanation for this. can you help me on this. Cheers TM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Navjot Singh Sent: Wednesday, January 14, 2004 5:15 PM To: [EMAIL PROTECTED] Subject: RE: dlr-storage = mysql did you specify the --with-mysql while running ./configure. are you sure kannel was successfully compiled with mysql? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Wednesday, January 14, 2004 7:52 PM To: [EMAIL PROTECTED] Subject: dlr-storage = mysql Hi guys Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported I changed the in the core group internal storage to mysql as clearly explained in kannel user's guide. I want to store status report and other things in my mysql database. I ./configured my kannel gateway with --with-enable-mysql Where am I missing the point? Help please. Thanks TM
RE: dlr-storage = mysql
On Fri, 2004-01-16 at 11:17, Ted Mwakabaga wrote: No I don't have this line field-source = source in my dlr-db group Looks like a bug in the documentation ;-) Surely what the application emits is more important. -Tarun -- http://www.tarundua.net Nothing you ever wanted to find about Tarun Dua
RE: dlr-storage = mysql
did you specify the --with-mysql while running ./configure. are you sure kannel was successfully compiled with mysql? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Mwakabaga Sent: Wednesday, January 14, 2004 7:52 PM To: [EMAIL PROTECTED] Subject: dlr-storage = mysql Hi guys Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported I changed the in the core group internal storage to mysql as clearly explained in kannel user's guide. I want to store status report and other things in my mysql database. I ./configured my kannel gateway with --with-enable-mysql Where am I missing the point? Help please. Thanks TM
Re: dlr-storage = mysql
On Wed, 2004-01-14 at 19:51, Ted Mwakabaga wrote: Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported Do you have the mysql client libraries installed. -Tarun -- http://www.tarundua.net Nothing you ever wanted to find about Tarun Dua
RE: dlr-storage = mysql
Thanks Tarun I was assuming the latest versions of Red Hat Linux have the client libraries installed by default. I tried rpm -qa | grep -i mysql and it gave me Mysql-3.23.58-1.9 Mysql-server-3.23.58-1.9 Mysql-devel-3.23.58-1.9 I use redhat 9. Do I still miss client libraries? How should I go about it? Thanks TM -Original Message- From: Tarun Dua [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 6:14 PM To: Ted Mwakabaga Cc: [EMAIL PROTECTED] Subject: Re: dlr-storage = mysql On Wed, 2004-01-14 at 19:51, Ted Mwakabaga wrote: Pls help me, when I run my bearerbox it stops with msg PANIC dlr : dlr storage of type 'mysql' is not supported Do you have the mysql client libraries installed. -Tarun -- http://www.tarundua.net Nothing you ever wanted to find about Tarun Dua