The idea is like this

1. In SMS Outgoing Queue you have this table entries:
   id_sms | sms_destination | sms_message | state |
       1        6281111          test sms            0
       2        6281112          test sms            0
       3        6281113          test sms            0



2.When you send SMS with "id_sms=1" like point 1 to Kannel SMSGW by HTTP Request, please add these Query STring parameter

   dlr-mask=31
dlr-url=urlencode(http://yourhost/dlr.php?msgid=<id_sms>&state=%d&msisdn=%p)

example (kannel sms sender listen on port 8811, with URI /sendsms, username=xxx, password=yyy, yourhost=127.0.0.1):

http://localhost:8811/sendsms?username=xxx&password=yyy&to=6281111&text=test+sms&dlr-mask=31&dlr-url=http%3A%2F%2F127.0.0.1%2Fdlr.php%3Fmsgid%3D1%26state%3D%25d%26msisdn%3D%25p

3. When Kannel receive delivery report, it will request http://yourhost/dlr.php and pass Query String parameter msgid=<id_sms>&state... and so on

   Your php script then simply

UPDATE table SET state=$HTTP_GET_VARS["state"] WHERE id_sms=$HTTP_GET_VARS["msgid"]

Good luck
Jay wrote:

Hi guys,

I have been searching the mailing list for a somewhat clear explanation of implementing dlr's.

could someone give me a step by step procedure into implementing dlr?

i already have this :

    dlr-storage = mysql

    dlr-url = "http://localhost/jay/dlr.php?type=%d";

    created the dlr-db group, dlr table and etc...
and invokes /cgi-bin/sendsms with dlr-mask=1+2

questions are :

1. will kannel be the one to insert to the dlr table? or will my script in dlr-url handle the insert on dlr table?

2. what are the most common parameters needed for the dlr-url?

3. are the sample dlr table fields in dlr-mysql.conf all mandatory? what parameters should i use to insert to those fields?

4. how do i create msg id? is this the same with SMS ID?

too many questions, so little time...

help guys!

thanks in advance!








*Roland Jay E. Acuesta Jr.*
Application Developer / Software Engr. / DBA
GMA NEW MEDIA INC.
GMA Network Center
11th Jamboree St. Kamuning, Q.C.
Tel : (632)-882-2300
Mobile : +63919-3633711
// /"Contentment is not the fulfillment of what you want, it is the realization of how much you already have."/

------------------------------------------------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC <http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com> and save big.




Reply via email to