解决druid访问失败

13693261870

2025-07-08 ea96e4fd148c14b94b939e3deaa43cb049b810ef

解决druid访问失败

 pom.xml

@@ -23,7 +23,7 @@
        <tobato.version>1.27.2</tobato.version>
        <kaptcha.version>2.3.3</kaptcha.version>
        <pagehelper.boot.version>2.0.0</pagehelper.boot.version>
<!--        <druid.version>1.2.23</druid.version>-->
        <druid.version>1.2.25</druid.version>
        <dynamic-ds.version>4.3.1</dynamic-ds.version>
        <commons.io.version>2.19.0</commons.io.version>
        <velocity.version>2.3</velocity.version>

 se-system/pom.xml

@@ -98,12 +98,12 @@
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.22</version>
            <version>1.2.25</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
            <version>1.2.25</version>
        </dependency>

        <!--text-->

 se-system/src/main/java/com/terra/system/config/DruidConfig.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
package com.terra.system.config;

import com.alibaba.druid.support.http.StatViewServlet;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.HashMap;
import java.util.Map;

@Configuration
@SuppressWarnings("ALL")
public class DruidConfig {
    @Bean
    public ServletRegistrationBean druidServlet() {
        ServletRegistrationBean bean = new ServletRegistrationBean();
        bean.setServlet(new StatViewServlet());
        bean.addUrlMappings("/druid/*");
        Map<String, String> initParameters = new HashMap<>();
        //initParameters.put("resetEnable", "false"); //禁用HTML页面上的“Rest All”功能
        //initParameters.put("allow", "127.0.0.1");  //ip白名单（没有配置或者为空，则允许所有访问）
        //initParameters.put("loginUsername", "admin");  //++监控页面登录用户名
        //initParameters.put("loginPassword", "admin");  //++监控页面登录用户密码
        //initParameters.put("deny", ""); //ip黑名单

        bean.setInitParameters(initParameters);

        return bean;
    }
}

 se-system/src/main/java/com/terra/system/config/InitConfig.java

@@ -49,6 +49,11 @@
    public void run(ApplicationArguments args) {
        // noinspection AlibabaRemoveCommentedCode
        try {
            //String enable1 = env.getProperty("spring.datasource.druid.stat-view-servlet.enabled");
            //String enable2 = env.getProperty("spring.datasource.druid.web-stat-filter.enabled");
            //String filters = env.getProperty("spring.datasource.druid.filters");
            //String pattern = env.getProperty("spring.datasource.druid.stat-view-servlet.url-pattern");
            
            GdalHelper.init(env.getProperty("sys.gdal_path"));
            UploadAttachService.init(env.getProperty("sys.attachTabs"));


 se-system/src/main/java/com/terra/system/config/WebConfig.java

@@ -49,6 +49,7 @@
    protected void addResourceHandlers(ResourceHandlerRegistry registry) {
        registry.addResourceHandler("/webjars/**").addResourceLocations("classpath:/META-INF/resources/webjars/");
        registry.addResourceHandler("swagger-ui.html").addResourceLocations("classpath:/META-INF/resources/");
        registry.addResourceHandler("/druid/**").addResourceLocations("classpath:/META-INF/resources/druid/");
        registry.addResourceHandler("/**").addResourceLocations("classpath:/static/");
        super.addResourceHandlers(registry);
    }

 se-system/src/main/resources/application-dev.yml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,137 @@
server:
  tomcat:
    uri-encoding: UTF-8
    max-connections: 5000
    max-http-form-post-size: 100MB
    threads:
      max: 2000
  servlet:
    context-path: /

spring:
  application:
    name: se-system
  mvc:
    static-path-pattern: /static/**
  # redis
  redis:
    database: 0
    host: 127.0.0.1
    port: 6369
    password: rediS_5L#F4_Server
    # è¿žæŽ¥è¶…时时长（毫秒）
    timeout: 10000
    lettuce:
      pool:
        # è¿žæŽ¥æ± æœ€å¤§è¿žæŽ¥æ•°ï¼ˆä½¿ç”¨è´Ÿå€¼è¡¨ç¤ºæ²¡æœ‰é™åˆ¶ï¼‰
        max-active: 1000
        # è¿žæŽ¥æ± æœ€å¤§é˜»å¡žç­‰å¾…时间（使用负值表示没有限制）
        max-wait: -1
        # è¿žæŽ¥æ± ä¸­çš„最大空闲连接
        max-idle: 10
        # è¿žæŽ¥æ± ä¸­çš„最小空闲连接
        min-idle: 5
  # session
  session:
    # 20分钟
    timeout: PT20M
  # è®¾ç½®ä¸Šä¼ æ–‡ä»¶å¤§å°
  servlet:
    multipart:
      enabled: true
      max-file-size: 204800MB
      max-request-size: 1048576MB
  # jackson
  jackson:
    time-zone: GMT+8
    date-format: yyyy-MM-dd HH:mm:ss
    locale: zh_CN
  thymeleaf:
    cache: false
  # datasource
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    #url: jdbc:postgresql://192.168.11.205:5433/jhs?useAffectedRows=true
    url: jdbc:postgresql://127.0.0.1:5433/jhs?useAffectedRows=true
    username: postgres
    #password: Postgres!_14_Lf
    password: postgres
    driver-class-name: org.postgresql.Driver
    platform: POSTGRESQL
    filters: stat,wall,log4j
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    logAbandoned: true
    # é…ç½®è¿žæŽ¥æ± ä¿¡æ¯
    druid:
      initial-size: 5
      min-idle: 5
      max-active: 100
      max-wait: 60000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      max-pool-prepared-statement-per-connection-size: 50
      pool-prepared-statements: true
      validation-query: SELECT 1
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      filters: stat,wall
      web-stat-filter:
        enabled: true
      stat-view-servlet:
        enabled: true
        url-pattern: /druid/*
        reset-enable: false
        login-username: admin
        login-password: ad_!Druid!_min

mybatis-plus:
  type-aliases-package: com.terra.system.entity
  config-location: classpath:mybatis.xml
  mapper-locations: classpath:mapper/**/*.xml

# logging
logging:
  config: classpath:logback-spring.xml

# RestTemplate config
remote:
  maxTotalConnect: 0
  maxConnectPerRoute: 1000
  connectTimeout: 30000
  readTimeout: -1

# ç³»ç»Ÿé…ç½®
sys:
  # å¯ç”¨swagger
  swaggerEnable: true
  # è‡ªåŠ¨æŸ¥è¯¢
  autoQuery: 0
  # ç®¡ç†å‘˜ID
  admin: ad_Lf1122_min
  # IIS的主机地址
  iisHost: 127.0.0.1
  # FME服务地址
  fmeUrl: http://192.168.11.205:88/
  # FME令牌
  fmeToken: c36e4f94-dfde-401e-9967-2c4a449f1300
  # å‡ºå›¾æœåŠ¡
  exportServer: http://127.0.0.1/ExportMap
  # Turf服务
  turfServer: http://127.0.0.1/Turf
  # Gdal驱动目录
  gdal_path: E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin
  # ç“¦ç‰‡åœ°å€
  tile_path: E:\data\2d\tiles
  path:
    # ä¸‹è½½ç›®å½•
    download: D:\JHS\data\download
    # ä¸Šä¼ ç›®å½•
    upload: D:\JHS\data\upload
    # ä¸´æ—¶ç›®å½•
    temp: D:\JHS\data\temp
  cad:
    exePath: C:/360/MxDrawCloudServer1.0TryVersion/MxDrawCloudServer/Bin/MxCAD/Release/mxcadassembly.exe
    targetPath: C:/360/MxDrawCloudServer1.0TryVersion/MxDrawCloudServer/SRC/TsWeb/public/data
  # ä¸Šä¼ é™„件表
  attachTabs: bd.b_pac_hydrogeology,bd.b_pac_frozensoil

 se-system/src/main/resources/static/favicon.ico

Binary files differ