<div dir="ltr">Hi I am trying to configure the Kea with mysql backend as part of leases data storage.<br>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.<br><br> ./configure --with-mysql <br> make<br> sudo make install<br><br>For the first command it was successful <br>
<b>output </b>: Kea source configure results:<br> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br><br>Package:<br> Name: kea<br> Version: 1.5.0<br> Extended version: 1.5.0 (tarball)<br> OS Family: Linux<br><br> Hooks directory: /usr/local/lib/hooks<br> Premium hooks: no<br><br>C++ Compiler:<br> CXX: g++ --std=c++11<br> CXX_VERSION: g++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36)<br> CXX_STANDARD: 201103<br> DEFS: -DHAVE_CONFIG_H<br> CPPFLAGS: -DOS_LINUX -DBOOST_ASIO_HEADER_ONLY<br> CXXFLAGS: -g -O2<br> LDFLAGS: -lpthread<br> KEA_CXXFLAGS: -Wall -Wextra -Wnon-virtual-dtor -Wwrite-strings -Woverloaded-virtual -Wno-sign-compare -pthread -Wno-missing-field-initializers -fPIC<br><br>Botan: no<br><br><b>MySQL:<br> MYSQL_VERSION: 8.0.17<br> MYSQL_CPPFLAGS: -I/usr/include/mysql -m64<br> MYSQL_LIBS: -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl</b><br>----and more<br><br>but when I execute the command <b>make </b>it gave me error <br> Error:<br> ==============================================<br> from ../../../src/lib/mysql/mysql_connection.h:14,<br> from mysql_connection.cc:11:<br>../../../src/lib/mysql/mysql_con<b>stants.h:20:7: error: ‘my_bool’ does not name a type<br> const my_bool MLM_FALSE = 0;</b><br> ^<br>../../../src/lib/mysql/mysql_constants.h:23:7: error: ‘my_bool’ does not name a type<br> const my_bool MLM_TRUE = 1;<br> ^<br>In file included from ../../../src/lib/mysql/mysql_connection.h:14:0,<br> from mysql_connection.cc:11:<br><b>../../../src/lib/mysql/mysql_binding.h:565:5: error: ‘my_bool’ does not name a type<br>mysql_connection.cc: In member function ‘void isc::db::MySqlConnection::openDatabase()’:<br>mysql_connection.cc:162:5: error: ‘my_bool’ was not declared in this scope<br> my_bool auto_reconnect = MLM_FALSE;</b><br> ^<br>mysql_connection.cc:162:13: error: expected ‘;’ before ‘auto_reconnect’<br> my_bool auto_reconnect = MLM_FALSE;<br> ^<br>mysql_connection.cc:163:62: error: ‘auto_reconnect’ was not declared in this scope<br> int result = mysql_options(mysql_, MYSQL_OPT_RECONNECT, &auto_reconnect);<br> <br>----------->When I surf for it some of the references says it is issue with mysql 8 <br>So,I tried installing lower version like mysql 5.7 but it gave me another error like <br> while loading shared libraries<b>: libmysqlclient.so.18: cannot open shared object file: No such file or directory. </b> <div>Any help is appreciated thanks in advance<br></div></div>