Percona Server moved to https://jira.percona.com/projects/PS

SSL is not supported on 5.1.66-rel14.1 rpm's

Bug #1075932 reported by Martin Arrieta
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Critical
Ignacio Nin

Bug Description

SSL is not supported by Percona Server 5.1.66-rel14.1 RPM's

From the documentation, "NO" means that the server was compiled without ssl support.

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_have_ssl

" have_ssl

YES if mysqld supports SSL connections, NO if not. DISABLED indicates that the server was compiled with SSL support, but but was not started with the appropriate --ssl-xxx options. For more information, see Section 6.3.6.2, “Configuring MySQL for SSL”.

This variable was added in MySQL 5.1.17. Before that, use have_openssl."

# rpm -qa | grep percona -i
Percona-Server-shared-51-5.1.66-rel14.1.495.rhel6.x86_64
Percona-Server-client-51-5.1.66-rel14.1.495.rhel6.x86_64
Percona-Server-server-51-5.1.66-rel14.1.495.rhel6.x86_64
percona-release-0.0-1.x86_64

mysql> show variables like '%ssl%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl | NO |
| have_ssl | NO |

- The binary version is not affected by this bug (Percona-Server-5.1.66-rel14.1-495.Linux.x86_64.tar.gz)

mysql [localhost] {msandbox} ((none)) > show variables like "%ssl%";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |

- The community version is compiled with ssl enabled:

# rpm -qa | grep -i mysql
MySQL-shared-5.1.66-1.glibc23.i386
MySQL-server-5.1.66-1.glibc23.x86_64
MySQL-client-5.1.66-1.glibc23.x86_64

mysql> show variables like '%ssl%';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |

For the record, PS 5.5 is not affected by this bug:

mysql> show variables like '%ssl%';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |

# rpm -qa | grep -i percona
Percona-Server-server-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-shared-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-client-55-5.5.28-rel29.1.335.rhel6.x86_64

Regards,

Martin Arrieta.
@martinarrietac

Related branches

lp:~percona-core/percona-server/release-5.1.66-14.1
Laurynas Biveinis (community): Approve
Diff: 5112 lines (+2955/-403)
95 files modified
Makefile (+2/-2)
Percona-Server/CMakeLists.txt (+3/-0)
Percona-Server/Docs/INSTALL-BINARY (+3/-3)
Percona-Server/client/mysql.cc (+14/-6)
Percona-Server/client/mysql_upgrade.c (+2/-2)
Percona-Server/client/mysqladmin.cc (+3/-3)
Percona-Server/client/mysqlbinlog.cc (+13/-1)
Percona-Server/client/mysqlcheck.c (+2/-2)
Percona-Server/client/mysqldump.c (+1/-1)
Percona-Server/client/mysqlimport.c (+2/-2)
Percona-Server/client/mysqlshow.c (+2/-2)
Percona-Server/client/mysqlslap.c (+3/-3)
Percona-Server/client/mysqltest.cc (+1/-1)
Percona-Server/client/sql_string.h (+7/-3)
Percona-Server/configure.in (+1/-1)
Percona-Server/extra/perror.c (+3/-2)
Percona-Server/extra/yassl/src/ssl.cpp (+1/-1)
Percona-Server/extra/yassl/taocrypt/src/Makefile.am (+1/-1)
Percona-Server/extra/yassl/taocrypt/src/crypto.cpp (+0/-37)
Percona-Server/include/welcome_copyright_notice.h (+13/-8)
Percona-Server/mysql-test/Makefile.am (+1/-0)
Percona-Server/mysql-test/lib/mtr_cases.pm (+33/-0)
Percona-Server/mysql-test/r/information_schema.result (+18/-4)
Percona-Server/mysql-test/r/information_schema_db.result (+4/-1)
Percona-Server/mysql-test/r/mysqlshow.result (+8/-2)
Percona-Server/mysql-test/r/openssl_1.result (+3/-3)
Percona-Server/mysql-test/r/subselect.result (+0/-2)
Percona-Server/mysql-test/suite/federated/federated.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_archive.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_bug_13118.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_bug_25714.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_bug_35333.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_debug.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_innodb.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_server.test (+2/-2)
Percona-Server/mysql-test/suite/federated/federated_transactions.test (+2/-2)
Percona-Server/mysql-test/suite/federated/include/federated.inc (+1/-1)
Percona-Server/mysql-test/suite/funcs_1/t/is_engines_federated.test (+1/-1)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb-index.result (+1/-1)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb-zip.result (+3/-3)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb.result (+1/-1)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb_bug53591.result (+1/-1)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb_information_schema_buffer.result (+127/-0)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb_misc1.result (+1/-1)
Percona-Server/mysql-test/suite/innodb_plugin/r/percona_skip_innodb_i_s.result (+3/-0)
Percona-Server/mysql-test/suite/innodb_plugin/t/innodb_information_schema_buffer.test (+76/-0)
Percona-Server/mysql-test/t/openssl_1.test (+6/-0)
Percona-Server/mysql-test/t/partition_federated.test (+1/-1)
Percona-Server/scripts/mysql_secure_installation.pl.in (+7/-3)
Percona-Server/scripts/mysql_secure_installation.sh (+13/-5)
Percona-Server/sql/filesort.cc (+2/-3)
Percona-Server/sql/gen_lex_hash.cc (+3/-3)
Percona-Server/sql/ha_partition.cc (+90/-43)
Percona-Server/sql/ha_partition.h (+2/-10)
Percona-Server/sql/handler.cc (+27/-2)
Percona-Server/sql/item.cc (+6/-1)
Percona-Server/sql/item_strfunc.cc (+35/-18)
Percona-Server/sql/item_subselect.cc (+1/-1)
Percona-Server/sql/log_event.h (+1/-1)
Percona-Server/sql/mysqld.cc (+1/-1)
Percona-Server/sql/share/charsets/Index.xml (+1/-1)
Percona-Server/sql/spatial.cc (+6/-5)
Percona-Server/sql/spatial.h (+8/-0)
Percona-Server/sql/sql_prepare.cc (+8/-0)
Percona-Server/sql/sql_select.cc (+9/-6)
Percona-Server/sql/sql_show.cc (+3/-2)
Percona-Server/sql/sql_string.h (+7/-3)
Percona-Server/storage/federated/ha_federated.cc (+1/-1)
Percona-Server/storage/innobase/btr/btr0pcur.c (+32/-37)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+0/-1)
Percona-Server/storage/innodb_plugin/ChangeLog (+29/-0)
Percona-Server/storage/innodb_plugin/btr/btr0btr.c (+41/-6)
Percona-Server/storage/innodb_plugin/btr/btr0cur.c (+23/-18)
Percona-Server/storage/innodb_plugin/btr/btr0pcur.c (+31/-36)
Percona-Server/storage/innodb_plugin/buf/buf0buf.c (+129/-0)
Percona-Server/storage/innodb_plugin/handler/ha_innodb.cc (+20/-6)
Percona-Server/storage/innodb_plugin/handler/i_s.cc (+1757/-0)
Percona-Server/storage/innodb_plugin/handler/i_s.h (+3/-0)
Percona-Server/storage/innodb_plugin/ibuf/ibuf0ibuf.c (+13/-5)
Percona-Server/storage/innodb_plugin/include/buf0buf.h (+102/-1)
Percona-Server/storage/innodb_plugin/include/buf0buf.ic (+20/-0)
Percona-Server/storage/innodb_plugin/include/fil0fil.h (+2/-0)
Percona-Server/storage/innodb_plugin/include/log0log.h (+3/-0)
Percona-Server/storage/innodb_plugin/include/univ.i (+18/-0)
Percona-Server/storage/innodb_plugin/page/page0cur.c (+1/-0)
Percona-Server/storage/innodb_plugin/page/page0page.c (+19/-12)
Percona-Server/storage/innodb_plugin/row/row0ins.c (+8/-1)
Percona-Server/storage/innodb_plugin/row/row0merge.c (+14/-0)
Percona-Server/storage/innodb_plugin/scripts/install_innodb_plugins.sql (+3/-0)
Percona-Server/storage/innodb_plugin/scripts/install_innodb_plugins_win.sql (+3/-0)
Percona-Server/support-files/mysql.spec.sh (+6/-1)
Percona-Server/vio/viosslfactories.c (+59/-41)
build/debian/rules (+1/-1)
build/percona-server.spec (+2/-6)
build/percona-shared-compat.spec (+1/-1)
Martin Arrieta (martinarrieta)
tags: added: i27367
Ignacio Nin (ignacio-nin)
Changed in percona-server:
assignee: nobody → Ignacio Nin (ignacio-nin)
importance: Undecided → Critical
Ignacio Nin (ignacio-nin)
Changed in percona-server:
status: New → In Progress
Ignacio Nin (ignacio-nin)
Changed in percona-server:
status: In Progress → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-349

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.