To do SQLBox MySQL quick and dirty schedulling patch you just need to add datetime type field in the table and edit sqlbox_mysql.h in my case it will be:
#define SQLBOX_MYSQL_SELECT_QUERY "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, priority, custom, insertdate FROM %S WHERE insertdate < NOW() LIMIT 0,1" Do ordinary make clean and make install. Run this SQLBox as a new daemon, so you will have 2 SQLBox running. Keep in mind that this scheduling will raise your memory consumption. I'm sure Alejandro has better solution. And hopefully the next SQLBox version will add internal Kannel Msg-ID, Foreign-ID, and compatibility with Meta-Data. Willy On Wed, 2009-09-30 at 12:25 +0100, Kenny Orisanaiye wrote: > Hi Alejandro, > > Is there any hope of having this scheduling capabilities in the SQLBox > in the nearest future ? > > -- > Kenny > > p: +2348034939090 > e: [email protected] > w: www.nuObjects.com > > Bulk SMS Solutions | Managed Hosting | Enterprise Application > Development > > > On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri > <[email protected]> wrote: > Alex, > > The deferred field does get processed and afaik it's passed on > the SMPP link (as long as the SMSC supports it) so I'd rather > don't touch it either :) > > Regards, > > Alejandro > > El 18/11/2008, a las 01:54 p.m., Alexander Malysh escribió: > > > > Hi, > > there is deferred filed in kannel Msg struct, that > could be used for this... > > Alejandro Guerrieri schrieb: > I think that having scheduling capabilities > would be cool, but I definitely do not agree > with using the time column, since that column > is used internally on Kannel and cannot be > tweaked without disrupting other stuff. > I think this needs further thinking, though. > There are performance considerations to take > into account for example (when you have lots > of messages queued, adding a condition on the > select can impact performance if it's not done > right). > Regards, > Alejandro Guerrieri > El 18/11/2008, a las 12:36 p.m., Ehizogie > Binitie escribió: > Hi Alex > What are your thoughts on converting > the timestamp on the sqlbox field > into a basic scheduler. > > So messages are delivered if system > time greater = or > msg time stamp? > > Ehi > > On Tue, 2008-11-18 at 10:15 -0200, > Alejandro Guerrieri wrote: > Ken, > > I've used SqlBox to handle > 200-300K messages per day for > months with > no issues using commodity > hardware (P IV 3.0 Ghz with 1 > Gig RAM) and > using the same box for kannel, > sqlbox and MySQL. The traffic > was > unevenly distributed across > the day, with day hours > receiving almost > all traffic. > > I think Sqlbox can handle that > load on decent hardware. > You'll have to > take into account other > factors though, specially on > the application's > side, as well as the SMPP > traffic to your carrier. > > Regards, > > Alejandro Guerrieri > > El 18/11/2008, a las 09:46 > a.m., Ken Bellars escribió: > > Hi Alejandro, > > Your contributions are > highly appreciated. > > Am about to use SQLbox > for a production > system for delivering > 5million > sms/monthly. please > can SQLbox handle this > seamlessly? > > I anticipate your > early reply. > > On 11/18/08, Alejandro > Guerrieri > <[email protected]> wrote: > Hi, > > I've just > commited a new > SqlBox > version. > Changes on > this version > are: > > - Added > support for > the LibSDB > database > abstraction > library. DB > support is now > similar to > Kannel's. > - Extensive > code > reorganization > to move the > queries into > the header > files and > allow reusing > from the > libsdb module. > - Added > examples for > database > connections on > sample conf > file. > > I've also > started a > numbering > schema and I'm > also tagging > relevant > versions. > > Cvs version > 20081103 is > now tagged as > rev-0-6-0 and > represents > Sqlbox-0.6.0. > Cvs version > 20081113 is > now tagged as > rev-0-7-0. > Cvs version > 20081118 is > now tagged as > rev-0.7.1 > (This is the > latest > release). > > As usual, you > can checkout > latest version > from CVS, and > also retrieve > tagged > versions as > follow: > > cvs co -r > rev-0-6-0 (to > retrieve > version 0.6.0, > for example). > > You can also > download this > and former > releases from > here: > > > http://www.kannel.org/~aguerrieri/ > > Regards, > > Alejandro > Guerrieri > > > > > > -- > Regards, > Kenny > > > "Whosoever desires > constant success must > change his conduct > with the > times."-Niccolo > Machiavelli > > > > > > > > > >
