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
