mysql odbc ssl default configuration centos

0

I am trying to determine if my ODBC code is using SSL or not. I know I do not configure it in my /etc/odbc.ini or ~/.odbc.ini files. But when I go into isql, it seems to be enabled. So I am a little confused how it can be using SSL when I don't have any certificates setup. Maybe I am looking up this information in the wrong way?

++ /usr/local/easysoft/unixODBC/bin/isql mkt
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>  SHOW SESSION STATUS LIKE 'Ssl_cipher';
+-----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name                                                   | Value                                                                                                                                                                                                                                                                                                       |
+-----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Ssl_cipher                                                      | AES256-SHA                                                                                                                                                                                                                                                                                                  |
+-----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched
SQL> 

I am asking this because Amazon needs to rotate the certificate information for my RDS instance, so I need to find where this stuff is configured on the application server and apply the proper updates there as well.

user3329922

Posted 2019-10-16T20:10:05.807

Reputation: 111

No answers