648540858
2023-11-02 f36eb7ebebf5b4bbe79d27636d4a4ddb49067273
添加打包文件
2个文件已修改
3个文件已添加
365 ■■■■■ 已修改文件
src/main/resources/all-application.yml 13 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
打包/config/assist-application.yml 63 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
打包/config/config.ini 166 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
打包/config/wvp-application.yml 120 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
数据库/更新-mysql-2.6.9.sql 3 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/all-application.yml
@@ -34,6 +34,19 @@
        poolMaxWait: 5
    # [必选] jdbc数据库配置
    datasource:
        # kingbase配置
        #        type: com.zaxxer.hikari.HikariDataSource
        #        driver-class-name: com.kingbase8.Driver
        #        url: jdbc:kingbase8://192.168.1.55:54321/wvp?useUnicode=true&characterEncoding=utf8
        #        username: system
        #        password: system
        # postgresql配置
        #    type: com.zaxxer.hikari.HikariDataSource
        #    driver-class-name: org.postgresql.Driver
        #    url: jdbc:postgresql://192.168.1.242:3306/242wvp
        #    username: root
        #    password: SYceshizu1234
        # mysql配置
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/wvp2?useUnicode=true&characterEncoding=UTF8&rewriteBatchedStatements=true&serverTimezone=PRC&useSSL=false&allowMultiQueries=true
´ò°ü/config/assist-application.yml
New file
@@ -0,0 +1,63 @@
spring:
    # REDIS数据库配置
    redis:
        # [可选] è¶…æ—¶æ—¶é—´
        timeout: 10000
        # ä»¥ä¸‹ä¸ºå•机配置
        # [必须修改] Redis服务器IP, REDIS安装在本机的,使用127.0.0.1
        host: 127.0.0.1
        # [必须修改] ç«¯å£å·
        port: 6379
        # [可选] æ•°æ®åº“ DB
        database: 1
        # [可选] è®¿é—®å¯†ç ,若你的redis服务器没有设置密码,就不需要用密码去连接
        password: adminadmin123.
        # ä»¥ä¸‹ä¸ºé›†ç¾¤é…ç½®
#        cluster:
#            nodes: 192.168.1.242:7001
#        password: 4767cb971b40a1300fa09b7f87b09d1c
# [可选] WVP监听的HTTP端口, ç½‘页和接口调用都是这个端口
server:
    port: 18081
    # [可选] HTTPS配置, é»˜è®¤ä¸å¼€å¯
    ssl:
        # [可选] æ˜¯å¦å¼€å¯HTTPS访问
        enabled: false
        # [可选] è¯ä¹¦æ–‡ä»¶è·¯å¾„,放置在resource/目录下即可,修改xxx为文件名
        key-store: classpath:xxx.jks
        # [可选] è¯ä¹¦å¯†ç 
        key-password: password
        # [可选] è¯ä¹¦ç±»åž‹ï¼Œ é»˜è®¤ä¸ºjks,根据实际修改
        key-store-type: JKS
# [根据业务需求配置]
userSettings:
    # [必选 ] æœåŠ¡ID
    id: 334533
    # [可选 ] å½•像下载合成临时文件保存时长, ä¸é…ç½®é»˜è®¤å–值recordDay(单位: å¤©ï¼‰æ¯å¤©æ™š12点自动对过期文件执行清理
    # recordTempDay: 7
    # [必选 ] ffmpeg路径
    ffmpeg: lib/ffmpeg
    # [必选 ] ffprobe路径, ä¸€èˆ¬å®‰è£…ffmpeg就会自带, ä¸€èˆ¬è·Ÿffmpeg在同一目录,用于查询文件的信息
    ffprobe: lib/ffprobe
    # [可选 ] é™åˆ¶ ffmpeg åˆå¹¶æ–‡ä»¶ä½¿ç”¨çš„线程数,间接限制cpu使用率, é»˜è®¤2 é™åˆ¶åˆ°50%
    threads: 2
swagger-ui:
    enabled: true
# [可选] æ—¥å¿—配置, ä¸€èˆ¬ä¸éœ€è¦æ”¹
logging:
    file:
        name: logs/wvp.log
        max-history: 30
        max-size: 10MB
        total-size-cap: 300MB
    level:
        root: WARN
        top:
            panll:
                assist: info
        net:
            bramp:
                ffmpeg: error
´ò°ü/config/config.ini
New file
@@ -0,0 +1,166 @@
; auto-generated by mINI class {
[api]
apiDebug=1
defaultSnap=./www/logo.png
secret=034523TF8yT83wh5Wvz73f7
snapRoot=./www/snap/
[cluster]
origin_url=
retry_count=3
timeout_sec=15
[ffmpeg]
bin=/usr/bin/ffmpeg
cmd=%s -re -i %s -c:a aac -strict -2 -ar 44100 -ab 48k -c:v libx264 -f flv %s
log=./ffmpeg/ffmpeg.log
restart_sec=0
snap=%s -i %s -y -f mjpeg -t 0.001 %s
[general]
check_nvidia_dev=1
enableVhost=0
enable_ffmpeg_log=0
flowThreshold=1024
maxStreamWaitMS=15000
mediaServerId=GQ3TF8yT83wh5Wvz
mergeWriteMS=0
resetWhenRePlay=1
streamNoneReaderDelayMS=15000
unready_frame_cache=100
wait_add_track_ms=3000
wait_track_ready_ms=10000
[hls]
broadcastRecordTs=0
deleteDelaySec=10
fileBufSize=65536
segDur=2
segKeep=0
segNum=3
segRetain=5
[hook]
admin_params=secret=034523TF8yT83wh5Wvz73f7
alive_interval=30.000000
enable=1
on_flow_report=
on_http_access=
on_play=http://192.168.1.3:18082/index/hook/on_play
on_publish=http://192.168.1.3:18082/index/hook/on_publish
on_record_mp4=
on_record_ts=
on_rtp_server_timeout=http://192.168.1.3:18082/index/hook/on_rtp_server_timeout
on_rtsp_auth=
on_rtsp_realm=
on_send_rtp_stopped=http://192.168.1.3:18082/index/hook/on_send_rtp_stopped
on_server_keepalive=http://192.168.1.3:18082/index/hook/on_server_keepalive
on_server_started=http://192.168.1.3:18082/index/hook/on_server_started
on_shell_login=
on_stream_changed=http://192.168.1.3:18082/index/hook/on_stream_changed
on_stream_none_reader=http://192.168.1.3:18082/index/hook/on_stream_none_reader
on_stream_not_found=http://192.168.1.3:18082/index/hook/on_stream_not_found
retry=1
retry_delay=3.000000
timeoutSec=20
[http]
charSet=utf-8
dirMenu=1
forbidCacheSuffix=
forwarded_ip_header=
keepAliveSecond=15
maxReqSize=40960
notFound=<html><head><title>404 Not Found</title></head><body bgcolor="white"><center><h1>您访问的资源不存在!</h1></center><hr><center>ZLMediaKit(git hash:f6cba98/2023-02-06T14:18:21+08:00,branch:master,build time:2023-02-07T10:51:47)</center></body></html>
port=6080
rootPath=./www
sendBufSize=65536
sslport=16080
virtualPath=
[multicast]
addrMax=239.255.255.255
addrMin=239.0.0.0
udpTTL=64
[protocol]
add_mute_audio=1
continue_push_ms=3000
enable_audio=1
enable_fmp4=1
enable_hls=1
enable_mp4=0
enable_rtmp=1
enable_rtsp=1
enable_ts=1
fmp4_demand=0
hls_demand=0
hls_save_path=./www
modify_stamp=0
mp4_as_player=0
mp4_max_second=3600
mp4_save_path=./www
rtmp_demand=0
rtsp_demand=0
ts_demand=0
[record]
appName=record
fastStart=0
fileBufSize=65536
fileRepeat=0
sampleMS=500
[rtc]
externIP=192.168.1.3
port=8000
preferredCodecA=PCMA,PCMU,opus,mpeg4-generic
preferredCodecV=H264,H265,AV1,VP9,VP8
rembBitRate=0
tcpPort=8000
timeoutSec=15
[rtmp]
handshakeSecond=15
keepAliveSecond=15
modifyStamp=0
port=1935
sslport=19350
[rtp]
audioMtuSize=600
lowLatency=0
rtpMaxSize=10
videoMtuSize=1400
[rtp_proxy]
dumpDir=
h264_pt=98
h265_pt=99
opus_pt=100
port=10000
port_range=40000-40500
ps_pt=96
timeoutSec=15
[rtsp]
authBasic=0
directProxy=1
handshakeSecond=15
keepAliveSecond=15
lowLatency=0
port=10554
sslport=
[shell]
maxReqSize=1024
port=9000
[srt]
latencyMul=4
pktBufSize=8192
port=9000
timeoutSec=5
; } ---
´ò°ü/config/wvp-application.yml
New file
@@ -0,0 +1,120 @@
spring:
    # [可选]上传文件大小限制
    servlet:
        multipart:
            max-file-size: 10MB
            max-request-size: 100MB
    # REDIS数据库配置
    redis:
        # [可选] è¶…æ—¶æ—¶é—´
        timeout: 10000
        # ä»¥ä¸‹ä¸ºå•机配置
        # [必须修改] Redis服务器IP, REDIS安装在本机的,使用127.0.0.1
        host: 127.0.0.1
        #        # [必须修改] ç«¯å£å·
        port: 6379
        # [可选] æ•°æ®åº“ DB
        database: 1
        # [可选] è®¿é—®å¯†ç ,若你的redis服务器没有设置密码,就不需要用密码去连接
        password: adminadmin123.
        # ä»¥ä¸‹ä¸ºé›†ç¾¤é…ç½®
#        cluster:
#            nodes: 192.168.1.66:9001,192.168.1.66:9002,192.168.1.66:9003,192.168.1.66:9004,192.168.1.66:9005,192.168.1.66:9006
#        password: adminadmin123.
        # [可选] jdbc数据库配置, é¡¹ç›®ä½¿ç”¨sqlite作为数据库,一般不需要配置
    # mysql数据源
    datasource:
        # kingbase配置
#        type: com.zaxxer.hikari.HikariDataSource
#        driver-class-name: com.kingbase8.Driver
#        url: jdbc:kingbase8://192.168.1.55:54321/wvp?useUnicode=true&characterEncoding=utf8
#        username: system
#        password: system
        # postgresql配置
#        type: com.zaxxer.hikari.HikariDataSource
#        driver-class-name: org.postgresql.Driver
#        url: jdbc:postgresql://192.168.1.242:3306/242wvp
#        username: root
#        password: SYceshizu1234
        # mysql配置
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.1.242:3306/242wvp?useUnicode=true&characterEncoding=UTF8&rewriteBatchedStatements=true&serverTimezone=PRC&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true
        username: root
        password: SYceshizu1234
# kingbase å’Œ postgresql需要开启这个配置
#pagehelper:
#  helper-dialect: postgresql
#[可选] WVP监听的HTTP端口, ç½‘页和接口调用都是这个端口
server:
    port: 18080
# ä½œä¸º28181服务器的配置
sip:
    # [必须修改] æœ¬æœºçš„IP
    ip: 192.168.1.3
    # [可选] 28181服务监听的端口
    port: 15060
    # æ ¹æ®å›½æ ‡6.1.2中规定,domain宜采用ID统一编码的前十位编码。国标附录D中定义前8位为中心编码(由省级、市级、区级、基层编号组成,参照GB/T 2260-2007)
    # åŽä¸¤ä½ä¸ºè¡Œä¸šç¼–码,定义参照附录D.3
    # 3701020049标识山东济南历下区 ä¿¡æ¯è¡Œä¸šæŽ¥å…¥
    # [可选]
    domain: 3402000001
    # [可选]
    id: 34020000013000000001
    # [可选] é»˜è®¤è®¾å¤‡è®¤è¯å¯†ç ï¼ŒåŽç»­æ‰©å±•使用设备单独密码, ç§»é™¤å¯†ç å°†ä¸è¿›è¡Œæ ¡éªŒ
    password: 12345678
#zlm é»˜è®¤æœåŠ¡å™¨é…ç½®
media:
    # [必须修改] zlm服务器唯一id,用于触发hook时区别是哪台服务器,general.mediaServerId
    id: GQ3TF8yT83wh5Wvz
    # [必须修改] zlm服务器的内网IP
    ip: 192.168.1.3
    # [必须修改] zlm服务器的http.port
    http-port: 6080
    # [可选] zlm服务器的hook.admin_params=secret
    secret: 034523TF8yT83wh5Wvz73f7
    # å¯ç”¨å¤šç«¯å£æ¨¡å¼, å¤šç«¯å£æ¨¡å¼ä½¿ç”¨ç«¯å£åŒºåˆ†æ¯è·¯æµï¼Œå…¼å®¹æ€§æ›´å¥½ã€‚ å•端口使用流的ssrc区分, ç‚¹æ’­è¶…时建议使用多端口测试
    rtp:
        # [可选] æ˜¯å¦å¯ç”¨å¤šç«¯å£æ¨¡å¼, å¼€å¯åŽä¼šåœ¨portRange范围内选择端口用于媒体流传输
        enable: true
        # [可选] åœ¨æ­¤èŒƒå›´å†…选择端口用于媒体流传输,
        port-range: 30000,30500 # ç«¯å£èŒƒå›´
        # [可选] å›½æ ‡çº§è”在此范围内选择端口发送媒体流,请不要与收流端口范围重合
        send-port-range: 50502,50506 # ç«¯å£èŒƒå›´
    # å½•像辅助服务, éƒ¨ç½²æ­¤æœåŠ¡å¯ä»¥å®žçŽ°zlm录像的管理与下载, 0 è¡¨ç¤ºä¸ä½¿ç”¨
    record-assist-port: 18089
    # å½•像路径
    record-path: ./www/record
    # å½•像保存时长
    record-day: 7
# [可选] æ—¥å¿—配置, ä¸€èˆ¬ä¸éœ€è¦æ”¹
logging:
    config: classpath:logback-spring-local.xml
# [根据业务需求配置]
user-settings:
    server-id: 741266
    auto-apply-play: true
    interface-authentication: true
    interface-authentication-excludes:
        - /api/v1/**
        - /api/media/stream_info_by_app_and_stream
        - /api/v1/control/ptz
        - /api/cloud/record/*/**
    # æŽ¨æµç›´æ’­æ˜¯å¦å½•制
    record-push-live: true
    # å›½æ ‡æ˜¯å¦å½•制
    record-sip: false
    # ä½¿ç”¨æŽ¨æµçŠ¶æ€ä½œä¸ºæŽ¨æµé€šé“çŠ¶æ€
    use-pushing-as-status: false
    # è®¾å¤‡ä¸Šçº¿æ—¶æ˜¯å¦è‡ªåŠ¨åŒæ­¥é€šé“
    sync-channel-on-device-online: false
     # æ¶ˆæ¯é€šé“功能-缺少国标ID是否给所有上级发送消息
    send-to-platforms-when-id-lost: false
Êý¾Ý¿â/¸üÐÂ-mysql-2.6.9.sql
@@ -60,8 +60,7 @@
    change online on_line varchar(50) null;
alter table device
    add COLUMN switch_primary_sub_stream bool default false comment '开启主子码流切换的开关(0-不开启,1-开启)现在已知支持设备为 å¤§åŽã€TP——LINK全系设备'
    add COLUMN switch_primary_sub_stream bool default false comment '开启主子码流切换的开关(0-不开启,1-开启)现在已知支持设备为 å¤§åŽã€TP——LINK全系设备';
alter table device_alarm
    change deviceId device_id varchar(50) not null;