Hi, Yes I spotted that and so did the bearerbox! If you start it without that field it tells you. So I added it and the message went away.
The structure is : CREATE TABLE dlr ( smsc varchar(40), ts varchar(40), source varchar(40), destination varchar(40), service varchar(40), url varchar(255), mask int(10), status int(10) ) In the kannel conf I have: 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 > > From: "Rene Kluwen" <[EMAIL PROTECTED]> > Date: Fri 18/Oct/2002 22:47 GMT > To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: Re: No DLR db entries with GSM-as-SMSC > > What is the structure of your dlr table? > I noticed that in the docs there is the source-field missing in the create > table definition that is given. > > That could be a possible problem. > > -- Rene... > > -------- > This email message has been automatically scanned for viri using Sophos > antivirus. > -------- > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 18, 2002 9:44 PM > Subject: No DLR db entries with GSM-as-SMSC > > > > 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? > > > > > > > > _______________________________________________________________________ > > Freeserve AnyTime, only £13.99 per month with one month's FREE trial! > > For more information visit http://www.freeserve.com/time/ or call free on > 0800 970 8890 > > > > > > > > _______________________________________________________________________ Freeserve AnyTime, only £13.99 per month with one month's FREE trial! For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890
