Hi, Apparently your bearerbox doesn't know where to route received DLRs. You should read UG about smsbox-route, and then route all your DLRs to your smsbox, so that they can be posted to your dlr-url.
BR, Nikos On Sun, Jun 26, 2011 at 7:04 AM, Harbhag Singh Sohal < harbhag.so...@gmail.com> wrote: > Sometimes the dlr is stored in the table specified by me via the > dlr-url script and sometimes it get stored in the sent_sms table of > sqlbox. Why is this happening ? > > On Sat, Jun 25, 2011 at 5:39 PM, Nikos Balkanas <nbalka...@gmail.com> > wrote: > > Hi, > > > > Your php is not kannel's problem. This is not a php forum. There are 2 > ways > > to match dlrs to original SMS. > > 1) access.log > > 2) Specify your own msgid in your dlr-url: > > &msgid=<id> > > wehere id=1,2..... > > You know what sms you are sending when you specify your dlr-url. You also > > get back that id once the relevant DLR arrives. You can match those two. > > BR, > > Nikos > > > > > > On Sat, Jun 25, 2011 at 1:29 PM, Harbhag Singh Sohal > > <harbhag.so...@gmail.com> wrote: > >> > >> but how would I know that which dlr is from which SMS ? > >> is it being identified by msgid parameter ? > >> > >> > >> I am using sqlbox to send sms so in the dlr-url column I have added > >> http://localhost/dlr.php as the dlr-url and dlr-mask is set to 31. > >> > >> and the dlr.php file contains > >> > >> $conn = mysql_connect("localhost","foo","bar"); > >> mysql_select_db("adbook",$conn); > >> mysql_query("INSERT INTO tdlr ('dlr') VALUES ('1')"); > >> > >> mysql_close($conn); > >> > >> this is the only code that is there in dlr.php file and according to > >> this an new row should be inserted into the database everytime dlr is > >> received, but its not happening. > >> > >> On Sat, Jun 25, 2011 at 1:41 PM, Harbhag Singh Sohal > >> <harbhag.so...@gmail.com> wrote: > >> > but how would I know that which dlr is from which SMS ? > >> > is it being identified by msgid parameter ? > >> > > >> > On Fri, Jun 24, 2011 at 9:03 PM, Rene Kluwen <rene.klu...@chimit.nl> > >> > wrote: > >> >> > >> >> > >> >> > >> >> > >> >> From: Mpeirwe Benjamin [mailto:bmpei...@gmail.com] > >> >> Sent: Friday, 24 June, 2011 15:54 > >> >> To: Rene Kluwen > >> >> Subject: Re: understanding DLR > >> >> > >> >> > >> >> > >> >> dlr you specified is a temporary storage....do what rene told you > >> >> > >> >> On Fri, Jun 24, 2011 at 2:07 PM, Rene Kluwen <rene.klu...@chimit.nl> > >> >> wrote: > >> >> > >> >> Don't use the dlr database table for that. > >> >> Instead specify dlr-mask & dlr-url. See the users guide. > >> >> > >> >> -----Original Message----- > >> >> From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On > >> >> Behalf > >> >> Of Harbhag Singh Sohal > >> >> Sent: Friday, 24 June, 2011 08:22 > >> >> To: users@kannel.org > >> >> Subject: understanding DLR > >> >> > >> >> HI, > >> >> > >> >> I am using mysql as dlr-storage. When I send SMS I can see dlr table > >> >> get populated but after its gets deleted. Now in the access.log file, > >> >> I see the following entries > >> >> > >> >> 2011-06-24 11:42:58 Sent SMS [SMSC:huawei_e220] [SVC:] [ACT:] [BINF:] > >> >> [FID:62] [META:] [from:+9194********] [to:94********] > >> >> [flags:-1:0:-1:-1:31] [msg:38:---..Harbhag Singh Sohal.] [udh:0:] > >> >> 2011-06-24 11:42:58 Receive DLR [SMSC:huawei_e220] [SVC:] [ACT:] > >> >> [BINF:] [FID:62] [META:] [from:+9194********] [to:94*******] > >> >> [flags:-1:-1:-1:-1:8] [msg:4:ACK/] [udh:0:] > >> >> 2011-06-24 11:43:57 Receive DLR [SMSC:huawei_e220] [SVC:] [ACT:] > >> >> [BINF:] [FID:62] [META:] [from:+9194**********] [to:94*******] > >> >> [flags:-1:-1:-1:-1:1] [msg:7:Success] [udh:0:] > >> >> > >> >> From above i can see that message was delivered successfully. What is > >> >> [FID:62] , is it being used to associate a particular message to its > >> >> dlr. How can store the above information to the database so that I > can > >> >> notify the users that the message has been delivered successfully ? > >> >> > >> >> -- > >> >> Regards > >> >> Harbhag Singh Sohal > >> >> www.harbhag.wordpress.com > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> -- > >> >> "The Scientist explores what is, > >> >> the Engineer creates what has never been." > >> >> Theodore von Karman > >> >> > >> >> > >> > > >> > > >> > > >> > -- > >> > Regards > >> > Harbhag Singh Sohal > >> > www.harbhag.wordpress.com > >> > > >> > >> > >> > >> -- > >> Regards > >> Harbhag Singh Sohal > >> www.harbhag.wordpress.com > >> > > > > > > > > -- > Regards > Harbhag Singh Sohal > www.harbhag.wordpress.com > >