server: port: 80 spring: servlet: multipart: location: /tmp/tomcat/work/Tomcat/localhost/ROOT redis: host: 127.0.0.1 port: 6379 password: zejuwuye@zzw datasource: type: com.zaxxer.hikari.HikariDataSource platform: mysql continue-on-error: false # 在初始化数据库时,遇到错误是否继续 driver-class-name: com.mysql.jdbc.Driver # mysql驱动 url: jdbc:mysql://127.0.0.1:3306/zzw1?useSSL=false&useUnicode=true&characterEncoding=utf-8 # 基础数据库名,用空就从config 去拉 username: root # 数据用户名,需要从config-server中发现 password: zejuwuye@zzw # 数据用密码,需要从config-server中发现 useUnicode: true # 是否使用Unicode字符集,如果参数characterEncoding设置为gb2312或gbk,本参数值必须设置为true characterEncoding: utf8mb4 # 当useUnicode设置为true时,指定字符编码 autoCommit: true # 指定updates是否自动提交 autoReconnect: true # 当数据库连接异常中断时,是否自动重新连接 failOverReadOnly: false # 自动重连成功后,连接是否设置为只读 maxReconnects: 3 # autoReconnect设置为true时,重试连接的次数 initialTimeout: 2 # autoReconnect设置为true时,两次重连之间的时间间隔,单位:秒 zerodatetimebehavior: converttonull allowMultiQueries: true # 在一条语句中,允许使用“;”来分隔多条查询 testWhileIdle: true # 连接是否被空闲连接回收器(如果有)进行检验.如果检测失败,则连接将被从池中去除 test-on-borrow: true #在取出连接时进行有效验证 validation-query: select user() # 连接池 hikari: auto-commit: true # 指定updates是否自动提交 connection-test-query: select user() # 指定校验连接合法性执行的sql语句 connection-timeout: 60000 # 指定连接的超时时间,毫秒单位 idle-timeout: 10000 # 指定连接多久没被使用时,被设置为空闲,默认为10ms initialization-fail-fast: true # 当创建连接池时,没法创建指定最小连接数量是否抛异常 leak-detection-threshold: 60000 # 使用Hikari connection pool时,多少毫秒检测一次连接泄露. login-timeout: 10 # 指定连接数据库的超时时间 maximum-pool-size: 200 # 指定连接池最大的连接数,包括使用中的和空闲的连接. minimum-idle: 5 # 指定连接维护的最小空闲连接数 max-lifetime: 60000 #连接生命时长, 比mysql的wait_timeout短1分钟左右 weChat: app-id: wxbabe943ffb235c79 dev-mode: true token: weixin app-secret: a32326e830bf8521fa30d4d9d536223d wx-article-count: 3 encrypt-message: false encoding-aes-key: FmN1lqkVl1y9PzE0twc60gAwgJa15BtkKJZqgJA8liy host: http://zejuwuye.zzwtec.com ws-host: http://captureroom.zzwtec.com product-video: http://v-wb.youku.com/v_show/id_XMTU4Mjc2MjMyMA==.html zzwtec-open-api-base: https://open.zzwtec.com zzwtec-secret-key: a32326e830bf8521fa30d4d9d536223d xteaKey: 18c1326ae83347ab xteaIv: 9afcd148 profile: dev noticeTemplateId: RY-K3E-yLI9PlqoXjwbirCI0fqTXOiE1hyXDQzI_DN4 #物业通知消息模板id visitTemplateId: JGBHMq-KTFSwoZtGR5boP7SzRAJJaWwDPPYY2NH4kaM #来访提醒消息模板id feedbackTemplateId: E2GNXFzwl-y3tz_zDaZU95XxTNs_JGMdFIUFHRuH8tQ #开锁反馈消息模板id sysUser: username: xgl password: 123456 # 短信 sms: yzx: appid: aa6ad4686bdf4f4fa7c9ad43b6ef5bf8 sid: e2e16f323fc66eb3d8da446651a96295 token: c1ec2aeb8d4b43a2c8a533bb052e637b templateid: 321808 url: https://open.ucpaas.com/ol/sms/sendsms openapi: url: login: https://open.zzwtec.com/admin/login login-out: https://open.zzwtec.com/admin/logout query-community-config-by-community-id: https://open.zzwtec.com/communityConfig/queryCommunityConfigByCommunityId query-community-info: https://open.zzwtec.com/community/queryCommunityInfo query-all-build-id-by-community-id: https://open.zzwtec.com/build/queryAllBuildIdByCommunityId query-cell-by-build-id: https://open.zzwtec.com/cell/queryCellByBuildId query-cell-by-cell-id: https://open.zzwtec.com/cell/queryCellByCellId add-cell: https://open.zzwtec.com/cell/addCell update-cell: https://open.zzwtec.com/cell/updateCell delete-cell-by-ids: https://open.zzwtec.com/cell/deleteCellByIds query-user-cell: https://open.zzwtec.com/userCell/queryUserCell delete-user-cell-by-user-id-cell-id: https://open.zzwtec.com/user/deleteUserCellByUserIdCellId add-user-by-user-cell-info: https://open.zzwtec.com/user/addUserByUserCellInfo update-user-by-user-cell-info: https://open.zzwtec.com/user/updateUserByUserCellInfo query-notice-by-community-id: https://open.zzwtec.com/news/queryNoticeByCommunityId query-notice-by-notice-id: https://open.zzwtec.com/news/queryNoticeByNoticeId query-build-by-community-id: https://open.zzwtec.com/build/queryBuildByCommunityId query-build-by-id: https://open.zzwtec.com/build/queryBuildById add-build: https://open.zzwtec.com/build/addBuild delete-build-by-ids: https://open.zzwtec.com/build/deleteBuildByIds update-build: https://open.zzwtec.com/build/updateBuild query-page-door-by-community-id-or-build-id: https://open.zzwtec.com/door/queryPageDoorByCommunityIdOrBuildId query-door-by-id: https://open.zzwtec.com/door/queryDoorById set-door-remote: https://open.zzwtec.com/door/setDoorRemote query-user-by-user-id: https://open.zzwtec.com/user/queryUserByUserId # 获取头像接口 face: headFaceUrl: http://fastdfs.zzwtec.com/