|
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 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pak Bei Sent: Monday, January 12, 2004 09:25 To: [EMAIL PROTECTED] Subject: SQLBOX [Was Re: Feature request: storing incoming/outgoing messagesin database] 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! |
