RE: SQL Box Question
If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Thursday, 09 September, 2010 19:34 To: Kannel list Subject: SQL Box Question Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
Re: SQL Box Question
Dear all, I know this is not the right address to unsubscribe me from Kannel group, but I've been trying to unsubcribe me severeal times using the right procedure without succes. Can some one help me tu unscribe from this group? Thank you in advance Carla - Forwarded Message From: carla godinho To: listname-requ...@kannel.org Sent: Thu, 19 August, 2010 10:38:37 Subject: unsubscribe From: Rene Kluwen To: T.K.Thapa ; Kannel list Sent: Thu, 9 September, 2010 19:27:06 Subject: RE: SQL Box Question If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox. == Rene From:users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Thursday, 09 September, 2010 19:34 To: Kannel list Subject: SQL Box Question Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
RE: SQL Box Question
Hello, I don't understand completely. While submitting sms to smsbox i am using dlr-mask=7 and i am not using dlr-url. Do you mean that i should change dlr-mask=7 to dlr-mask=31 and put any id in dlr-url? Please explain. Regards Tapan Thapa --- On Thu, 9/9/10, Rene Kluwen wrote: From: Rene Kluwen Subject: RE: SQL Box Question To: "'T.K.Thapa'" , "'Kannel list'" Date: Thursday, 9 September, 2010, 11:57 PM If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Thursday, 09 September, 2010 19:34 To: Kannel list Subject: SQL Box Question Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
Re: SQL Box Question
That's not what Rene had in mind. You can use any dlr-mask you like. But to match DLRs with MTs you need to do it with dlr-url. When you push the SMS you type: /cgi-bin/sendsms?from=...&to=&text=&dlr-mask=...&dlr-url=http://mydlr.php?...&msgid=1&; Of course dlr-url has to be urlencoded. msgid you increment each time you push an MT. Then you know which msgid goes with what SMS you send and you can match the DLR received with msgid and SMS. BR, Nikos - Original Message - From: T.K.Thapa To: Rene Kluwen Cc: Kannel list Sent: Friday, September 10, 2010 6:21 AM Subject: RE: SQL Box Question Hello, I don't understand completely. While submitting sms to smsbox i am using dlr-mask=7 and i am not using dlr-url. Do you mean that i should change dlr-mask=7 to dlr-mask=31 and put any id in dlr-url? Please explain. Regards Tapan Thapa --- On Thu, 9/9/10, Rene Kluwen wrote: From: Rene Kluwen Subject: RE: SQL Box Question To: "'T.K.Thapa'" , "'Kannel list'" Date: Thursday, 9 September, 2010, 11:57 PM If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Thursday, 09 September, 2010 19:34 To: Kannel list Subject: SQL Box Question Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
Re: SQL Box Question
For my case I did some patches on smsbox, mysql dlr and sqlbox to store internal message-id and use it to map between MO, MT, and DLR if no foreign-id. And I developed a simple consolidator script and store the result it consolidated table sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote: > Hello, > > I was just checking sqlbox with bearerbox and smsbox to log all sent > messages. I have seen that in sent_sms table there is no relation (Like > message id mapping) between MT and DLR. Is it normal behaviour? If yes then > can you please suggest how will i map sent messages to DLR? > > Regards > Tapan Thapa >
Re: SQL Box Question
Can you share newly developed smsbox/sqlbox binary with source code? I will try to compile for my o.s. from your provided source code. Regards Tapan Thapa --- On Sat, 11/9/10, KangMas Willy wrote: From: KangMas Willy Subject: Re: SQL Box Question To: "T.K.Thapa" Cc: "Kannel list" Date: Saturday, 11 September, 2010, 6:56 AM For my case I did some patches on smsbox, mysql dlr and sqlbox to store internal message-id and use it to map between MO, MT, and DLR if no foreign-id. And I developed a simple consolidator script and store the result it consolidated table sangprabv sangpr...@gmail.comhttp://www.petitiononline.com/froyo/ On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote: Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
RE: SQL Box Question
Why, if you can use the dlr-url field for this? Dlr-url has the same value for MT and for DLR. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Saturday, 11 September, 2010 07:12 To: KangMas Willy Cc: Kannel list Subject: Re: SQL Box Question Can you share newly developed smsbox/sqlbox binary with source code? I will try to compile for my o.s. from your provided source code. Regards Tapan Thapa --- On Sat, 11/9/10, KangMas Willy wrote: From: KangMas Willy Subject: Re: SQL Box Question To: "T.K.Thapa" Cc: "Kannel list" Date: Saturday, 11 September, 2010, 6:56 AM For my case I did some patches on smsbox, mysql dlr and sqlbox to store internal message-id and use it to map between MO, MT, and DLR if no foreign-id. And I developed a simple consolidator script and store the result it consolidated table sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote: Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
RE: SQL Box Question
Ok, Let me summaries the things which i understood from your suggestions. When i am sending sms to smsbox which is connected to sqlbox i need to set dlr-url= and it will be same for MT as well as DLR. Am i right? My understanding for dlr-url is if we specify this parameter then kannel invokes some third party api/url to provide delivery information. Am i right? Please explain. Regards Tapan Thapa --- On Sat, 11/9/10, Rene Kluwen wrote: From: Rene Kluwen Subject: RE: SQL Box Question To: "'T.K.Thapa'" , "'KangMas Willy'" Cc: "'Kannel list'" Date: Saturday, 11 September, 2010, 12:36 PM Why, if you can use the dlr-url field for this? Dlr-url has the same value for MT and for DLR. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Saturday, 11 September, 2010 07:12 To: KangMas Willy Cc: Kannel list Subject: Re: SQL Box Question Can you share newly developed smsbox/sqlbox binary with source code? I will try to compile for my o.s. from your provided source code. Regards Tapan Thapa --- On Sat, 11/9/10, KangMas Willy wrote: From: KangMas Willy Subject: Re: SQL Box Question To: "T.K.Thapa" Cc: "Kannel list" Date: Saturday, 11 September, 2010, 6:56 AM For my case I did some patches on smsbox, mysql dlr and sqlbox to store internal message-id and use it to map between MO, MT, and DLR if no foreign-id. And I developed a simple consolidator script and store the result it consolidated table sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote: Hello, I was just checking sqlbox with bearerbox and smsbox to log all sent messages. I have seen that in sent_sms table there is no relation (Like message id mapping) between MT and DLR. Is it normal behaviour? If yes then can you please suggest how will i map sent messages to DLR? Regards Tapan Thapa
Re: SQL Box Question
Thanks for the explation Rene. That is why I asked the patch developed by sangprabv (sangpr...@gmail.com http://www.petitiononline.com/froyo/). Sangprabv: can you please share the code with us. I think this patch will help other too. Regards Tapan Thapa