使用Java部署的,但是配置application.yaml文件后启动没有正确连上数据库

Takagi

是本地启动吗？查看你的启动命令中是否包含 --spring.profiles.active=dev。此处的 dev 是你的 Active Profiles 。如果没有此命令则说明启动时运行的是 application.yaml 而不是 application-dev.yaml

龙飞

Takagi
这是我的启动命令：
/www/server/java/jdk-17.0.8/bin/java -jar -Xmx1024M -Xms256M /longfei/app/halo.jar --server.port=8090 --spring.config.additional-location=optional:file:longfei/.halo2/

龙飞

Takagi 但是这个数据库配置不就在application.yaml里配置嘛，所以启动应该也是启动application.yaml，而不应该去启动那个application-dev.yaml吧

Ryan Wang 👍

龙飞 --spring.config.additional-location=optional:file:longfei/.halo2/

file: 后面跟的是绝对地址，光 longfei/.halo2/ 可能不行

龙飞

Ryan Wang 👍 --spring.config.additional-location=optional:file:/longfei/.halo2/application.yaml
那就这样填嘛

龙飞

Ryan Wang 👍 /www/server/java/jdk-17.0.8/bin/java -jar -Xmx1024M -Xms256M /longfei/app/halo.jar --server.port=8090 --spring.config.additional-location=optional:file:/longfei/.halo2/application.yaml

不行不行，这样也起不来

21:23:15.551 [main] ERROR org.springframework.boot.SpringApplication -- Application run failed
org.yaml.snakeyaml.scanner.ScannerException: while scanning an anchor
in 'reader', line 21, column 13:
work-dir: &longfei/.halo2
^
unexpected character found /(47)
in 'reader', line 21, column 21:
work-dir: &longfei/.halo2
^

at org.yaml.snakeyaml.scanner.ScannerImpl.scanAnchor(ScannerImpl.java:1510)
at org.yaml.snakeyaml.scanner.ScannerImpl.fetchAnchor(ScannerImpl.java:968)
at org.yaml.snakeyaml.scanner.ScannerImpl.fetchMoreTokens(ScannerImpl.java:401)
at org.yaml.snakeyaml.scanner.ScannerImpl.checkToken(ScannerImpl.java:238)
at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingValue.produce(ParserImpl.java:669)
at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:161)
at org.yaml.snakeyaml.comments.CommentEventsCollector$1.peek(CommentEventsCollector.java:57)
at org.yaml.snakeyaml.comments.CommentEventsCollector$1.peek(CommentEventsCollector.java:43)
at org.yaml.snakeyaml.comments.CommentEventsCollector.collectEvents(CommentEventsCollector.java:136)
at org.yaml.snakeyaml.comments.CommentEventsCollector.collectEvents(CommentEventsCollector.java:116)
at org.yaml.snakeyaml.composer.Composer.composeScalarNode(Composer.java:241)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:205)
at org.yaml.snakeyaml.composer.Composer.composeKeyNode(Composer.java:359)
at org.yaml.snakeyaml.composer.Composer.composeMappingChildren(Composer.java:344)
at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:323)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:209)
at org.yaml.snakeyaml.composer.Composer.composeValueNode(Composer.java:369)
at org.yaml.snakeyaml.composer.Composer.composeMappingChildren(Composer.java:348)
at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:323)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:209)
at org.yaml.snakeyaml.composer.Composer.getNode(Composer.java:131)
at org.yaml.snakeyaml.constructor.BaseConstructor.getData(BaseConstructor.java:162)
at org.springframework.boot.env.OriginTrackedYamlLoader$OriginTrackingConstructor.getData(OriginTrackedYamlLoader.java:99)
at org.yaml.snakeyaml.Yaml$1.next(Yaml.java:515)
at org.springframework.beans.factory.config.YamlProcessor.process(YamlProcessor.java:203)
at org.springframework.beans.factory.config.YamlProcessor.process(YamlProcessor.java:169)
at org.springframework.boot.env.OriginTrackedYamlLoader.load(OriginTrackedYamlLoader.java:84)
at org.springframework.boot.env.YamlPropertySourceLoader.load(YamlPropertySourceLoader.java:50)
at org.springframework.boot.context.config.StandardConfigDataLoader.load(StandardConfigDataLoader.java:54)
at org.springframework.boot.context.config.StandardConfigDataLoader.load(StandardConfigDataLoader.java:36)
at org.springframework.boot.context.config.ConfigDataLoaders.load(ConfigDataLoaders.java:96)
at org.springframework.boot.context.config.ConfigDataImporter.load(ConfigDataImporter.java:132)
at org.springframework.boot.context.config.ConfigDataImporter.resolveAndLoad(ConfigDataImporter.java:87)
at org.springframework.boot.context.config.ConfigDataEnvironmentContributors.withProcessedImports(ConfigDataEnvironmentContributors.java:121)
at org.springframework.boot.context.config.ConfigDataEnvironment.processInitial(ConfigDataEnvironment.java:245)
at org.springframework.boot.context.config.ConfigDataEnvironment.processAndApply(ConfigDataEnvironment.java:232)
at org.springframework.boot.context.config.ConfigDataEnvironmentPostProcessor.postProcessEnvironment(ConfigDataEnvironmentPostProcessor.java:96)
at org.springframework.boot.context.config.ConfigDataEnvironmentPostProcessor.postProcessEnvironment(ConfigDataEnvironmentPostProcessor.java:89)
at org.springframework.boot.env.EnvironmentPostProcessorApplicationListener.onApplicationEnvironmentPreparedEvent(EnvironmentPostProcessorApplicationListener.java:109)
at org.springframework.boot.env.EnvironmentPostProcessorApplicationListener.onApplicationEvent(EnvironmentPostProcessorApplicationListener.java:94)
at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:185)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:178)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:156)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:138)
at org.springframework.boot.context.event.EventPublishingRunListener.multicastInitialEvent(EventPublishingRunListener.java:136)
at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:81)
at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:64)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:118)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:112)
at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:63)
at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:370)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:330)
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:149)
at run.halo.app.Application.main(Application.java:28)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91)
at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53)
at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58)

龙飞

Ryan Wang 👍

/www/server/java/jdk-17.0.8/bin/java -jar -Xmx1024M -Xms256M /longfei/app/halo.jar --server.port=8090 --spring.config.additional-location=optional:file:longfei/.halo2/application.yaml

我用这个命令改了一下，但还是报错一样的
2024-06-27T21:25:05.844+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.873+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.879+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.886+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.893+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.899+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.904+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.914+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.921+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.926+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.932+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.938+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.943+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-06-27T21:25:05.949+08:00 WARN 306905 --- [ main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only

Ryan Wang 👍

最简单的方式是，你 cd 到你服务器的 longfei/.halo2 目录，然后执行 pwd，这个地址就是你需要填的地址。

龙飞

Ryan Wang 👍
那我这也对的啊，这个就是绝对地址
[root@yeup ~]# cd /
[root@yeup /]# cd longfei/.halo2/
[root@yeup .halo2]# pwd
/longfei/.halo2
[root@yeup .halo2]#

Ryan Wang 👍

龙飞 [root@yeup .halo2]# pwd
/longfei/.halo2

你命令中的是 longfei/.halo2，这里打印的是 /loingfei/.halo2，你为什么会认为是一样的？

- /www/server/java/jdk-17.0.8/bin/java -jar -Xmx1024M -Xms256M /longfei/app/halo.jar --server.port=8090 --spring.config.additional-location=optional:file:longfei/.halo2/
+ /www/server/java/jdk-17.0.8/bin/java -jar -Xmx1024M -Xms256M /longfei/app/halo.jar --server.port=8090 --spring.config.additional-location=optional:file:/longfei/.halo2/

龙飞

Ryan Wang 👍
牛，项目成功启动了，但是初始化后台登录的时候又报了一个500的错误

2024-06-28T09:14:49.657+08:00  WARN 851895 --- [eReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.SinglePageReconciler-worker-1/Request[name=373a5f79-f44f-441a-9df1-85a4f553ece8]
2024-06-28T09:14:50.018+08:00 ERROR 851895 --- [tor-tcp-epoll-1] a.w.r.e.AbstractErrorWebExceptionHandler : [ba0e97c5-41]  500 Server Error for HTTP GET "/apis/api.console.halo.run/v1alpha1/plugin-presets"

org.pf4j.PluginRuntimeException: java.nio.file.NoSuchFileException: /presets/plugins/plugin-feed.jar
	at run.halo.app.plugin.YamlPluginFinder.getManifestPath(YamlPluginFinder.java:124) ~[!/:2.16.3]
	Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: 
Error has been observed at the following site(s):
	*__checkpoint ⇢ Handler run.halo.app.core.extension.endpoint.PluginEndpoint$$Lambda$1565/0x00007fdc688aa000@299eabed [DispatcherHandler]
	*__checkpoint ⇢ run.halo.app.security.InitializeRedirectionWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ AuthorizationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ ExceptionTranslationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ LogoutWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ ServerRequestCacheWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ SecurityContextServerWebExchangeWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ LogoutPageGeneratingWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ AnonymousAuthenticationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ SecurityWebFilterChainProxy [DefaultWebFilterChain]
	*__checkpoint ⇢ TotpAuthenticationFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ AuthenticationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ SecurityWebFilterChainProxy [DefaultWebFilterChain]
	*__checkpoint ⇢ RememberMeAuthenticationFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ SecurityWebFilterChainProxy [DefaultWebFilterChain]
	*__checkpoint ⇢ AuthenticationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ AuthenticationWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ ReactorContextWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ CsrfWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ CorsWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ HttpHeaderWriterWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ ServerWebExchangeReactorContextWebFilter [DefaultWebFilterChain]
	*__checkpoint ⇢ org.springframework.security.web.server.WebFilterChainProxy [DefaultWebFilterChain]
	*__checkpoint ⇢ run.halo.app.webfilter.AdditionalWebFilterChainProxy [DefaultWebFilterChain]
	*__checkpoint ⇢ HTTP GET "/apis/api.console.halo.run/v1alpha1/plugin-presets" [ExceptionHandlingWebHandler]
Original Stack Trace:
		at run.halo.app.plugin.YamlPluginFinder.getManifestPath(YamlPluginFinder.java:124) ~[!/:2.16.3]
		at run.halo.app.plugin.YamlPluginFinder.readPluginDescriptor(YamlPluginFinder.java:79) ~[!/:2.16.3]
		at run.halo.app.plugin.YamlPluginFinder.find(YamlPluginFinder.java:64) ~[!/:2.16.3]
		at run.halo.app.core.extension.service.impl.PluginServiceImpl.lambda$getPresets$0(PluginServiceImpl.java:122) ~[!/:2.16.3]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:113) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxArray$ArraySubscription.slowPath(FluxArray.java:126) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxArray$ArraySubscription.request(FluxArray.java:99) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMap$MapSubscriber.request(FluxMap.java:164) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2367) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2241) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMap$MapSubscriber.onSubscribe(FluxMap.java:92) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onSubscribe(FluxMapFuseable.java:96) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onSubscribe(FluxMapFuseable.java:96) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxArray.subscribe(FluxArray.java:53) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxArray.subscribe(FluxArray.java:59) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.InternalFluxOperator.subscribe(InternalFluxOperator.java:68) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxDefer.subscribe(FluxDefer.java:54) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.Flux.subscribe(Flux.java:8840) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxConcatArray$ConcatArraySubscriber.onComplete(FluxConcatArray.java:238) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxConcatArray.subscribe(FluxConcatArray.java:79) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.InternalFluxOperator.subscribe(InternalFluxOperator.java:68) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxDeferContextual.subscribe(FluxDeferContextual.java:57) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at org.springframework.http.server.reactive.ChannelSendOperator.subscribe(ChannelSendOperator.java:77) ~[spring-web-6.1.8.jar!/:6.1.8]
		at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:76) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:165) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:79) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2571) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2367) ~[reactor-core-3.6.6.jar!/:3.6.6]
		at

Ryan Wang 👍

龙飞忽略即可，这个只是安装预设插件的异常，因为目前通过 jar 安装还无法正常初始化预设插件。你可以先手动安装一个 https://www.halo.run/store/apps/app-VYJbF，然后在里面安装需要的插件。

龙飞

Ryan Wang 👍 好的，感谢您的解答