martinarrieta
commented
4 years ago Same issue. Here is the full example.
$ mysql -u sysbench -P 3306 -h 192.168.1.2 -p --ssl --ssl-cipher="DHE-RSA-AES256-SHA"
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1347997
Server version: 5.5.57-38.9-log Percona Server (GPL), Release 38.9, Revision fc6d4f87a88
Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, 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.57-38.9, for debian-linux-gnu (x86_64) using readline 5.1
Connection id: 1347997
Current database:
Current user: svc_sysbench@192.168.1.3
SSL: Cipher in use is DHE-RSA-AES256-SHA
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.57-38.9-log Percona Server (GPL), Release 38.9, Revision fc6d4f87a88
Protocol version: 10
Connection: 192.168.1.2 via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 4 days 13 min 47 sec
--------------
mysql> Bye
$ sysbench --mysql-port=3306 --mysql-host=192.168.1.2 --mysql-user=sysbench \
--mysql-db=sysbench --mysql-ssl=on --mysql-ssl-cipher="DHE-RSA-AES256-SHA" \
--mysql-password="SECRET" --threads=5 oltp_write_only prepare
sysbench 1.0.19 (using bundled LuaJIT 2.1.0-beta2)
Initializing worker threads...
FATAL: unable to connect to MySQL server on host '192.168.1.2', port 3306, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_default_verify_paths failed
FATAL: unable to connect to MySQL server on host '192.168.1.2', port 3306, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_default_verify_paths failed
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:83: connection creation failed
FATAL: unable to connect to MySQL server on host '192.168.1.2', port 3306, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_default_verify_paths failed
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:83: connection creation failed
FATAL: unable to connect to MySQL server on host '192.168.1.2', port 3306, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_default_verify_paths failed
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:83: connection creation failed
(last message repeated 1 times)
FATAL: unable to connect to MySQL server on host '192.168.1.2', port 3306, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_default_verify_paths failed
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:83: connection creation failed
frankf-cgn
We're trying to get sysbench running on one of DigitalOcean's recently released Managed MySQL containers.
Running the command:
Results in the following error:
However if we try to connect to this via command line or using DataGrip, it connects just fine. The part that is frustrating is the
FATAL: error 2026: SSL connection error: unknown error number, which clearly sysbench is having an issue connecting, but then passes anunknown error number. Makes things difficult to debug!Has anyone run into this problem before?