Q1) FOA, dlr with mysql has 2 purposes :
-you don't loose your dlr when you restart your bearbox (security)
-you don't use your memory to store them. (stability)
Q2) I dit not get the meaning of "Anyone has a little php script as an example
for inserting in mysql...."
Just,
# 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)
# )
Then bearbox will insert into this table all his stuff
2006-01-04 23:52:45 [23954] [28] DEBUG: sql: INSERT INTO dlr (smsc, ts, src,
dest, srvc, url, mask, boxc, status) VALUES ('SMSC1', '040106235240',
'<shortcode>', '<number>', '<srvc>', 'http://<ip>:<port>/dlr?.......<params>',
'16', '', '0');
Vincent
--
Telemaque - NICE
Service Technique
Tel : +33 4 93 97 71 64 (fax 68)
[EMAIL PROTECTED]
----- Original Message -----
From: "vladimir calderon" <[EMAIL PROTECTED]>
To: <users@kannel.org>
Sent: Wednesday, January 04, 2006 11:40 PM
Subject: Explanation mysql and dlr
Hi,
recently, i downloaded kannel and installed succesfully. I began adding
gently all the options (although i haven't tested it against a real smsc).
I have 2 questions:
Q1) The one option i don't understand is dlr with mysql storage. apparently
this is used by kannel just for managing purposes and not for us users
knowing if a sms reaches destination etc.... please correct me if i'm wrong.
Well, i have turned on mysql query log but no query is fired to mysql when
executing fakesmsc neither when sending a sms with the cgi-bin/sendsms
script. So, what's the purpose of dlr storage with mysql?
Of course, bearerbox does make a succesful connection to the db and tells me
everything is fine (and you can see this connection in the mysql log)....
but no queries are sent.
Q2) Anyone has a little php script as an example for inserting in mysql....
just to know a correct way to catch a unique id for any sms sent.
Thanks in advance.
vcy
