Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.2
-
None
-
vagrant and baremetal
Description
when I try to connect to mariadb 10.2 running with ssl on the maxscale serverip and port I get error " error:140940F5:SSL routines:ssl3_read_bytes:unexpected record"
when I connect to mysql server directly from maxscale machine the connection works
10.10.10.10 - maxscale 2.2 server
10.10.10.13/14/15 - mariadb Db servers
root@node1:~# mysql -h10.10.10.13 -umaxscale -pmaxscale -e "select @@server_id"
|
+-------------+
|
| @@server_id |
|
+-------------+
|
| 10101013 |
|
+-------------+
|
root@node1:~# mysql -h10.10.10.10 -umaxscale -pmaxscale -e "select @@server_id"
|
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
|
I have proper grants and self-sign certs
MariaDB [(none)]> show grants for maxscale@'10.%';
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for maxscale@10.% |
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'maxscale'@'10.%' IDENTIFIED BY PASSWORD '*53E5D0C7885BD540911663B04133F20C94AD4306' REQUIRE SSL
|
----
|
The log shows
|
---
|
2018-03-04 18:51:37 error : (39) SSL operation failed, dcb 0x21213a0 in state DCB_STATE_POLLING fd 20 return code -1. More details may follow.
|
2018-03-04 18:51:37 error : (39) error:140940F5:SSL routines:ssl3_read_bytes:unexpected record
|
2018-03-04 18:51:37 error : [mariadbbackend] Unable to write to backend 'node4' due to authentication failure. Server in state RUNNING MASTER.
|
2018-03-04 18:51:37 error : (39) SSL operation failed, dcb 0x2123420 in state DCB_STATE_POLLING fd 22 return code -1. More details may follow.
|
2018-03-04 18:51:37 error : (39) error:140940F5:SSL routines:ssl3_read_bytes:unexpected record
|
The exact setup with ssl work fine with 2.1. I am using self-sign certs .