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
