有没有大佬教学一下宝塔下chatwoot的安装，送个小红包

小萝卜

misakafa 发表于 2024-3-27 17:19
这个是iptables命令报错了，看看你的docker-compose.yml文件

1. version: '3'
   
2. 
   
3. services:
   
4.   base: &base
   
5.     image: chatwoot/chatwoot:latest
   
6.     env_file: .env ## Change this file for customized env variables
   
7.     volumes:
   
8.       - /data/storage:/app/storage
   
9. 
   
10.   rails:
    
11.     <<: *base
    
12.     depends_on:
    
13.       - postgres
    
14.       - redis
    
15.     ports:
    
16.       - '127.0.0.1:3000:3000'
    
17.     environment:
    
18.       - NODE_ENV=production
    
19.       - RAILS_ENV=production
    
20.       - INSTALLATION_ENV=docker
    
21.     entrypoint: docker/entrypoints/rails.sh
    
22.     command: ['bundle', 'exec', 'rails', 's', '-p', '3000', '-b', '0.0.0.0']
    
23. 
    
24.   sidekiq:
    
25.     <<: *base
    
26.     depends_on:
    
27.       - postgres
    
28.       - redis
    
29.     environment:
    
30.       - NODE_ENV=production
    
31.       - RAILS_ENV=production
    
32.       - INSTALLATION_ENV=docker
    
33.     command: ['bundle', 'exec', 'sidekiq', '-C', 'config/sidekiq.yml']
    
34. 
    
35.   postgres:
    
36.     image: postgres:12
    
37.     restart: always
    
38.     ports:
    
39.       - '127.0.0.1:5431:5432'
    
40.     volumes:
    
41.       - /data/postgres:/var/lib/postgresql/data
    
42.     environment:
    
43.       - POSTGRES_DB=chatwoot
    
44.       - POSTGRES_USER=postgres
    
45.       # Please provide your own password.
    
46.       - POSTGRES_PASSWORD=bb4539bbef963874da80cedc0ecaca989
    
47. 
    
48.   redis:
    
49.     image: redis:alpine
    
50.     restart: always
    
51.     command: ["sh", "-c", "redis-server --requirepass "$REDIS_PASSWORD""]
    
52.     env_file: .env
    
53.     volumes:
    
54.       - /data/redis:/data
    
55.     ports:
    
56.       - '127.0.0.1:6378:6379'
    

复制代码

misakafa

小萝卜 发表于 2024-3-27 17:12
关闭防火墙还是连不上

docker的规则被你清掉了，删除镜像重新启吧，参考28楼提供docker-compose试试，docker-compose中的有些端口要改一下，别和你宝塔启动的服务端口冲突了

小萝卜

misakafa 发表于 2024-3-27 17:37
docker的规则被你清掉了，删除镜像重新启吧，参考28楼提供docker-compose试试，docker-compose中的有些端 ...

1. [root@workserver chatwoot]# docker compose run --rm rails bundle exec rails db:chatwoot_prepare
   
2. WARN[0000] /www/wwwroot/support.rose.com/chatwoot/docker-compose.yaml: `version` is obsolete
   
3. [+] Creating 2/2
   
4. ✔ Container chatwoot-redis-1     Created                                               2.5s
   
5. ✔ Container chatwoot-postgres-1  Created                                               2.5s
   
6. [+] Running 0/2
   
7. ⠸ Container chatwoot-redis-1     Starting                                              4.3s
   
8. ⠸ Container chatwoot-postgres-1  Starting                                              4.3s
   
9. Error response from daemon: driver failed programming external connectivity on endpoint chatwoot-redis-1 (2ab104c1ba6c4af259ac6bab16adea28bd354c27006d252917b81b352ea19a62):  (iptables failed: iptables --wait -t nat -A DOCKER -p tcp -d 127.0.0.1 --dport 6378 -j DNAT --to-destination 172.24.0.2:6379 ! -i br-0442c7e2ad68: iptables: No chain/target/match by that name.
   
10. (exit status 1))
    
11. [root@workserver chatwoot]# docker compose run --rm rails bundle exec rails db:chatwoot_prepare
    
12. WARN[0000] /www/wwwroot/support.rose.com/chatwoot/docker-compose.yaml: `version` is obsolete
    
13. [+] Creating 2/2
    
14. ✔ Container chatwoot-redis-1     Created                                               2.1s
    
15. ✔ Container chatwoot-postgres-1  Created                                               2.1s
    
16. [+] Running 2/2
    
17. ✔ Container chatwoot-redis-1     Started                                               2.1s
    
18. ✔ Container chatwoot-postgres-1  Started                                               2.1s
    
19. [+] Running 12/12
    
20. ✔ rails 11 layers [⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿]      0B/0B      Pulled                                43.9s
    
21.    ✔ c926b61bad3b Pull complete                                                         0.4s
    
22.    ✔ 0bfb8f508c71 Pull complete                                                         0.4s
    
23.    ✔ e49674a1e21a Pull complete                                                         0.3s
    
24.    ✔ a8d637e9f7e0 Pull complete                                                         1.6s
    
25.    ✔ 80c3bd4e2c8c Pull complete                                                         1.0s
    
26.    ✔ 71db01de2232 Pull complete                                                         4.4s
    
27.    ✔ d81ce3c1e381 Pull complete                                                         1.3s
    
28.    ✔ fb043248c8af Pull complete                                                         7.7s
    
29.    ✔ 28c50097771b Pull complete                                                         4.9s
    
30.    ✔ 6ac8f70d1ae3 Pull complete                                                         4.9s
    
31.    ✔ 4f4fb700ef54 Pull complete                                                         5.2s
    
32. + rm -rf /app/tmp/pids/server.pid
    
33. + rm -rf '/app/tmp/cache/*'
    
34. + echo 'Waiting for postgres to become ready....'
    
35. Waiting for postgres to become ready....
    
36. + docker/entrypoints/helpers/pg_database_url.rb
    
37. + export 'POSTGRES_PORT=5432'
    
38. + PG_READY='pg_isready -h postgres -p 5432 -U postgres'
    
39. + pg_isready -h postgres -p 5432 -U postgres
    
40. postgres:5432 - accepting connections
    
41. + echo 'Database ready to accept connections.'
    
42. Database ready to accept connections.
    
43. + bundle install
    
44. Bundle complete! 126 Gemfile dependencies, 247 gems now installed.
    
45. Gems in the groups 'development' and 'test' were not installed.
    
46. Bundled gems are installed into `/gems`
    
47. + BUNDLE='bundle check'
    
48. + bundle check
    
49. The Gemfile's dependencies are satisfied
    
50. + exec bundle exec rails db:chatwoot_prepare
    
51. Created database 'chatwoot_production'
    
52. rails aborted!
    
53. Redis::CannotConnectError: Connection refused - connect(2) for 127.0.0.1:6378 (Redis::CannotConnectError)
    
54. /app/lib/global_config.rb:24:in `block in clear_cache'
    
55. /app/lib/global_config.rb:24:in `clear_cache'
    
56. /app/db/seeds.rb:2:in `<main>'
    
57. /app/lib/tasks/db_enhancements.rake:28:in `rescue in block (3 levels) in <main>'
    
58. /app/lib/tasks/db_enhancements.rake:19:in `block (3 levels) in <main>'
    
59. /app/lib/tasks/db_enhancements.rake:18:in `each'
    
60. /app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
    
61. 
    
62. Caused by:
    
63. RedisClient::CannotConnectError: Connection refused - connect(2) for 127.0.0.1:6378 (RedisClient::CannotConnectError)
    
64. /app/lib/global_config.rb:24:in `block in clear_cache'
    
65. /app/lib/global_config.rb:24:in `clear_cache'
    
66. /app/db/seeds.rb:2:in `<main>'
    
67. /app/lib/tasks/db_enhancements.rake:28:in `rescue in block (3 levels) in <main>'
    
68. /app/lib/tasks/db_enhancements.rake:19:in `block (3 levels) in <main>'
    
69. /app/lib/tasks/db_enhancements.rake:18:in `each'
    
70. /app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
    
71. 
    
72. Caused by:
    
73. Errno::ECONNREFUSED: Connection refused - connect(2) for 127.0.0.1:6378 (Errno::ECONNREFUSED)/app/lib/global_config.rb:24:in `block in clear_cache'
    
74. /app/lib/global_config.rb:24:in `clear_cache'
    
75. /app/db/seeds.rb:2:in `<main>'
    
76. /app/lib/tasks/db_enhancements.rake:28:in `rescue in block (3 levels) in <main>'
    
77. /app/lib/tasks/db_enhancements.rake:19:in `block (3 levels) in <main>'
    
78. /app/lib/tasks/db_enhancements.rake:18:in `each'
    
79. /app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
    
80. 
    
81. Caused by:
    
82. ActiveRecord::NoDatabaseError: We could not find your database: chatwoot_production. Which can be found in the database configuration file located at config/database.yml. (ActiveRecord::NoDatabaseError)
    
83. 
    
84. To resolve this issue:
    
85. 
    
86. - Did you create the database for this app, or delete it? You may need to create your database.
    
87. - Has the database name changed? Check your database.yml config has the correct database name.
    
88. 
    
89. To create your database, run:
    
90. 
    
91.         bin/rails db:create
    
92. /app/lib/tasks/db_enhancements.rake:20:in `block (3 levels) in <main>'
    
93. /app/lib/tasks/db_enhancements.rake:18:in `each'
    
94. /app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
    
95. 
    
96. Caused by:
    
97. PG::ConnectionBad: connection to server at "172.24.0.2", port 5432 failed: FATAL:  database "chatwoot_production" does not exist (PG::ConnectionBad)
    
98. /app/lib/tasks/db_enhancements.rake:20:in `block (3 levels) in <main>'
    
99. /app/lib/tasks/db_enhancements.rake:18:in `each'
    
100. /app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
     
101. Tasks: TOP => db:setup => db:seed
     
102. (See full trace by running task with --trace)

复制代码

用28楼的配置文件把pgsql改成跟.env一样后就这样

misakafa

小萝卜 发表于 2024-3-27 17:49
用28楼的配置文件把pgsql改成跟.env一样后就这样

搞好没

ceplavia

你在容器内要怎么连127.0.0.1，redis在宿主机就把参数换成docker网卡的网关，要是redis也在容器内塞进一个网络里不就好了

misakafa

小萝卜 发表于 2024-3-27 17:49
用28楼的配置文件把pgsql改成跟.env一样后就这样

.env文件中REDIS_URL=redis://redis:6379 改成这个
docker-compose文件中这里改一下
  redis:
    image: redis:alpine
    restart: always
    command: ["sh", "-c", "redis-server --requirepass \"$REDIS_PASSWORD\""]
    env_file: .env
    volumes:
      - ./data/redis:/data
    ports:
      - 6378:6379
在重新启一下试试

小萝卜

misakafa 发表于 2024-3-27 19:04
.env文件中REDIS_URL=redis://redis:6379 改成这个
docker-compose文件中这里改一下
  redis:

1. [root@workserver chatwoot]# docker compose run --rm rails bundle exec rails db:chatwoot_prepare
   
2. WARN[0000] /www/wwwroot/support.rosehacker.com/chatwoot/docker-compose.yaml: `version` is obsolete
   
3. [+] Creating 2/2
   
4. ✔ Container chatwoot-redis-1     Created                                               1.0s
   
5. ✔ Container chatwoot-postgres-1  Created                                               1.0s
   
6. [+] Running 2/2
   
7. ✔ Container chatwoot-redis-1     Started                                               1.8s
   
8. ✔ Container chatwoot-postgres-1  Started                                               1.9s
   
9. [+] Running 12/12
   
10. ✔ rails 11 layers [⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿]      0B/0B      Pulled                                43.6s
    
11.    ✔ c926b61bad3b Pull complete                                                         0.4s
    
12.    ✔ 0bfb8f508c71 Pull complete                                                         0.4s
    
13.    ✔ e49674a1e21a Pull complete                                                         0.3s
    
14.    ✔ a8d637e9f7e0 Pull complete                                                         1.1s
    
15.    ✔ 80c3bd4e2c8c Pull complete                                                         0.8s
    
16.    ✔ 71db01de2232 Pull complete                                                         5.4s
    
17.    ✔ d81ce3c1e381 Pull complete                                                         1.2s
    
18.    ✔ fb043248c8af Pull complete                                                         7.0s
    
19.    ✔ 28c50097771b Pull complete                                                         5.1s
    
20.    ✔ 6ac8f70d1ae3 Pull complete                                                         5.5s
    
21.    ✔ 4f4fb700ef54 Pull complete                                                         5.7s
    
22. + rm -rf /app/tmp/pids/server.pid
    
23. + rm -rf '/app/tmp/cache/*'
    
24. + echo 'Waiting for postgres to become ready....'
    
25. Waiting for postgres to become ready....
    
26. + docker/entrypoints/helpers/pg_database_url.rb
    
27. + export 'POSTGRES_PORT=5432'
    
28. + PG_READY='pg_isready -h postgres -p 5432 -U postgres'
    
29. + pg_isready -h postgres -p 5432 -U postgres
    
30. postgres:5432 - accepting connections
    
31. + echo 'Database ready to accept connections.'
    
32. Database ready to accept connections.
    
33. + bundle install
    
34. Bundle complete! 126 Gemfile dependencies, 247 gems now installed.
    
35. Gems in the groups 'development' and 'test' were not installed.
    
36. Bundled gems are installed into `/gems`
    
37. + BUNDLE='bundle check'
    
38. + bundle check
    
39. The Gemfile's dependencies are satisfied
    
40. + exec bundle exec rails db:chatwoot_prepare
    
41. Loading Installation config

复制代码

现在按大佬说的改完，好像是完成了，但是访问起来还是502错误。

misakafa

小萝卜 发表于 2024-3-27 19:38
现在按大佬说的改完，好像是完成了，但是访问起来还是502错误。

自己看看是不是ngx配置错了

小萝卜

misakafa 发表于 2024-3-27 20:10
自己看看是不是ngx配置错了

1. 
   
2. #PROXY-START/
   
3. 
   
4. location ^~ /
   
5. {
   
6.     proxy_pass http://127.0.0.1:3000;
   
7.     proxy_set_header Host $host;
   
8.     proxy_set_header X-Real-IP $remote_addr;
   
9.     proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
   
10.     proxy_set_header REMOTE-HOST $remote_addr;
    
11.     proxy_set_header Upgrade $http_upgrade;
    
12.     proxy_set_header Connection $connection_upgrade;
    
13.     proxy_http_version 1.1;
    
14.     # proxy_hide_header Upgrade;
    
15. 
    
16.     add_header X-Cache $upstream_cache_status;
    
17. 
    
18.     #Set Nginx Cache
    
19.    
    
20.    
    
21.     set $static_filexRm0w58E 0;
    
22.     if ( $uri ~* "\.(gif|png|jpg|css|js|woff|woff2)$" )
    
23.     {
    
24.             set $static_filexRm0w58E 1;
    
25.             expires 1m;
    
26.         }
    
27.     if ( $static_filexRm0w58E = 0 )
    
28.     {
    
29.     add_header Cache-Control no-cache;
    
30.     }
    
31. }
    
32. 
    
33. #PROXY-END/

复制代码

刚刚出门了下，我感觉没有配错呢。

小萝卜

misakafa 发表于 2024-3-27 20:10
自己看看是不是ngx配置错了

大佬方便加个联系方式不，虽然还没成功，但我感觉应该快成功了，发个小红包请你喝个奶茶。