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
