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
<http:///>
