Dear Beckman, Thx for the nice explanation. I was trying to out ways to get to the ts field ;) If you recall my earlier message in which i mentioned about the script which is called in using dlr-url to check for the unique id in kannel table to get to the ts field ? There is one problem to it, if the message is delivered before my script gets to it then the script has no way to get the ts field hence i was trying to get something on that. Getting another insert was basically to get those values in another table for the same work and then remove them at leisure, says once a day or something.
-- regards, Anand > On Fri, 15 Apr 2005, Anand Gupta wrote: > >> is it possible (it should be actually for a kannel hacker) that when the >> mysql inserts are made, a second insert is made in another db which will >> probably be a clone of the dlr db of kannel except certain parameters >> will >> be kept in for further use ? >> >> I guess i should start looking for some kannel hacker or someone who >> could >> help in changing code inside ./gw/dlr_mysql.c where all this happens. >> Anyone ? > > The DLR store, either internal or mysql, is not intended for your use, > only for kannel. > > The purpose is to keep an entry in the store until the message is either > reported as successfully delivered OR absolutely failed (I believe). > Once > they are delivered or failed, the need for the entry in the store is no > longer needed (no more calls to the DLR URL will occur, etc). > > The DLR URL has a purpose -- to give you as much information about the > delivery of a message to a script you write. That script can do all > sorts > of things, like make an entry in a DB table that is a clone of the > Kannel > MYSQL Store table. > > That's why the script you write to handle DLRs is so important, IF you > want to keep that information. > > So make your dlr url a script, and write it to do what you asked. I > highly doubt the kannel code will ever do this natively, because it > isn't > really a core function of kannel, it's just a feature which can be > implemented by you. > > Beckman > --------------------------------------------------------------------------- > Peter Beckman Internet > Guy > [EMAIL PROTECTED] > http://www.purplecow.com/ > --------------------------------------------------------------------------- >
