VMSCommServer/VMS-FTP-INFO.SQL

phvmslocal
local12#$!

phvmscenter
center12#$!


port: 50021
admin port: 14147


passive-mode: true

port-range: 8000~8030

TB_VMS_SYMB_LIB.SYMB_IMAG_TYPE	VARCHAR(7)	Y		심벌 이미지 유형 ==> 크기확인
TB_VMS_SYMB_LIB.IMAG_SIZE				NUMBER(10)	Y		이미지 사이즈 ==> 크기작으면 늘려주어야 함	

SYMB_TYPE	7	N	VARCHAR(5)	Y		심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상,SBT4:대기환경등급)
5000, 5999

-- 동영상 파일 유형
avi, mpeg, mkv, mp4

동영상 파일 (*.avi;*.mpeg;*.mpg;*.mkv;*.mp4)|*.avi;*.mpeg;*.mpg;*.mkv;*.mp4
Video Files|*.AVI;*.MP4;*.MPG;*.MPEG


-- VMS FTP 정보
insert into TB_CMMN_CLSF_CD (CMMN_CLSF_CD, MSG_TYPE_CD, CMMN_CLSF_KOR_NM, CMMN_CLSF_ENGL_NM, USE_SYST_CD, RMRK, USE_YN) values ('VMFTP', null, 'VMS FTP 정보', 'VMS FTP 정보', '공통', null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('1', 'VMFTP', '172.16.20.12', '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('2', 'VMFTP', '50021',        '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('3', 'VMFTP', '0',            '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('4', 'VMFTP', 'phvmscenter',  '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('5', 'VMFTP', 'center12#$!',  '', null, null, null, null, 'Y');
commit;

-- VMS 폼 관련 테이블 수정
INSERT INTO TB_VMS_FORM_TYPE(VMS_FORM_TYPE_CD, VMS_FORM_TYPE_NM, EDTN_CD, USE_YN) VALUES(70, '동영상', 'EDI0', 'Y');
COMMIT;

INSERT INTO TB_VMS_FORM_OBJECT_TYPE(VMS_FORM_TYPE_CD, VMS_FORM_OBJECT_TYPE_CD, VMS_FORM_OBJECT_TYPE_NM, USE_YN) VALUES(70, 200, '동영상', 'Y');
COMMIT;

ALTER TABLE TB_VMS_DSPL_PRST ADD VMS_DSPL_MSG_INFO VARCHAR(100);
COMMENT ON TABLE TB_VMS_DSPL_PRST IS 'VMS 표출 현재';
COMMENT ON COLUMN TB_VMS_DSPL_PRST.VMS_DSPL_MSG_INFO IS 'VMS 메시지 표출 정보';


ITS_OP.exe
VmsOprMain.exe
VmsCommServer.exe

VideoVMS.inf 파일 업데이트

select * from TB_VMS_FORM_TYPE where VMS_FORM_TYPE_CD = '70';
select * from TB_VMS_FORM_OBJECT_TYPE where VMS_FORM_TYPE_CD = '70';

select * from TB_CMMN_CLSF_CD where CMMN_CLSF_CD = 'VMFTP';
select * from TB_CMMN_CD where CMMN_CLSF_CD = 'VMFTP' order by CMMN_CD;
update TB_CMMN_CD set CMMN_CD_KOR_NM = '1' where CMMN_CLSF_CD = 'VMFTP' and CMMN_CD = '3';
commit;


rtsp://cctv3660:admin1357!!@192.168.1.221/profile1/media.smp
rtsp://admin:cctv3660!@192.168.22.51/profile1/media.smp


##### VMS Serverer
172.16.20.12
Administrator
phsver!230#

##### WEB Server && 상황판
utis.pohang.go.kr
220.122.218.208
172.16.150.14:33814
phits/ph2024#!@


운영단말
ADMIN
phutis0!
pohang/pohang

-- 운영단말
172.16.30.200
172.16.30.201
172.16.30.13
172.16.30.190
172.16.150.14
172.16.30.11
172.16.30.12
172.16.20.12

-- VMS 제어기
192.168.1.220
192.168.22.50