I am having difficulty getting DLR messages to work. One sample message I sent had the following dlr-url saved in sent_sms: http://localhost/dispatch/delivery_status?bulkmt_id=24&type=%25d
When the url gets called by smsbox the type=%d does not get updated with the delivery status. This is my set up below and log snippets for the message sent. kannel version: svn-r4858 sqlbox version: svn-r4858 core smsbox-port = 13002 smsbox2342 smsbox-id = sqlbox bearerbox-port = 13005 sendsms-port = 13013 smsc smsc-id = My SMSC sqlbox smsbox-id = sqlbox bearerbox-port = 13002 smsbox-port = 13005 smsbox-route group = smsbox-route smsbox-id = sqlbox smsc-id = "My SMSC" smsc log ======== 2011-01-24 12:05:40 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (0.00,0.00) 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (0.00,0.00) 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[25188971234]: Sending PDU: 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP PDU 0x12c1920 dump: 2011-01-24 12:05:57 [24926] [6] DEBUG: type_name: submit_sm 2011-01-24 12:05:57 [24926] [6] DEBUG: command_id: 4 = 0x00000004My SMSC 2011-01-24 12:05:57 [24926] [6] DEBUG: command_status: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: sequence_number: 1492 = 0x000005d4 2011-01-24 12:05:57 [24926] [6] DEBUG: service_type: NULL 2011-01-24 12:05:57 [24926] [6] DEBUG: source_addr_ton: 2 = 0x00000002 2011-01-24 12:05:57 [24926] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2011-01-24 12:05:57 [24926] [6] DEBUG: source_addr: "2342" 2011-01-24 12:05:57 [24926] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 2011-01-24 12:05:57 [24926] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2011-01-24 12:05:57 [24926] [6] DEBUG: destination_addr: "25188971234" 2011-01-24 12:05:57 [24926] [6] DEBUG: esm_class: 3 = 0x00000003 2011-01-24 12:05:57 [24926] [6] DEBUG: protocol_id: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: priority_flag: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: schedule_delivery_time: NULL 2011-01-24 12:05:57 [24926] [6] DEBUG: validity_period: NULL 2011-01-24 12:05:57 [24926] [6] DEBUG: registered_delivery: 1 = 0x00000001 2011-01-24 12:05:57 [24926] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: data_coding: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: sm_length: 5 = 0x00000005 2011-01-24 12:05:57 [24926] [6] DEBUG: short_message: "test2" 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP PDU dump ends. 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (1.00,0.00) 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (1.00,0.00) 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[My SMSC]: Got PDU: 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP PDU 0x12c1920 dump: 2011-01-24 12:05:57 [24926] [6] DEBUG: type_name: submit_sm_resp 2011-01-24 12:05:57 [24926] [6] DEBUG: command_id: 2147483652 = 0x80000004 2011-01-24 12:05:57 [24926] [6] DEBUG: command_status: 0 = 0x00000000 2011-01-24 12:05:57 [24926] [6] DEBUG: sequence_number: 1492 = 0x000005d4 2011-01-24 12:05:57 [24926] [6] DEBUG: message_id: "d41591" 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP PDU dump ends. 2011-01-24 12:05:57 [24926] [6] DEBUG: DLR[mysql]: Adding DLR smsc=My SMSC, ts=13899153, src=2342, dst=25188971234, mask=31, boxc=sqlbox 2011-01-24 12:05:57 [24926] [6] DEBUG: adding DLR entry into database 2011-01-24 12:05:57 [24926] [6] DEBUG: sql: INSERT INTO `dlr` (`smsc`, `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxid`, `status`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) 2011-01-24 12:05:57 [24926] [6] DEBUG: SMSC[My SMSC]: creating DLR message 2011-01-24 12:05:57 [24926] [6] DEBUG: SMSC[My SMSC]: DLR = http://localhost/dispatch/delivery_status?bulkmt_id=25&type=%25d 2011-01-24 12:05:57 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (1.00,0.00) 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP[My SMSC]: throughput (0.00,0.00) 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP[My SMSC]: Got PDU: 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP PDU 0x12c1920 dump: 2011-01-24 12:06:03 [24926] [6] DEBUG: type_name: deliver_sm 2011-01-24 12:06:03 [24926] [6] DEBUG: command_id: 5 = 0x00000005 2011-01-24 12:06:03 [24926] [6] DEBUG: command_status: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: sequence_number: 19 = 0x00000013 2011-01-24 12:06:03 [24926] [6] DEBUG: service_type: NULL 2011-01-24 12:06:03 [24926] [6] DEBUG: source_addr_ton: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: source_addr_npi: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: source_addr: "25188971234" 2011-01-24 12:06:03 [24926] [6] DEBUG: dest_addr_ton: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: dest_addr_npi: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: destination_addr: "2342" 2011-01-24 12:06:03 [24926] [6] DEBUG: esm_class: 4 = 0x00000004 2011-01-24 12:06:03 [24926] [6] DEBUG: protocol_id: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: priority_flag: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: schedule_delivery_time: NULL 2011-01-24 12:06:03 [24926] [6] DEBUG: validity_period: NULL 2011-01-24 12:06:03 [24926] [6] DEBUG: registered_delivery: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: data_coding: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: sm_length: 102 = 0x00000066 2011-01-24 12:06:03 [24926] [6] DEBUG: short_message: 2011-01-24 12:06:03 [24926] [6] DEBUG: Octet string at 0x12bf950: 2011-01-24 12:06:03 [24926] [6] DEBUG: len: 102 2011-01-24 12:06:03 [24926] [6] DEBUG: size: 103 2011-01-24 12:06:03 [24926] [6] DEBUG: immutable: 0 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 69 64 3a 30 30 31 33 38 39 39 31 35 33 20 73 75 id:0013899153 su 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 62 3a 30 30 31 20 64 6c 76 72 64 3a 30 30 31 20 b:001 dlvrd:001 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 61 74 65 3a 31 31 30 31 submit date:1101 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 32 34 31 32 30 35 20 64 6f 6e 65 20 64 61 74 65 241205 done date 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 3a 31 31 30 31 32 34 31 32 30 35 20 73 74 61 74 :1101241205 stat 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 3a 44 45 4c 49 56 52 44 20 65 72 72 3a 30 30 32 :DELIVRD err:002 2011-01-24 12:06:03 [24926] [6] DEBUG: data: 20 74 65 78 74 3a text: 2011-01-24 12:06:03 [24926] [6] DEBUG: Octet string dump ends. 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP PDU dump ends. 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP[My SMSC] handle_pdu, got DLR 2011-01-24 12:06:03 [24926] [6] DEBUG: DLR[mysql]: Looking for DLR smsc=My SMSC, ts=13899153, dst=25188971234, type=1 2011-01-24 12:06:03 [24926] [6] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxid` FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1 2011-01-24 12:06:03 [24926] [6] DEBUG: column=mask buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: column=service buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: column=url buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: column=source buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: column=destination buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: column=boxid buffer_type=253 max_length=0 length=255 2011-01-24 12:06:03 [24926] [6] DEBUG: DLR[mysql]: created DLR message for URL <http://localhost/dispatch/delivery_status?bulkmt_id=25&type=%25d> 2011-01-24 12:06:03 [24926] [6] DEBUG: removing DLR from database 2011-01-24 12:06:03 [24926] [6] DEBUG: sql: DELETE FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1 2011-01-24 12:06:03 [24926] [6] DEBUG: new group created `smpp' 2011-01-24 12:06:03 [24926] [6] DEBUG: group=`smpp' key=`dlr_err' value=`002' 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP[My SMSC]: Sending PDU: 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP PDU 0x12bd100 dump: 2011-01-24 12:06:03 [24926] [6] DEBUG: type_name: deliver_sm_resp 2011-01-24 12:06:03 [24926] [6] DEBUG: command_id: 2147483653 = 0x80000005 2011-01-24 12:06:03 [24926] [6] DEBUG: command_status: 0 = 0x00000000 2011-01-24 12:06:03 [24926] [6] DEBUG: sequence_number: 19 = 0x00000013 2011-01-24 12:06:03 [24926] [6] DEBUG: message_id: NULL 2011-01-24 12:06:03 [24926] [6] DEBUG: SMPP PDU dump ends. smsbox log ========== 2011-01-24 12:06:03 [24950] [4] INFO: Starting delivery report <(null)> from <2342> 2011-01-24 12:06:03 [24950] [9] DEBUG: Queue contains 0 pending requests. 2011-01-24 12:06:03 [24950] [9] DEBUG: Parsing URL `http://localhost/dispatch/delivery_status?bulkmt_id=25&type=%25d': 2011-01-24 12:06:03 [24950] [9] DEBUG: Scheme: http:// 2011-01-24 12:06:03 [24950] [9] DEBUG: Host: localhost 2011-01-24 12:06:03 [24950] [9] DEBUG: Port: 80 2011-01-24 12:06:03 [24950] [9] DEBUG: Username: (null) 2011-01-24 12:06:03 [24950] [9] DEBUG: Password: (null) 2011-01-24 12:06:03 [24950] [9] DEBUG: Path: /dispatch/delivery_status 2011-01-24 12:06:03 [24950] [9] DEBUG: Query: bulkmt_id=25&type=%25d 2011-01-24 12:06:03 [24950] [9] DEBUG: Fragment: (null) 2011-01-24 12:06:03 [24950] [9] DEBUG: Connecting nonblocking to <127.0.0.1> 2011-01-24 12:06:03 [24950] [9] DEBUG: HTTP: Opening connection to `localhost:80' (fd=27). 2011-01-24 12:06:03 [24950] [9] DEBUG: Socket connecting 2011-01-24 12:06:03 [24950] [8] DEBUG: Get info about connecting socket 2011-01-24 12:06:03 [24950] [8] DEBUG: HTTP: Sending request: 2011-01-24 12:06:03 [24950] [8] DEBUG: Octet string at 0xad05d0: 2011-01-24 12:06:03 [24950] [8] DEBUG: len: 136 2011-01-24 12:06:03 [24950] [8] DEBUG: size: 1024 2011-01-24 12:06:03 [24950] [8] DEBUG: immutable: 0 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 47 45 54 20 2f 64 69 73 70 61 74 63 68 2f 64 65 GET /dispatch/de 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6c 69 76 65 72 79 5f 73 74 61 74 75 73 3f 62 75 livery_status?bu 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6c 6b 6d 74 5f 69 64 3d 32 35 26 74 79 70 65 3d lkmt_id=25&type= 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 25 32 35 64 20 48 54 54 50 2f 31 2e 31 0d 0a 48 %25d HTTP/1.1..H 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6f 73 74 3a 20 6c 6f 63 61 6c 68 6f 73 74 0d 0a ost: localhost.. 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 43 6f 6e 6e 65 63 74 69 6f 6e 3a 20 6b 65 65 70 Connection: keep 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 2d 61 6c 69 76 65 0d 0a 55 73 65 72 2d 41 67 65 -alive..User-Age 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6e 74 3a 20 4b 61 6e 6e 65 6c 2f 73 76 6e 2d 72 nt: Kannel/svn-r 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 34 38 35 38 0d 0a 0d 0a 4858.... 2011-01-24 12:06:03 [24950] [8] DEBUG: Octet string dump ends. 2011-01-24 12:06:03 [24950] [8] DEBUG: HTTP: Status line: <HTTP/1.1 200 OK> 2011-01-24 12:06:03 [24950] [8] DEBUG: HTTP: Received response: 2011-01-24 12:06:03 [24950] [8] DEBUG: Octet string at 0xad04b0: 2011-01-24 12:06:03 [24950] [8] DEBUG: len: 323 2011-01-24 12:06:03 [24950] [8] DEBUG: size: 1024 2011-01-24 12:06:03 [24950] [8] DEBUG: immutable: 0 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 44 61 74 65 3a 20 4d 6f 6e 2c 20 32 34 20 4a 61 Date: Mon, 24 Ja 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6e 20 32 30 31 31 20 31 31 3a 30 36 3a 30 33 20 n 2011 11:06:03 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 47 4d 54 0d 0a 53 65 72 76 65 72 3a 20 41 70 61 GMT..Server: Apa 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 63 68 65 2f 32 2e 32 2e 31 36 20 28 55 62 75 6e che/2.2.16 (Ubun 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 74 75 29 0d 0a 58 2d 50 6f 77 65 72 65 64 2d 42 tu)..X-Powered-B 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 79 3a 20 50 68 75 73 69 6f 6e 20 50 61 73 73 65 y: Phusion Passe 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6e 67 65 72 20 28 6d 6f 64 5f 72 61 69 6c 73 2f nger (mod_rails/ 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 6d 6f 64 5f 72 61 63 6b 29 20 33 2e 30 2e 30 0d mod_rack) 3.0.0. 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 0a 58 2d 52 75 6e 74 69 6d 65 3a 20 37 0d 0a 43 .X-Runtime: 7..C 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 61 63 68 65 2d 43 6f 6e 74 72 6f 6c 3a 20 6e 6f ache-Control: no 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 2d 63 61 63 68 65 0d 0a 43 6f 6e 74 65 6e 74 2d -cache..Content- 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 4c 65 6e 67 74 68 3a 20 31 0d 0a 53 74 61 74 75 Length: 1..Statu 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 73 3a 20 32 30 30 0d 0a 56 61 72 79 3a 20 41 63 s: 200..Vary: Ac 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 63 65 70 74 2d 45 6e 63 6f 64 69 6e 67 0d 0a 4b cept-Encoding..K 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 65 65 70 2d 41 6c 69 76 65 3a 20 74 69 6d 65 6f eep-Alive: timeo 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 75 74 3d 31 35 2c 20 6d 61 78 3d 31 30 30 0d 0a ut=15, max=100.. 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 43 6f 6e 6e 65 63 74 69 6f 6e 3a 20 4b 65 65 70 Connection: Keep 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 2d 41 6c 69 76 65 0d 0a 43 6f 6e 74 65 6e 74 2d -Alive..Content- 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 54 79 70 65 3a 20 74 65 78 74 2f 68 74 6d 6c 3b Type: text/html; 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 20 63 68 61 72 73 65 74 3d 75 74 66 2d 38 0d 0a charset=utf-8.. 2011-01-24 12:06:03 [24950] [8] DEBUG: data: 0d 0a 20 .. 2011-01-24 12:06:03 [24950] [8] DEBUG: Octet string dump ends. -- View this message in context: http://old.nabble.com/Sqlbox-and-DLR-url-tp30747797p30747797.html Sent from the Kannel - User mailing list archive at Nabble.com.
