Hi,
The dlr table in kannel is used as a temporary placeholder. Once the DLR is
received the entry is deleted. If all DLRs are matched, table should be
empty.
BR,
Nikos
----- Original Message -----
From: "Michael vd Poel" <[email protected]>
To: <[email protected]>
Sent: Sunday, June 12, 2011 7:42 AM
Subject: MySQL issue
Hi all,
I have Kannel running on CentOS and it is sending messages. I have
configured
with '--with-mysql' and when Kannel is starting, it shows "2011-06-12
01:10:05
[7937] [0] INFO: MYSQL: Connected to server at localhost."
In the configuration file, I have:
dlr-storage=mysql
group = mysql-connection
id = mydlr
host = localhost
username = gebruiker
password = password
database = sms
max-connections = 10
group = dlr-db
id = mydlr
table=log
field-smsc=smsc
field-timestamp=timestamp
field-destination=destination
field-source=source
field-service=service
field-url=url
field-mask=mask
The MySQL user 'gebruiker' has INSERT privilege.
I have a table with corresponding fields in the database. But the table
isn't
populating.
Does anyone see what I am overlooking?
Thanks for any help!
Michael