Re: [Announce] New Sqlbox version

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
>                                         
>                                         
>                                 
>                                 
>                 
>                 
>         
>         
>         
>