MDRM 시스템에 등록 된 OS TYPE 변경법

1. Environment
  • MDRM 전버전
2. Symptoms
  • MDRM 수동으로 시스템 등록 시, OS Type이 UNKOWN으로 표기 될 때
3. Solution

1) OS 정보 확인

$ docker exec -it gam /bin/bash
$ su - mccs -c "psql -d mccs"
> select * from os_versions;

os_ver_id | os_ver_name
-----------+---------------------------------
00000 | Windows Server 2003 (32bit)
00001 | Windows Server 2003 (64bit)
00010 | Windows Server 2003 R2 (32bit)
00011 | Windows Server 2003 R2 (64bit)
00020 | Windows Server 2008 (32bit)
00021 | Windows Server 2008 (64bit)
00030 | Windows Server 2008 R2 (32bit)
00031 | Windows Server 2008 R2 (64bit)
00041 | Windows Server 2012 (64bit)
00050 | Windows XP Professional (32bit)
00051 | Windows Server 2012 R2 (64bit)
00060 | Windows 7 (32bit)
00061 | Windows 7 (64bit)
00999 | Windows Server
01000 | Redhat Enterprise 5 (32bit)
01001 | Redhat Enterprise 5 (64bit)
01010 | Redhat Enterprise 6 (32bit)
01011 | Redhat Enterprise 6 (64bit)
01020 | Redhat Enterprise 7 (32bit)
01021 | Redhat Enterprise 7 (64bit)
01999 | Redhat Enterprise

2) node 확인방법

> select node_id, node_name, os_ver_id from nodes;

3) node OS type 변경

> update nodes
set os_ver_id = '01021'# os_ver_id
where node_id = 'N0023'; # node_id