I have tried setting msg-id-type=0x03 , 0x02 & 0x01 & 0x00, none of which place a dlr into mysql table.
thanks Barry > ----- Original Message ----- > From: "Barry Murphy" <[email protected]> > To: "Nikos Balkanas" <[email protected]> > Sent: Monday, May 24, 2010 12:16 AM > Subject: Re: MySQL not storing > > >> Hi, >> >> With regards to submit in my logs, all I have is the following on full >> debug 0 . >> smsc:~# grep submit /tmp/kannel.log >> 2010-05-23 23:55:45 [4413] [6] DEBUG: type_name: submit_sm >> 2010-05-23 23:55:45 [4413] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-23 23:56:03 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 >> 61 74 65 3a 31 30 30 35 submit date:1005 >> 2010-05-24 00:02:15 [4413] [6] DEBUG: type_name: submit_sm >> 2010-05-24 00:02:15 [4413] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 00:02:31 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 >> 61 74 65 3a 31 30 30 35 submit date:1005 >> 2010-05-24 00:05:40 [4413] [6] DEBUG: type_name: submit_sm >> 2010-05-24 00:05:40 [4413] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 00:05:47 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 >> 61 74 65 3a 31 30 30 35 submit date:1005 >> 2010-05-24 00:08:42 [4413] [6] DEBUG: type_name: submit_sm >> 2010-05-24 00:08:42 [4413] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 00:08:47 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 >> 61 74 65 3a 31 30 30 35 submit date:1005 >> 2010-05-24 00:29:09 [5952] [6] DEBUG: type_name: submit_sm >> 2010-05-24 00:29:10 [5952] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 00:45:51 [5952] [6] DEBUG: type_name: submit_sm >> 2010-05-24 00:45:52 [5952] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 01:49:05 [5952] [6] DEBUG: type_name: submit_sm >> 2010-05-24 01:49:05 [5952] [6] DEBUG: type_name: submit_sm_resp >> 2010-05-24 09:14:08 [5952] [6] DEBUG: type_name: submit_sm >> 2010-05-24 09:14:09 [5952] [6] DEBUG: type_name: submit_sm_resp >> smsc:~# >> >> >> Thanks >> Barry >> >> >> >> On Sun, 23 May 2010 21:15:50 +0300, "Nikos Balkanas" >> <[email protected]> >> wrote: >>> Sorry, that should read "msg-id-type" not "message-type". >>> >>> BR, >>> Nikos >>> ----- Original Message ----- >>> From: "Nikos Balkanas" <[email protected]> >>> To: "Barry Murphy" <[email protected]>; <[email protected]> >>> Sent: Sunday, May 23, 2010 9:11 PM >>> Subject: Re: MySQL not storing >>> >>> >>>> Hi, >>>> >>>> Mysql looks fine. Your problem doesn't seem to be that "mysql doesn't >>>> store", but rather that mysql doesn't match. Please read User's guide >>>> why >>>> in message-type. If that doesn't solve your problem. please repost, >> this >>>> time including also submit & submit_resp PDUs in your logs. >>>> >>>> BR, >>>> Nikos >>>> ----- Original Message ----- >>>> From: "Barry Murphy" <[email protected]> >>>> To: <[email protected]> >>>> Sent: Sunday, May 23, 2010 9:33 AM >>>> Subject: MySQL not storing >>>> >>>> >>>>> 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 >>>>> >>>>
