I'm having some issues compiling MySQL with SSL support enabled.
Using:
7.2-RELEASE FreeBSD (GENERIC kernel)
mysql-server-5.1.39
mysql-client-5.1.39
openssl-0.9.8k_5
I've added the following /etc/make.conf
However, when I use portupgrade to upgrade MySQL server & client, or build the ports using WITH_OPENSSL=yes they both report that they haven't been built with OpenSSL:
Reading the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.1/en/secure-using-ssl.html
It says the following:
Any suggestions as to what I'm doing wrong.
Using:
7.2-RELEASE FreeBSD (GENERIC kernel)
mysql-server-5.1.39
mysql-client-5.1.39
openssl-0.9.8k_5
I've added the following /etc/make.conf
Code:
# Always compile MySQL with SSL, Optimized & Statically compiled
.if ${.CURDIR:M*/database/mysql*}
WITH_OPENSSL=yes
BUILD_OPTIMIZED=yes
BUILD_STATIC=yes
.endif
However, when I use portupgrade to upgrade MySQL server & client, or build the ports using WITH_OPENSSL=yes they both report that they haven't been built with OpenSSL:
Code:
mysql> show variables like '%ssl%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl | NO |
| have_ssl | NO |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
+---------------+-------+
7 rows in set (0.00 sec)
Code:
# mysql --ssl-ca=cacert.pem
mysql: unknown variable 'ssl-ca=cacert.pem'
Reading the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.1/en/secure-using-ssl.html
It says the following:
However, I can't see any options for that when I look at the make options for openssl.Building MySQL using OpenSSL requires a shared OpenSSL library, otherwise linker errors occur.
Any suggestions as to what I'm doing wrong.