Hi, I've setup Kannel to use mysql for storage, see setup below. When I check the status page it shows no errors and that mysql is being used for DLR, select queries seem fine, but when sending a message from smsbox it doesnt appear to add an entry to DLR, see debug info below:
#### CONFIG #### group = core dlr-storage = mysql group = mysql-connection id = mydlr host = 10.10.1.1 username = user password = pass database = smsc max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc #### DEBUG #### 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump: 2010-05-23 06:25:17 [4017] [6] DEBUG: type_name: deliver_sm 2010-05-23 06:25:17 [4017] [6] DEBUG: command_id: 5 = 0x00000005 2010-05-23 06:25:17 [4017] [6] DEBUG: command_status: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: sequence_number: 124 = 0x0000007c 2010-05-23 06:25:17 [4017] [6] DEBUG: service_type: NULL 2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr_ton: 1 = 0x00000001 2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr: "64274909123" 2010-05-23 06:25:17 [4017] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 2010-05-23 06:25:17 [4017] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2010-05-23 06:25:17 [4017] [6] DEBUG: destination_addr: "621234567" 2010-05-23 06:25:17 [4017] [6] DEBUG: esm_class: 4 = 0x00000004 2010-05-23 06:25:17 [4017] [6] DEBUG: protocol_id: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: priority_flag: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: schedule_delivery_time: NULL 2010-05-23 06:25:17 [4017] [6] DEBUG: validity_period: NULL 2010-05-23 06:25:17 [4017] [6] DEBUG: registered_delivery: 1 = 0x00000001 2010-05-23 06:25:17 [4017] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: data_coding: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: sm_length: 109 = 0x0000006d 2010-05-23 06:25:17 [4017] [6] DEBUG: short_message: 2010-05-23 06:25:17 [4017] [6] DEBUG: Octet string at 0x819e8b0: 2010-05-23 06:25:17 [4017] [6] DEBUG: len: 109 2010-05-23 06:25:17 [4017] [6] DEBUG: size: 110 2010-05-23 06:25:17 [4017] [6] DEBUG: immutable: 0 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 20 69 64 3a 32 31 35 33 32 30 32 32 20 20 73 75 id:21532022 su 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 62 3a 30 30 31 20 64 6c 76 72 64 3a 30 30 31 20 b:001 dlvrd:001 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 61 74 65 3a 31 30 30 35 submit date:1005 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 32 33 30 38 32 35 20 64 6f 6e 65 20 64 61 74 65 230825 done date 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 3a 31 30 30 35 32 33 30 38 32 35 20 73 74 61 74 :1005230825 stat 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 3a 44 45 4c 49 56 52 44 20 65 72 72 3a 30 30 30 :DELIVRD err:000 2010-05-23 06:25:17 [4017] [6] DEBUG: data: 20 74 65 78 74 3a 20 33 35 46 30 32 30 text: 35F020 2010-05-23 06:25:17 [4017] [6] DEBUG: Octet string dump ends. 2010-05-23 06:25:17 [4017] [6] DEBUG: receipted_message_id: "21532022" 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU dump ends. 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP[internal] handle_pdu, got DLR 2010-05-23 06:25:17 [4017] [6] WARNING: SMPP[internal]: Got DLR with unknown 'message_state' (-1). 2010-05-23 06:25:17 [4017] [6] DEBUG: DLR[mysql]: Looking for DLR smsc=internal, ts=21532022, dst=64274909123, type=2 2010-05-23 06:25:17 [4017] [6] DEBUG: sql: SELECT mask, service, url, source, destination, boxc FROM dlr WHERE smsc='internal' AND ts='21532022'; 2010-05-23 06:25:17 [4017] [6] DEBUG: no rows found 2010-05-23 06:25:17 [4017] [6] WARNING: DLR[mysql]: DLR from SMSC<internal> for DST<64274909123> not found. 2010-05-23 06:25:17 [4017] [6] ERROR: SMPP[internal]: got DLR but could not find message or was not interested in it id<21532022> dst<64274909123>, type<2> 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP[internal]: Sending PDU: 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU 0x819b848 dump: 2010-05-23 06:25:17 [4017] [6] DEBUG: type_name: deliver_sm_resp 2010-05-23 06:25:17 [4017] [6] DEBUG: command_id: 2147483653 = 0x80000005 2010-05-23 06:25:17 [4017] [6] DEBUG: command_status: 0 = 0x00000000 2010-05-23 06:25:17 [4017] [6] DEBUG: sequence_number: 124 = 0x0000007c 2010-05-23 06:25:17 [4017] [6] DEBUG: message_id: NULL 2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU dump ends. 2010-05-23 06:25:34 [4017] [0] WARNING: Killing signal or HTTP admin command received, shutting down... 2010-05-23 06:25:34 [4017] [0] DEBUG: Shutting down Kannel... 2010-05-23 06:25:34 [4017] [0] DEBUG: shutting down smsc 2010-05-23 06:25:34 [4017] [0] DEBUG: Shutting down SMSCConn SMPP:1.2.3.4:7901/7901:userid:VMA (slow) 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP[internal]: Sending unbind: 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump: 2010-05-23 06:25:34 [4017] [6] DEBUG: type_name: unbind 2010-05-23 06:25:34 [4017] [6] DEBUG: command_id: 6 = 0x00000006 2010-05-23 06:25:34 [4017] [6] DEBUG: command_status: 0 = 0x00000000 2010-05-23 06:25:34 [4017] [6] DEBUG: sequence_number: 4 = 0x00000004 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU dump ends. 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP[internal]: Got PDU: 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump: 2010-05-23 06:25:34 [4017] [6] DEBUG: type_name: unbind_resp 2010-05-23 06:25:34 [4017] [6] DEBUG: command_id: 2147483654 = 0x80000006 2010-05-23 06:25:34 [4017] [6] DEBUG: command_status: 0 = 0x00000000 2010-05-23 06:25:34 [4017] [6] DEBUG: sequence_number: 4 = 0x00000004 2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU dump ends. 2010-05-23 06:25:35 [4017] [6] DEBUG: SMPP[internal]: io_thread: break and shutting down Many thanks in advance Barry
