Hi, AFAIK,
MySQL storage in dlr storage means/work when DLR for specified message arrive, it will trigger dlr-url in dlr storage, and then delete the entry. If you plan to record the dlr status, you have to do some scripting and put it in your dlr-url (the action will be done if DLR arrived). Your error means the incomming DLR cannot find a matching dlr-url entry in your dlr table. Hope this help start digging.. --tjatur On Wed, 2007-02-07 at 17:44 +0530, Tushar wrote: > Hi all, > > > > I m configuring kannel message reception. The DLRs received > by kannel is not getting saved MYSQL.. The log of bearerbox is as > follows:- > > > > Please help me with the configuration of DLRs….. > > > > 2007-02-07 17:15:51 [15840] [7] DEBUG: Octet string at 0x81cc2f0: > > 2007-02-07 17:15:51 [15840] [7] DEBUG: len: 113 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: size: 114 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: immutable: 0 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 69 64 3a 34 35 43 42 > 38 44 35 39 20 73 75 62 3a id:45CB8D59 sub: > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 20 20 30 20 64 6c 76 > 72 64 3a 20 20 30 20 73 75 0 dlvrd: 0 su > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 62 6d 69 74 20 64 61 > 74 65 3a 30 37 30 32 30 37 bmit date:070207 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 31 36 35 38 20 64 6f > 6e 65 20 64 61 74 65 3a 30 1658 done date:0 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 37 30 32 30 37 31 36 > 35 39 20 73 74 61 74 3a 44 702071659 stat:D > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 45 4c 49 56 52 44 20 > 65 72 72 3a 30 30 30 20 54 ELIVRD err:000 T > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 65 78 74 3a 74 65 73 > 74 20 6d 65 73 73 61 67 65 ext:test message > > 2007-02-07 17:15:51 [15840] [7] DEBUG: data: 34 > 4 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: Octet string dump ends. > > 2007-02-07 17:15:51 [15840] [7] DEBUG: message_state: 2 = 0x00000002 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: receipted_message_id: > "45CB8D59" > > 2007-02-07 17:15:51 [15840] [7] DEBUG: SMPP PDU dump ends. > > 2007-02-07 17:15:51 [15840] [7] DEBUG: SMPP[mysmpp] handle_pdu, got > DLR > > 2007-02-07 17:15:51 [15840] [7] DEBUG: DLR[mysql]: Looking for DLR > smsc=mysmpp, ts=45CB8D59, dst=919820245371, type=1 > > 2007-02-07 17:15:51 [15840] [7] DEBUG: sql: SELECT mask, service, url, > source, destination, boxc FROM dlr WHERE smsc='mysmpp' AND > ts='45CB8D59'; > > 2007-02-07 17:15:51 [15840] [7] DEBUG: no rows found > > 2007-02-07 17:15:51 [15840] [7] WARNING: DLR[mysql]: DLR for > DST<919820245371> not found. > > 2007-02-07 17:15:51 [15840] [7] ERROR: SMPP[mysmpp]: got DLR but could > not find message or was not interested in it id<45CB8D59> > dst<919820245371>, type<1> > >
