[MDEV-10895] main.ssl_ca fails on Power in buildbot Created: 2016-09-26  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: SSL, Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Georg Richter
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar/builds/183/steps/test/logs/stdio

main.ssl_ca                              w3 [ fail ]
        Test ended at 2016-09-25 06:01:03
 
CURRENT_TEST: main.ssl_ca
ERROR 2026 (HY000): SSL connection error: No such file or directory
mysqltest: At line 27: exec of '/home/buildbot/maria-slave/p8-rhel6-bintar/build/client/mysql --defaults-file=/home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/var/3/my.cnf --ssl-ca=~/maria-slave/p8-rhel6-bintar/build/mysql-test/std_data/cacert.pem --ssl-key=/home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/std_data/client-key.pem --ssl-cert=/home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/std_data/client-cert.pem test -e "SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';"' failed, error: 256, status: 1, errno: 0
Output from before failure:
# path substitution : should connect
 
 
 
The result from queries just before the failure was:
#
# Bug#21920657: SSL-CA FAILS SILENTLY IF THE PATH CANNOT BE FOUND
#
# try to connect with wrong '--ssl-ca' path : should fail
ERROR 2026 (HY000): SSL connection error: xxxx
# try to connect with correct '--ssl-ca' path : should connect
have_ssl
1
#
# Bug#21920678: SSL-CA DOES NOT ACCEPT ~USER TILDE HOME DIRECTORY
#               PATH SUBSTITUTION
#
# try to connect with '--ssl-ca' option using tilde home directoy
# path substitution : should connect



 Comments   
Comment by Georg Richter [ 2016-09-26 ]

The test fails, since Connector/C doesn't support bash features like tilde or environment variable in filenames.
This should be supported by an application, but not but the database driver itself.

Please note, that the server also doesn't support special filenames in my.cnf
both

ssl_ca=~/etc/mysql/ca-cert.pem

and

ssl_ca=$HOME/etc/mysql/ca-cert.pem

end up with error:

2016-09-26 19:09:42 140703322871616 [Warning] SSL error: SSL_CTX_set_default_verify_paths failed
2016-09-26 19:09:42 140703322871616 [Warning] SSL error: error:02001002:system library:fopen:No such file or directory
2016-09-26 19:09:42 140703322871616 [Warning] SSL error: error:2006D080:BIO routines:BIO_new_file:no such file

Generated at Thu Feb 08 07:45:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.