Hi, Does this happen when you remove msg-id-type=0X02 from your configuration?
On Thu, Sep 30, 2010 at 2:43 PM, hafez ahmad <hafezad...@gmail.com> wrote: > Hi All, > > I have problem with the DLR that DLR row not found, I use msg-id-type=0X02 > , but I still have the problem, please note also that this problem not > always happened, sometimes the kannel finds the DLR row in the database. > > Also I have note the following the TS field in the DLR table > mean reference to the Manual > > field-timestamp = ts > > " > field-timestamp (m) string The table field that is used for the > timestamp data > " > > but as we see in the below log: > > 2010-09-30 16:12:01 [23945] [15] DEBUG: sql: SELECT mask, service, url, > source, destination, boxc FROM dlr WHERE smsc='MYSMPP' AND * > ts='1657099323'*; > > but the ts here is the message id not the Timestamp , do you have any > ideas about that ? > > > > 2010-09-30 16:12:01 [23945] [15] DEBUG: len: 120 > 2010-09-30 16:12:01 [23945] [15] DEBUG: size: 121 > 2010-09-30 16:12:01 [23945] [15] DEBUG: immutable: 0 > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 69 64 3a 36 32 43 35 35 > 34 33 42 20 73 75 62 3a id:62C5543B sub: > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 30 30 31 20 64 6c 76 72 > 64 3a 30 30 31 20 73 75 001 dlvrd:001 su > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 62 6d 69 74 20 64 61 74 > 65 3a 31 30 30 39 33 30 bmit date:100930 > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 31 36 31 32 20 64 6f 6e > 65 20 64 61 74 65 3a 31 1612 done date:1 > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 30 30 39 33 30 31 36 31 > 32 20 73 74 61 74 3a 52 009301612 stat:R > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 45 4a 45 43 54 44 20 65 > 72 72 3a 30 30 30 20 74 EJECTD err:000 t > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 65 78 74 3a 20 20 20 20 > 20 20 20 20 20 20 20 20 ext: > 2010-09-30 16:12:01 [23945] [15] DEBUG: data: 20 20 20 20 20 20 20 20 > > 2010-09-30 16:12:01 [23945] [15] DEBUG: Octet string dump ends. > 2010-09-30 16:12:01 [23945] [15] DEBUG: SMPP PDU dump ends. > 2010-09-30 16:12:01 [23945] [15] DEBUG: SMPP[MYSMPP] handle_pdu, got DLR > 2010-09-30 16:12:01 [23945] [15] DEBUG: DLR[mysql]: Looking for DLR > smsc=MYSMPP, ts=1657099323, dst=9XXXXXXXXXX, type=2 > 2010-09-30 16:12:01 [23945] [15] DEBUG: sql: SELECT mask, service, url, > source, destination, boxc FROM dlr WHERE smsc='MYSMPP' AND ts='1657099323'; > 2010-09-30 16:12:01 [23945] [15] DEBUG: no rows found > 2010-09-30 16:12:01 [23945] [15] WARNING: DLR[mysql]: DLR from SMSC<MYSMPP> > for DST<9XXXXXXXXXX> not found. > > Regards and very thanks > Hafez > >