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!

Reply via email to