Summary: | dev-db/mysql-5.1.67 - mysqld refuses SSL certificate login | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | bgentoo <benoit+gentoobugg> |
Component: | [OLD] Development | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | CC: | benoit+gentoobugg |
Priority: | Normal | ||
Version: | unspecified | ||
Hardware: | AMD64 | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- | |
Attachments: | ca-cert.pem |
Description
bgentoo
2013-02-28 21:12:38 UTC
Please post your `emerge --info' output in a comment. ➜ ~ emerge --info Portage 2.1.11.50 (default/linux/amd64/13.0, gcc-4.6.3, glibc-2.15-r3, 3.2.13-grsec-xxxx-grs-ipv6-64 x86_64) ================================================================= System uname: Linux-3.2.13-grsec-xxxx-grs-ipv6-64-x86_64-Intel-R-_Atom-TM-_CPU_N2800_@_1.86GHz-with-gentoo-2.1 KiB Mem: 2028344 total, 1133792 free KiB Swap: 525852 total, 524568 free Timestamp of tree: Sun, 10 Feb 2013 00:15:01 +0000 ld GNU ld (GNU Binutils) 2.22 app-shells/bash: 4.2_p37 dev-lang/python: 2.7.3-r2, 3.2.3 dev-util/cmake: 2.8.9 dev-util/pkgconfig: 0.28 sys-apps/baselayout: 2.1-r1 sys-apps/openrc: 0.11.8 sys-apps/sandbox: 2.5 sys-devel/autoconf: 2.69 sys-devel/automake: 1.11.6 sys-devel/binutils: 2.22-r1 sys-devel/gcc: 4.6.3 sys-devel/gcc-config: 1.7.3 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82-r4 sys-kernel/linux-headers: 3.6 (virtual/os-headers) sys-libs/glibc: 2.15-r3 Repositories: gentoo ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="* -@EULA" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt /var/bind" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.4/ext-active/ /etc/php/cgi-php5.4/ext-active/ /etc/php/cli-php5.4/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -pipe" DISTDIR="/usr/portage/distfiles" FCFLAGS="-O2 -pipe" FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch" FFLAGS="-O2 -pipe" GENTOO_MIRRORS="http://distfiles.gentoo.org" LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j5" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="" SYNC="rsync://mirror.ovh.net/gentoo-portage/" USE="acl amd64 berkdb bzip2 cli cracklib crypt cxx dlz dri fortran gdbm iconv ipv6 mmx modules mudflap multilib ncurses nls openmp pam pcre readline session sse sse2 ssl tcpd unicode zlib" ABI_X86="64" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" PHP_TARGETS="php5-3" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_2" RUBY_TARGETS="ruby18 ruby19" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mga nouveau nv r128 radeon savage sis tdfx trident vesa via vmware dummy v4l" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, USE_PYTHON (In reply to comment #0) > ➜ ~ ll /var/lib/mysql/certs > -rw-r--r-- 1 mysql mysql 1229 Feb 28 21:51 ca-cert.pem > -rw-r--r-- 1 mysql mysql 1679 Feb 28 21:51 ca-key.pem > -rw-r--r-- 1 mysql mysql 1099 Feb 28 21:52 client-cert.pem > -rw-r--r-- 1 mysql mysql 1679 Feb 28 21:51 client-key.pem > -rw-r--r-- 1 mysql mysql 956 Feb 28 21:51 client-req.pem > -rw-r--r-- 1 mysql mysql 1099 Feb 28 21:51 server-cert.pem > -rw-r--r-- 1 mysql mysql 1675 Feb 28 21:51 server-key.pem > -rw-r--r-- 1 mysql mysql 956 Feb 28 21:51 server-req.pem > > And here is where the fun begins: > ➜ ~ mysql -uroot --ssl-ca=/var/lib/mysql/certs/ca-cert.pem -p > Enter password: > ERROR 2026 (HY000): SSL connection error > What permissions are on /var/lib/mysql itself? By default they are: drwxr-x--- 2 mysql mysql 4096 Feb 26 16:35 /var/lib/mysql If the client is not in the mysql group, they would get denied reading the ca-cert.pem due to the folder permission. > FYI: I've tested the same configuration using the same certificates with > version 5.5.29-r1 without success, but it worked out on another OS.... > (meaning that it's probably not a configuration issue) > > Thanks!!! The permissions are correct: drwxr-x--- 7 mysql mysql 4096 Feb 28 20:27 mysql And I use mysql as root... I also though about a permission issue but even when I put all the certificates in /tmp with a really permissive rights (777) I have the same issue. Cannot repeat here. Instructions listed in Comment 0 used to create the server cert. Did not bother with the "client certs" as they are not used for this test. ------ dev-db/mysql-5.5.29 ~ # mysql --ssl-ca=/etc/mysql/certs/ca-cert.pem Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.29 Source distribution Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \s -------------- mysql Ver 14.14 Distrib 5.5.29, for Linux (x86_64) using readline 6.2 Connection id: 1 Current database: Current user: root@localhost SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: /usr/bin/less Using outfile: '' Using delimiter: ; Server version: 5.5.29 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 9 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.444 -------------- mysql> show variables like '%ssl%'; +---------------+----------------------------------+ | Variable_name | Value | +---------------+----------------------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /etc/mysql/certs/ca-cert.pem | | ssl_capath | | | ssl_cert | /etc/mysql/certs/server-cert.pem | | ssl_cipher | | | ssl_key | /etc/mysql/certs/server-key.pem | +---------------+----------------------------------+ 7 rows in set (0.00 sec) ------ dev-db/mysql-5.1.67-r1 ~ # mysql --ssl-ca=/etc/mysql/certs/ca-cert.pem Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.67 Gentoo Linux mysql-5.1.67-r1 Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \s -------------- mysql Ver 14.14 Distrib 5.1.67, for pc-linux-gnu (x86_64) using readline 5.1 Connection id: 1 Current database: Current user: root@localhost SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: /usr/bin/less Using outfile: '' Using delimiter: ; Server version: 5.1.67 Gentoo Linux mysql-5.1.67-r1 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 15 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.266 -------------- mysql> show variables like '%ssl%'; +---------------+----------------------------------+ | Variable_name | Value | +---------------+----------------------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /etc/mysql/certs/ca-cert.pem | | ssl_capath | | | ssl_cert | /etc/mysql/certs/server-cert.pem | | ssl_cipher | | | ssl_key | /etc/mysql/certs/server-key.pem | +---------------+----------------------------------+ 7 rows in set (0.00 sec) Can you please tell what are the use flag that you used since I can reproduce it on all the machines but cannot make it work on any? (In reply to comment #6) > Can you please tell what are the use flag that you used since I can > reproduce it on all the machines but cannot make it work on any? The same flags as you except with latin1 on. That flag only changes the config file and does not affect the build. Out of curiosity, did you build mysql with the broken openssl-1.0.1d and not rebuild after it was masked? No I'm still using openssl-1.0.1c |