you can use mysql triggers at insert to do a copy in another similar table.
On Sat, Jan 22, 2011 at 9:14 AM, Kazi M <[email protected]> wrote: > > Dear Nabble Users, > > I noticed that using above configuration ... i see that the delivery report > is getting stored in the database but it is deleted immediately after > inserting .. how can i retain this delivery report permanently in mysql > database table. > > Any type of Help will be a great favour > > thanking you > > > > Kazi M wrote: > > > > http://old.nabble.com/file/p30699861/smskannel.conf smskannel.conf > > http://old.nabble.com/file/p30699861/smsbox.log smsbox.log > > http://old.nabble.com/file/p30699861/kannel.log kannel.log > > > > > > Hello Team, > > > > I m using Kannel 1.4.3 with mysql 4.2 ... I compiled kannel with mysql > > succesfully .... and have created the db table as well and am trying to > > send sms using http interface .. and am using smppsimulator as smsc ... > > now my requirement is to test kannel with delivery reports .. and i want > > my delivery report to be stored in the table ... but my url is not > hitting > > and it says dlr-url cannot be fetched > > > > i have attached my config file , smsboxlog,bearerboxlog,and my php > > scripts(config.php and dlr.php) > > and my dlr-url is in encoded form > > > > > http://127.0.0.1:13013/cgi-bin/sendsms?username=tester&password=foobar&to=012323&from=012445&text=HELLO&dlr-mask=31&dlr-url=http%3A%2F%2Flocalhost%2Fdlr.php%3Fsmsc%3D%25i%26status%3D%25d%26service%3D%25n%26destination%3D%25P%26source%3D%25p%26ts%3D%25t > > > > above is the url I am giving in the browser .. > > > > and i also have doubt about where should be these php scripts placed (i > > mean in which folder) > > > > http://old.nabble.com/file/p30699861/dlr.php dlr.php > > http://old.nabble.com/file/p30699861/config.php config.php > > > > > > Please Guys Help me out .. I am not directly asking u guys . I ve trying > > from past 2 weeks and read almost all of the posts related to dlr-url .. > > but coudnt find a solution > > > > Help would be greatly Appreciated > > > > > > > > Your's Thankful, > > Kazi M > > > > -- > View this message in context: > http://old.nabble.com/ERROR%3A-Couldn%27t-fetch-dlr-url-tp30699861p30734567.html > Sent from the Kannel - User mailing list archive at Nabble.com. > > > -- Regards, Abdul Basit | +92 32 1416 4196 | +92 30 0841 1445
