Below is the configuration I use. Maybe the parameters needs to be
updated against Kannel new version 1.4.1
Table Struncture
create table dlr (smsc varchar(16),
boxc varchar(16),
ts varchar(32),
source varchar(32),
destination varchar(32),
service varchar(16),
url varchar(255),
mask varchar(4),
status varchar(8));
create index dlr_index on dlr (smsc, ts, destination) ;
DB Configurations in Kannel
group = mysql-connection
id = mydlr
host = localhost
mysql-username = bearer
mysql-password = barbearer
database = dlr
group = dlr-db
id = mydlr
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
field-boxc-id = boxc
Regards,
Remon
-----Original Message-----
From: Jovan Kostovski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2008 6:18 PM
To: Iain Dooley
Cc: [email protected]
Subject: Re: mysql storage
On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley
<[EMAIL PROTECTED]> wrote:
> and then created a database kannel, with username kannel and password
> kannel.
I'm using a table with all the fields as varchars. Works without any
problems.
CHEERS, Jovan
