Re: DLR Report

Hi David,

I had done something for DLR this before.
I had set dlrmask=7, and also dlrurl and has compiled with mysql support.
I am getting the following log from bboxaccess log

2003-05-05 09:57:48 Sent SMS [SMSC:XXXXX] [SVC:YYYYY] [ACT:] [from:xxx] [to:+xxxxxxxxxxx] [flags:0:1:0:0:7] [msg:12:hellotesting] [udh:0:]

2003-05-05 09:58:19 DLR SMS [SMSC:XXXXX] [SVC:YYYYY] [ACT:] [from:+xxxxxxxxxx] [to:xxx] [flags:0:0:0:0:1] [msg:102:id:4229699656 sub:001 dlvrd:001 submit date:0305050952 done date:0305050952 stat:DELIVRD err:000 Text:] [udh:0:]

From the bbox log I get this:
....
2003-05-05 09:58:19 [7] DEBUG:      data: 39 35 32 20 73 74 61 74   952 stat
2003-05-05 09:58:19 [7] DEBUG:      data: 3a 44 45 4c 49 56 52 44   :DELIVRD
2003-05-05 09:58:19 [7] DEBUG:      data: 20 65 72 72 3a 30 30 30    err:000
2003-05-05 09:58:19 [7] DEBUG:      data: 20 54 65 78 74 3a          Text:
2003-05-05 09:58:19 [7] DEBUG:    Octet string dump ends.
2003-05-05 09:58:19 [7] DEBUG: SMPP PDU dump ends.
2003-05-05 09:58:19 [7] DEBUG: SMPP[XXXXX] handle_pdu, got DLR
2003-05-05 09:58:19 [7] DEBUG: Found entry, row[0]=7, row[1]=YYYYY, row[2]=http://10.100.1.2/dlr.asp?phone=%P&status=%d&text=%A&id=123, row[3]=xxx, row[4]=(null)
2003-05-05 09:58:19 [7] DEBUG: created DLR message for URL <http://10.100.1.2/dlr.asp?phone=%P&status=%d&text=%A&id=123>
2003-05-05 09:58:19 [7] DEBUG: removing DLR from database
2003-05-05 09:58:19 [7] ERROR: Could not route message to smsbox id <(null)>, smsbox is gone!

I havent tried to change the source as David told. This log is what I am getting now.
May be the change suggested by Nisan Bloch in the CVS source will solve this problem?

Thanks
Shanavaz.

  ----- Original Message ----- 
  From: David Tully 
  To: Shanavaz E A ; [email protected] 
  Sent: Tuesday, May 20, 2003 9:31 PM
  Subject: Re: DLR Report


  Hi Shanavaz.

  > Do any one of you have DLR reports working on mysql DLR storage in SMPP
  SMSC?
  I do.

  You won't get it working without modifying the source code - there's a bug
  in Kannel.

  The change was posted by Nisan Bloch  in : 'Re: INFO: NOTE: sender and
  receiver same number
  <41313131313>, ignoring!', posted on 14/04/03.

  Apart from the bug, you still need to recompile Kannel to add in mysql
  support, along with the parameters listed in the userguide.

  Here's how I have it configured..

  In the core group:
  dlr-storage = mysql

  Also:


  # MYSQL Config
  group = mysql-connection
  id = mydlr
  host = localhost
  mysql-username = *username*
  mysql-password = *password*
  database = dlr

  # MYSQL Delivery Reports
  group = dlr-db
  id = mydlr
  table = dlr
  field-smsc = smsc
  field-timestamp = ts
  field-source  = source
  field-destination = destination
  field-service = service
  field-url = url
  field-mask = mask
  field-status = status



  Regards,

  David.



  ----- Original Message -----
  From: Shanavaz E A
  To: [email protected]
  Sent: Tuesday, May 20, 2003 4:59 PM
  Subject: DLR Report


  Hi,
  Do any one of you have DLR reports working on mysql DLR storage in SMPP
  SMSC?
  If yes, please give me the URL you are using to send message. Please... It
  is very urgent.

  Also pls give what parameters you have set in your conf. file to make it
  working.

  Please reply soon. This is very urgent.

  Thanking you,
  Shanavaz.