You have to tell Kannel to use MySQL - look at the top of your config for 
something that says "internal" now and change to whatever the docs say.

-----Original Message-----
From: Iain Dooley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2008 7:09 AM
To: [email protected]
Subject: mysql storage

hi all, i've finalled gotten round to trying mysql storage. i compiled
mysql support in, and included the following in smskannel.conf:

group = mysql-connection
id = mydlr
host = localhost
username = kannel
password = kannel
database = kannel
max-connections = 1

group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc

and then created a database kannel, with username kannel and password
kannel.

what i'm unsure of is how i should structure my database table. does
anyone have a suggested CREATE TABLE statement?

cheers
iain


Reply via email to