zhuyifeiRuichuang commented on issue #8150: URL: https://github.com/apache/incubator-seata/issues/8150#issuecomment-4805928268
连不上数据库的问题，我的处理方法是，先调整`application.yaml`的内容，例如 ```bash root@test:/data/seata# cat config/application.yml # Copyright 1999-2019 Seata.io Group. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. server: port: 7091 spring: application: name: seata-server logging: config: classpath:logback-spring.xml file: #path: ${log.home:${user.home}/logs/seata} path: /root/logs/seata extend: logstash-appender: destination: 127.0.0.1:4560 kafka-appender: bootstrap-servers: 127.0.0.1:9092 topic: logback_to_logstash seata: config: # support: nacos 、 consul 、 apollo 、 zk 、 etcd3 type: nacos nacos: server-addr: 172.16.0.30:8848 namespace: seata-server group: SEATA_GROUP username: nacos password: nacos context-path: ##if use MSE Nacos with auth, mutex with username/password attribute #access-key: #secret-key: data-id: seataServer.properties # consul: # server-addr: 127.0.0.1:8500 # acl-token: # key: seata.properties # apollo: # appId: seata-server # apollo-meta: http://192.168.1.204:8801 # apollo-config-service: http://192.168.1.204:8080 # namespace: application # apollo-access-key-secret: # cluster: seata # zk: # server-addr: 127.0.0.1:2181 # session-timeout: 6000 # connect-timeout: 2000 # username: # password: # node-path: /seata/seata.properties # etcd3: # server-addr: http://localhost:2379 # key: seata.properties registry: # support: nacos 、 eureka 、 redis 、 zk 、 consul 、 etcd3 、 sofa type: nacos # preferred-networks: 30.240.* nacos: application: seata-server server-addr: 172.16.0.30:8848 group: SEATA_GROUP namespace: seata-server cluster: default username: nacos password: nacos context-path: ##if use MSE Nacos with auth, mutex with username/password attribute #access-key: #secret-key: # eureka: # service-url: http://localhost:8761/eureka # application: default # weight: 1 # redis: # server-addr: localhost:6379 # db: 0 # password: # cluster: default # timeout: 0 # zk: # cluster: default # server-addr: 127.0.0.1:2181 # session-timeout: 6000 # connect-timeout: 2000 # username: # password: # consul: # cluster: default # server-addr: 127.0.0.1:8500 # acl-token: # etcd3: # cluster: default # server-addr: http://localhost:2379 # sofa: # server-addr: 127.0.0.1:9603 # application: default # region: DEFAULT_ZONE # datacenter: DefaultDataCenter # cluster: default # group: SEATA_GROUP # address-wait-time: 3000 server: service-port: 8091 #If not configured, the default is '${server.port} + 1000' max-commit-retry-timeout: -1 max-rollback-retry-timeout: -1 rollback-failed-unlock-enable: false enable-check-auth: true enable-parallel-request-handle: true retry-dead-threshold: 130000 xaer-nota-retry-timeout: 60000 enableParallelRequestHandle: true recovery: committing-retry-period: 1000 async-committing-retry-period: 1000 rollbacking-retry-period: 1000 timeout-retry-period: 1000 undo: log-save-days: 7 log-delete-period: 86400000 session: branch-async-queue-size: 5000 #branch async remove queue size enable-branch-async-remove: false #enable to asynchronous remove branchSession store: # support: file 、 db 、 redis mode: db session: mode: db lock: mode: db # file: # dir: sessionStore # max-branch-session-size: 16384 # max-global-session-size: 512 # file-write-buffer-cache-size: 16384 # session-reload-read-size: 100 # flush-disk-mode: async db: datasource: druid db-type: mysql driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://172.16.0.30:3306/seata?rewriteBatchedStatements=true user: root password: root123456 min-conn: 10 max-conn: 100 global-table: global_table branch-table: branch_table lock-table: lock_table distributed-lock-table: distributed_lock query-limit: 1000 max-wait: 5000 # redis: # mode: single # database: 0 # min-conn: 10 # max-conn: 100 # password: # max-total: 100 # query-limit: 1000 # single: # host: 127.0.0.1 # port: 6379 # sentinel: # master-name: # sentinel-hosts: # sentinel-password: # metrics: # enabled: false # registry-type: compact # exporter-list: prometheus # exporter-prometheus-port: 9898 # transport: # rpc-tc-request-timeout: 15000 # enable-tc-server-batch-send-response: false # shutdown: # wait: 3 # thread-factory: # boss-thread-prefix: NettyBoss # worker-thread-prefix: NettyServerNIOWorker # boss-thread-size: 1 security: secretKey: SeataSecretKey0c382ef121d778043159209298fd40bf3850a017 tokenValidityInMilliseconds: 1800000 ignore: urls: /,/**/*.css,/**/*.js,/**/*.html,/**/*.map,/**/*.svg,/**/*.png,/**/*.ico,/console-fe/public/**,/api/v1/auth/login root@test:/data/seata# ``` 然后是改nacos的配置， <img width="2556" height="1197" alt="Image" src="https://github.com/user-attachments/assets/6ff75183-d99a-49ad-aed4-aee1a44d855b"; /> <img width="2556" height="1197" alt="Image" src="https://github.com/user-attachments/assets/4f8afad7-9b25-4756-97f9-864ae6b33d5b"; /> <img width="2556" height="1197" alt="Image" src="https://github.com/user-attachments/assets/807b4121-d2d3-44ba-971d-f3cec0969123"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
