Hi I have tried to follow your question to be able to setup deleivery reports as well but much of the correspondence is reformated and i can no decipher it please since you have been able to set it up can you give me the procedure to do it from scratch. One major issue is where do i find dlr.php do i have to create it and if i have to create it what is the logic inside it.
Then when am sending the sms there is the much talked about mask where do i put it and what is the full url i should use if i want to use mysql dlr? Thanks in advance Andrew On Wed, 20 Aug 2003 10:12:33 +0200 (GMT+02:00) David Meier <[EMAIL PROTECTED]> wrote: > Thanks Navjot, > > It seems to work now. I can see the table for the dlr's > is being updated however the records are flushed from the > table right after successful delivery to the mobile. In > the logs I get the following entry: > > 2003-08-20 10:09:15 [6] DEBUG: created DLR message for > URL <http://localhost/dlr/dlr.php?msgid=16&code=%d> > 2003-08-20 10:09:15 [6] DEBUG: removing DLR from database > > Any idea? I have not set the flush command somewhere > explicitly. By the way I am running kannel 1.3.1. > > Dave > > > > > |However, why are the entries only temporary and > deleted again? > > |Can't they just stay in there for loggin purpose or > so? > > > > > > They should be there even after you shutdown your > bearerbox. DLRs > > are meant for persistent storage. The only way theye > can be deleted > > is either use *kannel's http flush command* or you > delete them > > manually from mysql. > > > > |Actually, what I want is to keep track of the messages > sent for > > |billing reasons. Please correct me if needed: > > | > > |I do set up a MySQL db to store the message. When > sending the data > > |it will be inserted into that table with a status=0 > value. After > > |successful delivery, rejection or whatever reason the > SMSC reports > > |the dlrurl actually a homegrown script is used to > update the > > |message store table with a new status. And that's how > dlr's are > > used? > > You are absolutely right. > > > > hth > > navjot > > > > |Dave > > |> > > |> so, i was right about the absence of few variables. > so far so > > good |> ;-) > > |> You need to set 1 variable dlrmask (another is > optional). You > > just |> need to append &dlrmask=31 and send the > request. > > |> See in the dlr table and you will find one row. > > |> > > |> if any probs, write back. > > |> Navjot Singh > > |> > > |> > > |> |-----Original Message----- > > |> |From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > |> Behalf Of |David Meier > > |> |Sent: Tuesday, August 19, 2003 2:41 PM > > |> |To: [EMAIL PROTECTED] > > |> |Subject: Re: RE: No DLR db entries with GSM-as-SMSC > > |> | > > |> | > > |> |Hello Navjot, > > |> | > > |> |aha, they need to be set as well? I am a little bit > confused > > about |> |how the dlrurl has to look like in my case of > mysql-dlr. > > Maybe you |> |can give me a hint on that. > > |> | > > |> |Thanks, Dave > > |> | > > |> |> > > |> |> hi david, > > |> |> > > |> |> Can you post the request that are sending to send > SMS? > > |> |> Rest everyting seems fine so I can be doubtful if > the dlrurl > > and |> |> dlrmask variables are set. > > |> |> > > |> |> regards > > |> |> Navjot Singh > > |> |> > > |> |> > > |> |> |-----Original Message----- > > |> |> |From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] |> |> Behalf Of > |David Meier > > |> |> |Sent: Monday, August 18, 2003 9:26 PM > > |> |> |To: [EMAIL PROTECTED] > > |> |> |Subject: Re: No DLR db entries with GSM-as-SMSC > > |> |> | > > |> |> | > > |> |> |Looks like I'not alone... I got the same > problem. How did you > > |> get |> |it solved? > > |> |> | > > |> |> |Dave > > |> |> | > > |> |> |> > > |> |> |> Hi, > > |> |> |> > > |> |> |> I have built kannel with mysql dlr support and > added > > entries |> in |> the |> config file. When I start the > bearerbox I > > get a |> sucessful |> Mysql |> connection message. When > I send SMS's > > though |> nothing hits |> my dlr |> table. When I > misspell the db > > name in my |> conf I get a |> complaint on |> bearerbox > startup that > > the db is not |> present. When I |> misspell the |> > table name I > > don't. I can send |> SMS's ok with this |> wrong table > name, |> > > which suggests to me |> either it deliberately |> isn't > attempting > > to |> write a record |> until some other event occurs > |> or I'm > > being dumb |> again. Anyone |> know which it is please > ? ;-) |> |> > > Here are the relevant entries: |> |> |> > > |> |> |> group = core > > |> |> |> ... > > |> |> |> dlr-storage = mysql > > |> |> |> > > |> |> |> group = mysql-connection > > |> |> |> id = dlr-db > > |> |> |> host = site1 > > |> |> |> mysql-username = "" > > |> |> |> mysql-password = "" > > |> |> |> database = mydlrdatabase > > |> |> |> > > |> |> |> group = dlr-db > > |> |> |> id = dlr-db > > |> |> |> table = dlr > > |> |> |> field-smsc = smsc > > |> |> |> field-timestamp = ts > > |> |> |> field-source = source > > |> |> |> field-destination = destination > > |> |> |> field-service = service > > |> |> |> field-url = url > > |> |> |> field-mask = mask > > |> |> |> field-status = status > > |> |> |> > > |> |> |> Are any entries in group = smsc, group = > smsbox or group = > > |> |> |> sendsms-user needed for db dlr storage? > > | > > == Download ringtones, logos and picture messages at Ananzi Mobile Fun. http://www.ananzi.co.za/cgi-bin/goto.pl?mobile
