dbt_open_database: unknown database driver "mysql"

[d.mul...@gmail.com]

Hi!
First of all many thanks for the mother!
Maybe you can help me with my issue? When I trying to start mopherd, I have got next errors:
mopherd[3096]: dbt_open_database: unknown database driver "mysql
mopherd[3096]: dbt_init: cannot open database greylist
How can I fix it?

Config file looks like this:

table[greylist] = {
    driver      = "mysql",
    host        = "127.0.0.1",
    user        = "mopher",
    pass        = "secret"
}

[Manuel Badzong]

On Tue, Jan 17, 2017 at 09:43:31AM -0800, d.mul...@gmail.com wrote:
> How can I fix it?

You need to recompile mopher with MySQL support. But you probably need to
install the required MySQL development files first.

If you are on a Debian or Ubuntu system try the following commands:

sudo apt-get install libmysqlclient-dev
make clean
./configure
make
sudo make install

Kind regards

Manuel

[d.mul...@gmail.com]

Thank you for the answer!
My server based on Centos 6.5, I had installed mysql-libs which provide libmysqlclient.so, but when I trying run ~/mopher/mopher-0.6.0/./configure I get the folowing error:
checking for mysql_real_connect in -lmysqlclient... no.
I had changed  lmysqlclient to libmysqlclient into configure file,but it is not helped for me.
Can mopher use mysql data base on centos? Can you advise me what kind of packet I need ti install instead  libmysqlclient-dev?

вторник, 17 января 2017 г., 21:49:47 UTC+3 пользователь Manuel Badzong написал:

[Manuel Badzong]

On Wed, Jan 18, 2017 at 01:35:24AM -0800, d.mul...@gmail.com wrote:
> Can mopher use mysql data base on centos? Can you advise me what kind of packet
> I need ti install instead  libmysqlclient-dev?

There should be no problem with MySQL on CentOS. I'm not a CentOS expert, but I
think you can identify the required packages using the following yum commands:

yum provides "*/libmysclient*"
yum provides "*/mysql.h"


Kind regards

Manuel

[d.mul...@gmail.com]

I had installed all pakets from output of command yum provides "*mysqlclient*" and "*mysql.h*" and get the same sittuation...





вторник, 17 января 2017 г., 20:43:31 UTC+3 пользователь d.mul...@gmail.com написал:

[Manuel Badzong]

On Wed, Jan 18, 2017 at 02:50:26AM -0800, d.mul...@gmail.com wrote:

> I had installed all pakets from output of command yum provides "*mysqlclient*"
> and "*mysql.h*" and get the same sittuation...

We need to find the library and include paths for libmysqlclient and pass it to
configure. Can you give me the output of the following commands:

find / -name mysql.h
find / -name "libmysqlclient*.so"


Kind regards

Manuel

[d.mul...@gmail.com]

of course:
find / -name mysql.h
/usr/include/mysql/mysql.h

find / -name "libmysqlclient*.so"
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient_r.so

вторник, 17 января 2017 г., 20:43:31 UTC+3 пользователь d.mul...@gmail.com написал:

Hi!

[Manuel Badzong]

> find / -name "libmysqlclient*.so"
> /usr/lib64/mysql/libmysqlclient.so

Try to run configure like this:

LDFLAGS="-L/usr/lib64/mysql" ./configure

[d.mul...@gmail.com]

thank you so much!
now everything is fine and looks great)

вторник, 17 января 2017 г., 20:43:31 UTC+3 пользователь d.mul...@gmail.com написал:

Hi!