# Env



ushastry@jammy:~/Downloads/mysql-5.7.40/bld$ openssl version

OpenSSL 3.0.2 15 Mar 2022 (Library: OpenSSL 3.0.2 15 Mar 2022)

ushastry@jammy:~/Downloads/mysql-5.7.40/bld$ find /usr -name \*ssl\*\.h -print

/usr/include/glib-2.0/gio/gsubprocesslauncher.h

/usr/include/x86_64-linux-gnu/openssl/opensslconf.h

/usr/include/openssl/sslerr_legacy.h

/usr/include/openssl/ssl.h

/usr/include/openssl/prov_ssl.h

/usr/include/openssl/ssl2.h

/usr/include/openssl/sslerr.h

/usr/include/openssl/ssl3.h

/usr/include/openssl/ossl_typ.h

/usr/include/openssl/opensslv.h

ushastry@jammy:~/Downloads/mysql-5.7.40/bld$ cat /etc/*release

DISTRIB_ID=Ubuntu

DISTRIB_RELEASE=22.04

DISTRIB_CODENAME=jammy

DISTRIB_DESCRIPTION="Ubuntu 22.04.1 LTS"

PRETTY_NAME="Ubuntu 22.04.1 LTS"

NAME="Ubuntu"

VERSION_ID="22.04"

VERSION="22.04.1 LTS (Jammy Jellyfish)"

VERSION_CODENAME=jammy

ID=ubuntu

ID_LIKE=debian

HOME_URL="https://www.ubuntu.com/"

SUPPORT_URL="https://help.ubuntu.com/"

BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"

PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"

UBUNTU_CODENAME=jammy





prefix=/home/ushastry/Downloads/my5740
rm -rf bld/
mkdir bld && cd bld
rm -rf CMakeCache.txt
cmake \
      -DBUILD_CONFIG=mysql_release \
      -DCMAKE_BUILD_TYPE=RelWithDebInfo \
      -DCMAKE_INSTALL_PREFIX:PATH=$prefix \
      -DWITH_SSL="system" \
      -DWITH_ZLIB="system" \
      -DMYSQL_DATADIR="${prefix}/data" \
      -DMYSQL_UNIX_ADDR="${prefix}/var/mysql.sock" \
      -DENABLED_LOCAL_INFILE=1 \
      -DMYSQL_MAINTAINER_MODE=0 \
      -DWITH_BOOST=../boost \
      -DWITH_NUMA=ON \
	  ..

ushastry@jammy:~/Downloads/mysql-5.7.40$ rm -rf bld/

mkdir bld && cd bld

rm -rf CMakeCache.txt

cmake \

      -DBUILD_CONFIG=mysql_release \

      -DCMAKE_BUILD_TYPE=RelWithDebInfo \

      -DCMAKE_INSTALL_PREFIX:PATH=$prefix \

      -DWITH_SSL="system" \

      -DWITH_ZLIB="system" \

      -DMYSQL_DATADIR="${prefix}/data" \

      -DMYSQL_UNIX_ADDR="${prefix}/var/mysql.sock" \

      -DENABLED_LOCAL_INFILE=1 \

      -DMYSQL_MAINTAINER_MODE=0 \

      -DWITH_BOOST=../boost \

      -DWITH_NUMA=ON \

          ..

CMake Deprecation Warning at CMakeLists.txt:30 (CMAKE_MINIMUM_REQUIRED):

  Compatibility with CMake < 2.8.12 will be removed from a future version of

  CMake.



  Update the VERSION argument <min> value or use a ...<max> suffix to tell

  CMake that the project does not need compatibility with older versions.





CMake Deprecation Warning at CMakeLists.txt:35 (CMAKE_POLICY):

  The OLD behavior for policy CMP0018 will be removed from a future version

  of CMake.



  The cmake-policies(7) manual explains that the OLD behaviors of all

  policies are deprecated and that a policy should be set to OLD only under

  specific short-term circumstances.  Projects should be ported to the NEW

  behavior and not rely on setting a policy to OLD.





CMake Deprecation Warning at CMakeLists.txt:41 (CMAKE_POLICY):

  The OLD behavior for policy CMP0022 will be removed from a future version

  of CMake.



  The cmake-policies(7) manual explains that the OLD behaviors of all

  policies are deprecated and that a policy should be set to OLD only under

  specific short-term circumstances.  Projects should be ported to the NEW

  behavior and not rely on setting a policy to OLD.





CMake Deprecation Warning at CMakeLists.txt:48 (CMAKE_POLICY):

  The OLD behavior for policy CMP0045 will be removed from a future version

  of CMake.



  The cmake-policies(7) manual explains that the OLD behaviors of all

  policies are deprecated and that a policy should be set to OLD only under

  specific short-term circumstances.  Projects should be ported to the NEW

  behavior and not rely on setting a policy to OLD.





CMake Deprecation Warning at CMakeLists.txt:49 (CMAKE_POLICY):

  The OLD behavior for policy CMP0042 will be removed from a future version

  of CMake.



  The cmake-policies(7) manual explains that the OLD behaviors of all

  policies are deprecated and that a policy should be set to OLD only under

  specific short-term circumstances.  Projects should be ported to the NEW

  behavior and not rely on setting a policy to OLD.





CMake Deprecation Warning at CMakeLists.txt:62 (CMAKE_POLICY):

  The OLD behavior for policy CMP0075 will be removed from a future version

  of CMake.



  The cmake-policies(7) manual explains that the OLD behaviors of all

  policies are deprecated and that a policy should be set to OLD only under

  specific short-term circumstances.  Projects should be ported to the NEW

  behavior and not rely on setting a policy to OLD.





-- Running cmake version 3.22.1

-- Could NOT find Git (missing: GIT_EXECUTABLE) 

-- Configuring with MAX_INDEXES = 64U

-- The C compiler identification is GNU 11.3.0

-- The CXX compiler identification is GNU 11.3.0

-- Detecting C compiler ABI info

-- Detecting C compiler ABI info - done

-- Check for working C compiler: /usr/bin/cc - skipped

-- Detecting C compile features

-- Detecting C compile features - done

-- Detecting CXX compiler ABI info

-- Detecting CXX compiler ABI info - done

-- Check for working CXX compiler: /usr/bin/c++ - skipped

-- Detecting CXX compile features

-- Detecting CXX compile features - done

-- CMAKE_GENERATOR: Unix Makefiles

-- Looking for include file libaio.h

-- Looking for include file libaio.h - found

-- Looking for io_queue_init in aio

-- Looking for io_queue_init in aio - found

-- Looking for SHM_HUGETLB

-- Looking for SHM_HUGETLB - found

-- Looking for sys/types.h

-- Looking for sys/types.h - found

-- Looking for stdint.h

-- Looking for stdint.h - found

-- Looking for stddef.h

-- Looking for stddef.h - found

-- Check size of void *

-- Check size of void * - done

-- SIZEOF_VOIDP 8

-- Performing Test HAVE_C_SHIFT_OR_OPTIMIZATION_BUG

-- Performing Test HAVE_C_SHIFT_OR_OPTIMIZATION_BUG - Failed

-- Performing Test HAVE_CXX_SHIFT_OR_OPTIMIZATION_BUG

-- Performing Test HAVE_CXX_SHIFT_OR_OPTIMIZATION_BUG - Failed

-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD

-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD - Failed

-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD

-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD - Failed

-- Performing Test HAVE_C_FP_CONTRACT_FLAG

-- Performing Test HAVE_C_FP_CONTRACT_FLAG - Success

-- Performing Test HAVE_CXX_FP_CONTRACT_FLAG

-- Performing Test HAVE_CXX_FP_CONTRACT_FLAG - Success

-- MySQL 5.7.40

-- Packaging as: mysql-5.7.40-Linux-x86_64

-- Local boost dir /home/ushastry/Downloads/mysql-5.7.40/boost/boost_1_59_0

-- Found /home/ushastry/Downloads/mysql-5.7.40/boost/boost_1_59_0/boost/version.hpp 

-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 105900

-- BOOST_INCLUDE_DIR /home/ushastry/Downloads/mysql-5.7.40/boost/boost_1_59_0

-- Performing Test HAVE_LLVM_LIBCPP

-- Performing Test HAVE_LLVM_LIBCPP - Failed

-- Looking for pthread.h

-- Looking for pthread.h - found

-- Performing Test CMAKE_HAVE_LIBC_PTHREAD

-- Performing Test CMAKE_HAVE_LIBC_PTHREAD - Success

-- Found Threads: TRUE  

-- Looking for floor

-- Looking for floor - not found

-- Looking for floor in m

-- Looking for floor in m - found

-- Looking for gethostbyname_r

-- Looking for gethostbyname_r - found

-- Looking for bind

-- Looking for bind - found

-- Looking for crypt

-- Looking for crypt - not found

-- Looking for crypt in crypt

-- Looking for crypt in crypt - found

-- Looking for setsockopt

-- Looking for setsockopt - found

-- Looking for dlopen

-- Looking for dlopen - found

-- Looking for dlsym

-- Looking for dlsym - found

-- Looking for sched_yield

-- Looking for sched_yield - found

-- Looking for clock_gettime

-- Looking for clock_gettime - found

-- Looking for timer_create

-- Looking for timer_create - found

-- Looking for atomic_thread_fence

-- Looking for atomic_thread_fence - not found

-- Looking for atomic_thread_fence in atomic

-- Looking for atomic_thread_fence in atomic - found

-- Looking for backtrace

-- Looking for backtrace - found

-- Looking for include file alloca.h

-- Looking for include file alloca.h - found

-- Looking for include file arpa/inet.h

-- Looking for include file arpa/inet.h - found

-- Looking for include file crypt.h

-- Looking for include file crypt.h - found

-- Looking for include file dlfcn.h

-- Looking for include file dlfcn.h - found

-- Looking for include file execinfo.h

-- Looking for include file execinfo.h - found

-- Looking for include file fpu_control.h

-- Looking for include file fpu_control.h - found

-- Looking for include file grp.h

-- Looking for include file grp.h - found

-- Looking for include file ieeefp.h

-- Looking for include file ieeefp.h - not found

-- Looking for include file langinfo.h

-- Looking for include file langinfo.h - found

-- Looking for include file malloc.h

-- Looking for include file malloc.h - found

-- Looking for include file netinet/in.h

-- Looking for include file netinet/in.h - found

-- Looking for include file poll.h

-- Looking for include file poll.h - found

-- Looking for include file pwd.h

-- Looking for include file pwd.h - found

-- Looking for include file strings.h

-- Looking for include file strings.h - found

-- Looking for include file sys/ioctl.h

-- Looking for include file sys/ioctl.h - found

-- Looking for include file sys/mman.h

-- Looking for include file sys/mman.h - found

-- Looking for include file sys/resource.h

-- Looking for include file sys/resource.h - found

-- Looking for include file sys/select.h

-- Looking for include file sys/select.h - found

-- Looking for include file sys/socket.h

-- Looking for include file sys/socket.h - found

-- Looking for include files curses.h, term.h

-- Looking for include files curses.h, term.h - not found

-- Looking for include file termios.h

-- Looking for include file termios.h - found

-- Looking for include file termio.h

-- Looking for include file termio.h - found

-- Looking for include file unistd.h

-- Looking for include file unistd.h - found

-- Looking for include file sys/wait.h

-- Looking for include file sys/wait.h - found

-- Looking for include file sys/param.h

-- Looking for include file sys/param.h - found

-- Looking for include file fnmatch.h

-- Looking for include file fnmatch.h - found

-- Looking for include file sys/un.h

-- Looking for include file sys/un.h - found

-- Looking for include file sys/devpoll.h

-- Looking for include file sys/devpoll.h - not found

-- Looking for include file sys/epoll.h

-- Looking for include file sys/epoll.h - found

-- Looking for TAILQ_FOREACH

-- Looking for TAILQ_FOREACH - found

-- Looking for _aligned_malloc

-- Looking for _aligned_malloc - not found

-- Looking for backtrace

-- Looking for backtrace - found

-- Looking for printstack

-- Looking for printstack - not found

-- Looking for index

-- Looking for index - found

-- Looking for clock_gettime

-- Looking for clock_gettime - found

-- Looking for cuserid

-- Looking for cuserid - found

-- Looking for directio

-- Looking for directio - not found

-- Looking for ftruncate

-- Looking for ftruncate - found

-- Looking for compress

-- Looking for compress - not found

-- Looking for crypt

-- Looking for crypt - found

-- Looking for dlopen

-- Looking for dlopen - found

-- Looking for fchmod

-- Looking for fchmod - found

-- Looking for fcntl

-- Looking for fcntl - found

-- Looking for fdatasync

-- Looking for fdatasync - found

-- Looking for fdatasync

-- Looking for fdatasync - found

-- Looking for fedisableexcept

-- Looking for fedisableexcept - found

-- Looking for fseeko

-- Looking for fseeko - found

-- Looking for fsync

-- Looking for fsync - found

-- Looking for gethostbyaddr_r

-- Looking for gethostbyaddr_r - found

-- Looking for gethrtime

-- Looking for gethrtime - not found

-- Looking for getnameinfo

-- Looking for getnameinfo - found

-- Looking for getpass

-- Looking for getpass - found

-- Looking for getpassphrase

-- Looking for getpassphrase - not found

-- Looking for getpwnam

-- Looking for getpwnam - found

-- Looking for getpwuid

-- Looking for getpwuid - found

-- Looking for getrlimit

-- Looking for getrlimit - found

-- Looking for getrusage

-- Looking for getrusage - found

-- Looking for initgroups

-- Looking for initgroups - found

-- Looking for issetugid

-- Looking for issetugid - not found

-- Looking for getuid

-- Looking for getuid - found

-- Looking for geteuid

-- Looking for geteuid - found

-- Looking for getgid

-- Looking for getgid - found

-- Looking for getegid

-- Looking for getegid - found

-- Looking for lstat

-- Looking for lstat - found

-- Looking for madvise

-- Looking for madvise - found

-- Looking for malloc_info

-- Looking for malloc_info - found

-- Looking for memrchr

-- Looking for memrchr - found

-- Looking for mlock

-- Looking for mlock - found

-- Looking for mlockall

-- Looking for mlockall - found

-- Looking for mmap64

-- Looking for mmap64 - found

-- Looking for poll

-- Looking for poll - found

-- Looking for posix_fallocate

-- Looking for posix_fallocate - found

-- Looking for posix_memalign

-- Looking for posix_memalign - found

-- Looking for pread

-- Looking for pread - found

-- Looking for pthread_condattr_setclock

-- Looking for pthread_condattr_setclock - found

-- Looking for pthread_sigmask

-- Looking for pthread_sigmask - found

-- Looking for readlink

-- Looking for readlink - found

-- Looking for realpath

-- Looking for realpath - found

-- Looking for setfd

-- Looking for setfd - not found

-- Looking for sigaction

-- Looking for sigaction - found

-- Looking for sleep

-- Looking for sleep - found

-- Looking for stpcpy

-- Looking for stpcpy - found

-- Looking for stpncpy

-- Looking for stpncpy - found

-- Looking for strlcpy

-- Looking for strlcpy - not found

-- Looking for strndup

-- Looking for strndup - found

-- Looking for strnlen

-- Looking for strnlen - found

-- Looking for strlcat

-- Looking for strlcat - not found

-- Looking for strsignal

-- Looking for strsignal - found

-- Looking for fgetln

-- Looking for fgetln - not found

-- Looking for strsep

-- Looking for strsep - found

-- Looking for tell

-- Looking for tell - not found

-- Looking for vasprintf

-- Looking for vasprintf - found

-- Looking for memalign

-- Looking for memalign - found

-- Looking for nl_langinfo

-- Looking for nl_langinfo - found

-- Looking for ntohll

-- Looking for ntohll - not found

-- Looking for clock_gettime

-- Looking for clock_gettime - found

-- Looking for epoll_create

-- Looking for epoll_create - found

-- Looking for inet_ntop

-- Looking for inet_ntop - found

-- Looking for kqueue

-- Looking for kqueue - not found

-- Looking for timeradd

-- Looking for timeradd - found

-- Looking for timerclear

-- Looking for timerclear - found

-- Looking for timercmp

-- Looking for timercmp - found

-- Looking for timerisset

-- Looking for timerisset - found

-- Looking for include file sys/time.h

-- Looking for include file sys/time.h - found

-- Looking for include file sys/times.h

-- Looking for include file sys/times.h - found

-- Looking for times

-- Looking for times - found

-- Looking for gettimeofday

-- Looking for gettimeofday - found

-- Looking for lrand48

-- Looking for lrand48 - found

-- Looking for TIOCGWINSZ

-- Looking for TIOCGWINSZ - found

-- Looking for FIONREAD

-- Looking for FIONREAD - found

-- Looking for FIONREAD

-- Looking for FIONREAD - not found

-- Looking for SIGEV_THREAD_ID

-- Looking for SIGEV_THREAD_ID - found

-- Looking for SIGEV_PORT

-- Looking for SIGEV_PORT - not found

-- Looking for log2

-- Looking for log2 - found

-- Looking for isinf

-- Looking for isinf - found

-- Performing Test HAVE_CXX_ISINF

-- Performing Test HAVE_CXX_ISINF - Success

-- Looking for timer_create

-- Looking for timer_create - found

-- Looking for timer_settime

-- Looking for timer_settime - found

-- Looking for kqueue

-- Looking for kqueue - not found

-- Looking for EVFILT_TIMER

-- Looking for EVFILT_TIMER - not found

-- Check size of char *

-- Check size of char * - done

-- Check size of long

-- Check size of long - done

-- Check size of short

-- Check size of short - done

-- Check size of int

-- Check size of int - done

-- Check size of long long

-- Check size of long long - done

-- Check size of off_t

-- Check size of off_t - done

-- Check size of time_t

-- Check size of time_t - done

-- Check size of struct timespec

-- Check size of struct timespec - done

-- Performing Test HAVE_TM_GMTOFF

-- Performing Test HAVE_TM_GMTOFF - Success

-- Check size of uint

-- Check size of uint - done

-- Check size of ulong

-- Check size of ulong - done

-- Check size of u_int32_t

-- Check size of u_int32_t - done

-- Performing Test HAVE_VISIBILITY_HIDDEN

-- Performing Test HAVE_VISIBILITY_HIDDEN - Success

-- Checking stack direction : -1

-- Looking for include files time.h, sys/time.h

-- Looking for include files time.h, sys/time.h - found

-- Looking for O_NONBLOCK

-- Looking for O_NONBLOCK - found

-- Performing Test HAVE_PAUSE_INSTRUCTION

-- Performing Test HAVE_PAUSE_INSTRUCTION - Success

-- Performing Test HAVE_BUILTIN_UNREACHABLE

-- Performing Test HAVE_BUILTIN_UNREACHABLE - Success

-- Performing Test HAVE_BUILTIN_EXPECT

-- Performing Test HAVE_BUILTIN_EXPECT - Success

-- Performing Test HAVE_BUILTIN_STPCPY

-- Performing Test HAVE_BUILTIN_STPCPY - Success

-- Performing Test HAVE_GCC_ATOMIC_BUILTINS

-- Performing Test HAVE_GCC_ATOMIC_BUILTINS - Success

-- Performing Test HAVE_GCC_SYNC_BUILTINS

-- Performing Test HAVE_GCC_SYNC_BUILTINS - Success

-- Looking for netinet/in6.h

-- Looking for netinet/in6.h - not found

-- Check size of struct sockaddr_in6

-- Check size of struct sockaddr_in6 - done

-- Check size of struct in6_addr

-- Check size of struct in6_addr - done

-- Performing Test HAVE_SOCKADDR_STORAGE_SS_FAMILY

-- Performing Test HAVE_SOCKADDR_STORAGE_SS_FAMILY - Success

-- Performing Test HAVE_SOCKADDR_IN_SIN_LEN

-- Performing Test HAVE_SOCKADDR_IN_SIN_LEN - Failed

-- Performing Test HAVE_SOCKADDR_IN6_SIN6_LEN

-- Performing Test HAVE_SOCKADDR_IN6_SIN6_LEN - Failed

-- Performing Test HAVE_PTHREAD_THREADID_NP

-- Performing Test HAVE_PTHREAD_THREADID_NP - Failed

-- Performing Test HAVE_IMPLICIT_DEPENDENT_NAME_TYPING

-- Performing Test HAVE_IMPLICIT_DEPENDENT_NAME_TYPING - Failed

-- Looking for chown

-- Looking for chown - found

-- Looking for include file numa.h

-- Looking for include file numa.h - found

-- Looking for include file numaif.h

-- Looking for include file numaif.h - found

-- Performing Test HAVE_LIBNUMA

-- Performing Test HAVE_LIBNUMA - Success

-- Check size of socklen_t

-- Check size of socklen_t - failed

-- Found ZLIB: /usr/lib/x86_64-linux-gnu/libz.so (found version "1.2.11") 

-- ZLIB_VERSION (system) is 1.2.11

-- ZLIB_INCLUDE_DIR /usr/include

-- ZLIB_LIBRARY /usr/lib/x86_64-linux-gnu/libz.so

CMake Warning at cmake/zlib.cmake:128 (MESSAGE):

  ZLIB version must be at least 1.2.12, found 1.2.11.



  Using -DWITH_ZLIB=bundled

Call Stack (most recent call first):

  CMakeLists.txt:601 (MYSQL_CHECK_ZLIB)





-- Check size of off64_t

-- Check size of off64_t - done

-- Looking for unistd.h

-- Looking for unistd.h - found

-- OPENSSL_INCLUDE_DIR = /usr/include

-- OPENSSL_LIBRARY = /usr/lib/x86_64-linux-gnu/libssl.so

-- CRYPTO_LIBRARY = /usr/lib/x86_64-linux-gnu/libcrypto.so

-- OPENSSL_MAJOR_VERSION = 

-- OPENSSL_MINOR_VERSION = 

-- OPENSSL_FIX_VERSION = 

-- Looking for SHA512_DIGEST_LENGTH

-- Looking for SHA512_DIGEST_LENGTH - found

-- 

Cannot find appropriate system libraries for WITH_SSL=system.

Make sure you have specified a supported SSL version. 

Valid options are : 

system (use the OS openssl library), 

yes (synonym for system), 

</path/to/custom/openssl/installation>



CMake Error at cmake/ssl.cmake:63 (MESSAGE):

  Please install the appropriate openssl developer package.



Call Stack (most recent call first):

  cmake/ssl.cmake:306 (FATAL_SSL_NOT_FOUND_ERROR)

  CMakeLists.txt:603 (MYSQL_CHECK_SSL)