Re: removing DLR from database

Hi.

I am seeing the same errors with kannel 1.2.1, 1.3.1 and today's CVS.

2003-04-14 11:37:27 [7] DEBUG: SMPP[O2] handle_pdu, got DLR
2003-04-14 11:37:27 [7] DEBUG: Found entry, row[0]=31, row[1]=tester,
row[2]=http://212.x.x.x/cgi-bin/dlrmysql.cgi?type=%d&time=%t&to=%P,
row[3]=353863832024, row[4]=(null)
2003-04-14 11:37:27 [7] DEBUG: created DLR message for URL
<http://212.x.x.x/cgi-bin/dlrmysql.cgi?type=%d&time=%t&to=%P>
2003-04-14 11:37:27 [7] DEBUG: removing DLR from database
2003-04-14 11:37:27 [7] ERROR: Could not route message to smsbox id
<(null)>, smsbox is gone!

Kannel sends a message for the initial DLR of type 12, but the message it
tries to send above (which is a type 1) isn't sent. There's no reference to
it in the apache logs nor anywhere else.
This setup works fine when using internal dlr, but doesn't work with mysql
dlr.

Also, when using mysql dlr, %P is from, instead of to!

Internal dlr works as documented - %P is to and %p from.

Regards,

David.



> From: Andreas Fink
> Subject: Re: removing DLR from database
> Date: Fri, 07 Mar 2003 07:48:55 -0800
>
> On Freitag, März 7, 2003, at 03:59 Uhr, Bartosz Jozwiak wrote:
>
>> Hello all,
>>
>>
>> Pleasetell me why Kannel is removing DLR form data base?
>>
>> What can be wrong?
>>
>>
>> 2003-03-06 09:30:56 [6] DEBUG: Found entry, row[0]=31, row[1]=simple,
row[2]=http://66.xxx.x.xxx/php/submitform.php?status=, row[3]=447781482005,
row[4]=(null)
>> 2003-03-06 09:30:56 [6] DEBUG: created DLR message for URL
<http://66.xxx.xxx.xx/php/submitform.php?status=>
>> 2003-03-06 09:30:56 [6] DEBUG: removing DLR from database
>> 2003-03-06 09:30:56 [6] ERROR: Could not route message to smsbox id
<(null)>, smsbox is gone!
>>
>> Regards,
>>
>>
>
>
> Because it doesn't need to track any data for this SMS anymore in this
temporary storage. The delivery report came back with a final status so
> there will be no subsequent reports for this SMS anymore so Kannel removes
the entry and delivers the delivery report back to the originator
> via the indicated original URL. Why it tries to send it to smsbox <(null)>
is something which I dont understand.
> Maybe Stipe can answer this? I'm sure it has something to do with the
smsbox specific routing.
>
> Andreas Fink
> Global Networks Switzerland AG
>
> ------------------------------------------------------------------
> Tel: +41-61-6666333 Fax: +41-61-6666334 Mobile: +41-79-2457333
> Global Networks, Inc. Clarastrasse 3, 4058 Basel, Switzerland
> Web: http://www.global-networks.ch/  [EMAIL PROTECTED]
> ------------------------------------------------------------------
> Member of the GSM Association