[Kea-users] Kea Integrating with mysql

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Kea-users] Kea Integrating with mysql

surya
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_constants.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 type
mysql_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

_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] Kea Integrating with mysql

Thomas Markwalder
Hello:

We have addressed this problem under this issue: https://gitlab.isc.org/isc-projects/kea/issues/354.  This will be included in our Kea 1.6.0 release, due out later this month.  Kea-1.6.0-Beta2 is available now.  MySQL removed the "my_bool" in recent versions.

Cheers,

Thomas Markwalder
ISC Software Engineering

On 8/1/19 6:47 AM, Surya Teja wrote:
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_constants.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 type
mysql_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

_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users


_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users