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? > |
