Thanks for responding Willy. With regard to (1), if sqlbox is not being used, what is the benefit of using mysql dlr over using internal dlr?
With which version is sqlbox compatible? Thanks, Sindu ----- Original Message ---- From: Willy Mularto <sangpr...@gmail.com> To: Sindu R <riss.regis...@yahoo.com> Cc: users@kannel.org Sent: Fri, 15 January, 2010 8:44:01 AM Subject: Re: Questions regarding MySQL dlr and sqlbox 1 and 2, you have answered your own question ;) 2.a, 2.b, 2.c SQLBox Store all MO, MT, and DLR in sent_sms table (it doesn't delete it from that table). Do not use SQLBox with current CVS and stable version. It still incompatible. Willy sangpr...@gmail.com On Jan 15, 2010, at 9:22 AM, Sindu R wrote: > Hello, > > Would really appreciate some inputs / more information. > Pointers to the documentation / posts will also help. > > Thanks, > Sindu > > > ----- Original Message ---- > From: Sindu R <riss.regis...@yahoo.com> > To: users@kannel.org > Sent: Wed, 13 January, 2010 3:20:58 PM > Subject: Questions regarding MySQL dlr and sqlbox > > Hi, > > I have been learning to use Kannel for MT and MO messages and have > successfully managed to get it working. > My initial configuration was using dlr-storage = internal and have now > switched to using MySQL dlr. > > Though the configuration works fine, I have some basic questions in this > regard. > > 1) What is the basic difference in using dlr-storage = internal and > dlr-storage = mysql? > I understand that in the first case, dlrs are stored in the memory and in the > second case, mysql db is used.. > However, since this is used internally by Kannel and the entries are finally > deleted from the table, can anyone help me understand how using mysql for dlr > storage will be helpful. > In a typical app scenario, what benefit will using mysql dlr provide over > using internal dlr storage? > > 2) Though my understanding was initially incorrect, I now understand that in > order to store the dlrs, I need to have my own table and the dlr-url should > handle the requirement of adding / updating the dlr information in my custom > table as per my app requirement. > I just recently came across sqlbox and was wondering if using sqlbox would > simplify managing sent messages and delivery reports. > > a) I understand that it can be used for MT messages by adding the messages to > be sent to the send_sms table and once sent will be moved to the sent_sms > table. > Will these messages continue to remain in the sent_sms table? > > b) Will sqlbox also help in handling MO messages and delivery reports? > Will the delivery reports also get stored in any table or would we need to > handle this in code as when not using sqlbox? > > c) If sqlbox handles delivery reports as well, what is the significance of > the dlr-url when using sqlbox? > > It would be really great if someone could answer these queries. > > Thanks, > Sindu > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >http://in.yahoo.com/ > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >http://in.yahoo.com/ > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
