Ok so I found the problem, I was not adding dlr_mask 31 which I'm now doing and getting results inserted into dlr table and also into sent_sms for sqlbox. Problem is I only seem to get these messages when I restart kannel, then all the delivery reports come through at that point. Also dlr table is not removing entries, should it be? Its not updating them either.
thanks Barry On Mon, 24 May 2010 12:26:27 +1200, Barry Murphy <[email protected]> wrote: > 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 >>>>>> >>>>>
