[Announce] New Sqlbox version
sangprabv
sangprabv at gmail.com
Wed Sep 30 14:44:21 CEST 2009
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: kenny at nuObjects.com
> w: www.nuObjects.com
>
> Bulk SMS Solutions | Managed Hosting | Enterprise Application
> Development
>
>
> On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri
> <aguerrieri at kannel.org> 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
> <aguerrieri at kannel.org> 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
>
>
>
>
>
>
>
>
>
>
More information about the devel
mailing list