i get this error when i execute logstash -f sql.conf
[2022-06-15T10:04:50,181][WARN ][logstash.inputs.jdbc ][main][e19f080911532a0b3a2b7a97c8a03964c2d0dd49cbfd57c4dec8d41439afebcf] Exception when executing JDBC query {:exception=>Sequel::DatabaseConnectionError, :message=>"Java::ComMicrosoftSqlserverJdbc::SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:08c85704-17c9-4355-83fd-abdef1e01cf9", :cause=>"com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:08c85704-17c9-4355-83fd-abdef1e01cf9"}
TLSv1 and TLSv1.1 are disabled by Java by default. The settings are in java.security.
Look for the disabled algorithm TLSv1 in java.security and remove it. If using a container, mount your custom java.security file to that file location inside the container to replace it.
Sorry, I don't know how to read that error message. It is a screenshot, so I cannot copy-and-paste the error text into Google search or Google translate. Screenshots are good, but a copy of the error text is ideal to accompany the screenshot.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.