hi!! in short, as we have mentioned several times, the dlr table is used to store the queue of messages NOT sent to the SMSC. So once sent, the cooresponding dlr table record of a particular messages is DELETED.
In short, you should have EMPTY dlr table most of the time, in case your smsc connection is stable. In case you want to store the DELVERY STATUSES of e SENT massage, you need something MORE to be done. simple example: needed daemons: A db server of your choice, db table with a design according to your needs. FIRST READ twice this manual, THEN ask what is the db design. Web server, with script handling GET requests. the script, in short to name it get.dlr.status.crap, will get the HTTP GET request values and will store them in the db you have created. NOW, WHAT info may Kannel provide for you ? read here, http://kannel.org/download/kannel-userguide-snapshot/userguide.html#AEN3607 Table 6-9. Parameters (Escape Codes) in a view to make kannel feed the script with info about a sent massage, you HAVE TO SET the dlr-mask more than 1: why ? read bellow a quotation from the manual dlr-mask number (bit mask) Optional. Request for delivery reports with the state of the sent message. The value is a bit mask composed of: 1: Delivered to phone, 2: Non-Delivered to Phone, 4: Queued on SMSC, 8: Delivered to SMSC, 16: Non-Delivered to SMSC. Must set dlr-url on sendsms-user group or use the dlr-url CGI variable. so WHEN you know what info do you want from the SMSC reports, you HAVE to SET unique dlr-url for each message example: "http://localhost/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID=3dbbe751d578416708726402f1866c5c&charset=%C&kannel_id=%I"; how come this is a unique dlr-url ? because the smsID you create is unique for your system, i.e. each time you call the sendsms with another value for the dlr-url ok NOW you URLENCODE the value of the dlr-url when you compose the sendsms url http://localhost:13005/cgi-bin/sendsms?username=pyro&password=pyro&from=8888&to=91971236987&text=Test%20Message&charset=UTF-16BE&mclass=2&coding=1&pid=0&dlr-mask=31 &dlr-url=http%3A%2F%2Flocalhost%2Fdlr.pgsql.php%3FsmscID%3D%25i%26dlr%3D%25d%26answer%3D%25A%26to%3D%25p%26from%3D%25P%26ts%3D%25T%26smsID%3D3dbbe751d578416708726402f1866c5c%26charset%3D%25C%26kannel_id%3D%25I So, now WHEN the SMSC reports a status change of the SENT sms with id 3dbbe751d578416708726402f1866c5c, Kannel will parse the dlr-url and will initiate HTTP GET request at the dlr-url with the values received from the SMSC HERE you use your proficient skills in web and database programming and administration. the called dlr.pgsql.php script could perform simple sql injection, or another more complicated task. So again FORGET about the dlr table used by kannel pandu reddy wrote: > hi !! > > i'm using kannel and all works well(connection to the > simulator(smpp), sms sending and receiving), but > though i put the mysql storage i find the sms > in the table for only submit_sm. send the messages through http we can set > the dlr-mask value.but how we can set a > > dlr_mask value for for deliver_sm.the deliver_sm messages will come through > simulator.So how we can inserted deliver_sm messages in table . > > i want some more fields in the mysql dlr table like > message ,msg_type,date ,submit_time fields in a one table . > > is it possible?. i created in message field in table test with simulator it > showing *zero* in the table.and added msg_type also it is also same > /_*ZERO*_/ in > the table.how i can set this two parameters in mysql dlr table.can i add > any fields in the config file. > > > i am using below url for submit messages > > http://localhost:13005/cgi-bin/sendsms?username=pyro&password=pyro&from=8888&to=91971236987&text=Test%20Message&charset=UTF-16BE&mclass=2&coding=1&pid=0&dlr-mask=31 > > <http://localhost:13005/cgi-bin/sendsms?username=pyro&password=pyro&from=8888&to=91971236987&text=Test%20Message&charset=UTF-16BE&mclass=2&coding=1&pid=0&dlr-mask=31> > > > with this url how we can set dlr-mask value for > deliver_sm.wat is the dlr_mask value for SMPPSimulator. > > > please help me > Thanks in Advance. > > Best Regards, >
