宝塔配置完成访问不了根据客服提供的方式进行配置

赵先生

无法正常访问打不开`io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:590) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:583) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:559) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:492) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:636) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:629) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:118) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.channel.epoll.AbstractEpollChannel$AbstractEpollUnsafe$2.run(AbstractEpollChannel.java:616) ~[netty-transport-classes-epoll-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:156) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.AbstractEventExecutor.runTask(AbstractEventExecutor.java:173) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:166) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:408) ~[netty-transport-classes-epoll-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:998) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.119.Final.jar:4.1.119.Final]
halo-1 | at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
halo-1 | Suppressed: java.lang.Exception: #block terminated with an error
halo-1 | at reactor.core.publisher.BlockingSingleSubscriber.blockingGet(BlockingSingleSubscriber.java:104) ~[reactor-core-3.7.4.jar:3.7.4]
halo-1 | at reactor.core.publisher.Mono.block(Mono.java:1779) ~[reactor-core-3.7.4.jar:3.7.4]
halo-1 | at org.springframework.boot.r2dbc.init.R2dbcScriptDatabaseInitializer.runScripts(R2dbcScriptDatabaseInitializer.java:68) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:146) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:108) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applySchemaScripts(AbstractScriptDatabaseInitializer.java:98) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:76) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:66) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1859) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:601) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:523) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:347) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1155) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1121) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1056) ~[spring-beans-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987) ~[spring-context-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627) ~[spring-context-6.2.5.jar:6.2.5]
halo-1 | at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:318) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:149) ~[spring-boot-3.4.4.jar:3.4.4]
halo-1 | at run.halo.app.Application.main(Application.java:28) ~[classes/:2.20.18]
halo-1 | at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
halo-1 | at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
halo-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102) ~[application/:na]
halo-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64) ~[application/:na]
halo-1 | at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40) ~[application/:na]
halo-1 | Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection
halo-1 | at org.springframework.r2dbc.connection.ConnectionFactoryUtils.lambda$getConnection$0(ConnectionFactoryUtils.java:100) ~[spring-r2dbc-6.2.5.jar:6.2.5]
halo-1 | at reactor.core.publisher.Mono.lambda$onErrorMap$29(Mono.java:3862) ~[reactor-core-3.7.4.jar:3.7.4]
halo-1 | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) ~[reactor-core-3.7.4.jar:3.7.4]
halo-1 | ... 40 common frames omitted
halo-1 | Caused by: io.netty.channel.ConnectTimeoutException: connection timed out after 30000 ms: /192.168.80.101:3306
halo-1 | at io.netty.channel.epoll.AbstractEpollChannel$AbstractEpollUnsafe$2.run(AbstractEpollChannel.java:615) ~[netty-transport-classes-epoll-4.1.119.Final.jar:4.1.119.Final]
halo-1 | ... 10 common frames omitted
halo-1 |

[Khalo-1 exited with code 1`

数据库连接，请根据实际修改

- --spring.r2dbc.url=r2dbc:pool:mysql:localhost
- --spring.r2dbc.username=halo
- --spring.r2dbc.password=已经输入
- --spring.sql.init.platform=mysql

外部访问地址，请根据实际需要修改

- --halo.external-url=http://localhost:8090/

赵先生

客服发的地址：https://bbs.halo.run/d/6716-%E5%AE%9D%E5%A1%94%E5%86%85%E5%A6%82%E4%BD%95%E9%83%A8%E7%BD%B2halo%E5%91%A2/2

败犬

无法连接到数据库，连接超时，检查一下MySQL数据库能否正常连接。

Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection Caused by: io.netty.channel.ConnectTimeoutException: connection timed out after 30000 ms: /192.168.80.101:3306

赵先生

败犬是不是这个地址这样配置 localhost 如果是就数据库没问题我宝塔的数据库

败犬

赵先生
情况一：
有可能是没有给数据库足够的权限，造成无法连接，如下配置测试一下。

情况二：
你的mysq大概是docker安装的，你不懂docker的网络那就把MySQL对外暴露端口，连接地址就为服务器的IP:本地端口/数据库。
如图所示，我的服务器对外IP是192.168.80.102，MySQL暴露的本地端口是13306，数据库名是halo，用户是halo，密码是Pk22SEF6tKiJjTdk
记得给数据库开权限。
则数据库连接配置如下

      # 数据库连接，请根据实际修改
      - --spring.r2dbc.url=r2dbc:pool:mysql://192.168.80.102:13306/halo
      - --spring.r2dbc.username=halo
      - --spring.r2dbc.password=Pk22SEF6tKiJjTdk
      - --spring.sql.init.platform=mysql