|However, why are the entries only temporary and deleted again? |Can't they just stay in there for loggin purpose or so?
<navjot> 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. </navjot> |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? | | |
