Hello,
When I try to run kannel with "dlr-storage = mysql", it simply doesn't
start, and log files don't say anything, I have love level at 0, but the
deamon simply doesn't even start, thus no logging, and I don't know what
is wrong.
I have below for my mysql configuration in kannel.conf:
################ MYSQL CONFIGURATION ##################
group = mysql-connection
id = mydlr
host = 127.0.0.1
port = 3306
username = root
password = PASSWORD
database = dlr
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 my database from mysql:
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| smsc | varchar(40) | YES | | NULL | |
| ts | varchar(40) | YES | | NULL | |
| destination | varchar(40) | YES | | NULL | |
| source | varchar(40) | YES | | NULL | |
| service | varchar(40) | YES | | NULL | |
| url | varchar(255) | YES | | NULL | |
| mask | int(10) | YES | | NULL | |
| status | int(10) | YES | | NULL | |
| boxc | varchar(40) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
Any idea?
Kind Regards,
Ali Ansari