I too had Incorrect DLR mapping Problem using Mysql-DLR, all i did was commented out the msg-id-type in kannel conf file so that it could take default value. i think people having DLR missmatch problem should give it a try..
On Tue, Apr 3, 2012 at 1:30 PM, <[email protected]> wrote: > Send users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.kannel.org/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. Re: users Digest, Vol 68, Issue 6 (Vijay kumar Dadhich) > 2. Re: users Digest, Vol 68, Issue 6 (Tapan Thapa) > 3. RE: Incorrect DLR mapping (Sudeep Kumar) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 3 Apr 2012 11:03:39 +0530 > From: Vijay kumar Dadhich <[email protected]> > To: [email protected] > Subject: Re: users Digest, Vol 68, Issue 6 > Message-ID: > <CAFoBUeQHYV2j1EL=zm=lkkizxwgtjiv0ekywdo9n7rdgrbw...@mail.gmail.com > > > Content-Type: text/plain; charset=UTF-8 > > HI Tapan, > > According to my view, you should receive the dlr with in 12 to 24 > hours from operator. but in your present situation you can copy this > data in a new table or you can make (dump) backup this tables or > databases for your record. For the next time i suggest you , you take > a field as a current time stamp in dlr table, so you can truncate > /delete the data which have more then 12 hourse in table or whatever > time you select. > > On Mon, Apr 2, 2012 at 3:30 PM, <[email protected]> wrote: > > Send users mailing list submissions to > > ? ? ? [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > ? ? ? ?http://www.kannel.org/mailman/listinfo/users > > or, via email, send a message with subject or body 'help' to > > ? ? ? [email protected] > > > > You can reach the person managing the list at > > ? ? ? [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of users digest..." > > > > > > Today's Topics: > > > > ? 1. Kannel - DLR Storage - MySQL (Tapan Thapa) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 2 Apr 2012 13:25:29 +0530 > > From: Tapan Thapa <[email protected]> > > To: [email protected] > > Subject: Kannel - DLR Storage - MySQL > > Message-ID: > > ? ? ? ?< > cajalo3dtzus3j+bptcnehxurg_ga99r5q9wg+rxsiz4ju_x...@mail.gmail.com> > > Content-Type: text/plain; charset="iso-8859-1" > > > > Hello Community, > > > > I had enabled dlr-storage under kannel to store delivery report in mysql > > database and now dlr table is having more then 8 (.8 million) lacs > records. > > > > Can any one let me know how should i delete old dlr from database for > which > > i have not received the delivery report since last 10 days? > > > > Thanks in advance. > > > > Regards > > Tapan Thapa > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: < > http://www.kannel.org/pipermail/users/attachments/20120402/0b1b8a9e/attachment-0001.html > > > > > > ------------------------------ > > > > _______________________________________________ > > users mailing list > > [email protected] > > http://www.kannel.org/mailman/listinfo/users > > > > > > End of users Digest, Vol 68, Issue 6 > > ************************************ > > > > -- > Thanks & Regards, > > -Vijay Kumar Dadhich > Entrepreneur > [email protected] > > > > ------------------------------ > > Message: 2 > Date: Tue, 3 Apr 2012 11:17:14 +0530 > From: Tapan Thapa <[email protected]> > To: Vijay kumar Dadhich <[email protected]> > Cc: [email protected] > Subject: Re: users Digest, Vol 68, Issue 6 > Message-ID: > <CAJaLo3AzKXV4knz2Q1dbgO=ev5rq9hw_tx6uqkrxkuvspei...@mail.gmail.com > > > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > Thanks for the suggestion Vijay as i was thinking on the same direction as > well. > > I will go with your suggested approach. > > Thanks spameden for you kind support as well. > > Regards > Tapan Thapa > > On Tue, Apr 3, 2012 at 11:03 AM, Vijay kumar Dadhich > <[email protected]>wrote: > > > HI Tapan, > > > > According to my view, you should receive the dlr with in 12 to 24 > > hours from operator. but in your present situation you can copy this > > data in a new table or you can make (dump) backup this tables or > > databases for your record. For the next time i suggest you , you take > > a field as a current time stamp in dlr table, so you can truncate > > /delete the data which have more then 12 hourse in table or whatever > > time you select. > > > > On Mon, Apr 2, 2012 at 3:30 PM, <[email protected]> wrote: > > > Send users mailing list submissions to > > > [email protected] > > > > > > To subscribe or unsubscribe via the World Wide Web, visit > > > http://www.kannel.org/mailman/listinfo/users > > > or, via email, send a message with subject or body 'help' to > > > [email protected] > > > > > > You can reach the person managing the list at > > > [email protected] > > > > > > When replying, please edit your Subject line so it is more specific > > > than "Re: Contents of users digest..." > > > > > > > > > Today's Topics: > > > > > > 1. Kannel - DLR Storage - MySQL (Tapan Thapa) > > > > > > > > > ---------------------------------------------------------------------- > > > > > > Message: 1 > > > Date: Mon, 2 Apr 2012 13:25:29 +0530 > > > From: Tapan Thapa <[email protected]> > > > To: [email protected] > > > Subject: Kannel - DLR Storage - MySQL > > > Message-ID: > > > < > > cajalo3dtzus3j+bptcnehxurg_ga99r5q9wg+rxsiz4ju_x...@mail.gmail.com> > > > Content-Type: text/plain; charset="iso-8859-1" > > > > > > Hello Community, > > > > > > I had enabled dlr-storage under kannel to store delivery report in > mysql > > > database and now dlr table is having more then 8 (.8 million) lacs > > records. > > > > > > Can any one let me know how should i delete old dlr from database for > > which > > > i have not received the delivery report since last 10 days? > > > > > > Thanks in advance. > > > > > > Regards > > > Tapan Thapa > > > -------------- next part -------------- > > > An HTML attachment was scrubbed... > > > URL: < > > > http://www.kannel.org/pipermail/users/attachments/20120402/0b1b8a9e/attachment-0001.html > > > > > > > > > ------------------------------ > > > > > > _______________________________________________ > > > users mailing list > > > [email protected] > > > http://www.kannel.org/mailman/listinfo/users > > > > > > > > > End of users Digest, Vol 68, Issue 6 > > > ************************************ > > > > > > > > -- > > Thanks & Regards, > > > > -Vijay Kumar Dadhich > > Entrepreneur > > [email protected] > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://www.kannel.org/pipermail/users/attachments/20120403/375d7f2a/attachment-0001.html > > > > ------------------------------ > > Message: 3 > Date: Tue, 3 Apr 2012 13:30:18 +0530 > From: Sudeep Kumar <[email protected]> > To: Kannel Users <[email protected]> > Subject: RE: Incorrect DLR mapping > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > Hi All, > Got the problem, just posting here so that it could be of help to others. > Since the mgs-id returned by the SMSC is neither decimal nor hexadecimal, > it requires the msg-id-type field to be undefined making the bearerbox then > fall back to the C string option which works well. > Regards,Sudeep. > > From: [email protected] > To: [email protected] > Subject: Incorrect DLR mapping > Date: Sun, 1 Apr 2012 16:49:16 +0530 > > > > > > > > Hi, > I searched the list for incorrect Dlr mapping and found some of the > threads discussing what was close to our issue, but that was with CIMD and > other smsc types not with SMPP. Hence I ask the following: > > Bearerbox puts 13 as the 'ts' field value which is also found in the Sent > Sms entry in access_server.log. Mentioned below is an example trace: > > Subtmit_sm: > 2012-03-22 11:28:01 [5391] [32] DEBUG: SMPP[R05]: Sending PDU: > 2012-03-22 11:28:01 [5391] [32] DEBUG: SMPP PDU 0xff37170 dump: > 2012-03-22 11:28:01 [5391] [32] DEBUG: type_name: submit_sm > 2012-03-22 11:28:01 [5391] [32] DEBUG: command_id: 4 = 0x00000004 > 2012-03-22 11:28:01 [5391] [32] DEBUG: command_status: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: sequence_number: 1147800 = > 0x00118398 > 2012-03-22 11:28:01 [5391] [32] DEBUG: service_type: NULL > 2012-03-22 11:28:01 [5391] [32] DEBUG: source_addr_ton: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: source_addr_npi: 1 = 0x00000001 > 2012-03-22 11:28:01 [5391] [32] DEBUG: source_addr: "Demo" > 2012-03-22 11:28:01 [5391] [32] DEBUG: dest_addr_ton: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: dest_addr_npi: 1 = 0x00000001 > 2012-03-22 11:28:01 [5391] [32] DEBUG: destination_addr: "xxx9209xxxxx" > 2012-03-22 11:28:01 [5391] [32] DEBUG: esm_class: 3 = 0x00000003 > 2012-03-22 11:28:01 [5391] [32] DEBUG: protocol_id: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: priority_flag: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: schedule_delivery_time: NULL > 2012-03-22 11:28:01 [5391] [32] DEBUG: validity_period: NULL > 2012-03-22 11:28:01 [5391] [32] DEBUG: registered_delivery: 1 = > 0x00000001 > 2012-03-22 11:28:01 [5391] [32] DEBUG: replace_if_present_flag: 0 = > 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: data_coding: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: sm_default_msg_id: 0 = 0x00000000 > 2012-03-22 11:28:01 [5391] [32] DEBUG: sm_length: 159 = 0x0000009f > 2012-03-22 11:28:01 [5391] [32] DEBUG: short_message: > 2012-03-22 11:28:01 [5391] [32] DEBUG: Octet string at 0xbd3fa20: > 2012-03-22 11:28:01 [5391] [32] DEBUG: len: 159 > 2012-03-22 11:28:01 [5391] [32] DEBUG: size: 160 > 2012-03-22 11:28:01 [5391] [32] DEBUG: immutable: 0 > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 53 70 65 63 69 61 6c 20 > 50 72 69 63 65 20 46 6f Special Price Fo > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 72 20 33 20 44 61 79 73 > 20 46 6f 72 20 50 72 65 r 3 Days For Pre > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 2d 4c 61 75 6e 63 68 20 > 50 72 6f 6a 65 63 74 20 -Launch Project > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 49 6e 20 54 68 61 6e 65 > 20 28 77 29 2e 20 31 2c In Thane (w). 1, > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 20 31 2e 35 2c 20 32 20 > 26 20 33 20 42 48 4b 73 1.5, 2 & 3 BHKs > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 20 34 35 20 6c 61 63 73 > 20 4f 6e 77 61 72 64 73 45 lacs Onwards > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 2e 20 52 69 76 65 72 20 > 26 20 4d 6f 75 6e 74 61 . River & Mounta > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 69 6e 20 56 69 65 77 2e > 20 41 6c 6c 20 4d 6f 64 in View. All Mod > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 65 72 6e 20 41 6d 65 6e > 69 74 69 65 73 2e 20 43 ern Amenities. C > 2012-03-22 11:28:01 [5391] [32] DEBUG: data: 61 6c 6c 20 39 39 33 30 > 32 35 34 38 38 33 2e all xxxxxxxxxxx. > 2012-03-22 11:28:01 [5391] [32] DEBUG: Octet string dump ends. > 2012-03-22 11:28:01 [5391] [32] DEBUG: SMPP PDU dump ends. > > submit_sm_resp: > =============== > 2012-03-22 11:28:02 [5391] [32] DEBUG: SMPP[R05]: Got PDU: > 2012-03-22 11:28:02 [5391] [32] DEBUG: SMPP PDU 0xff37170 dump: > 2012-03-22 11:28:02 [5391] [32] DEBUG: type_name: submit_sm_resp > 2012-03-22 11:28:02 [5391] [32] DEBUG: command_id: 2147483652 = > 0x80000004 > 2012-03-22 11:28:02 [5391] [32] DEBUG: command_status: 0 = 0x00000000 > 2012-03-22 11:28:02 [5391] [32] DEBUG: sequence_number: 1147800 = > 0x00118398 > 2012-03-22 11:28:02 [5391] [32] DEBUG: message_id: > 2012-03-22 11:28:02 [5391] [32] DEBUG: Octet string at 0xa9f2ba0: > 2012-03-22 11:28:02 [5391] [32] DEBUG: len: 29 > 2012-03-22 11:28:02 [5391] [32] DEBUG: size: 30 > 2012-03-22 11:28:02 [5391] [32] DEBUG: immutable: 0 > 2012-03-22 11:28:02 [5391] [32] DEBUG: data: 64 74 65 63 68 70 6c 2d > 31 33 33 32 33 39 35 37 dtechpl-13323957 > 2012-03-22 11:28:02 [5391] [32] DEBUG: data: 31 33 33 35 37 2d 34 30 > 2d 30 32 30 32 13357-40-0202 > 2012-03-22 11:28:02 [5391] [32] DEBUG: Octet string dump ends. > 2012-03-22 11:28:02 [5391] [32] DEBUG: SMPP PDU dump ends. > 2012-03-22 11:28:02 [5391] [32] DEBUG: DLR[mysql]: Adding DLR smsc=R05, > ts=13, src=Demo, dst=xxx9209xxxxx, mask=3, boxc=SMSZING > 2012-03-22 11:28:02 [5391] [32] DEBUG: adding DLR entry into database > 2012-03-22 11:28:02 [5391] [32] DEBUG: sql: INSERT INTO `Dlr` (`smsc`, > `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, `status`) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) > > Here's what I am talking about. Even though the submit_sm_resp contains > the msg-id bearerbox puts ts=13 as the value. As this happens for all sms > when the dlr arrives the first entry (since bbox uses limit 1) with ts=13 > and smsc=R05 is mapped, thus causing a mismatch of the DLRs. > > PS : From the sequence number you can make sure here that the > submit_sm_resp PDU is indeed for the submit_sm PDU mentioned above. > > Thanks & Regards, > Sudeep. > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://www.kannel.org/pipermail/users/attachments/20120403/b8c3d8cc/attachment.html > > > > ------------------------------ > > _______________________________________________ > users mailing list > [email protected] > http://www.kannel.org/mailman/listinfo/users > > > End of users Digest, Vol 68, Issue 11 > ************************************* > -- Best Wishes Mohd. Sadique khan # 9717848717
