Hi, Having messages queuing up in the dlr and never leaving, this is a problem I assume as per below problem
Thanks Barry On Mon, 24 May 2010 13:18:03 +1200, Barry Murphy <[email protected]> wrote: > 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 >>>>>>> >>>>>>
