Of course you were right! OK, it seems now to keep track of the message in the database. And the fog has lifted a bit more... However, why are the entries only temporary and deleted again? Can't they just stay in there for loggin purpose or so?
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? 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?
