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', '+xxxxxxx', '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 =
>>>> 0x80000004
>>>> 2005-04-14 14:16:41 [15081] [7] DEBUG: command_status: 0 =
>>>> 0x00000000
>>>> 2005-04-14 14:16:41 [15081] [7] DEBUG: sequence_number: 5 =
>>>> 0x00000005
>>>> 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=+xxxxxxxxx, 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/
> ---------------------------------------------------------------------------
>