Hi,
Thank you. The only think I want to do at this point is to save the phone
number and the message of the senders in a mysql database. I will go directly
in that database to see the infos.
I did the following. What is missing to have the infos in the mysql database?
I created the database.
I did this:
group = mysql-connection
id = mydlr
host = localhost
username = root
password = mypassword
database = dlr
max-connections = 1
I did this:
#---- DLR table structure
group = dlr-db
id =
mydlr
table = dlr
field-smsc = smsc
field-timestamp =
ts
field-destination = destination
field-source =
source
field-service = service
field-url = url
field-mask =
mask
field-status = status
field-boxc-id = boxc
Thanks,
Naryam
--- On Thu, 12/31/09, Nikos Balkanas <[email protected]> wrote:
From: Nikos Balkanas <[email protected]>
Subject: Re: MySql Script for kannel for storing response from SMPP
To: "naryam smith" <[email protected]>, [email protected]
Date: Thursday, December 31, 2009, 6:47 PM
Hi,
DLRs are biding proof of receipt of an SMS. It is generated
from the SIM of the destination phone and propagated throughout the chain to
reach you. That's what you need to bill your customer.
As Jovan mentioned, kannel can process DLRs in memory or using
an external DB. This is just for internal processing by kannel and are deleted
after SMS delivery or failure. External DB is slower, but preserves DLRs during
a server crash, and are necessary if you load balance among various
bearerboxes.
DLRs are recorded permanenetly in access logs. Kannel gives the option of an
additional HTTP API to store them permanently into an externally defined
storage. That's what dlr-url does for you. Upon receipt of a DLR kannel will
call the dlr-url if defined. Mind you it is your responsibility to provide the
external webserver and database for the storage.
You can define default dlr-url in group sendsms-user (read
user guide). Or you can give it directly in the push URL (must be
urlencoded).
There are various types of DLRs you can request from the SMSc,
i.e. SMS buffered, SMS accepted by SMSc, etc. dlr-mask specifies which of these
reports you want. To get all use 63 - in latest CVS. You can give dlr-mask only
in the push url of each message. You should read User's guide to learn about
the
different DLR types and how are defined in dlr-mask.
Hope this helps,
Happy New Year,
Nikos
----- Original Message -----
From:
naryam
smith
To: [email protected]
Sent: Friday, January 01, 2010 12:48
AM
Subject: Re: MySql Script for kannel for
storing response from SMPP
Hi
I have the same problem as Kiran. I do not
understand where to set the dlr-url and dlr-mask and what are the
formats of these parameters. I could not understand from the
documentation.
Also, from Debian (without gnome/kde or similar
how do I access a URL such as:
> http://192.168.1.93:13013/cgi-bin/sendsms?username=kiran&password=kiran&to=919036971573&text=This+is+testfor
>
priority and message response&dlr-mask=31&priority=3
Where
would you use such url?
Thanks,
Naryam
--- On
Wed, 12/30/09, Jovan Kostovski <[email protected]>
wrote:
From:
Jovan Kostovski <[email protected]>
Subject: Re: MySql
Script for kannel for storing response from SMPP
To:
"[email protected]"
<[email protected]>
Cc: [email protected]
Date:
Wednesday, December 30, 2009, 10:35 AM
On Wed, Dec 30, 2009 at 2:07 PM, [email protected]
<[email protected]>
wrote:
> Hi Jovan,
>
> I created Mysql tables a
below.And also can any one please check my kannel
>
configuration if any mistake is there please let me know what is
wrong. I
> want to test message priority and message response
(dlr-mask).
The dlr table is a temporary table used by Kannel
to store dlr data
for the message for which it hasn't received
delivery status.
If you want to check the DRL statuses, you should
define dlr-url and
dlr-mask for the messages that you are
sending.
>
> Database name kannel:
>
>
CREATE TABLE dlr (
> smsc
varchar(40),
> ts varchar(40),
>
destination varchar(40),
>
source varchar(40),
>
service varchar(40),
>
url varchar(255),
>
mask int(10),
>
status int(10),
>
boxc varchar(40)
>
)
The correct configuration for the dlr table which you have
created is:
#---- DLR table structure
group = dlr-db
id =
mydlr
table = dlr
field-smsc = smsc
field-timestamp =
ts
field-destination = destination
field-source =
source
field-service = service
field-url = url
field-mask =
mask
field-status = status
field-boxc-id = boxc
> Send
SMS URL
>
> http://192.168.1.93:13013/cgi-bin/sendsms?username=kiran&password=kiran&to=919036971573&text=This+is+testfor
>
priority and message
response&dlr-mask=31&priority=3
The dlr-url is missing
in the request.
This url is called when kannel receives the message
status. Set the
parameters of the dlr-url which you are interested
in
and set some messageid. Check the userguide for details
;)
BR,
Jovan
