Re: SMPP message ID greater than 9223372036854775807 breaking DLRs
Kyriacos/Netsmart <[email protected]> Mon, 7 Aug 2023 09:04:51 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------ho0DRRQtJPiFAAkr3y5jVa1F Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit And your mysql table create statement. It might be that you are using a filed type that can not hold such large numbers. Can easily be converted to a char based storage if you don't have extreme space limit issues on the DB side. On 06/08/2023 6:16 pm, Mesbahuddin Malik wrote: > Send your Smpp Config. > > On Sun, Aug 6, 2023 at 8:26 PM Alex Kinch <[email protected]> wrote: > > Hi all, > > I've run into an issue with a certain SMS provider (Nexmo/Vonage) > that is using message IDs greater than 9223372036854775807 (e.g. > 6142530091694509440651642911224527237), which is in turn breaking > DLR processing in Kannel. > > They use hex in submit_sm_resp and decimal in deliver_sm so I have > to have msg-id-type=0x01 set, so it's not like I can remove it and > have Kannel use a C literal instead. > > I've just tried the latest daily build and have the same issue. > Using MySQL for DLR storage if that's relevant. > > Any help appreciated! > > Thanks > Alex > -- Kyriacos Sakkas Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email:[email protected] http://www.netsmart.com.cy Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender [email protected] ** --------------ho0DRRQtJPiFAAkr3y5jVa1F Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> And your mysql table create statement. It might be that you are using a filed type that can not hold such large numbers. Can easily be converted to a char based storage if you don't have extreme space limit issues on the DB side.<br> <br> <div class="moz-cite-prefix">On 06/08/2023 6:16 pm, Mesbahuddin Malik wrote:<br> </div> <blockquote type="cite" cite="mid:CAG=0pxzVKfOdLpSXi6gsx7=QYjX-46G-0dnh0nToB16OdQ3ddA@mail.gmail.com"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <div dir="ltr">Send your Smpp Config.</div> <br> <div class="gmail_quote"> <div dir="ltr" class="gmail_attr">On Sun, Aug 6, 2023 at 8:26 PM Alex Kinch <<a href="mailto:[email protected]" moz-do-not-send="true" class="moz-txt-link-freetext">[email protected]</a>> wrote:<br> </div> <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div dir="ltr">Hi all, <div><br> </div> <div>I've run into an issue with a certain SMS provider (Nexmo/Vonage) that is using message IDs greater than 9223372036854775807 (e.g. 6142530091694509440651642911224527237), which is in turn breaking DLR processing in Kannel. </div> <div><br> </div> <div>They use hex in submit_sm_resp and decimal in deliver_sm so I have to have <span style="font-family:monospace">msg-id-type=0x01 </span>set, so it's not like I can remove it and have Kannel use a C literal instead. </div> <div><br> </div> <div>I've just tried the latest daily build and have the same issue. Using MySQL for DLR storage if that's relevant.</div> <div><br> </div> <div>Any help appreciated!</div> <div><br> </div> <div>Thanks</div> <div>Alex </div> </div> </blockquote> </div> </blockquote> <br> <pre class="moz-signature" cols="72">-- Kyriacos Sakkas Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="http://www.netsmart.com.cy">http://www.netsmart.com.cy</a> Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender at <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> **</pre> </body> </html> --------------ho0DRRQtJPiFAAkr3y5jVa1F--