Hi, On Wednesday 29 October 2003 09:59, [EMAIL PROTECTED] wrote: > Hi, > > Do you have any suggestions on where to start doing this ?
not really... > > 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. please no. smsbox is even right now a bit overloaded and imo smsbox is not a right place for db stuff. > > The thought of creating a dbbox has also struk me, does that sound as a > good idea ? that imo a good idea... if I undestand design of kannel correctly then this is the way to go... Good luck! > > > 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 -- 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
