[a@localhost ~]$ cd ~/sandboxes/msb_5_1_51/ [a@localhost msb_5_1_51]$ cat my.cnf |egrep "(\[|ssl)" cat: my.cnf: No such file or directory [a@localhost msb_5_1_51]$ cat my.sandbox.cnf |egrep "(\[|ssl)" [mysql] prompt='mysql [\h] {\u} (\d) > ' [client] [mysqld] ssl-key=/tmp/server-key.pem ssl-cert=/tmp/server-cert.pem # ssl-ca=/tmp/client-cert.pem ssl-ca=/tmp/ca-cert.pem [client] # ssl-ca=/tmp/server-cert.pem ssl-ca=/tmp/ca-cert.pem ssl-key=/tmp/client-key.pem ssl-cert=/tmp/client-cert.pem [a@localhost msb_5_1_51]$ ./start sandbox server already started (found pid file /home/a/sandboxes/msb_5_1_51/data/mysql_sandbox5151.pid) sandbox server started [a@localhost msb_5_1_51]$ ./restart /home/a/mysql-5.1.51/5.1.51/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql_sandbox5151.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql_sandbox5151.sock' exists! Attempting normal termination --- kill -15 12851 /home/a/sandboxes/msb_5_1_51/send_kill: line 31: kill: (12851) - No such process SERVER UNRESPONSIVE --- kill -9 12851 /home/a/sandboxes/msb_5_1_51/send_kill: line 46: kill: (12851) - No such process .. sandbox server started [a@localhost msb_5_1_51]$ [a@localhost msb_5_1_51]$ [a@localhost msb_5_1_51]$ ./use ERROR 2026 (HY000): SSL connection error [a@localhost msb_5_1_51]$ ./my sql --ssl-ca="" --ssl-cert=/tmp/client client-cert.pem client.csr client-key.pem client.crt client.key client-req.pem [a@localhost msb_5_1_51]$ ./my sql --ssl-ca="" --ssl-cert=/tmp/client-cert.pem --ssl-key="" SSL error: Unable to get private key from '' ERROR 2026 (HY000): SSL connection error [a@localhost msb_5_1_51]$ ./my sql --ssl-ca="" --ssl-cert="" --ssl-key=/tmp/client-key.pem SSL error: Unable to get certificate from '' ERROR 2026 (HY000): SSL connection error [a@localhost msb_5_1_51]$ ./my sql --ssl-ca= --ssl-cert= --ssl-key=/tmp/client-key.pem SSL error: Unable to get certificate from '' ERROR 2026 (HY000): SSL connection error [a@localhost msb_5_1_51]$ ./my sql --ssl-ca --ssl-cert --ssl-key=/tmp/client-key.pem ERROR 2026 (HY000): SSL connection error [a@localhost msb_5_1_51]$ ./my sql --ssl-ca --ssl-cert=/tmp/client-cert.pem --ssl-key /home/a/mysql-5.1.51/5.1.51/bin/mysql: option '--ssl-key' requires an argument [a@localhost msb_5_1_51]$ ./my sql --skip-ssl Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.1.51 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql [localhost] {msandbox} ((none)) > status; -------------- /home/a/mysql-5.1.51/5.1.51/bin/mysql Ver 14.14 Distrib 5.1.51, for unknown-linux-gnu (x86_64) using EditLine wrapper Connection id: 6 Current database: Current user: msandbox@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.1.51 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /tmp/mysql_sandbox5151.sock Uptime: 1 min 49 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.45 -------------- mysql [localhost] {msandbox} ((none)) > show variables like "%ssl%"; +---------------+----------------------+ | Variable_name | Value | +---------------+----------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /tmp/ca-cert.pem | | ssl_capath | | | ssl_cert | /tmp/server-cert.pem | | ssl_cipher | | | ssl_key | /tmp/server-key.pem | +---------------+----------------------+ 7 rows in set (0.00 sec) mysql [localhost] {msandbox} ((none)) > exit Bye [a@localhost msb_5_1_51]$ vim my.sandbox.cnf [a@localhost msb_5_1_51]$ cat my.sandbox.cnf |egrep "(\[|ssl)" [mysql] prompt='mysql [\h] {\u} (\d) > ' [client] [mysqld] ssl-key=/tmp/server-key.pem ssl-cert=/tmp/server-cert.pem ssl-ca=/tmp/client-cert.pem # ssl-ca=/tmp/ca-cert.pem [client] ssl-ca=/tmp/server-cert.pem # ssl-ca=/tmp/ca-cert.pem ssl-key=/tmp/client-key.pem ssl-cert=/tmp/client-cert.pem [a@localhost msb_5_1_51]$ ./restart /home/a/mysql-5.1.51/5.1.51/bin/mysqladmin: connect to server at 'localhost' failed error: 'SSL connection error' Attempting normal termination --- kill -15 21830 . sandbox server started [a@localhost msb_5_1_51]$ ./use Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.51 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql [localhost] {msandbox} ((none)) > \s -------------- /home/a/mysql-5.1.51/5.1.51/bin/mysql Ver 14.14 Distrib 5.1.51, for unknown-linux-gnu (x86_64) using EditLine wrapper Connection id: 1 Current database: Current user: msandbox@localhost SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.1.51 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /tmp/mysql_sandbox5151.sock Uptime: 6 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.833 -------------- mysql [localhost] {msandbox} ((none)) > show variables like "%ssl%"; +---------------+----------------------+ | Variable_name | Value | +---------------+----------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /tmp/client-cert.pem | | ssl_capath | | | ssl_cert | /tmp/server-cert.pem | | ssl_cipher | | | ssl_key | /tmp/server-key.pem | +---------------+----------------------+ 7 rows in set (0.00 sec) mysql [localhost] {msandbox} ((none)) > exit Bye [a@localhost msb_5_1_51]$ cat my.sandbox.cnf |grep bin [a@localhost msb_5_1_51]$ cat my.sandbox.cnf # The MySQL Sandbox # Copyright (C) 2006-2010 Giuseppe Maxia # Contacts: http://datacharmer.org # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA [mysql] prompt='mysql [\h] {\u} (\d) > ' # [client] user = msandbox password = msandbox port = 5151 socket = /tmp/mysql_sandbox5151.sock [mysqld] user = a port = 5151 socket = /tmp/mysql_sandbox5151.sock basedir = /home/a/mysql-5.1.51/5.1.51 datadir = /home/a/sandboxes/msb_5_1_51/data tmpdir = /home/a/sandboxes/msb_5_1_51/tmp pid-file = /home/a/sandboxes/msb_5_1_51/data/mysql_sandbox5151.pid #log-slow-queries = /home/a/sandboxes/msb_5_1_51/data/msandbox-slow.log #log = /home/a/sandboxes/msb_5_1_51/data/msandbox.log # # additional options passed through 'my_clause' # log-error=msandbox.err ssl-key=/tmp/server-key.pem ssl-cert=/tmp/server-cert.pem ssl-ca=/tmp/client-cert.pem # ssl-ca=/tmp/ca-cert.pem [client] ssl-ca=/tmp/server-cert.pem # ssl-ca=/tmp/ca-cert.pem ssl-key=/tmp/client-key.pem ssl-cert=/tmp/client-cert.pem [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/5.1.51/ bin/ include/ libexec/ scripts/ sql-bench/ data/ lib/ mysql-test/ share/ support-files/ [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/ CMakeLists.txt mysqlaccess mysqldumpslow mysql_secure_installation .deps/ mysqlbug mysql_find_rows mysql_secure_installation.pl.in make_binary_distribution mysql_config mysql_fix_extensions mysql_setpermission make_sharedlib_distribution mysql_convert_table_format mysql_fix_privilege_tables mysql_zap make_win_bin_dist mysqld_multi mysqlhotcopy msql2mysql mysqld_safe mysql_install_db [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/mysqlbug |grep config [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/mysqlbug Finding system information for a MySQL bug report test -x Could not find a text editor. (tried emacs) You can change editor by setting the environment variable VISUAL. If your shell is a bourne shell (sh) do VISUAL=your_editors_name; export VISUAL If your shell is a C shell (csh) do setenv VISUAL your_editors_name [a@localhost msb_5_1_51]$ VISUAL=cat [a@localhost msb_5_1_51]$ export $VISUAL [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/mysqlbug |grep config [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/mysqlbug Finding system information for a MySQL bug report test -x Could not find a text editor. (tried emacs) You can change editor by setting the environment variable VISUAL. If your shell is a bourne shell (sh) do VISUAL=your_editors_name; export VISUAL If your shell is a C shell (csh) do setenv VISUAL your_editors_name [a@localhost msb_5_1_51]$ setenv VISUAL vim bash: setenv: command not found [a@localhost msb_5_1_51]$ VISUAL=vim [a@localhost msb_5_1_51]$ export VISUAL [a@localhost msb_5_1_51]$ echo $VISUAL vim [a@localhost msb_5_1_51]$ /home/a/mysql-5.1.51/scripts/mysqlbug Finding system information for a MySQL bug report test -x /usr/bin/vim Using editor /usr/bin/vim You can change editor by setting the environment variable VISUAL. If your shell is a bourne shell (sh) do VISUAL=your_editors_name; export VISUAL If your shell is a C shell (csh) do setenv VISUAL your_editors_name File not changed, no bug report submitted. The raw bug report exists in /tmp/failed-mysql-bugreport If you use this remember that the first lines of the report are now a lie.. [a@localhost msb_5_1_51]$ cat bug.output |grep config Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-libgcj-multifile --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --enable-plugin --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre --with-cpu=generic --host=x86_64-redhat-linux Configure command: ./configure '--with-ssl=/usr/local/openssl' [a@localhost msb_5_1_51]$ vim bug.output [a@localhost msb_5_1_51]$ ldd -v ~/mysql-5.1.51/5.1.51/bin/mysqld |grep ssl ldd: /home/a/mysql-5.1.51/5.1.51/bin/mysqld: No such file or directory [a@localhost msb_5_1_51]$ ldd -v ~/mysql-5.1.51/5.1.51/ |grep ssl bin/ data/ include/ lib/ mysql-test/ scripts/ sql-bench/ COPYING EXCEPTIONS-CLIENT INSTALL-BINARY libexec/ README share/ support-files/ [a@localhost msb_5_1_51]$ ldd -v ~/mysql-5.1.51/5.1.51/bin/ |grep ssl innochecksum mysqlaccess mysql_convert_table_format mysqlhotcopy mysql_upgrade msql2mysql mysqlaccess.conf mysqld_multi mysqlimport mysql_waitpid myisamchk mysqladmin mysqld_safe mysql_secure_installation mysql_zap myisam_ftdump mysqlbinlog mysqldump mysql_setpermission perror myisamlog mysqlbug mysqldumpslow mysqlshow replace myisampack mysqlcheck mysql_find_rows mysqlslap resolveip my_print_defaults mysql_client_test mysql_fix_extensions mysqltest resolve_stack_dump mysql mysql_config mysql_fix_privilege_tables mysql_tzinfo_to_sql [a@localhost msb_5_1_51]$ ps aux |grep 5151 a 27959 0.0 0.3 74960 7356 pts/2 Sl 10:50 0:00 /home/a/mysql-5.1.51/5.1.51/libexec/mysqld --defaults-file=/home/a/sandboxes/msb_5_1_51/my.sandbox.cnf --basedir=/home/a/mysql-5.1.51/5.1.51 --datadir=/home/a/sandboxes/msb_5_1_51/data --log-error=/home/a/sandboxes/msb_5_1_51/data/msandbox.err --pid-file=/home/a/sandboxes/msb_5_1_51/data/mysql_sandbox5151.pid --socket=/tmp/mysql_sandbox5151.sock --port=5151 a 28166 0.0 0.0 61180 732 pts/2 R+ 10:53 0:00 grep 5151 [a@localhost msb_5_1_51]$ ldd -v ~/mysql-5.1.51/5.1.51/libexec/mysqld |grep ssl libssl.so.6 => /lib64/libssl.so.6 (0x0000003b35a00000) /lib64/libssl.so.6: [a@localhost msb_5_1_51]$ ls -la /lib64/libssl.so.6 lrwxrwxrwx 1 root root 16 Aug 12 17:42 /lib64/libssl.so.6 -> libssl.so.0.9.8e [a@localhost msb_5_1_51]$