The bidding is still ongoing on rentacoder - it closes on Jan 28th.
----- Original Message -----
Sent: Friday, January 16, 2004 8:22
PM
Subject: RE: SQLBOX [Was Re: Feature
request: storing incoming/outgoingmessagesin database]
This is a feature (storing MO/MT messages in a
database) is also something I've been looking for for quite a while
now.
I kept monitoring Kannel after some requests of other
users for this, however up until now, I've not seen this feature request
been picked up by one of the devs.. I suppose we're just waiting for
somebody to consider this a calling :-o
I would do it if it hadn't been a while since I
seriously programmed though, maybe with some help from other people
interested ? ..
Pak, the way you described your application is exactly
what I've had in mind for a project of mine too: i.e. poll an "outbound"
table for messages to be sent. Or maybe even work with triggers (like oracle
has for instance). And vice versa for the MO messages obviously.
This would also great to do some accounting real easy, a couple of queries
and you're done..
Kind regards,
Renaat
Dear All,
What is the status of "own
smsbox" called sqlbox ?
Why don't you list it to TODO list ?
Regards.
--------------------------------------------------------------------------------
From: Stipe Tolj
Subject: Re:
Feature request: storing incoming/outgoing messages in database
Date:
Wed, 29 Oct 2003 04:20:38 -0800
> Right now I'm using kannel
towards Telenor (Norwegian telco running Logica
> CMG SMSC) and it
works fine (when you remember to specify
> interface-version=33, that
part took some time to figure out :-P).
>
> Actually the only
part of kannel I use is the smpp parsing/sending,
> "forwarding" of
the message to a URL, and sending a message through the
> SMPP
SMSC.
>
> In this context I'm wondering if the following
extensions have been
> thought of:
>
> 1. Store incoming
messages into a sdb supported database (like you do with
> dlr's)
?
>
> 2. Have a thread in smsbox that checks a table in a
database for messages
> that are to be sent to a smsbox compatible
protocol.
I had(?!) (yes *had*) an sqlbox
implementation that did this with
mysql. Actually it took my 1 week of
coding and I lost it, because my
laptop has been taken away by some rude
people that had to break into
my car. ;((
I have to check if I can find it on
one of our other local machine
here arround.
The basic idea was to use
pre-processor magic from gw/msg-decl.h and
wrap the structure of a SMS
message into table attributes.
Then I had a poll'ing thread that
checked in a configurable ammount of
sec if there are new messages in the
"outgoing" table and passed it
(as a smsbox connection) to bearerbox.
Same for MO messages, passed
everything into an other table for external
applications to poll them.
So, the idea has been there and even
the implementation. But don't
consider doing this inside smsbox itself.
Write an "own smsbox" called
sqlbox for this.
Stipe
Yahoo! Personals
- New people, new
possibilities. FREE for a limited time!