Bug: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

[baoziyucha]

Chat2DB Version

1.0.7

Describe the bug

测试链接SQL server错误，SQL server版本比较老。

{"getApplicationMessage":{"env":"desktop","versions":"1.0.7","buildTime":1714100472366,"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) chat2db-pro/1.0.7 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"errorCode":"No appropriate protocol (protocol is disabled or cipher suites are inappropriate)","errorDetail":"javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)\r\n\tat java.base/sun.security.ssl.HandshakeContext.(Unknown Source)\r\n\tat java.base/sun.security.ssl.ClientHandshakeContext.(Unknown Source)\r\n\tat java.base/sun.security.ssl.TransportContext.kickstart(Unknown Source)\r\n\tat java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)\r\n\tat java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)\r\n\tat com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1795)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3329)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2950)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2790)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1663)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1064)\r\n\tat ai.chat2db.spi.sql.IDriverManager.getConnection(IDriverManager.java:90)\r\n\tat ai.chat2db.spi.sql.IDriverManager.getConnection(IDriverManager.java:75)\r\n\tat ai.chat2db.spi.util.JdbcUtils.testConnect(JdbcUtils.java:159)\r\n\tat ai.chat2db.server.domain.core.impl.DataSourceServiceImpl.preConnect(DataSourceServiceImpl.java:49)\r\n\tat ai.chat2db.server.web.api.controller.data.source.DataSourceController.preConnect(DataSourceController.java:85)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)\r\n\tat org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n\tat ai.chat2db.server.web.api.aspect.ConnectionInfoHandler.connectionInfoHandler(ConnectionInfoHandler.java:52)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)\r\n\tat org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)\r\n\tat org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)\r\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)\r\n\tat org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n\tat ai.chat2db.server.web.api.aspect.ControllerHandler.handle(ControllerHandler.java:71)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)\r\n\tat org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)\r\n\tat org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)\r\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)\r\n\tat org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)\r\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)\r\n\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)\r\n\tat ai.chat2db.server.web.api.controller.data.source.DataSourceController$$SpringCGLIB$$0.preConnect()\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat ai.chat2db.server.start.controller.console.ConsoleHelper.doController(ConsoleHelper.java:252)\r\n\tat ai.chat2db.server.start.controller.console.ConsoleHelper.lambda$onMessage$1(ConsoleHelper.java:123)\r\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)\r\n\tat java.base/java.util.concurrent.FutureTask.run(Unknown Source)\r\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\r\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\r\n\tat java.base/java.lang.Thread.run(Unknown Source)\r\n","solutionLink":"https://github.com/chat2db/Chat2DB/wiki/Chat2DB","requestParams":"{\"actionType\":\"execute\",\"headers\":{\"Accept-Language\":\"zh-CN\",\"Time-Zone\":\"Asia/Shanghai\"},\"uuid\":\"46776ff0-39c6-4819-86bc-0cc4541ba3a8\",\"requestUrl\":\"/api/connection/datasource/pre_connect\",\"method\":\"post\",\"message\":{\"ssh\":{\"use\":false,\"hostName\":\"\",\"port\":\"22\",\"userName\":\"\",\"localPort\":\"\",\"authenticationType\":\"password\",\"password\":\"\"},\"driverConfig\":{\"jdbcDriverClass\":\"com.microsoft.sqlserver.jdbc.SQLServerDriver\",\"jdbcDriver\":\"mssql-jdbc-11.2.1.jre17.jar\"},\"alias\":\"@192.168.2.113\",\"environmentId\":2,\"host\":\"192.168.2.113\",\"port\":\"1433\",\"instance\":\"\",\"authenticationType\":\"1\",\"user\":\"sa\",\"password\":\"\",\"database\":\"\",\"url\":\"jdbc:sqlserver://192.168.2.113:1433;database=\",\"extendInfo\":[{\"key\":\"encrypt\",\"value\":\"true\"},{\"key\":\"trustServerCertificate\",\"value\":\"true\"},{\"key\":\"integratedSecurity\",\"value\":\"false\"},{\"key\":\"Trusted_Connection\",\"value\":\"yes\"},{\"key\":\"sslProtocol\",\"value\":\"TLSv1\"},{\"key\":\"createDatabaseIfNotExist\",\"value\":\"true\"},{\"key\":\"useSSL\",\"value\":\"false\"}],\"connectionEnvType\":\"DAILY\",\"type\":\"SQLSERVER\",\"id\":14673}}"}