Bug #86005 using -v changes behavior

• Submitted: 19 Apr 2017 13:11
• Modified: 8 Jun 2017 9:25
• Reporter: j s
• Status: Can't repeat
• Category: MySQL Server: Command-line Clients
• Severity: S1 (Critical)
• Version: 5.7
• OS: Red Hat (version 6)
• CPU Architecture: Any

[19 Apr 2017 13:11] j s

Description:
When trying to connect to mysqlrouter using SSL an error is returned. If you modify the command to include -vv then it succeeds

How to repeat:
1) setup database that requires SSL connection
2) on different host, setup mysqlrouter with basic config
3) try to connect to mysqlrouter with SSL parameters and see that it fails with ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
3a) I used mysql --no-defaults -h 127.0.0.1 -u chronam_q1 -p --ssl-ca=/opt/chronam/certs/ca.pem --ssl-cert=/opt/chronam/certs/client-cert.pem --ssl-key=/opt/chronam/certs/client-key.pem chronam_p1
4) try to connect and add -vv to the command and see that it connects fine. you must use -vv, -v will cause it to still fail.
4a) I used mysql --no-defaults -vv -h 127.0.0.1 -u chronam_q1 -p --ssl-ca=/opt/chronam/certs/ca.pem --ssl-cert=/opt/chronam/certs/client-cert.pem --ssl-key=/opt/chronam/certs/client-key.pem chronam_p1

[19 Apr 2017 13:22] j s

here are the exact versions I am using

bash$ rpm -qa \*mysql\*
mysql-commercial-devel-5.7.17-1.1.el6.x86_64
mysql-commercial-common-5.7.17-1.1.el6.x86_64
mysql57-community-release-el6-10.noarch
mysql-router-2.1.3-1.el6.x86_64
mysql-commercial-client-5.7.17-1.1.el6.x86_64
mysql-commercial-libs-5.7.17-1.1.el6.x86_64

[19 Apr 2017 13:29] Chris Adams

One other note: in our environment, this only happens when connecting to the router. Connecting directly to the database server works.

[8 Jun 2017 9:25] MySQL Verification Team

Hello!

Thank you for the report and feedback.
I tried to reproduce the issue using MySQL version 5.7.18 and MySQL Router version 2.1.2-rc but still not seeing the reported issue. Joining the steps shortly for your reference.

Please could you try with latest MySQL Router version and 5.7.18. If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh

[8 Jun 2017 9:26] MySQL Verification Team

test results

Attachment: 86005.results (application/octet-stream, text), 8.36 KiB.