Re: [Kannel-Users] Re: [Kannel-Users] message id
Dear Beckman, I understood that part before itself. My reply was directed towards Linkas response. -- regards, Anand > To reiterate, the ts value is not available for expansion in the dlr URL. > > It could be, but kannel does not currently implement this. > > You are welcome to rewrite kannel to do this. > > Beckman > > On Thu, 14 Apr 2005, Anand Gupta wrote: > >> My smsc returns unique number always in the ts value. Thats where they >> have asked me to grab the message id from. >> >> -- >> regards, >> >> Anand >> >>> Also depends on the type of connection you have with your >>> provider/smsc. >>> Using EMI/UCP protocol is know not to have a unique id to any message. >>> Infact if your kannel will send more than one message in a single >>> second, ts will confuse the DLR and the reply is not unique. >>> >>> J >>> >>> Anand Gupta wrote: >>> Thx Beckman for taking time to reply. Well the whole reason for which i want to track the message_id is based on that only. My smsc has the reports available in csv format after 24hrs. Now when the reports come in, how will i know which report is for which message ? There can be multiple sender id, multiple messages to same numbers... This is the reason i was looking for getting the message_id. When kannel sends the message id to mysql db, its strange why it can't send it to the dlr url as well. I thought about a small hack on this, not perfect though. The mysql db stores the dlr-url as well which has a unique sequence number called slid. If inside my url php file i search the db using regex with the slid number (since the same number is available inside the php file also as one of the parameters) and then copy the message id from there. The above is not perfect and nor is efficient for when the messages volume increase, so will the db. I hope someone else on this list has a better solution. >>> >>> >> >> > > --- > Peter Beckman Internet > Guy > [EMAIL PROTECTED] > http://www.purplecow.com/ > --- >
Re: [Kannel-Users] Re: [Kannel-Users] message id
To reiterate, the ts value is not available for expansion in the dlr URL. It could be, but kannel does not currently implement this. You are welcome to rewrite kannel to do this. Beckman On Thu, 14 Apr 2005, Anand Gupta wrote: My smsc returns unique number always in the ts value. Thats where they have asked me to grab the message id from. -- regards, Anand Also depends on the type of connection you have with your provider/smsc. Using EMI/UCP protocol is know not to have a unique id to any message. Infact if your kannel will send more than one message in a single second, ts will confuse the DLR and the reply is not unique. J Anand Gupta wrote: Thx Beckman for taking time to reply. Well the whole reason for which i want to track the message_id is based on that only. My smsc has the reports available in csv format after 24hrs. Now when the reports come in, how will i know which report is for which message ? There can be multiple sender id, multiple messages to same numbers... This is the reason i was looking for getting the message_id. When kannel sends the message id to mysql db, its strange why it can't send it to the dlr url as well. I thought about a small hack on this, not perfect though. The mysql db stores the dlr-url as well which has a unique sequence number called slid. If inside my url php file i search the db using regex with the slid number (since the same number is available inside the php file also as one of the parameters) and then copy the message id from there. The above is not perfect and nor is efficient for when the messages volume increase, so will the db. I hope someone else on this list has a better solution. --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ ---
Re: [Kannel-Users] Re: [Kannel-Users] message id
On Thu, 14 Apr 2005, Anand Gupta wrote: Thx Beckman for taking time to reply. Well the whole reason for which i want to track the message_id is based on that only. My smsc has the reports available in csv format after 24hrs. Now when the reports come in, how will i know which report is for which message ? There can be multiple sender id, multiple messages to same numbers... This is the reason i was looking for getting the message_id. When kannel sends the message id to mysql db, its strange why it can't send it to the dlr url as well. The sql generated to put the DLR in the DB is generated by a different box than the DLR call itself. I would think that you could have an escape code that was replaced when storing the DLR information, but no, this is not yet built into kannel. The mysql db stores the dlr-url as well which has a unique sequence number called slid. If inside my url php file i search the db using regex with the slid number (since the same number is available inside the php file also as one of the parameters) and then copy the message id from there. The above is not perfect and nor is efficient for when the messages volume increase, so will the db. I hope someone else on this list has a better solution. As far as I know, your proposed solution is really the only option, other than relying on the SMSC to delivery a delivery receipt, which would include your message ID. --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ ---
Re: [Kannel-Users] message id
My smsc returns unique number always in the ts value. Thats where they have asked me to grab the message id from. -- regards, Anand > Also depends on the type of connection you have with your provider/smsc. > Using EMI/UCP protocol is know not to have a unique id to any message. > Infact if your kannel will send more than one message in a single > second, ts will confuse the DLR and the reply is not unique. > > J > > Anand Gupta wrote: > >>Thx Beckman for taking time to reply. >> >>Well the whole reason for which i want to track the message_id is based >> on >>that only. My smsc has the reports available in csv format after 24hrs. >>Now when the reports come in, how will i know which report is for which >>message ? There can be multiple sender id, multiple messages to same >>numbers... This is the reason i was looking for getting the message_id. >>When kannel sends the message id to mysql db, its strange why it can't >>send it to the dlr url as well. >> >>I thought about a small hack on this, not perfect though. >> >>The mysql db stores the dlr-url as well which has a unique sequence >> number >>called slid. If inside my url php file i search the db using regex with >>the slid number (since the same number is available inside the php file >>also as one of the parameters) and then copy the message id from there. >> >>The above is not perfect and nor is efficient for when the messages >> volume >>increase, so will the db. >> >>I hope someone else on this list has a better solution. >> >> >> > >
Re: [Kannel-Users] message id
Also depends on the type of connection you have with your provider/smsc. Using EMI/UCP protocol is know not to have a unique id to any message. Infact if your kannel will send more than one message in a single second, ts will confuse the DLR and the reply is not unique. J Anand Gupta wrote: Thx Beckman for taking time to reply. Well the whole reason for which i want to track the message_id is based on that only. My smsc has the reports available in csv format after 24hrs. Now when the reports come in, how will i know which report is for which message ? There can be multiple sender id, multiple messages to same numbers... This is the reason i was looking for getting the message_id. When kannel sends the message id to mysql db, its strange why it can't send it to the dlr url as well. I thought about a small hack on this, not perfect though. The mysql db stores the dlr-url as well which has a unique sequence number called slid. If inside my url php file i search the db using regex with the slid number (since the same number is available inside the php file also as one of the parameters) and then copy the message id from there. The above is not perfect and nor is efficient for when the messages volume increase, so will the db. I hope someone else on this list has a better solution.
Re: [Kannel-Users] message id
Thx Beckman for taking time to reply. Well the whole reason for which i want to track the message_id is based on that only. My smsc has the reports available in csv format after 24hrs. Now when the reports come in, how will i know which report is for which message ? There can be multiple sender id, multiple messages to same numbers... This is the reason i was looking for getting the message_id. When kannel sends the message id to mysql db, its strange why it can't send it to the dlr url as well. I thought about a small hack on this, not perfect though. The mysql db stores the dlr-url as well which has a unique sequence number called slid. If inside my url php file i search the db using regex with the slid number (since the same number is available inside the php file also as one of the parameters) and then copy the message id from there. The above is not perfect and nor is efficient for when the messages volume increase, so will the db. I hope someone else on this list has a better solution. -- regards, Anand > Sorry, it's a little confusing. > > There are two types of DLR reports -- the one kannel "fakes" and the one > from your SMSC. > > Once your sms message makes it to the SMSC, kannel generates an ACK/ > message and calls your DLR URL with the appropriate information. THIS DLR > DOES NOT CONTAIN THE MESSAGE ID YOU SEEK. The "box" that calls the URL > does not know what the message_id is. > > However, when a Delivery Report text message comes in from your smsc... > > id:GFN1421584 sub:001 dlvrd:001 submit date:0504142010 done > date:0504142010 stat:UNDELIV err:PBD text:Thank you for your p > > Then you have the message ID in the response. You'll have to write a > regex > or something to grab the ID itself out of the message. > > Beckman > > On Thu, 14 Apr 2005, Anand Gupta wrote: > >> I just setup kannel to log DLR to mysql and i see the message id inside >> it. >> >> 2005-04-14 15:14:10 [25810] [7] DEBUG: sql: INSERT INTO dlr (smsc, ts, >> source, destination, service, url, mask, boxc, status) VALUES ('smsc1', >> 'GFN2618104', 'gldfs', '+xxx', 'tedfw', >> 'http://xxx.xxx.xxx/dlr.php?type=%d&slid=56&uid=1&dlr-rep=%A&others=%t%i%I%u%o', >> '31', '', '0'); >> >> Any ideas on what is the variable which stores the ts value ? since its >> being passed to the mysql db i guess it can also be passed to my http >> url >> as well. >> >> -- >> regards, >> >> Anand >> >>> You can't get it, except from the log file, or via DLR. >>> >>> There was a big fight over it a few months back, about protecting the >>> code >>> and not making the code too specific; I don't know if anyone ever made >>> a >>> patch. >>> >>> Beckman >>> >>> On Thu, 14 Apr 2005, Anand Gupta wrote: >>> Here is the response from my smsc while sending a message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP[smsc11]: Got PDU: 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU 0x87a7a18 dump: 2005-04-14 14:16:41 [15081] [7] DEBUG: type_name: submit_sm_resp 2005-04-14 14:16:41 [15081] [7] DEBUG: command_id: 2147483652 = 0x8004 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 = 0x 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 = 0x0005 2005-04-14 14:16:41 [15081] [7] DEBUG: message_id: "GFN1421584" 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU dump ends. 2005-04-14 14:16:41 [15081] [7] DEBUG: DLR[internal]: Adding DLR smsc=smsc1, ts=GFN1421584, src=gldf, dst=+x, mask=31, boxc= 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: creating DLR message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: DLR = http://xxx.xxx.xxx/dlr.php?type=%d&slid=54&uid=1&dlr-rep=%A&others=%t%i%I%u Now i am trying to get the message_id "GFN1421584" which is being returned in response to the submit_sm_resp. This is the message id i need to track messages from my smsc. What should i use to pass that to the url so i can track it. I see 049ddeb5-64fb-44ec-b0af-3adc094f91d1 as the id inside access.log. I guess this is some internal message id. What i want is the message id from the smsc. Any help would be highly appreciated. -- regards, Anand >>> >>> --- >>> Peter Beckman Internet >>> Guy >>> [EMAIL PROTECTED] >>> http://www.purplecow.com/ >>> --- >>> >> > > --- > Peter Beckman Internet > Guy > [EMAIL PROTECTED] > http://www.purplecow.com/ > --- >
Re: [Kannel-Users] Re: [Kannel-Users] message id
Sorry, it's a little confusing. There are two types of DLR reports -- the one kannel "fakes" and the one from your SMSC. Once your sms message makes it to the SMSC, kannel generates an ACK/ message and calls your DLR URL with the appropriate information. THIS DLR DOES NOT CONTAIN THE MESSAGE ID YOU SEEK. The "box" that calls the URL does not know what the message_id is. However, when a Delivery Report text message comes in from your smsc... id:GFN1421584 sub:001 dlvrd:001 submit date:0504142010 done date:0504142010 stat:UNDELIV err:PBD text:Thank you for your p Then you have the message ID in the response. You'll have to write a regex or something to grab the ID itself out of the message. Beckman On Thu, 14 Apr 2005, Anand Gupta wrote: I just setup kannel to log DLR to mysql and i see the message id inside it. 2005-04-14 15:14:10 [25810] [7] DEBUG: sql: INSERT INTO dlr (smsc, ts, source, destination, service, url, mask, boxc, status) VALUES ('smsc1', 'GFN2618104', 'gldfs', '+xxx', 'tedfw', 'http://xxx.xxx.xxx/dlr.php?type=%d&slid=56&uid=1&dlr-rep=%A&others=%t%i%I%u%o', '31', '', '0'); Any ideas on what is the variable which stores the ts value ? since its being passed to the mysql db i guess it can also be passed to my http url as well. -- regards, Anand You can't get it, except from the log file, or via DLR. There was a big fight over it a few months back, about protecting the code and not making the code too specific; I don't know if anyone ever made a patch. Beckman On Thu, 14 Apr 2005, Anand Gupta wrote: Here is the response from my smsc while sending a message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP[smsc11]: Got PDU: 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU 0x87a7a18 dump: 2005-04-14 14:16:41 [15081] [7] DEBUG: type_name: submit_sm_resp 2005-04-14 14:16:41 [15081] [7] DEBUG: command_id: 2147483652 = 0x8004 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 = 0x 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 = 0x0005 2005-04-14 14:16:41 [15081] [7] DEBUG: message_id: "GFN1421584" 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU dump ends. 2005-04-14 14:16:41 [15081] [7] DEBUG: DLR[internal]: Adding DLR smsc=smsc1, ts=GFN1421584, src=gldf, dst=+x, mask=31, boxc= 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: creating DLR message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: DLR = http://xxx.xxx.xxx/dlr.php?type=%d&slid=54&uid=1&dlr-rep=%A&others=%t%i%I%u Now i am trying to get the message_id "GFN1421584" which is being returned in response to the submit_sm_resp. This is the message id i need to track messages from my smsc. What should i use to pass that to the url so i can track it. I see 049ddeb5-64fb-44ec-b0af-3adc094f91d1 as the id inside access.log. I guess this is some internal message id. What i want is the message id from the smsc. Any help would be highly appreciated. -- regards, Anand --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --- --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ ---
Re: [Kannel-Users] message id
I just setup kannel to log DLR to mysql and i see the message id inside it. 2005-04-14 15:14:10 [25810] [7] DEBUG: sql: INSERT INTO dlr (smsc, ts, source, destination, service, url, mask, boxc, status) VALUES ('smsc1', 'GFN2618104', 'gldfs', '+xxx', 'tedfw', 'http://xxx.xxx.xxx/dlr.php?type=%d&slid=56&uid=1&dlr-rep=%A&others=%t%i%I%u%o', '31', '', '0'); Any ideas on what is the variable which stores the ts value ? since its being passed to the mysql db i guess it can also be passed to my http url as well. -- regards, Anand > You can't get it, except from the log file, or via DLR. > > There was a big fight over it a few months back, about protecting the code > and not making the code too specific; I don't know if anyone ever made a > patch. > > Beckman > > On Thu, 14 Apr 2005, Anand Gupta wrote: > >> Here is the response from my smsc while sending a message >> >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP[smsc11]: Got PDU: >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU 0x87a7a18 dump: >> 2005-04-14 14:16:41 [15081] [7] DEBUG: type_name: submit_sm_resp >> 2005-04-14 14:16:41 [15081] [7] DEBUG: command_id: 2147483652 = >> 0x8004 >> 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 = 0x >> 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 = 0x0005 >> 2005-04-14 14:16:41 [15081] [7] DEBUG: message_id: "GFN1421584" >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU dump ends. >> 2005-04-14 14:16:41 [15081] [7] DEBUG: DLR[internal]: Adding DLR >> smsc=smsc1, ts=GFN1421584, src=gldf, dst=+x, mask=31, boxc= >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: creating DLR message >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: DLR = >> http://xxx.xxx.xxx/dlr.php?type=%d&slid=54&uid=1&dlr-rep=%A&others=%t%i%I%u >> >> Now i am trying to get the message_id "GFN1421584" which is being >> returned >> in response to the submit_sm_resp. This is the message id i need to >> track >> messages from my smsc. What should i use to pass that to the url so i >> can >> track it. >> >> I see 049ddeb5-64fb-44ec-b0af-3adc094f91d1 as the id inside access.log. >> I >> guess this is some internal message id. What i want is the message id >> from >> the smsc. >> >> Any help would be highly appreciated. >> >> -- >> regards, >> >> Anand >> > > --- > Peter Beckman Internet > Guy > [EMAIL PROTECTED] > http://www.purplecow.com/ > --- >
Re: [Kannel-Users] message id
> You can't get it, except from the log file, or via DLR. can you please explain what do you mean by via DLR ? I am using the url to grab all those values, can i use some variable to pass that value ? something like that ? -- regards, Anand > > There was a big fight over it a few months back, about protecting the code > and not making the code too specific; I don't know if anyone ever made a > patch. > > Beckman > > On Thu, 14 Apr 2005, Anand Gupta wrote: > >> Here is the response from my smsc while sending a message >> >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP[smsc11]: Got PDU: >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU 0x87a7a18 dump: >> 2005-04-14 14:16:41 [15081] [7] DEBUG: type_name: submit_sm_resp >> 2005-04-14 14:16:41 [15081] [7] DEBUG: command_id: 2147483652 = >> 0x8004 >> 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 = 0x >> 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 = 0x0005 >> 2005-04-14 14:16:41 [15081] [7] DEBUG: message_id: "GFN1421584" >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU dump ends. >> 2005-04-14 14:16:41 [15081] [7] DEBUG: DLR[internal]: Adding DLR >> smsc=smsc1, ts=GFN1421584, src=gldf, dst=+x, mask=31, boxc= >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: creating DLR message >> 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: DLR = >> http://xxx.xxx.xxx/dlr.php?type=%d&slid=54&uid=1&dlr-rep=%A&others=%t%i%I%u >> >> Now i am trying to get the message_id "GFN1421584" which is being >> returned >> in response to the submit_sm_resp. This is the message id i need to >> track >> messages from my smsc. What should i use to pass that to the url so i >> can >> track it. >> >> I see 049ddeb5-64fb-44ec-b0af-3adc094f91d1 as the id inside access.log. >> I >> guess this is some internal message id. What i want is the message id >> from >> the smsc. >> >> Any help would be highly appreciated. >> >> -- >> regards, >> >> Anand >> > > --- > Peter Beckman Internet > Guy > [EMAIL PROTECTED] > http://www.purplecow.com/ > --- >
Re: [Kannel-Users] message id
You can't get it, except from the log file, or via DLR. There was a big fight over it a few months back, about protecting the code and not making the code too specific; I don't know if anyone ever made a patch. Beckman On Thu, 14 Apr 2005, Anand Gupta wrote: Here is the response from my smsc while sending a message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP[smsc11]: Got PDU: 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU 0x87a7a18 dump: 2005-04-14 14:16:41 [15081] [7] DEBUG: type_name: submit_sm_resp 2005-04-14 14:16:41 [15081] [7] DEBUG: command_id: 2147483652 = 0x8004 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 = 0x 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 = 0x0005 2005-04-14 14:16:41 [15081] [7] DEBUG: message_id: "GFN1421584" 2005-04-14 14:16:41 [15081] [7] DEBUG: SMPP PDU dump ends. 2005-04-14 14:16:41 [15081] [7] DEBUG: DLR[internal]: Adding DLR smsc=smsc1, ts=GFN1421584, src=gldf, dst=+x, mask=31, boxc= 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: creating DLR message 2005-04-14 14:16:41 [15081] [7] DEBUG: SMSC[smsc1]: DLR = http://xxx.xxx.xxx/dlr.php?type=%d&slid=54&uid=1&dlr-rep=%A&others=%t%i%I%u Now i am trying to get the message_id "GFN1421584" which is being returned in response to the submit_sm_resp. This is the message id i need to track messages from my smsc. What should i use to pass that to the url so i can track it. I see 049ddeb5-64fb-44ec-b0af-3adc094f91d1 as the id inside access.log. I guess this is some internal message id. What i want is the message id from the smsc. Any help would be highly appreciated. -- regards, Anand --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ ---