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.