Hi Alejandro, This would be fantastic! Can't wait anymore. :)
-- Kenny e: [email protected] w: www.nuObjects.com Bulk SMS Solutions | Managed Hosting | Enterprise Application Development On Wed, Sep 30, 2009 at 2:06 PM, Alejandro Guerrieri <[email protected]>wrote: > Yep, my plan is to add support to those fields, and also the ability to use > your custom sql queries without needing to patch the source code :) > > Regards, > -- > Alejandro Guerrieri > [email protected] > > > > On 30/09/2009, at 14:44, sangprabv wrote: > > 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/<http://www.kannel.org/%7Eaguerrieri/> >>> >>> Regards, >>> >>> Alejandro >>> Guerrieri >>> >>> >>> >>> >>> >>> -- >>> Regards, >>> Kenny >>> >>> >>> "Whosoever desires >>> constant success must >>> change his conduct >>> with the >>> times."-Niccolo >>> Machiavelli >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >
