Dear Ali,

When you compile the source code use below command.

 #./configure --with-mysql --with-mysql-dlr=/usr/include/mysql/mysql.h


And then check for the same.





On Wed, Feb 26, 2014 at 6:04 AM, Ali Ansari <mydi...@gmail.com> wrote:

> 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
>
>

Reply via email to