well,
as far as i know,
Kannel's External delivery report (DLR) storage comes to replace
the internal storage of the dlr info stored in the memory of the bearerbox
process.
but it has NOTHING to do with the possibility of setting a unique dlr-url,
its just handles the kannel logic in matching kannel internal ID to the SMSC id
...
in short, you set dlr-mask and unique dlr-ulr each time you send SMS.
in this case kannel will POST/GET the unique dlr-url when DLR SMS is received
by the SMSC
example:
log form the web server:
/dlr.pgsql.php?smscID=mtel&dlr=8&answer=ACK%2F&to=%2B359885100407&from=1302&ts=1194787318&smsID=9e89b246415f6e6ffb8f327f4a53c938&charset=ISO-8859-1&kannel_id=01a68bbd-81ba-4785-b719-62dce0d28e17
HTTP/1.1" 200 1 "-" "Kannel/cvs-20070627"
in the above row, smsID value is a unique key /md5 sum/ in the db table for the
MT traffic.
example for php script inserting the MT traffic in the sqlbox:
$dlrUrl=pg_escape_string("http://{$dlrhost[$recenthost]}:{$dlrport[$recenthost]}/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID={$mesgid}&charset=%C&kannel_id=%I";);
second example,
you use SQLBox to handle all MO MT DRL traffic in one table,
and there you may set some sql engine to handle the matching and tracking the
messages per their unique id.
for that you would need for example Oracle or PostgreSQL with rules on insert
in a view to simplify the process.
-----Original Message-----
From: Knaan Ratosh [EMAIL PROTECTED]
Sent: 11 Ноември 2007 г.
To: seikath
Subject:audit sent and queued messages to DB
> The problem is that I need to audit also success messages, and as I
> know the dlr stores a message in the DB and then deletes it when it's
> delivered
> successfully.
> Knaan Ratosh
> Acting VP R&D
> AxisMobile Ltd.
> Consumer Mobile Email
> Tel: Int +972-3-7685529
> Mobile: Int +972-54-3138460
> [EMAIL PROTECTED]
> -----Original Message-----
> From: seik [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 09, 2007 2:54 PM
> To: Knaan Ratosh
> Cc: [email protected]
> Subject: Re: audit sent and queued messages to DB
> well in case with "queued" you mean accepted by the SMSC and still not
> delivered to the recipient,
> you may just use DLR reporting data inserted into db
> each SMS should be sent with unique dlr smsid and proper value of the
> expiration timeout.
> from here you will deal with the sql queries i belive.
> -----Original Message-----
> From: Knaan Ratosh [EMAIL PROTECTED]
> Sent: 09 Ноември 2007 г.
> To: seik
> Subject:audit sent and queued messages to DB
>> Hi,
>> I need to store in an audit database information regarding messages that
>> were sent successfully, and ones that are
>> queued. I need this because I need to perform some reporting on the results
>> - for example, report that counts the
>> number of queued messages that were sent to a certain user within a range of
>> dates.
>> Does anyone have any idea how to do that?
>>
>> Knaan Ratosh
>> Acting VP R&D
>> AxisMobile Ltd.
>> Consumer Mobile Email
>> Tel: Int +972-3-7685529
>> Mobile: Int +972-54-3138460
>> [EMAIL PROTECTED]
>>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ************************************************************************************
