Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SSL options ignored when using read_default_file option #144

Open
travispaul opened this issue Oct 21, 2018 · 0 comments
Open

SSL options ignored when using read_default_file option #144

travispaul opened this issue Oct 21, 2018 · 0 comments

Comments

@travispaul
Copy link

travispaul commented Oct 21, 2018

I have a cnf file that works with the MySQL client:

[root@host ~]# cat /root/.my.cnf
[client]
user = someuser
password = somepass
host = some.remote.host
ssl-ca = /etc/pki/mysql/rds-combined-ca-bundle.pem
[root@host ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 7576589
Server version: 5.6.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> show status like 'Ssl_cipher';
+---------------+--------------------+
| Variable_name | Value              |
+---------------+--------------------+
| Ssl_cipher    | DHE-RSA-AES256-SHA |
+---------------+--------------------+
1 row in set (0.00 sec)

MySQL [(none)]>

However, when using this file with MySQLdb, the SSL options appear to be ignored:

>>> import MySQLdb
>>> db=MySQLdb.connect(read_default_file="/root/.my.cnf")
>>> db.query("show status like 'Ssl_cipher'")
>>> r=db.store_result()
>>> r.fetch_row()
(('Ssl_cipher', ''),)

Using version 1.2.5 on CentOS

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant