MySQL Bugs: #39292: MySQL fails to find OpenSSL

Bug #39292	MySQL fails to find OpenSSL
Submitted:	7 Sep 2008 4:44	Modified:	10 Sep 2008 19:09
Reporter:	Jason Saumur	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S3 (Non-critical)
Version:	5.0.67	OS:	MacOS (10.4.11)
Assigned to:		CPU Architecture:	Any

Description:
I'm running configure on a PowerMac G5 running Mac OS X 10.4.11 with the XCode developer tools installed.  I compiled OpenSSL into my /usr/local directory for use with MySQL and Apache. I get this message when I configure MySQL:

checking style of gethost* routines... checking whether madvise is declared... yes
other
checking style of gethostname_r routines... other
checking 3 argument to gethostname_r routines... char
checking "args to pthread_getspecific"... POSIX
checking "args to pthread_mutex_init"... POSIX
checking "args to readdir_r"... POSIX
checking "style of sigwait"... POSIX
checking "for pthread_attr_setscope"... yes
checking "can netinet files be included"... "yes"
checking for OpenSSL... Could not find an installation of OpenSSL

I'm compiling MySQL version 5.0.67

How to repeat:
Here are my configure options:

CFLAGS="-O3" CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-assembler --with-server-suffix --with-zlib-dir=/usr --with-comment --with-mysqlmanager --with-openssl=/usr/local/openssl --with-openssl-includes --with-openssl-libs --with-big-tables --with-max-indexes=\100

My openssl directory is at /usr/local/openssl with libs at $PREFIX/lib, etc.

Thank you for the report.

Please provide your config.log file

Config.log file

Attachment: bug-data-39292.zip (application/zip, text), 31.50 KiB.

Please add the path of openssl includes and libs and let us know if it will work with it

I added the --with-openssl-includes and --with-openssl-libs to the configure statement:

LDFLAGS="-L</usr/local/openssl/lib>" CFLAGS="-O3" CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-assembler --with-server-suffix --with-zlib-dir=/usr --with-comment --with-mysqlmanager --with-openssl=/usr/local/openssl --with-openssl-includes=/usr/local/openssl/include/openssl --with-openssl-libs=/usr/local/openssl/lib --with-big-tables --with-max-indexes=\100 --with-vio

However it gave the same message:
checking style of gethost* routines... checking whether madvise is declared... yes
other
checking style of gethostname_r routines... other
checking 3 argument to gethostname_r routines... char
checking "args to pthread_getspecific"... POSIX
checking "args to pthread_mutex_init"... POSIX
checking "args to readdir_r"... POSIX
checking "style of sigwait"... POSIX
checking "for pthread_attr_setscope"... yes
checking "can netinet files be included"... "yes"
checking for OpenSSL... Could not find an installation of OpenSSL

Attached is the new config.log

The new config.log file for the added options

Attachment: bug-data-39292-2-config.log.zip (application/zip, text), 31.55 KiB.

Thank you for the feedback.

config.log contains:

/usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/ld: warning -L: directory name (</usr/local/openssl/lib>) does not exist

and you set this name explicitly. Please provide output of `ls /usr/local/openssl/lib`

Here is the output for ls /usr/local/openssl/lib :

engines         libcrypto.a     libssl.a        pkgconfig

Thank you for the feedback.

Please change LDFLAGS="-L</usr/local/openssl/lib>"  to LDFLAGS="-L/usr/local/openssl/lib"

I change the LDFLAGS line to the prescribed to have configure be this:
LDFLAGS="-L/usr/local/openssl/lib" CFLAGS="-O3" CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-assembler --with-server-suffix --with-zlib-dir=/usr --with-comment --with-mysqlmanager --with-openssl=/usr/local/openssl --with-openssl-includes=/usr/local/openssl/include/openssl --with-openssl-libs=/usr/local/openssl/lib --with-big-tables --with-max-indexes=\100 --with-vio

However, the output is the same:
checking style of gethost* routines... checking whether madvise is declared... yes
other
checking style of gethostname_r routines... other
checking 3 argument to gethostname_r routines... char
checking "args to pthread_getspecific"... POSIX
checking "args to pthread_mutex_init"... POSIX
checking "args to readdir_r"... POSIX
checking "style of sigwait"... POSIX
checking "for pthread_attr_setscope"... yes
checking "can netinet files be included"... "yes"
checking for OpenSSL... Could not find an installation of OpenSSL

New Config.log data

Attachment: bug-data-39292-2-config.log.zip (application/zip, text), 31.21 KiB.

Thank you for the feedback.

You should either don't specify --with-openssl-includes and --with-openssl-libs or use --with-openssl-includes=/usr/local/openssl/include and path to libs which you specified.

Thank you for helping me find out the problem, it is greatly appreciated!

Sincerely,
Jason