Hi, You need to make a script/program that will collect the DLRs and update field "status". That script must be reachable via the dlr_url addres. Your field "status" will not be updated by magic :). The dlr_url will be called by kannel when the DLR is received by kannel and pass to it the DLR... then your script/progam needs to update the field "status" accordingly.
Hope it helps. Regards. Sent with MailTrack <https://mailtrack.io/install?source=signature&lang=en&referral=loycos...@gmail.com&idSignature=22> ------ loyc Cossou On 30 August 2016 at 10:33, JAHANZAIB SYED <aaca...@hotmail.com> wrote: > Dear mr.mahdi at gmail.com > > Hope you are doing well. and please accept my apology to contact you like > this. I need some help regarding kannel. I tried to join the kannel mailing > list few times but didn't received any reply. > I recently implemented kannel 1.4.x with sqlbox on ubuntu 12.4. all is > working. If i add insert query in send_sms table , the kannel send the sms > and move its entry to sent_sms. example: > > INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type, > smsc_id) VALUES ( 'MT', 'TESTID', '03333021909', 'test from zaib via mysql > box', 2,'zaibgsmid'); > > my send_sms and sent_sms table is as follows (both are same) > > mysql> describe send_sms; > +-----------+-----------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+-----------------+------+-----+---------+----------------+ > | sql_id | bigint(20) | NO | PRI | NULL | auto_increment | > | momt | enum('MO','MT') | YES | | NULL | | > | sender | varchar(20) | YES | | NULL | | > | receiver | varchar(20) | YES | | NULL | | > | udhdata | blob | YES | | NULL | | > | msgdata | text | YES | | NULL | | > | time | bigint(20) | YES | | NULL | | > | smsc_id | varchar(255) | YES | | NULL | | > | service | varchar(255) | YES | | NULL | | > | account | varchar(255) | YES | | NULL | | > | id | bigint(20) | YES | | NULL | | > | sms_type | bigint(20) | YES | | NULL | | > | mclass | bigint(20) | YES | | NULL | | > | mwi | bigint(20) | YES | | NULL | | > | coding | bigint(20) | YES | | NULL | | > | compress | bigint(20) | YES | | NULL | | > | validity | bigint(20) | YES | | NULL | | > | deferred | bigint(20) | YES | | NULL | | > | dlr_mask | bigint(20) | YES | | NULL | | > | dlr_url | varchar(255) | YES | | NULL | | > | pid | bigint(20) | YES | | NULL | | > | alt_dcs | bigint(20) | YES | | NULL | | > | rpi | bigint(20) | YES | | NULL | | > | charset | varchar(255) | YES | | NULL | | > | boxc_id | varchar(255) | YES | | NULL | | > | binfo | varchar(255) | YES | | NULL | | > | meta_data | text | YES | | NULL | | > | status | varchar(10) | YES | | NULL | | > +-----------+-----------------+------+-----+---------+----------------+ > 28 rows in set (0.01 sec) > > > But the only problem is that it does not update the status field. my goal > is to see the result so that i can query for successfull/failed sent sms. > > I guess it have something to with the dlr, can some1 please help me howto > configure dlr? howcan i submit dlr with url or directly in mysql? > any sample config? > > > > > *Regards, * > *JZ* >
