Hi all,
I have difficulty to set the DLR works for my kannel. My current configuration is to store the delivery report into MySQL database server but I didn't get any delivery report store to MySQL after I send the messages. What I do is, I send a sms to kannel by using http://192.168.0.98:13013/cgi-bin/sendsms?username=tester&password=foobar&to =0122126189&from=0122112880&text=Message+From+Gateway After I sent the message, I check the status and I got this: Kannel bearerbox version `1.1.6'. System Linux, release 2.4.8-26mdk, version #1 Sun Sep 23 17:06:39 CEST 2001, machine i586. Hostname smsgateway, IP 192.168.0.98. Libxml version 20403. Using MySQL 3.23.47. Using checking malloc. Status: running, uptime 0d 0h 12m 3s WDP: received 0 (0 queued), sent 0 (0 queued) SMS: received 0 (0 queued), sent 1 (0 queued), store size 0 DLR: 0 queued, using mysql storage Box connections: smsbox, IP 127.0.0.1 (on-line 0d 0h 11m 6s) SMSC connections: WMODB AT2[WMODB] (online 723s, rcvd 0, sent 4, failed 0, queued 0 msgs) and I check the bearerbox console, I got this: 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: international starting with + (+60122126189) 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: TP-Validity-Period: 24.0 hours 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: --> AT+CMGS=37^M 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: <-- > 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: send command status: 1 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: --> 0011000B910621126281F90000A71ACDF27C1E3E974146F9BB0D3A86E9E57B380F0A9EC36937 2002-04-15 09:39:27 [6] DEBUG: AT2[WMODB]: --> ^Z 2002-04-15 09:39:30 [6] DEBUG: AT2[WMODB]: <-- > 2002-04-15 09:39:30 [6] DEBUG: AT2[WMODB]: <-- +CMGS: 93 2002-04-15 09:39:30 [6] DEBUG: AT2[WMODB]: <-- OK 2002-04-15 09:39:30 [6] DEBUG: AT2[WMODB]: send command status: 0 2002-04-15 09:39:30 [1] DEBUG: Dumping 0 messages and 0 acks to store Can anyone tell me what's wrong with it? I attached my kannel.conf, dlr-mysql.dlr and dlr table structure below. best regard, Conteng. --------------kannel.conf---------------------------------------------- group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar log-file = "/usr/local/gateway/log/bearerbox.log" log-level = 4 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1;192.168.0.*" unified-prefix = "+60,0;+6012,012" access-log = "/usr/local/gateway/log/beareraccess.log" store-file = "/usr/local/gateway/log/smsDlr.store" dlr-storage = mysql include = "dlr-mysql.conf" # SMSC CONNECTIONS group = smsc smsc = at2 smsc-id = WMODB modemtype = wavecom device = /dev/ttyS0 speed = 9600 pin = 7151071 group = modems id = wavecom name = WMODB detect-string = WAVECOM # SMSBOX SETUP group = smsbox bearerbox-host = localhost sendsms-port = 13013 global-sender = 13013 log-file = "/usr/local/gateway/log/smsbox.log" log-level = 4 access-log = "/usr/local/gateway/log/smsboxaccess.log" # SEND-SMS USERS group = sendsms-user username = tester password = foobar default-sender = "+60122112880" # SERVICES group = sms-service keyword = nop text = "You asked nothing and I did it!" # there should be default always group = sms-service keyword = default text = "No service spesified" max-messages = 0 catch-all = true ---------------------dlr-mysql.conf--------------------------------------- group = mysql-connection id = dlr-db host = localhost mysql-username = kannel mysql-password = password database = kannel_dlr group = dlr-mysql mysql-id = dlr-db table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-service = service field-url = url field-mask = mask field-status = status -------------dlr table structure---------------------------------------------- mysql> desc dlr; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | smsc | varchar(40) | YES | | NULL | | | ts | varchar(40) | YES | | NULL | | | destination | varchar(40) | YES | | NULL | | | service | varchar(40) | YES | | NULL | | | url | varchar(255) | YES | | NULL | | | mask | int(10) | YES | | NULL | | | status | int(10) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec)
