[Kea-users] Kea Integrating with mysql

[Surya Teja]

Hi I am trying to configure the Kea with mysql backend as part of  leases
data storage.
Installed the dependencies of mysql on centos 7 and integrated it to kea
module by executeing following commands at the location where I installed
kea.

 ./configure --with-mysql
  make
 sudo make install

For the first command it was successful
  *output *:       Kea source configure results:
    -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Package:
  Name:              kea
  Version:           1.5.0
  Extended version:  1.5.0 (tarball)
  OS Family:         Linux

  Hooks directory:   /usr/local/lib/hooks
  Premium hooks:     no

C++ Compiler:
  CXX:             g++ --std=c++11
  CXX_VERSION:     g++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36)
  CXX_STANDARD:    201103
  DEFS:            -DHAVE_CONFIG_H
  CPPFLAGS:         -DOS_LINUX  -DBOOST_ASIO_HEADER_ONLY
  CXXFLAGS:        -g -O2
  LDFLAGS:          -lpthread
  KEA_CXXFLAGS:     -Wall -Wextra -Wnon-virtual-dtor -Wwrite-strings
-Woverloaded-virtual -Wno-sign-compare -pthread
-Wno-missing-field-initializers -fPIC

Botan: no




*MySQL:  MYSQL_VERSION:   8.0.17  MYSQL_CPPFLAGS:  -I/usr/include/mysql
-m64  MYSQL_LIBS:      -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt
-lssl -lcrypto -ldl*
----and more

but when I execute the command *make *it gave me error
 Error:
 ==============================================
 from ../../../src/lib/mysql/mysql_connection.h:14,
                 from mysql_connection.cc:11:
../../../src/lib/mysql/mysql_con
*stants.h:20:7: error: ‘my_bool’ does not name a type const my_bool
MLM_FALSE = 0;*
       ^
../../../src/lib/mysql/mysql_constants.h:23:7: error: ‘my_bool’ does not
name a type
 const my_bool MLM_TRUE = 1;
       ^
In file included from ../../../src/lib/mysql/mysql_connection.h:14:0,
                 from mysql_connection.cc:11:



*../../../src/lib/mysql/mysql_binding.h:565:5: error: ‘my_bool’ does not
name a typemysql_connection.cc: In member function ‘void
isc::db::MySqlConnection::openDatabase()’:mysql_connection.cc:162:5: error:
‘my_bool’ was not declared in this scope     my_bool auto_reconnect =
MLM_FALSE;*
     ^
mysql_connection.cc:162:13: error: expected ‘;’ before ‘auto_reconnect’
     my_bool auto_reconnect = MLM_FALSE;
             ^
mysql_connection.cc:163:62: error: ‘auto_reconnect’ was not declared in
this scope
     int result = mysql_options(mysql_, MYSQL_OPT_RECONNECT,
&auto_reconnect);

----------->When I surf for it some of the references says it is issue with
mysql 8
So,I tried installing lower version like mysql 5.7 but it gave me another
error like
 while loading shared libraries*: libmysqlclient.so.18: cannot open shared
object file: No such file or directory. *
Any help is appreciated thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190801/e2341e5f/attachment.htm>