Hi Rene, What do you mean "use sqlbox with the scheduling patch"? Do you mean sql query in the code which need to be tweaked or you have made some changes in the sqlbox code with scheduling feature or something else?
Regards Tapan Thapa --- On Fri, 25/6/10, Rene Kluwen <[email protected]> wrote: From: Rene Kluwen <[email protected]> Subject: RE: Scheduling Question To: "'T.K.Thapa'" <[email protected]>, "'Alvaro Cornejo'" <[email protected]> Cc: "'Kannel list'" <[email protected]> Date: Friday, 25 June, 2010, 4:36 PM Or use sqlbox with the scheduling patch that was posted recently. And send out 3 messages per time-frame/second. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of T.K.Thapa Sent: donderdag 24 juni 2010 18:53 To: Alvaro Cornejo Cc: Kannel list Subject: Re: Scheduling Question This seems great idea. I will check this out. Two SQLBOXs, 1st will have 3 messages per second in sqlbox query and 2nd will have 2 message per second in sqlbox query. Rane: Can you confirm if this will work? Regards Tapan Thapa --- On Thu, 24/6/10, Alvaro Cornejo <[email protected]> wrote: From: Alvaro Cornejo <[email protected]> Subject: Re: Scheduling Question To: "Rene Kluwen" <[email protected]> Cc: "T.K.Thapa" <[email protected]>, "Nikos Balkanas" <[email protected]>, "Kannel list" <[email protected]> Date: Thursday, 24 June, 2010, 10:19 PM Maybe you can doit with sqlbox??? If I do remember well, sqlbox has an option where you can configure how many messages get per loop it sends to bb. You can connect 2 sqlboxes each with a different number of messages per loop/query.... ?? 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.NET www.smsglobal.com.mx y www.pravcom.com On Thu, Jun 24, 2010 at 11:11 AM, Rene Kluwen <[email protected]> wrote: A more complex solution would be: 2 sms groups that connect to the localhost http service (or smppbox)… Each with a different throughput. This box further relays to your provider in one session. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of T.K.Thapa Sent: donderdag 24 juni 2010 17:45 To: Nikos Balkanas Cc: Kannel list Subject: Re: Scheduling Question Thanks for the reply Nikos but my provider is not ready to provide me two sessions. Can we have something else here. Regards Tapan Thapa --- On Thu, 24/6/10, Nikos Balkanas <[email protected]> wrote: From: Nikos Balkanas <[email protected]> Subject: Re: Scheduling Question To: "T.K.Thapa" <[email protected]> Cc: "'Kannel list'" <[email protected]> Date: Thursday, 24 June, 2010, 9:58 AM Hi, You could also define 2 smsc groups, with different smsc-ids, all to the same smsc. Assign throughput 3 to the 1 & 2 to the other. Then put preferred-smsc-id to 1 itself and allowed-smsc-id to 2 itself. Send sqlbox traffic to the 1(3) and important traffic (I assume less) to the 2. This way you will have guaranteed reserved 2 SMS/s always for important traffic, and if it fills up you could send it over smsc 1 as well. Hope this helps, Nikos ----- Original Message ----- From: T.K.Thapa To: 'Nikos Balkanas' ; 'sangprabv' ; Rene Kluwen Cc: 'Kannel list' Sent: Monday, June 21, 2010 5:40 PM Subject: RE: Scheduling Question 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
