前言
Chat2DB是款数据库连接工具，主要就是使用JDBC做数据库连接，外加多对接了几个聊天ai网站，把数据库和AI做了个集成，比使用传统工具Navicat，再另外去AI查方便一点。
官网可以直接下客户端使用，也可以部署到服务器上用浏览器访问，但是我找了半天没发现Web版的部署方法，所有就写一篇Web版的安装、部署、启动的流程，不一定适合每个人，因为每个人的环境、软硬件不一样，仅供参考。
安装部署过程
下载安装包
官网地址 https://chat2db.ai/zh
点击web下载，微信扫描完弹出的二维码，就会触发浏览器下载
下载的包叫chat2db-server-start.zip
上传到linux服务器上，解压，我的是centos7
cd /home
mkdir chat2db
# sftp窗口上传文件
unzip chat2db-server-start.zip
cd chat2db
下载JDK17
我系统是x86_64的，下对应的jdk117，不然启动报错，说jdk版本不行
下载位置想下哪下哪，我图省事下到当前目录
wget https://download.java.***/java/GA/jdk17.0.1/2a2082e5a09d4267845be086888add4f/12/GPL/openjdk-17.0.1_linux-x64_bin.tar.gz
tar -xvf openjdk-17.0.1_linux-x64_bin.tar.gz
不想改原有的java环境变量就别改，直接用/home/chat2db/jdk-17.0.1/bin/java -version测
启动
启动，指定lib文件夹
-Dchatgpt.apiKey是chatgpt的key，但是实际使用发现填了也没用，还是去连得ChatDB的网关地址，可能可以通过保外配置改变查询行为，-Dchatgpt.apiKey这项可以删掉，都搞包外配置了，key直接写配置文件里就行吧
nohup /home/chat2db/jdk-17.0.1/bin/java -jar -Dloader.path=lib -Dchatgpt.apiKey=此处需要替换为chatgpt秘钥 chat2db-server-start.jar &
启动成功
最终目录结构如下
登录
日志开头打印启动端口为：10821
在浏览器输入ip:10821，进入页面
可能出现的报错
启动报错Java版本低
Error: A JNI error has o***urred, please check your installation and try again
Exception in thread "main" java.lang.UnsupportedClassVersionError: org/springframework/boot/loader/PropertiesLauncher has been ***piled by a more recent version of the Java Runtime (class file version 61.0), this version of the Java Runtime only recognizes class file versions up to 52.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:756)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.***.URLClassLoader.defineClass(URLClassLoader.java:473)
at java.***.URLClassLoader.a***ess$100(URLClassLoader.java:74)
at java.***.URLClassLoader$1.run(URLClassLoader.java:369)
at java.***.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.A***essController.doPrivileged(Native Method)
at java.***.URLClassLoader.findClass(URLClassLoader.java:362)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:601)
解决方法是安装jdk17，不一定要改环境变量，启动时指定17的路径就行
flyway的bean创建失败
2023-10-31 13:36:39.468 INFO 18584 --- [ main] o.s.b.a.h2.H2ConsoleAutoConfiguration .88 : | H2 console available at '/h2'. Database available at 'jdbc:h2:~/.chat2db/db/chat2db_dev'
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation
Migration checksum mismatch for migration version 1.0.0
-> Applied to database : 1103295346
-> Resolved locally : -1991637693
Either revert the changes to the migration, or run repair to update the schema history.
Detected applied migration not resolved locally: 1.0.0.1.
If you removed this migration intentionally, run repair to mark the migration as deleted.
Detected applied migration not resolved locally: 1.0.1.
If you removed this migration intentionally, run repair to mark the migration as deleted.
Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1770)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:520)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:313)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:973)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:941)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:608)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:733)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:435)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:311)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1305)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1294)
at ai.chat2db.server.start.Application.main(Application.java:72)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke(NativeMethodA***essorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodA***essorImpl.invoke(DelegatingMethodA***essorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:95)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:466)
Caused by: org.flywaydb.core.api.exception.FlywayValidateException: Validate failed: Migrations have failed validation
Migration checksum mismatch for migration version 1.0.0
-> Applied to database : 1103295346
-> Resolved locally : -1991637693
Either revert the changes to the migration, or run repair to update the schema history.
Detected applied migration not resolved locally: 1.0.0.1.
If you removed this migration intentionally, run repair to mark the migration as deleted.
Detected applied migration not resolved locally: 1.0.1.
If you removed this migration intentionally, run repair to mark the migration as deleted.
Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE
at org.flywaydb.core.Flyway.lambda$migrate$0(Flyway.java:146)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:190)
at org.flywaydb.core.Flyway.migrate(Flyway.java:140)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1816)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766)
... 26 ***mon frames omitted
有可能的原因之一是以前初始化了一半的脚本影响了后续初始化，可以删掉已有的内容重新开始。
日志里h2的文件位置在~/.chat2db/db/chat2db_dev，可以去删掉这个路径的文件，重启就好了
cd ~/.chat2db/db/
ll
rm -rf chat2db_dev.mv.db
登录失败
2023-10-31 14:00:06.170 ERROR 4759 --- [io-10821-exec-5] a.c.s.s.e.EasyControllerExceptionHandler.164 : 220e62ae44b043ec826***3449ab48747 | 发生未知异常/api/oauth/login_a:ActionResult(su***ess=false, errorCode=***mon.systemError, errorMessage=An exception o***urs, you can view the exception details in the log in the help menu., errorDetail=***.hutool.crypto.CryptoException: SecurityException: JCE cannot authenticate the provider BC
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.init(DefaultHMacEngine.java:105)
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.<init>(DefaultHMacEngine.java:56)
at ***.hutool.crypto.digest.mac.MacEngineFactory.createEngine(MacEngineFactory.java:42)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:86)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:74)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:63)
at ***.hutool.jwt.signers.HMacJWTSigner.<init>(HMacJWTSigner.java:28)
at ***.hutool.jwt.signers.JWTSignerUtil.createSigner(JWTSignerUtil.java:239)
at ***.hutool.jwt.signers.JWTSignerUtil.hs256(JWTSignerUtil.java:36)
at ***.hutool.jwt.JWT.setKey(JWT.java:126)
at ***.dev33.satoken.jwt.SaJwtTemplate.generateToken(SaJwtTemplate.java:119)
at ***.dev33.satoken.jwt.SaJwtTemplate.createToken(SaJwtTemplate.java:109)
at ***.dev33.satoken.jwt.SaJwtUtil.createToken(SaJwtUtil.java:100)
at ***.dev33.satoken.jwt.StpLogicJwtForStateless.createTokenValue(StpLogicJwtForStateless.java:60)
at ***.dev33.satoken.jwt.StpLogicJwtForStateless.createLoginSession(StpLogicJwtForStateless.java:99)
at ***.dev33.satoken.stp.StpLogic.login(StpLogic.java:331)
at ***.dev33.satoken.stp.StpLogic.login(StpLogic.java:293)
at ***.dev33.satoken.stp.StpUtil.login(StpUtil.java:135)
at ai.chat2db.server.start.controller.oauth.OauthController.doLogin(OauthController.java:73)
at ai.chat2db.server.start.controller.oauth.OauthController.login(OauthController.java:63)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke(NativeMethodA***essorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodA***essorImpl.invoke(DelegatingMethodA***essorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:547)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at ai.chat2db.server.start.config.interceptor.CorsFilter.doFilter(CorsFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.zalando.logbook.servlet.LogbookFilter.doFilter(LogbookFilter.java:76)
at org.zalando.logbook.servlet.HttpFilter.doFilter(HttpFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at ai.chat2db.server.start.log.LogOncePerRequestFilter.doFilterInternal(LogOncePerRequestFilter.java:32)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
at org.apache.tomcat.util.***.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.***.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.lang.SecurityException: JCE cannot authenticate the provider BC
at java.base/javax.crypto.JceSecurity.getInstance(JceSecurity.java:144)
at java.base/javax.crypto.Mac.getInstance(Mac.java:272)
at ***.hutool.crypto.SecureUtil.createMac(SecureUtil.java:1086)
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.init(DefaultHMacEngine.java:95)
... 80 more
Caused by: java.lang.IllegalStateException: zip file closed
at java.base/java.util.zip.ZipFile.ensureOpen(ZipFile.java:840)
at java.base/java.util.zip.ZipFile.getManifestName(ZipFile.java:1066)
at java.base/java.util.zip.ZipFile$1.getManifestName(ZipFile.java:1125)
at java.base/javax.crypto.JarVerifier.verifySingleJar(JarVerifier.java:464)
at java.base/javax.crypto.JarVerifier.verifyJars(JarVerifier.java:320)
at java.base/javax.crypto.JarVerifier.verify(JarVerifier.java:263)
at java.base/javax.crypto.ProviderVerifier.verify(ProviderVerifier.java:130)
at java.base/javax.crypto.JceSecurity.verifyProvider(JceSecurity.java:190)
at java.base/javax.crypto.JceSecurity.getVerificationResult(JceSecurity.java:218)
at java.base/javax.crypto.JceSecurity.getInstance(JceSecurity.java:140)
... 83 more
, solutionLink=https://github.***/chat2db/Chat2DB/wiki/Chat2DB, traceId=null),请求参数:{}
***.hutool.crypto.CryptoException: SecurityException: JCE cannot authenticate the provider BC
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.init(DefaultHMacEngine.java:105)
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.<init>(DefaultHMacEngine.java:56)
at ***.hutool.crypto.digest.mac.MacEngineFactory.createEngine(MacEngineFactory.java:42)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:86)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:74)
at ***.hutool.crypto.digest.HMac.<init>(HMac.java:63)
at ***.hutool.jwt.signers.HMacJWTSigner.<init>(HMacJWTSigner.java:28)
at ***.hutool.jwt.signers.JWTSignerUtil.createSigner(JWTSignerUtil.java:239)
at ***.hutool.jwt.signers.JWTSignerUtil.hs256(JWTSignerUtil.java:36)
at ***.hutool.jwt.JWT.setKey(JWT.java:126)
at ***.dev33.satoken.jwt.SaJwtTemplate.generateToken(SaJwtTemplate.java:119)
at ***.dev33.satoken.jwt.SaJwtTemplate.createToken(SaJwtTemplate.java:109)
at ***.dev33.satoken.jwt.SaJwtUtil.createToken(SaJwtUtil.java:100)
at ***.dev33.satoken.jwt.StpLogicJwtForStateless.createTokenValue(StpLogicJwtForStateless.java:60)
at ***.dev33.satoken.jwt.StpLogicJwtForStateless.createLoginSession(StpLogicJwtForStateless.java:99)
at ***.dev33.satoken.stp.StpLogic.login(StpLogic.java:331)
at ***.dev33.satoken.stp.StpLogic.login(StpLogic.java:293)
at ***.dev33.satoken.stp.StpUtil.login(StpUtil.java:135)
at ai.chat2db.server.start.controller.oauth.OauthController.doLogin(OauthController.java:73)
at ai.chat2db.server.start.controller.oauth.OauthController.login(OauthController.java:63)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodA***essorImpl.invoke(NativeMethodA***essorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodA***essorImpl.invoke(DelegatingMethodA***essorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:547)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at ai.chat2db.server.start.config.interceptor.CorsFilter.doFilter(CorsFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.zalando.logbook.servlet.LogbookFilter.doFilter(LogbookFilter.java:76)
at org.zalando.logbook.servlet.HttpFilter.doFilter(HttpFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at ai.chat2db.server.start.log.LogOncePerRequestFilter.doFilterInternal(LogOncePerRequestFilter.java:32)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
at org.apache.tomcat.util.***.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.***.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.lang.SecurityException: JCE cannot authenticate the provider BC
at java.base/javax.crypto.JceSecurity.getInstance(JceSecurity.java:144)
at java.base/javax.crypto.Mac.getInstance(Mac.java:272)
at ***.hutool.crypto.SecureUtil.createMac(SecureUtil.java:1086)
at ***.hutool.crypto.digest.mac.DefaultHMacEngine.init(DefaultHMacEngine.java:95)
... 80 ***mon frames omitted
Caused by: java.lang.IllegalStateException: zip file closed
at java.base/java.util.zip.ZipFile.ensureOpen(ZipFile.java:840)
at java.base/java.util.zip.ZipFile.getManifestName(ZipFile.java:1066)
at java.base/java.util.zip.ZipFile$1.getManifestName(ZipFile.java:1125)
at java.base/javax.crypto.JarVerifier.verifySingleJar(JarVerifier.java:464)
at java.base/javax.crypto.JarVerifier.verifyJars(JarVerifier.java:320)
at java.base/javax.crypto.JarVerifier.verify(JarVerifier.java:263)
at java.base/javax.crypto.ProviderVerifier.verify(ProviderVerifier.java:130)
at java.base/javax.crypto.JceSecurity.verifyProvider(JceSecurity.java:190)
at java.base/javax.crypto.JceSecurity.getVerificationResult(JceSecurity.java:218)
at java.base/javax.crypto.JceSecurity.getInstance(JceSecurity.java:140)
... 83 ***mon frames omitted
使用openjdk，别用oracle的
无法执行二进制文件
-bash: /home/chat2db/jdk-17.0.1/bin/java: 无法执行二进制文件
可能是jdk版本不对，要对应系统
