What exactly i am trying to achieve here is, our SMPP provider has provided us 5 msg per second throughput and i have two users. First user is submitting sms directly into sqlbox database (sqlbox is connected to bearerbox) and second user is submitting sms via cgi url (smsbox directly connected to same bearerbox). Messages of second user are very critical so if first user (sqlbox) submit large/huge sms into sqlbox then also sqlbox should not send sms to bearerbox more then 5 msg per second although if first user sends sms in-between then, first user sms should pass immediately before sqlbox submitted messages.
I also want to know if messages submitted by sqlbox are high in quantity then can we somehow tweak sqlbox to submit sms to bearerbox between 9 A.M. to 7 P.M. (or any timing configurable) Please suggest. Regards Tapan Thapa --- On Mon, 21/6/10, Rene Kluwen <[email protected]> wrote: From: Rene Kluwen <[email protected]> Subject: RE: Scheduling Question To: "'Nikos Balkanas'" <[email protected]>, "'sangprabv'" <[email protected]>, "'T.K.Thapa'" <[email protected]> Cc: "'Kannel list'" <[email protected]> Date: Monday, 21 June, 2010, 7:40 PM That's correct. It depends on what you want to achieve. If you don't want to the queue to be too large because you are getting throttling errors. Then the throughput directive of group = smsc is the item to use. See documentation. == Rene -----Original Message----- From: Nikos Balkanas [mailto:[email protected]] Sent: maandag 21 juni 2010 15:34 To: Rene Kluwen; 'sangprabv'; 'T.K.Thapa' Cc: 'Kannel list' Subject: Re: Scheduling Question Not only that. It will also limit bandwidth on each smsc traffic, according to your agreements/specifications. I believe that the SMPP driver supports it now correctly. By all means, use it, if you are getting a lot of throttling errors in your logs and your SMSc will allow only a certain amount of SMS/s. After all, that is what it was created for. Don't be concerned about your queue. It will not get any larger if you already get throttling errors. BR, Nikos ----- Original Message ----- From: Rene Kluwen To: 'sangprabv' ; 'T.K.Thapa' Cc: 'Kannel list' Sent: Monday, June 21, 2010 3:04 PM Subject: RE: Scheduling Question Throughput is for smsc trotteling. The bearerbox queue will only get larger if you use this. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of sangprabv Sent: maandag 21 juni 2010 9:50 To: T.K.Thapa Cc: Kannel list Subject: Re: Scheduling Question it's in the smsc group, check it out. sangprabv [email protected] On Jun 21, 2010, at 2:26 PM, T.K.Thapa wrote: Where i need to configure throughput directive? Do i need to configure in bearerbox or sqlbox? if i am configuring in bearerbox then it will only limit bearerbox to submit at defined rate to smsc. it will not limit sqlbox to submit at defined rate to bearerbox. Regards Tapan Thapa --- On Mon, 21/6/10, sangprabv <[email protected]> wrote: From: sangprabv <[email protected]> Subject: Re: Scheduling Question To: "T.K.Thapa" <[email protected]> Cc: "Rene Kluwen" <[email protected]>, "Kannel list" <[email protected]> Date: Monday, 21 June, 2010, 10:41 AM You can use throughput directive. sangprabv [email protected] On Jun 21, 2010, at 12:02 PM, T.K.Thapa wrote: Hello, Two more questions: 1. Can sqlbox submit sms to bearerbox at a configurable rate? Lets say 5 message per second so that no queue is built at bearerbox for particular smsc. 2. If there is a queue at bearerbox (particular smsc), lets say 100 then till the time queue come down to less than 100, sqlbox do not push further messages to that particular smsc. Regards Tapan Thapa --- On Mon, 21/6/10, T.K.Thapa <[email protected]> wrote: From: T.K.Thapa <[email protected]> Subject: RE: Scheduling Question To: "Rene Kluwen" <[email protected]> Cc: "Kannel list" <[email protected]> Date: Monday, 21 June, 2010, 9:37 AM Hello, I have seen the same feature requested by many users. Can't we have the same by default in source code of sqlbox and put the query in configuration file. Regards Tapan Thapa --- On Sun, 20/6/10, Rene Kluwen <[email protected]> wrote: From: Rene Kluwen <[email protected]> Subject: RE: Scheduling Question To: "'sangprabv'" <[email protected]>, "'T.K.Thapa'" <[email protected]> Cc: [email protected] Date: Sunday, 20 June, 2010, 11:11 PM Yes, sqlbox does scheduling of writing with a simple (1-line) patch. You can find it on the mailinglist, but to facilitate your search, here it is again: in gw/sqlbox_mysql.h something like: SELECT sql_id, momt, sender, receiver, udhdata, \ msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, coding, \ compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \ charset, boxc_id, binfo, meta_data FROM %S WHERE time < UNIX_TIMESTAMP(NOW()) LIMIT 0,1" == Rene From: [email protected] [mailto:[email protected]] On Behalf Of sangprabv Sent: zondag 20 juni 2010 16:04 To: T.K.Thapa Cc: [email protected] Subject: Re: Scheduling Question Quick and dirty way is patch the query in the sqlbox source code. sangprabv [email protected] On Jun 20, 2010, at 4:15 PM, T.K.Thapa wrote: Hello, Does kannel bearerbox,smsbox or sqlbox support scheduling of messages? If yes how? Regards Tapan Thapa
