Hi list, I've been dealing with the DLR reports for a couple of days and I'm not able to make this works. I'm using mysql storage, and every time I send a message a new DLR record is inserted in the DLR table with the DLR status=12, this happens in the submit_sm phase, and after that in the deliver_sm kannel gets the DLR from the SMSC but always get the message "got DLR but could not find message or was not interested in it" I reviewed the mail list and did tests with all combinations of msg-id-type parameter and also y set the alt-charset parameter to "LATIN1" but in all cases the same result.
Here is my log 2004-04-16 09:58:42 [14] DEBUG: boxc_receiver: sms received 2004-04-16 09:58:42 [5] DEBUG: SMPP[viva]: Sending PDU: 2004-04-16 09:58:42 [5] DEBUG: SMPP PDU 0x80fc548 dump: 2004-04-16 09:58:42 [5] DEBUG: type_name: submit_sm 2004-04-16 09:58:42 [5] DEBUG: command_id: 4 = 0x00000004 2004-04-16 09:58:42 [5] DEBUG: command_status: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: sequence_number: 3 = 0x00000003 2004-04-16 09:58:42 [5] DEBUG: service_type: NULL 2004-04-16 09:58:42 [5] DEBUG: source_addr_ton: 2 = 0x00000002 2004-04-16 09:58:42 [5] DEBUG: source_addr_npi: 1 = 0x00000001 2004-04-16 09:58:42 [5] DEBUG: source_addr: "123" 2004-04-16 09:58:42 [5] DEBUG: dest_addr_ton: 2 = 0x00000002 2004-04-16 09:58:42 [5] DEBUG: dest_addr_npi: 1 = 0x00000001 2004-04-16 09:58:42 [5] DEBUG: destination_addr: "59170610160" 2004-04-16 09:58:42 [5] DEBUG: esm_class: 3 = 0x00000003 2004-04-16 09:58:42 [5] DEBUG: protocol_id: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: priority_flag: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: schedule_delivery_time: NULL 2004-04-16 09:58:42 [5] DEBUG: validity_period: NULL 2004-04-16 09:58:42 [5] DEBUG: registered_delivery: 1 = 0x00000001 2004-04-16 09:58:42 [5] DEBUG: replace_if_present_flag: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: data_coding: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: sm_default_msg_id: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: sm_length: 33 = 0x00000021 2004-04-16 09:58:42 [5] DEBUG: short_message: 2004-04-16 09:58:42 [5] DEBUG: Octet string at 0x80fc5e8: 2004-04-16 09:58:42 [5] DEBUG: len: 33 2004-04-16 09:58:42 [5] DEBUG: size: 34 2004-04-16 09:58:42 [5] DEBUG: immutable: 0 2004-04-16 09:58:42 [5] DEBUG: data: 68 6f 6c 61 20 65 73 74 hola est 2004-04-16 09:58:42 [5] DEBUG: data: 65 20 65 73 20 75 6e 20 e es un 2004-04-16 09:58:42 [5] DEBUG: data: 6d 65 6e 73 61 6a 65 20 mensaje 2004-04-16 09:58:42 [5] DEBUG: data: 64 65 20 70 72 75 65 62 de prueb 2004-04-16 09:58:42 [5] DEBUG: data: 61 a 2004-04-16 09:58:42 [5] DEBUG: Octet string dump ends. 2004-04-16 09:58:42 [5] DEBUG: SMPP PDU dump ends. 2004-04-16 09:58:42 [5] DEBUG: SMPP[viva]: Got PDU: 2004-04-16 09:58:42 [5] DEBUG: SMPP PDU 0x80fc548 dump: 2004-04-16 09:58:42 [5] DEBUG: type_name: submit_sm_resp 2004-04-16 09:58:42 [5] DEBUG: command_id: 2147483652 = 0x80000004 2004-04-16 09:58:42 [5] DEBUG: command_status: 0 = 0x00000000 2004-04-16 09:58:42 [5] DEBUG: sequence_number: 3 = 0x00000003 2004-04-16 09:58:42 [5] DEBUG: message_id: 2004-04-16 09:58:42 [5] DEBUG: Octet string at 0x80fbfd8: 2004-04-16 09:58:42 [5] DEBUG: len: 23 2004-04-16 09:58:42 [5] DEBUG: size: 24 2004-04-16 09:58:42 [5] DEBUG: immutable: 0 2004-04-16 09:58:42 [5] DEBUG: data: 30 34 30 34 31 36 30 39 04041609 2004-04-16 09:58:42 [5] DEBUG: data: 35 34 33 32 35 39 31 37 54325917 2004-04-16 09:58:42 [5] DEBUG: data: 30 36 31 30 31 36 30 0610160 2004-04-16 09:58:42 [5] DEBUG: Octet string dump ends. 2004-04-16 09:58:42 [5] DEBUG: SMPP PDU dump ends. 2004-04-16 09:58:42 [5] DEBUG: Found entry, row[0]=31, row[1]=viva, row[2]=http://10.29.3.23/kannel/dlr.php?id=3&dlr=%d, row[3]=123, row[4]=viva 2004-04-16 09:58:42 [5] DEBUG: created DLR message for URL <http://10.29.3.23/kannel/dlr.php?id=3&dlr=%d> 2004-04-16 09:58:42 [5] DEBUG: DLR not deleted because we wait on more reports 2004-04-16 09:58:42 [15] DEBUG: send_msg: sending msg to boxc: <viva> 2004-04-16 09:58:42 [15] DEBUG: boxc_sender: sent message to <127.0.0.1> 2004-04-16 09:58:42 [14] DEBUG: boxc_receiver: got ack 2004-04-16 09:58:47 [5] DEBUG: SMPP[viva]: Got PDU: 2004-04-16 09:58:47 [5] DEBUG: SMPP PDU 0x80fc5e8 dump: 2004-04-16 09:58:47 [5] DEBUG: type_name: deliver_sm 2004-04-16 09:58:47 [5] DEBUG: command_id: 5 = 0x00000005 2004-04-16 09:58:47 [5] DEBUG: command_status: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: sequence_number: 2 = 0x00000002 2004-04-16 09:58:47 [5] DEBUG: service_type: NULL 2004-04-16 09:58:47 [5] DEBUG: source_addr_ton: 1 = 0x00000001 2004-04-16 09:58:47 [5] DEBUG: source_addr_npi: 1 = 0x00000001 2004-04-16 09:58:47 [5] DEBUG: source_addr: "59170610160" 2004-04-16 09:58:47 [5] DEBUG: dest_addr_ton: 1 = 0x00000001 2004-04-16 09:58:47 [5] DEBUG: dest_addr_npi: 1 = 0x00000001 2004-04-16 09:58:47 [5] DEBUG: destination_addr: NULL 2004-04-16 09:58:47 [5] DEBUG: esm_class: 4 = 0x00000004 2004-04-16 09:58:47 [5] DEBUG: protocol_id: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: priority_flag: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: schedule_delivery_time: NULL 2004-04-16 09:58:47 [5] DEBUG: validity_period: NULL 2004-04-16 09:58:47 [5] DEBUG: registered_delivery: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: replace_if_present_flag: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: data_coding: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: sm_default_msg_id: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: sm_length: 63 = 0x0000003f 2004-04-16 09:58:47 [5] DEBUG: short_message: 2004-04-16 09:58:47 [5] DEBUG: Octet string at 0x80fc690: 2004-04-16 09:58:47 [5] DEBUG: len: 63 2004-04-16 09:58:47 [5] DEBUG: size: 64 2004-04-16 09:58:47 [5] DEBUG: immutable: 0 2004-04-16 09:58:47 [5] DEBUG: data: 69 64 3a 30 34 30 34 31 id:04041 2004-04-16 09:58:47 [5] DEBUG: data: 36 30 39 35 34 33 32 35 60954325 2004-04-16 09:58:47 [5] DEBUG: data: 39 31 37 30 36 31 30 31 91706101 2004-04-16 09:58:47 [5] DEBUG: data: 36 30 20 64 6f 6e 65 20 60 done 2004-04-16 09:58:47 [5] DEBUG: data: 64 61 74 65 3a 30 34 30 date:040 2004-04-16 09:58:47 [5] DEBUG: data: 34 31 36 30 39 35 34 33 41609543 2004-04-16 09:58:47 [5] DEBUG: data: 36 20 73 74 61 74 3a 44 6 stat:D 2004-04-16 09:58:47 [5] DEBUG: data: 45 4c 49 56 52 44 20 ELIVRD 2004-04-16 09:58:47 [5] DEBUG: Octet string dump ends. 2004-04-16 09:58:47 [5] DEBUG: SMPP PDU dump ends. 2004-04-16 09:58:47 [5] DEBUG: SMPP[viva] handle_pdu, got DLR 2004-04-16 09:58:47 [5] DEBUG: no rows found 2004-04-16 09:58:47 [5] ERROR: SMPP[viva]: got DLR but could not find message or was not interested in it 2004-04-16 09:58:47 [5] DEBUG: SMPP[viva]: Sending PDU: 2004-04-16 09:58:47 [5] DEBUG: SMPP PDU 0x80fc028 dump: 2004-04-16 09:58:47 [5] DEBUG: type_name: deliver_sm_resp 2004-04-16 09:58:47 [5] DEBUG: command_id: 2147483653 = 0x80000005 2004-04-16 09:58:47 [5] DEBUG: command_status: 0 = 0x00000000 2004-04-16 09:58:47 [5] DEBUG: sequence_number: 2 = 0x00000002 2004-04-16 09:58:47 [5] DEBUG: message_id: NULL 2004-04-16 09:58:47 [5] DEBUG: SMPP PDU dump ends. And here is my conf file group = core admin-port = 13000 admin-password = bar wapbox-port = 13002 smsbox-port = 13003 wdp-interface-name = "*" log-file = "/tmp/kannel.log" log-level = 0 dlr-storage =mysql group = mysql-connection id = mydlr host = localhost mysql-username = user mysql-password = pass database = dlr group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-source = source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc group = wapbox bearerbox-host = localhost log-file = "/tmp/wapbox.log" log-level = 0 syslog-level = none group = smsc smsc = smpp smsc-id = viva host = xxxxxxxxxxxxxxxxx allowed-prefix = "70;59170" port = 6699 transceiver-mode = true smsc-username = xxxxx smsc-password = xxxxx system-type = "VMA" interface-version = 0X34 msg-id-type = 0x01 alt-charset = LATIN1 group = smsbox smsbox-id = viva bearerbox-host = localhost sendsms-port = 13004 group = sendsms-user username = viva password = viva group = sms-service keyword = default name = service accepted-smsc = viva get-url="http://10.29.3.23/kannel/dlr.php?id=3&dlr=%d"; max-messages = 0 Hope someone of you can help me. Many thanks and Best regards Oscar Flores
