小白Docker挂载外部数据库和安装升级心得

xiaoxiongbaba

我是技术小白，安装Halo有一定的门槛，给同样是小白的同学分享一点经验！
因为不是很懂Docker的机制，出了问题也不会修复！
在这个前提下建议没有修改能力的同学，尽量只在Docker里面启动一个Halo的容器，并记好容器存储在宿主机文件里路径！
其次就是数据库尽量不要用Docker的，因为我也没有备份数据库的习惯，并且数据库容器一单出现问题无法启动，那就面临无法找回的风险！
所以我们可以选择外部数据库或者云数据库，这样不管是halo更新，还是halo容器因为各种奇奇怪怪的问题挂掉，可以重装Halo容器恢复到最后的状态！！
docker-compose.yml借鉴了论坛里不知道哪个提问帖子！需要的兄弟自取！每一行需要写什么都做了注释！

version: "3"

services:
  halo:
     #升级改下面halo:2.2.0这个版本号就OK！
    image: halohub/halo:2.2.0
    container_name: halo
    restart: on-failure:3
    volumes:
     #修改/XXX/XXX/halo/.halo2的路径为本地你找的到的路径。里面会存主题、插件、好像还有文章具体我不是很懂，你能找到的位置就好。
     #切记冒号后面的不要动！！！
      - /XXX/XXX/halo/.halo2:/root/.halo2 
    ports:
      - "8090:8090"
    command:
     #修改ysql://XXX.XXX.XXX.XXX:3306/halodb，这是你外部数据库Mysql的地址，替换数据库IP或者域名都可以！端口号（3306）后面的是数据库名。
     #嘿！兄弟记住这一行！一会儿下面说数据库的时候！记得回来看！！！我给这行起了个名字叫老六！！！
     - --spring.r2dbc.url=r2dbc:pool:mysql://XXX.XXX.XXX.XXX:3306/halodb 
     #下面sqlroot是数据库用户名，去你数据库里找。
     - --spring.r2dbc.username=sqlroot
     #下面是数据库密码，不用我多BB了吧！
     - --spring.r2dbc.password=xxxxxxxxxxxx
     #这是你用的数据库类型，用的啥就写啥！
     - --spring.sql.init.platform=mysql
     #域名总有吧，最后用啥域名就在这填啥！要不进后台会有警告！别问我咋知道的！
     - --halo.external-url=https://www.XXXXXXX.com/
     #下面两个是初始管理员账号和密码！！写完记住！
     - --halo.security.initializer.superadminusername=halo
     - --halo.security.initializer.superadminpassword=halo

另外还有就是大家如果云服务器需要宿主机搭建Mysql,容器链接不上的可以看我博客
https://www.pmbear.com/archives/1676139108419
我也是小白正在慢慢摸索，大家有什么需要可以留言交流！！
博客昨天刚弄好！！哈哈！以后慢慢写！

Maverick

我按照你的操作的还是不能访问啊，mysql地址的也改成了docker0 的那个ip

InvoLve1

我谷歌搜索,百度搜索找了半天没有找到任何部署方案终于找到了😄😄😄😄😄

Maverick

InvoLve1 hxd，你按照这个部署成功了吗？

InvoLve1

Maverick 你好，我已经按照楼主给的操作方法搭建Halo但还是无法连接Halo,因为我使用的是宿主数据库

InvoLve1

InvoLve1 正在查看报错信息

InvoLve1

InvoLve1 root@VM-0-16-debian:/www/wwwroot/Web/Halo# docker-compose up -d
[+] Running 2/2
⠿ Network halo_default Created 0.1s
⠿ Container halo Started 0.7s
root@VM-0-16-debian:/www/wwwroot/Web/Halo#

Maverick

InvoLve1
alo | 2023-02-19T22:00:24.882+08:00 WARN 7 --- [ main] onfigReactiveWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script halo | 2023-02-19T22:00:24.884+08:00 INFO 7 --- [ main] r.h.a.e.c.DefaultControllerManager : Shutting down 0 controllers... halo | 2023-02-19T22:00:24.885+08:00 INFO 7 --- [ main] r.h.a.e.c.DefaultControllerManager : Shutdown 0 controllers. halo | 2023-02-19T22:00:24.885+08:00 INFO 7 --- [ main] r.h.a.e.controller.DefaultController : Disposing controller garbage-collector-controller halo | 2023-02-19T22:00:24.886+08:00 INFO 7 --- [ main] r.h.a.e.controller.DefaultController : Controller garbage-collector-controller is disposed halo | 2023-02-19T22:00:24.886+08:00 WARN 7 --- [pool-5-thread-1] run.halo.app.metrics.VisitLogWriter : VisitLogWrite thread [pool-5-thread-1] interrupted halo | 2023-02-19T22:00:24.911+08:00 INFO 7 --- [ main] .s.b.a.l.ConditionEvaluationReportLogger : halo | halo | Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. halo | 2023-02-19T22:00:24.927+08:00 ERROR 7 --- [ main] o.s.boot.SpringApplication : Application run failed halo | halo | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1751) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:961) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:915) ~[spring-context-6.0.4.jar:6.0.4] halo | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:584) ~[spring-context-6.0.4.jar:6.0.4] halo | at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:150) ~[spring-boot-3.0.2.jar:3.0.2] halo | at run.halo.app.Application.main(Application.java:28) ~[classes/:2.2.0] halo | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] halo | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na] halo | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na] halo | at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na] halo | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[application/:na] halo | at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[application/:na] halo | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[application/:na] halo | at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[application/:na] halo | Caused by: org.springframework.r2dbc.connection.init.UncategorizedScriptException: Failed to execute database script halo | at org.springframework.r2dbc.connection.init.DatabasePopulator.lambda$populate$4(DatabasePopulator.java:65) ~[spring-r2dbc-6.0.4.jar:6.0.4] halo | at reactor.core.publisher.Mono.lambda$onErrorMap$27(Mono.java:3749) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.Mono.lambda$onErrorResume$29(Mono.java:3839) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.MonoUsingWhen$ResourceSubscriber.onError(MonoUsingWhen.java:203) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:106) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.Operators.error(Operators.java:198) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.MonoError.subscribe(MonoError.java:53) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.Mono.subscribe(Mono.java:4444) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:103) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:106) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxRetry$RetrySubscriber.onError(FluxRetry.java:95) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:180) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.pool.AbstractPool$Borrower.fail(AbstractPool.java:475) ~[reactor-pool-1.0.0.jar:1.0.0] halo | at reactor.pool.SimpleDequePool.lambda$drainLoop$9(SimpleDequePool.java:429) ~[reactor-pool-1.0.0.jar:1.0.0] halo | at reactor.core.publisher.FluxDoOnEach$DoOnEachSubscriber.onError(FluxDoOnEach.java:186) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxMapFuseable$MapFuseableConditionalSubscriber.onError(FluxMapFuseable.java:340) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.MonoCompletionStage$MonoCompletionStageSubscription.apply(MonoCompletionStage.java:114) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.MonoCompletionStage$MonoCompletionStageSubscription.apply(MonoCompletionStage.java:64) ~[reactor-core-3.5.2.jar:3.5.2] halo | at java.base/java.util.concurrent.CompletableFuture.uniHandle(Unknown Source) ~[na:na] halo | at java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(Unknown Source) ~[na:na] halo | at java.base/java.util.concurrent.CompletableFuture.postComplete(Unknown Source) ~[na:na] halo | at java.base/java.util.concurrent.CompletableFuture.completeExceptionally(Unknown Source) ~[na:na] halo | at com.github.jasync.sql.db.util.FutureUtilsKt.tryFailure(FutureUtils.kt:21) ~[jasync-pool-2.1.23.jar:na] halo | at com.github.jasync.sql.db.pool.TimeoutSchedulerImpl$addTimeout$1$scheduledFuture$1.invoke(TimeoutScheduler.kt:63) ~[jasync-common-2.1.23.jar:na] halo | at com.github.jasync.sql.db.pool.TimeoutSchedulerImpl$addTimeout$1$scheduledFuture$1.invoke(TimeoutScheduler.kt:62) ~[jasync-common-2.1.23.jar:na] halo | at com.github.jasync.sql.db.pool.TimeoutSchedulerImpl.schedule$lambda-0(TimeoutScheduler.kt:51) ~[jasync-common-2.1.23.jar:na] halo | at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:153) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.concurrent.AbstractEventExecutor.runTask(AbstractEventExecutor.java:174) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:167) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:470) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:406) ~[netty-transport-classes-epoll-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.87.Final.jar:4.1.87.Final] halo | at java.base/java.lang.Thread.run(Unknown Source) ~[na:na] halo | Suppressed: java.lang.Exception: #block terminated with an error halo | at reactor.core.publisher.BlockingSingleSubscriber.blockingGet(BlockingSingleSubscriber.java:99) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.Mono.block(Mono.java:1710) ~[reactor-core-3.5.2.jar:3.5.2] halo | at org.springframework.boot.r2dbc.init.R2dbcScriptDatabaseInitializer.runScripts(R2dbcScriptDatabaseInitializer.java:68) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:146) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:108) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applySchemaScripts(AbstractScriptDatabaseInitializer.java:98) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:76) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:66) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1797) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1747) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:961) ~[spring-beans-6.0.4.jar:6.0.4] halo | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:915) ~[spring-context-6.0.4.jar:6.0.4] halo | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:584) ~[spring-context-6.0.4.jar:6.0.4] halo | at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-3.0.2.jar:3.0.2] halo | at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:150) ~[spring-boot-3.0.2.jar:3.0.2] halo | at run.halo.app.Application.main(Application.java:28) ~[classes/:2.2.0] halo | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] halo | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na] halo | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na] halo | at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na] halo | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[application/:na] halo | at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[application/:na] halo | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[application/:na] halo | at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[application/:na] halo | Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection halo | at org.springframework.r2dbc.connection.ConnectionFactoryUtils.lambda$getConnection$0(ConnectionFactoryUtils.java:90) ~[spring-r2dbc-6.0.4.jar:6.0.4] halo | at reactor.core.publisher.Mono.lambda$onErrorMap$28(Mono.java:3763) ~[reactor-core-3.5.2.jar:3.5.2] halo | at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) ~[reactor-core-3.5.2.jar:3.5.2] halo | ... 26 common frames omitted halo | Caused by: java.util.concurrent.TimeoutException: Operation timeout after it took too long to return (PT5S) halo | ... 12 common frames omitted

Maverick

InvoLve1 我的错误代码

InvoLve1

Maverick 你好，我的错误代码，也是这样子

Maverick

InvoLve1 hxd 有解决办法吗？

xiaoxiongbaba

InvoLve1
你们俩去我博客看，有一步需要在数据库设置Docker的IP地址

xiaoxiongbaba

Maverick
你们俩去我博客看，有一步需要在数据库设置Docker的IP地址

xiaoxiongbaba

Maverick
还有就是你发的这个错误代码我看不懂，如果按照我这个配置你还是不能访问halo的话！首先需要排除几个问题。
1.先将mysql的访问权限更改成ALL，就是所有人都可以链接数据库。尝试是否可以打开。
2.方法1无法解决的话，检查docker-compose.yml是否填写正确。检查数据库名，数据库用户，数据库密码是否正确。
3.全部正确的话，检查服务器是否放行了8090端口。
如果还不能访问你就再回复我，我睡醒可以指导你一下。

InvoLve1

xiaoxiongbaba 经过一晚上的研究，终于可以了十分感谢这个教程

Maverick

xiaoxiongbaba hxd,全部试了一下呀，都按照你上面说的，还是无法启动

xiaoxiongbaba

InvoLve1
只要细心一点，大概也就那几个问题，毕竟也不用写代码！！！

xiaoxiongbaba

InvoLve1
数据库最后一定要把ALL权限关掉！！毕竟不安全！

InvoLve1

Maverick 你好,请问您是否使用宝塔面板进行安装的？

InvoLve1

InvoLve1 如果是使用宝塔面板安装，请把那个服务器的mysql端口3306和宝塔安全的端口也要放开

Maverick

InvoLve1 是的呀，是使用了宝塔面板

Maverick

InvoLve1 谢谢hxd，原来是宝塔的那个端口没放开，一直没注意这个问题