MySQL Forums
Forum List  »  Connector/ODBC

Turning Of Encryption Between ODBC to Localhost Database
Posted by: Carlin Connell
Date: October 10, 2021 10:50PM

Hi,

I am hoping that I have found the right place.

I have been tasked with optimizing our server.

I am trying to turn off encryption and decryption for SQL requests made to localhost.
But would like to be able to encrypt requests sent to replication databases.

I have noticed that there is a large portion of exclusive samples come from the TaoCrypt library doing encryption, decryption, and transform.

TaoCrypt::AES::decrypt 5,998 5,998 1.42% 1.42%
TaoCrypt::SHA::Transform 4,954 4,954 1.17% 1.17%
TaoCrypt::AES::encrypt 4,296 4,296 1.01% 1.01%

Looking into this a bit more, I have found the following stack trace:

TaoCrypt::AES::encrypt
TaoCrypt::Mode_BASE::CBC_Encrypt
yaSSL::`anonymous namespace`::buildMessage
yaSSL::sendData
vio_ssl_write
net_write_raw_loop
net_write_packet
net_flush
net_write_command
cli_advanceed_command
mysql_send_query
mysql_real_query
do_query
my_SQLExecute

This is basically the same for TaoCrypt::AES::decrypt.

In this test, the database is not issuing replication commands.
I would like to be able to employ encryption & decryption to non-local host databases.

I am using MySQL ODBC 5.3 Unicode driver.

What I have tried to do:
In the MySQL Connector/ODBC GUI window

Under the connections tab
[x] Disable default SSL

Under the SSL tab
[X] Disable TLS Version 1
[X] Disable TLS Version 1.1
[X] Disable TLS Version 1.2

I have been unable to find any documentation on this subject otherwise.

I am hoping that you would be able to provide me with how or guide me to the correct documentation so that I can turn off commands being encrypted and decrypted for requests being sent from ODBC to the database on the same server.

Sincere Regards,
Carl

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.