There was a post here some days ago by Tharaga. Check
http://www.nabble.com/Small-DLR-notification-tutorial---mysql-%2B-php-%2B-kannel---Version-2-td17820493.html
Best regards
James
Bryan Gintz wrote:
Hello,
I recompiled Kannel with --with-mysql and have the following in my
conf file:
group = core
.....
dlr-storage = mysql
and
group = mysql-connection
id = mydlr
host = localhost
username = devec_kannel
password = dvkannel
database = devec_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 here is the output from starting bearerbox
2008-06-20 08:25:19 [1689] [0] INFO: MYSQL: Connected to server at
localhost.
2008-06-20 08:25:19 [1689] [0] INFO: MYSQL: server version
4.0.24-standard, clie
nt version 4.1.10.
2008-06-20 08:25:19 [1689] [0] INFO: DLR using storage type: mysql
It looks like it connects, but in my mysql table, there is nothing. I
didn't see anything in the documentation about how to set up the
table, and I am wondering if I did it wrong.
Any ideas?
begin:vcard
fn:James Mutuku
n:Mutuku;James
org:Agile Systems Limited;Technical Department
adr:;;P.O Box 55686-00200;Nairobi;Kenya;00200;Kenya
email;internet:[EMAIL PROTECTED]
title:Lead Consultant
tel;work:+254-722-490994
tel;home:+254-722-490994
tel;cell:+254-722-490994
url:www.agile.co.ke
version:2.1
end:vcard
