Hi,
Do you have any suggestions on where to start doing this ?
I've been playing with the code adding a new TRANSTYPE_SQL to urltrans,
and extending the smsbox.c case switch for TRANSTYPE_* with database
calls. But then I see that initialization of the database would have to be
done each time a new sms is processed, or I'd have to extend the code in
the "int main()" block with initialization of db. And that I think is a
bit hackish.
The thought of creating a dbbox has also struk me, does that sound as a
good idea ?
> Hi,
>
> heh, one thing I can say: If you have need in such interface then just
> implement it and send us patch :)
>
> On Tuesday 28 October 2003 17:06, Rory Campbell-Lange wrote:
>> I've hacked the dlr mechanism to do an update rather than a delete.
>> Pretty simple to do -- even though I don't know C!
>>
>> I'd be very keen for Kannel to dispense with the http interface
>> altogether and only supply database connectivity. Working with Postgres
>> triggers and foreign keys etc would make managing multiple users etc
>> very simple. However that would make it a different project, and Kannel
>> works very well as it does at the moment.
>>
>> One issue that this does bring up, though, is that having native db
>> support (I'd recommend Postgresql here, again, due to its excellent
>> reliablity and BSD-style license) seems vital for persistant and unique
>> message ids across all SMSC groups.
>>
>> To persist with the db paradigm further:
>>
>> +------------------------------------------+
>>
>> | +--------+ +----------+ |
>>
>> sms in/ | | | | | | user's db
>> <---+----->| kannel +<------->| postgres +<----+--->
>> out | | | | | | interface
>>
>> | +--------+ +----------+ |
>>
>> +------------------------------------------+
>>
>> This would mean replacing the kannel interface with the user's db
>> interface. I suppose this is no more complex than the existing work you
>> have to do with cgi or whatever to support multiple kannel users over
>> the internet.
>>
>> Cheers!
>> Rory
>>
>> On 28/10/03, [email protected] ([email protected]) wrote:
>> > Hi,
>> >
>> > 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.
>> >
>> > With regards,
>> > Ken A. Rederg?rd
>
> --
> Best regards / Mit besten Grüßen aus Düsseldorf
>
> Dipl.-Ing.
> Alexander Malysh
> ___________________________________________
>
> Centrium GmbH
> Vogelsanger Weg 80
> 40470 Düsseldorf
>
> Fon: +49 (0211) 74 84 51 80
> Fax: +49 (0211) 277 49 109
>
> email: [email protected]
> web: www.centrium.de
> msn: [email protected]
> icq: 98063111
> ___________________________________________
>
> Please avoid sending me Word, Excel or PowerPoint attachments.
> See http://www.fsf.org/philosophy/no-word-attachments.html
>
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.