man, dont know for the mysql triggering i use postgresql mostly, and yes, this could be achieved with trigger or with rule on insert
the trigger updates the data, the rule just changes the data before to be inserted .. :) anyway its not sql issue here and, have to say, the idea to ask mblox for assistance is the best idea cheers Iain Dooley wrote: > >> the workarround .. :) >> in short, use postgresql for the dlr storage >> >> and use rule on insert to overwrite the smsc_id so when kannel does its >> sql query to find the message when DLR comes from the smsc. >> >> im not so familiar with mysql, but dont think mysql is able to do that. > > wow. okay, i'll also check with mblox if they can please send my dlr's > back to the originating server which would solve the problem without me > having to do anything. > > what you're describing above sounds like a trigger, is that correct? if > so you can do that with mysql. is there any documentation anywhere that > describes what has to happen in more detail? > > i need to setup kannel with mysql dlr storage soon anyway .. > > cheers > iain > > >
