오픈소스 설치 한글(hwp) 보고서 폼

설치

# https://www.postgresql.org/download/ 방문하여 OS 플랫폼, Ver 설정하면 스크립트 제공 (아래)

# 선택이 끝나면 위와 같이 설정 스크립트가 제공됨 (스크립트 순서에 따라 설치하면 됨)

# Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:
sudo dnf -qy module disable postgresql

# Install PostgreSQL:
sudo dnf install -y postgresql15-server

# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15​

# Install the repository RPM: Postgresql 15.2ve

# sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:

# sudo dnf -qy module disable postgresql​

# Install PostgreSQL:

# sudo dnf install -y postgresql15-server​

# Optionally initialize the database and enable automatic start:

# sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
# sudo systemctl enable postgresql-15
# sudo systemctl start postgresql-15​

# 설치가 끝나면 
postgres 계정 생성됨 (/etc/passwd)
/var/lib/pgsql/15/data/ * 각종.conf 파일 생성
/usrpgql-15/bin/ *각종 실행명령어 파일  psql  생성 등

# ansible host(192.168.56.53) -m setup > SetupModulInfo.txt

엔서블로 yml 스크립트 작성시 필요한 각종 함수(Module) 정보를 출력함

아래 yml 파일은 os가 CentOS 또는 Ubuntu 종류에 따라 nginx를 설치하는 yml 파일임  ( 출처 sysnet4admin )

# ansible 192.168.56.53 -m setup > 53.txt          * 아래는 53.txt 파일에 대한 출력 결과물이다. 

192.168.56.53 | SUCCESS => {
    "ansible_facts": {
        "ansible_all_ipv4_addresses": [
            "192.168.56.53", 
            "10.0.2.15"
        ], 
        "ansible_all_ipv6_addresses": [
            "fe80::a00:27ff:feaf:60e0", 
            "fe80::5054:ff:fe4d:77d3"
        ], 
        "ansible_apparmor": {
            "status": "disabled"
        }, 
        "ansible_architecture": "x86_64", 
        "ansible_bios_date": "12/01/2006", 
        "ansible_bios_version": "VirtualBox", 
        "ansible_cmdline": {
            "BOOT_IMAGE": "/boot/vmlinuz-3.10.0-1127.el7.x86_64", 
            "LANG": "en_US.UTF-8", 
            "biosdevname": "0", 
            "console": "ttyS0,115200n8", 
            "crashkernel": "auto", 
            "elevator": "noop", 
            "net.ifnames": "0", 
            "no_timer_check": true, 
            "ro": true, 
            "root": "UUID=1c419d6c-5064-4a2b-953c-05b2c67edb15"
        }, 
        "ansible_date_time": {
            "date": "2023-03-19", 
            "day": "19", 
            "epoch": "1679199226", 
            "hour": "04", 
            "iso8601": "2023-03-19T04:13:46Z", 
            "iso8601_basic": "20230319T041346239496", 
            "iso8601_basic_short": "20230319T041346", 
            "iso8601_micro": "2023-03-19T04:13:46.239496Z", 
            "minute": "13", 
            "month": "03", 
            "second": "46", 
            "time": "04:13:46", 
            "tz": "UTC", 
            "tz_offset": "+0000", 
            "weekday": "Sunday", 
            "weekday_number": "0", 
            "weeknumber": "11", 
            "year": "2023"
        }, 
        "ansible_default_ipv4": {
            "address": "10.0.2.15", 
            "alias": "eth0", 
            "broadcast": "10.0.2.255", 
            "gateway": "10.0.2.2", 
            "interface": "eth0", 
            "macaddress": "52:54:00:4d:77:d3", 
            "mtu": 1500, 
            "netmask": "255.255.255.0", 
            "network": "10.0.2.0", 
            "type": "ether"
        }, 
        "ansible_default_ipv6": {}, 
        "ansible_device_links": {
            "ids": {
                "sda": [
                    "ata-VBOX_HARDDISK_VB7426d174-3fc9655d"
                ], 
                "sda1": [
                    "ata-VBOX_HARDDISK_VB7426d174-3fc9655d-part1"
                ]
            }, 
            "labels": {}, 
            "masters": {}, 
            "uuids": {
                "sda1": [
                    "1c419d6c-5064-4a2b-953c-05b2c67edb15"
                ]
            }
        }, 
        "ansible_devices": {
            "sda": {
                "holders": [], 
                "host": "IDE interface: Intel Corporation 82371AB/EB/MB PIIX4 IDE (rev 01)", 
                "links": {
                    "ids": [
                        "ata-VBOX_HARDDISK_VB7426d174-3fc9655d"
                    ], 
                    "labels": [], 
                    "masters": [], 
                    "uuids": []
                }, 
                "model": "VBOX HARDDISK", 
                "partitions": {
                    "sda1": {
                        "holders": [], 
                        "links": {
                            "ids": [
                                "ata-VBOX_HARDDISK_VB7426d174-3fc9655d-part1"
                            ], 
                            "labels": [], 
                            "masters": [], 
                            "uuids": [
                                "1c419d6c-5064-4a2b-953c-05b2c67edb15"
                            ]
                        }, 
                        "sectors": "83884032", 
                        "sectorsize": 512, 
                        "size": "40.00 GB", 
                        "start": "2048", 
                        "uuid": "1c419d6c-5064-4a2b-953c-05b2c67edb15"
                    }
                }, 
                "removable": "0", 
                "rotational": "1", 
                "sas_address": null, 
                "sas_device_handle": null, 
                "scheduler_mode": "noop", 
                "sectors": "83886080", 
                "sectorsize": "512", 
                "size": "40.00 GB", 
                "support_discard": "0", 
                "vendor": "ATA", 
                "virtual": 1
            }
        }, 
        "ansible_distribution": "CentOS",               # 일부 서버 셋팅에 확인 안되는 부분 있음 : "OtherLinux",  "N/A" 등 
        "ansible_distribution_file_parsed": true, 
        "ansible_distribution_file_path": "/etc/redhat-release", 
        "ansible_distribution_file_variety": "RedHat", 
        "ansible_distribution_major_version": "7", 
        "ansible_distribution_release": "Core", 
        "ansible_distribution_version": "7.9", 
        "ansible_dns": {
            "nameservers": [
                "10.0.2.3"
            ]
        }, 
        "ansible_domain": "", 
        "ansible_effective_group_id": 1000, 
        "ansible_effective_user_id": 1000, 
        "ansible_env": {
            "HOME": "/home/vagrant", 
            "LANG": "en_US.UTF-8", 
            "LESSOPEN": "||/usr/bin/lesspipe.sh %s", 
            "LOGNAME": "vagrant", 
            "LS_COLORS": "rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:", 
            "MAIL": "/var/mail/vagrant", 
            "PATH": "/usr/local/bin:/usr/bin", 
            "PWD": "/home/vagrant", 
            "SELINUX_LEVEL_REQUESTED": "", 
            "SELINUX_ROLE_REQUESTED": "", 
            "SELINUX_USE_CURRENT_RANGE": "", 
            "SHELL": "/bin/bash", 
            "SHLVL": "2", 
            "SSH_CLIENT": "192.168.56.50 50676 22", 
            "SSH_CONNECTION": "192.168.56.50 50676 192.168.56.53 22", 
            "SSH_TTY": "/dev/pts/1", 
            "TERM": "xterm", 
            "USER": "vagrant", 
            "XDG_RUNTIME_DIR": "/run/user/1000", 
            "XDG_SESSION_ID": "8", 
            "_": "/usr/bin/python"
        }, 
        "ansible_eth0": {
            "active": true, 
            "device": "eth0", 
            "features": {
                "busy_poll": "off [fixed]", 
                "fcoe_mtu": "off [fixed]", 
                "generic_receive_offload": "on", 
                "generic_segmentation_offload": "on", 
                "highdma": "off [fixed]", 
                "hw_tc_offload": "off [fixed]", 
                "l2_fwd_offload": "off [fixed]", 
                "large_receive_offload": "off [fixed]", 
                "loopback": "off [fixed]", 
                "netns_local": "off [fixed]", 
                "ntuple_filters": "off [fixed]", 
                "receive_hashing": "off [fixed]", 
                "rx_all": "off", 
                "rx_checksumming": "off", 
                "rx_fcs": "off", 
                "rx_gro_hw": "off [fixed]", 
                "rx_udp_tunnel_port_offload": "off [fixed]", 
                "rx_vlan_filter": "on [fixed]", 
                "rx_vlan_offload": "on", 
                "rx_vlan_stag_filter": "off [fixed]", 
                "rx_vlan_stag_hw_parse": "off [fixed]", 
                "scatter_gather": "on", 
                "tcp_segmentation_offload": "on", 
                "tx_checksum_fcoe_crc": "off [fixed]", 
                "tx_checksum_ip_generic": "on", 
                "tx_checksum_ipv4": "off [fixed]", 
                "tx_checksum_ipv6": "off [fixed]", 
                "tx_checksum_sctp": "off [fixed]", 
                "tx_checksumming": "on", 
                "tx_fcoe_segmentation": "off [fixed]", 
                "tx_gre_csum_segmentation": "off [fixed]", 
                "tx_gre_segmentation": "off [fixed]", 
                "tx_gso_partial": "off [fixed]", 
                "tx_gso_robust": "off [fixed]", 
                "tx_ipip_segmentation": "off [fixed]", 
                "tx_lockless": "off [fixed]", 
                "tx_nocache_copy": "off", 
                "tx_scatter_gather": "on", 
                "tx_scatter_gather_fraglist": "off [fixed]", 
                "tx_sctp_segmentation": "off [fixed]", 
                "tx_sit_segmentation": "off [fixed]", 
                "tx_tcp6_segmentation": "off [fixed]", 
                "tx_tcp_ecn_segmentation": "off [fixed]", 
                "tx_tcp_mangleid_segmentation": "off", 
                "tx_tcp_segmentation": "on", 
                "tx_udp_tnl_csum_segmentation": "off [fixed]", 
                "tx_udp_tnl_segmentation": "off [fixed]", 
                "tx_vlan_offload": "on [fixed]", 
                "tx_vlan_stag_hw_insert": "off [fixed]", 
                "udp_fragmentation_offload": "off [fixed]", 
                "vlan_challenged": "off [fixed]"
            }, 
            "hw_timestamp_filters": [], 
            "ipv4": {
                "address": "10.0.2.15", 
                "broadcast": "10.0.2.255", 
                "netmask": "255.255.255.0", 
                "network": "10.0.2.0"
            }, 
            "ipv6": [
                {
                    "address": "fe80::5054:ff:fe4d:77d3", 
                    "prefix": "64", 
                    "scope": "link"
                }
            ], 
            "macaddress": "52:54:00:4d:77:d3", 
            "module": "e1000", 
            "mtu": 1500, 
            "pciid": "0000:00:03.0", 
            "promisc": false, 
            "speed": 1000, 
            "timestamping": [
                "tx_software", 
                "rx_software", 
                "software"
            ], 
            "type": "ether"
        }, 
        "ansible_eth1": {
            "active": true, 
            "device": "eth1", 
            "features": {
                "busy_poll": "off [fixed]", 
                "fcoe_mtu": "off [fixed]", 
                "generic_receive_offload": "on", 
                "generic_segmentation_offload": "on", 
                "highdma": "off [fixed]", 
                "hw_tc_offload": "off [fixed]", 
                "l2_fwd_offload": "off [fixed]", 
                "large_receive_offload": "off [fixed]", 
                "loopback": "off [fixed]", 
                "netns_local": "off [fixed]", 
                "ntuple_filters": "off [fixed]", 
                "receive_hashing": "off [fixed]", 
                "rx_all": "off", 
                "rx_checksumming": "off", 
                "rx_fcs": "off", 
                "rx_gro_hw": "off [fixed]", 
                "rx_udp_tunnel_port_offload": "off [fixed]", 
                "rx_vlan_filter": "on [fixed]", 
                "rx_vlan_offload": "on", 
                "rx_vlan_stag_filter": "off [fixed]", 
                "rx_vlan_stag_hw_parse": "off [fixed]", 
                "scatter_gather": "on", 
                "tcp_segmentation_offload": "on", 
                "tx_checksum_fcoe_crc": "off [fixed]", 
                "tx_checksum_ip_generic": "on", 
                "tx_checksum_ipv4": "off [fixed]", 
                "tx_checksum_ipv6": "off [fixed]", 
                "tx_checksum_sctp": "off [fixed]", 
                "tx_checksumming": "on", 
                "tx_fcoe_segmentation": "off [fixed]", 
                "tx_gre_csum_segmentation": "off [fixed]", 
                "tx_gre_segmentation": "off [fixed]", 
                "tx_gso_partial": "off [fixed]", 
                "tx_gso_robust": "off [fixed]", 
                "tx_ipip_segmentation": "off [fixed]", 
                "tx_lockless": "off [fixed]", 
                "tx_nocache_copy": "off", 
                "tx_scatter_gather": "on", 
                "tx_scatter_gather_fraglist": "off [fixed]", 
                "tx_sctp_segmentation": "off [fixed]", 
                "tx_sit_segmentation": "off [fixed]", 
                "tx_tcp6_segmentation": "off [fixed]", 
                "tx_tcp_ecn_segmentation": "off [fixed]", 
                "tx_tcp_mangleid_segmentation": "off", 
                "tx_tcp_segmentation": "on", 
                "tx_udp_tnl_csum_segmentation": "off [fixed]", 
                "tx_udp_tnl_segmentation": "off [fixed]", 
                "tx_vlan_offload": "on [fixed]", 
                "tx_vlan_stag_hw_insert": "off [fixed]", 
                "udp_fragmentation_offload": "off [fixed]", 
                "vlan_challenged": "off [fixed]"
            }, 
            "hw_timestamp_filters": [], 
            "ipv4": {
                "address": "192.168.56.53", 
                "broadcast": "192.168.56.255", 
                "netmask": "255.255.255.0", 
                "network": "192.168.56.0"
            }, 
            "ipv6": [
                {
                    "address": "fe80::a00:27ff:feaf:60e0", 
                    "prefix": "64", 
                    "scope": "link"
                }
            ], 
            "macaddress": "08:00:27:af:60:e0", 
            "module": "e1000", 
            "mtu": 1500, 
            "pciid": "0000:00:08.0", 
            "promisc": false, 
            "speed": 1000, 
            "timestamping": [
                "tx_software", 
                "rx_software", 
                "software"
            ], 
            "type": "ether"
        }, 
        "ansible_fibre_channel_wwn": [], 
        "ansible_fips": false, 
        "ansible_form_factor": "Other", 
        "ansible_fqdn": "ansible-node03", 
        "ansible_hostname": "ansible-node03", 
        "ansible_hostnqn": "", 
        "ansible_interfaces": [
            "lo", 
            "eth1", 
            "eth0"
        ], 
        "ansible_is_chroot": true, 
        "ansible_iscsi_iqn": "", 
        "ansible_kernel": "3.10.0-1127.el7.x86_64", 
        "ansible_kernel_version": "#1 SMP Tue Mar 31 23:36:51 UTC 2020", 
        "ansible_lo": {
            "active": true, 
            "device": "lo", 
            "features": {
                "busy_poll": "off [fixed]", 
                "fcoe_mtu": "off [fixed]", 
                "generic_receive_offload": "on", 
                "generic_segmentation_offload": "on", 
                "highdma": "on [fixed]", 
                "hw_tc_offload": "off [fixed]", 
                "l2_fwd_offload": "off [fixed]", 
                "large_receive_offload": "off [fixed]", 
                "loopback": "on [fixed]", 
                "netns_local": "on [fixed]", 
                "ntuple_filters": "off [fixed]", 
                "receive_hashing": "off [fixed]", 
                "rx_all": "off [fixed]", 
                "rx_checksumming": "on [fixed]", 
                "rx_fcs": "off [fixed]", 
                "rx_gro_hw": "off [fixed]", 
                "rx_udp_tunnel_port_offload": "off [fixed]", 
                "rx_vlan_filter": "off [fixed]", 
                "rx_vlan_offload": "off [fixed]", 
                "rx_vlan_stag_filter": "off [fixed]", 
                "rx_vlan_stag_hw_parse": "off [fixed]", 
                "scatter_gather": "on", 
                "tcp_segmentation_offload": "on", 
                "tx_checksum_fcoe_crc": "off [fixed]", 
                "tx_checksum_ip_generic": "on [fixed]", 
                "tx_checksum_ipv4": "off [fixed]", 
                "tx_checksum_ipv6": "off [fixed]", 
                "tx_checksum_sctp": "on [fixed]", 
                "tx_checksumming": "on", 
                "tx_fcoe_segmentation": "off [fixed]", 
                "tx_gre_csum_segmentation": "off [fixed]", 
                "tx_gre_segmentation": "off [fixed]", 
                "tx_gso_partial": "off [fixed]", 
                "tx_gso_robust": "off [fixed]", 
                "tx_ipip_segmentation": "off [fixed]", 
                "tx_lockless": "on [fixed]", 
                "tx_nocache_copy": "off [fixed]", 
                "tx_scatter_gather": "on [fixed]", 
                "tx_scatter_gather_fraglist": "on [fixed]", 
                "tx_sctp_segmentation": "on", 
                "tx_sit_segmentation": "off [fixed]", 
                "tx_tcp6_segmentation": "on", 
                "tx_tcp_ecn_segmentation": "on", 
                "tx_tcp_mangleid_segmentation": "on", 
                "tx_tcp_segmentation": "on", 
                "tx_udp_tnl_csum_segmentation": "off [fixed]", 
                "tx_udp_tnl_segmentation": "off [fixed]", 
                "tx_vlan_offload": "off [fixed]", 
                "tx_vlan_stag_hw_insert": "off [fixed]", 
                "udp_fragmentation_offload": "on", 
                "vlan_challenged": "on [fixed]"
            }, 
            "hw_timestamp_filters": [], 
            "ipv4": {
                "address": "127.0.0.1", 
                "broadcast": "", 
                "netmask": "255.0.0.0", 
                "network": "127.0.0.0"
            }, 
            "ipv6": [
                {
                    "address": "::1", 
                    "prefix": "128", 
                    "scope": "host"
                }
            ], 
            "mtu": 65536, 
            "promisc": false, 
            "timestamping": [
                "rx_software", 
                "software"
            ], 
            "type": "loopback"
        }, 
        "ansible_local": {}, 
        "ansible_lsb": {}, 
        "ansible_machine": "x86_64", 
        "ansible_machine_id": "4b38f45955af66429a6e7e9040f9a362", 
        "ansible_memfree_mb": 176, 
        "ansible_memory_mb": {
            "nocache": {
                "free": 362, 
                "used": 124
            }, 
            "real": {
                "free": 176, 
                "total": 486, 
                "used": 310
            }, 
            "swap": {
                "cached": 0, 
                "free": 2046, 
                "total": 2047, 
                "used": 1
            }
        }, 
        "ansible_memtotal_mb": 486, 
        "ansible_mounts": [
            {
                "block_available": 9623569, 
                "block_size": 4096, 
                "block_total": 10480385, 
                "block_used": 856816, 
                "device": "/dev/sda1", 
                "fstype": "xfs", 
                "inode_available": 20939939, 
                "inode_total": 20971008, 
                "inode_used": 31069, 
                "mount": "/", 
                "options": "rw,seclabel,relatime,attr2,inode64,noquota", 
                "size_available": 39418138624, 
                "size_total": 42927656960, 
                "uuid": "1c419d6c-5064-4a2b-953c-05b2c67edb15"
            }
        ], 
        "ansible_nodename": "ansible-node03", 
        "ansible_os_family": "RedHat", 
        "ansible_pkg_mgr": "yum", 
        "ansible_proc_cmdline": {
            "BOOT_IMAGE": "/boot/vmlinuz-3.10.0-1127.el7.x86_64", 
            "LANG": "en_US.UTF-8", 
            "biosdevname": "0", 
            "console": [
                "tty0", 
                "ttyS0,115200n8"
            ], 
            "crashkernel": "auto", 
            "elevator": "noop", 
            "net.ifnames": "0", 
            "no_timer_check": true, 
            "ro": true, 
            "root": "UUID=1c419d6c-5064-4a2b-953c-05b2c67edb15"
        }, 
        "ansible_processor": [
            "0", 
            "GenuineIntel", 
            "Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz"
        ], 
        "ansible_processor_cores": 1, 
        "ansible_processor_count": 1, 
        "ansible_processor_threads_per_core": 1, 
        "ansible_processor_vcpus": 1, 
        "ansible_product_name": "VirtualBox", 
        "ansible_product_serial": "NA", 
        "ansible_product_uuid": "NA", 
        "ansible_product_version": "1.2", 
        "ansible_python": {
            "executable": "/usr/bin/python", 
            "has_sslcontext": true, 
            "type": "CPython", 
            "version": {
                "major": 2, 
                "micro": 5, 
                "minor": 7, 
                "releaselevel": "final", 
                "serial": 0
            }, 
            "version_info": [
                2, 
                7, 
                5, 
                "final", 
                0
            ]
        }, 
        "ansible_python_version": "2.7.5", 
        "ansible_real_group_id": 1000, 
        "ansible_real_user_id": 1000, 
        "ansible_selinux": {
            "config_mode": "enforcing", 
            "mode": "enforcing", 
            "policyvers": 31, 
            "status": "enabled", 
            "type": "targeted"
        }, 
        "ansible_selinux_python_present": true, 
        "ansible_service_mgr": "systemd", 
        "ansible_ssh_host_key_ecdsa_public": "AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBEFLGbE+UjrBCTJzGQGQpJuWBHpjc5kxfSCmRrxHYXo1XqtHT11huXegxPSdCtev4MV9UtNGS5SSOrFyM46uubc=", 
        "ansible_ssh_host_key_ed25519_public": "AAAAC3NzaC1lZDI1NTE5AAAAIKZDZmJ30g1NEYAiVNFV5IJiRD7iiujBRAkrFMZ8W/8j", 
        "ansible_ssh_host_key_rsa_public": "AAAAB3NzaC1yc2EAAAADAQABAAABAQDAY5gSpWQ89ELcY2Yszi2y7YKESZEjvV6vJqp1jXSOSynDIGJl4wUVHGYLG4Ukj8KmDfeoB5suN/Fuh/APTVFQSb8Nc3DzLDNcChzdZVegcS1RiWf2hUjihqgPlhfl3s0Utgros+Z3AwstQwem/R3GTIJffj2Cj8kALsrYy4fmqEFNUT8dCvZKPpKVYNRs9ZtBI0O0YYkIHfJREmcK1ecQqRR+KEvC/pOG9o4Uj3w1cBQndGTjyii4G7ESx8X77p/ML8nb7G84OIVtKP8TqvftaDPPPfHsnzVHzk6LzRGkbLQDsaZeOGEe+UAYzbsyAS3Wyqbox0q18Kitlvb+u5Rx", 
        "ansible_swapfree_mb": 2046, 
        "ansible_swaptotal_mb": 2047, 
        "ansible_system": "Linux", 
        "ansible_system_capabilities": [
            ""
        ], 
        "ansible_system_capabilities_enforced": "True", 
        "ansible_system_vendor": "innotek GmbH", 
        "ansible_uptime_seconds": 973, 
        "ansible_user_dir": "/home/vagrant", 
        "ansible_user_gecos": "vagrant", 
        "ansible_user_gid": 1000, 
        "ansible_user_id": "vagrant", 
        "ansible_user_shell": "/bin/bash", 
        "ansible_user_uid": 1000, 
        "ansible_userspace_architecture": "x86_64", 
        "ansible_userspace_bits": "64", 
        "ansible_virtualization_role": "guest", 
        "ansible_virtualization_type": "virtualbox", 
        "gather_subset": [
            "all"
        ], 
        "module_setup": true
    }, 
    "changed": false
}

Ansible-CMDB & WEB-Server 만들기 

# yum install nginx -y   
 
- Ansible Server : 192.168.56.50 이고
- /usr/share/nginx/html/index.html       / WEB-server html 경로  
 
- page 확인

Ansible-cmdb 설치

https://ansible-cmdb.readthedocs.io/en/latest/installation                     * 설치주소 참조
 
# git clone https://github.com/fboender/ansible-cmdb.git                       *  git으로 설치함
   /usr/local/lib/ansible-cmdb                                                                    * 왼쪽 경로로 디렉토리가 생성됨

# cd /usr/local/lib/ansible-cmdb

# sudo bash -c ". build.sla && install"                                                       * ansible-cmdb 설치파일 
   Installed in /usr/local/

   /usr/local/lib/ansible-cmdb/ansible-cmdb.py                                           * 이게 설치파일인가 보다

# /usr/bin/./python /usr/local/lib/ansible-cmdb/ansible-cmdb.py                 * 파이선으로 돌리라고 함
  
# cd /usr/local/lib/ansible-cmdb                                                                   * 이 경로로 가서
 
# mkdir out                                                                                                   * out 디렉토리로 생성

$ ansible -m setup --tree /usr/local/lib/ansible-cmdb/out/ all   (vagrant 계정으로)
  위 명령을 root로 실행하니 ssh_keyscan 값이 없어서 에러남 
  vagrant 계정으로 ssh_keyscan 으로 생성되어 있으므로 vargant 스크립트 돌림

 

# ansible-cmdb -i /etc/ansible/hosts out/ > /usr/share/nginx/html/ansible-cmdb.html 
                                                                                                                      * cmdb 데이터를 web서버 경로로 생성
   /usr/share/nginx/html/   html 경로 퍼미션을 일단 777로 하고 root로 돌림
   (vagrant 계정이로 돌리니 html 디렉토리 퍼미션 에러,,일단 퍼미션은 나중에 맞추기로 함)

# http://192.168.56.50/ansible-cmdb.html 파일 확인

# 호스트 서버 ip를 클릭하면 # ansible -m setup 셋업으로 추출된 정보가 표출됨

설치준비

# CentOS 8 
# CentOS 2대
- EDB-R1 : DB서버                    (모니터링을 당할 DB서버 / PEM-Agent 설치 추가)
- EDB-PEM : PEM DB서버        (모니터링 수집서버, 웹서버, EPM 서버)

# CentOS8 의 경우 기존 /etc/yum.repos.d/ 주소를 다음과 같이 변경함(2023. 1~ 이후 기존 repo 주소 안됨)

# sudo sed -i -e "s|mirrorlist=|#mirrorlist=|g" /etc/yum.repos.d/CentOS-*
# sudo sed -i -e "s|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g" /etc/yum.repos.d/CentOS-*
  (/etc/yum.repos.d/파일의 미러주소를 mirror.centos... 에서 vault.centos.... 로 최신화) 

EDB 홈페이지 회원가입 - EDB 레포사이트 등록 

# https://www.enterprisedb.com/                                                                       / 회원가입 및 로그인
# https://www.enterprisedb.com/downloads/postgres-postgresql-downloads   / 각종 다운로드 사이트 주소

# EDB repo 주소를 /etc/yum.repos.d/에 추가함  
  - 위에 EDB Repo Token 값을 복사해야됨  - 아래 {     }  안의 값이 Token 값 붙혀넣기

# curl -1sLf 'https://downloads.enterprisedb.com/{OtRhf....v0j}/enterprise/setup.rpm.sh' | sudo -E bash

(폐쇄망에서는 EDB 전체 설치파일을 서버에 올려서 작업필요)

 

EDB v14설치 

==================== EDB 14 ver 설치방법 =======================================
# 설치 및 참고 주소 : https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
   (해당 os 클릭하면 설치방법 아래와 같이 나옴) 

# Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:
sudo dnf -qy module disable postgresql

# Install PostgreSQL:
sudo dnf install -y postgresql14-server

# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14 sudo systemctl start postgresql-14


# 설치가 끝나면  주요 파일 위치
/etc/passwd  postgres 계정이 생성됨
tcp 5432 port 가 생성됨
/usr/pgsql-14/bin                                      / psql 등 실행파일
/var/lib/pgsql/14/data                               / pg_hba.conf     postgresql.conf 등 환경 설정파일

# /var/lib/pgsql/15/data/postgresql.conf
listen_addresses = 'localhost' 를 listen_addresses = '*' 로 변경

#/var/lib/pgsql/15/data/pg_hba.conf
host all all 0.0.0.0/0 scram-sha-256                        / 줄  추가

host all all 0.0.0.0/0 trust                                         / superuser 패스워드 없이 로그인시 줄 추가
(간혹 superuser 패스워드를 모를경우 trust mode로 설정하고
HeidiSQL 툴로 패스워드 없이 접속하여 superuser 초기 패스워드 변경)

# systemctl restart postgresql-14                               / 시스템 환경 변경시  restart는 필수

# 또는 

# /usr/pgsql-14/bin/./psql                                                                        #  관리자 모드로 진입 (postgre 계정으로 )
$ postgres=# alter user postgres with password `!........2'; 안먹힐때
$ postgres=# \password postgres
   Enter new password:<new-password>
$ postgres=# \q


# DB서버를 EDB-PEM으로 수집당해야 되기 때문에 EDB-PEM Agent를 설치함

# PEM Agent Install 

# yum install edb-pem-agetn 
# Agent 등록:(PEM repo database 에 등록)
export PEM_SERVER_PASSWORD=PEM-DB-PASSWD     /  -PEM에 설치되는 EDB superuser password 임


# /usr/edb/pem/agent/bin/pemworker --register-agent
 Postgres Enterprise Manager Server Hostname: 192.168.56.XX       / PEM 서버 IP 
 Postgres Enterprise Manager Server Username: enterprisedb           / PEM superuser user 이름
 Postgres Enterprise Manager Server Port: 5444                                 / PEM 서비스 포트
 Postgres Enterprise Manager Agent registered successfully!             

# Agent 설정 변경
 sed -i ‘/heartbeat_connection=false/heartbeat_connection=true/g’ /usr/edb/pem/agent/etc/agent.cfg

#  Agent 시작
 systemctl enable --now pemagent
 systemctl start pemagent

 EDB-PEM 서버 설치

# 설치
  dnf –y install edb-as14-server edb-pem

# DB 생성
  PGSETUP_INITDB_OPTIONS="-E UTF-8" /usr/edb/as14/bin/edb-as-14-setup initdb

#DB 설정 변경 및 상태 확인
  systemctl enable --now edb-as-14
  systemctl status edb-as-14

#  환경파일 설치가 끝나면 기본 경로

/etc/passwd                                   /    enterprisedb  계정이 생성됨
tcp 5444 port 가 생성됨
/usr/edb/as14                                 / edb 실행파일 경로
/usr/edb/pem                                  / edb pem 실행파일 경로
/var/lib/edb/as14/data                       / pg_hba.conf     postgresql.conf 등 환경 설정파일


# 방화벽 등 포트 오픈 또는 Disable
  firewall-cmd --permanent --zone=public --add-port=8443/tcp
  firewall-cmd –reload
  또는
   systemctl disable firewalld

# Agent 서버에 접속하게 pg_hba.conf 설정
vi $PGDATA/pg_hba.conf
host all all 0.0.0.0/0 scram-sha-256 << 추가

# edb pem 서버 db설치 (Config PEM)
  /usr/edb/pem/bin/configure-pem-server.sh

-------------------------- EDB Postgres Enterprise Manager --------------------------
Install type: 1:Web Services and Database, 2:Web Services 3: Database [ ] :1
Enter local database server installation path (i.e. /usr/edb/as12 , or /usr/pgsql-12, etc.) [ ] :/usr/edb/as14
Enter database super user name [ ] :enterprisedb
Enter database server port number [ ] :5444
Enter database super user password [ ] :  (여기서 문제임!!!!!!)
Please enter CIDR formatted network address range that agents will connect to the server from, to be added to the server's pg_hba.conf file. For example, 192.168.1.0/24 [ 0.0.0.0/0 ] : 0.0.0.0/0
Enter database systemd unit file or init script name (i.e. edb-as-12 or postgresql-12, etc.) [ ] :edb-as-14
Please specify agent certificate path (Script will attempt to create this directory, if it does not exists) [ /root/.pem/ ] :

# pem Config 설치할때  enterprisedb 의 패스워드를 신규로 설정하거나 묻는게 없어서
   enterprisedb의 초기 패스워드를 모름  (설치 에러남)
  이럴경후  pg_hba.conf 파일의  host all all 0.0.0.0/0 scram-sha-256   ---> 에서  trust mode로 변경하고 
  HeidiSQL 툴로 패스워드 없이 접속하여 superuser 초기 패스워드 변경하여야 함

# pem 추가 서비스 시작
HTTP
# systemctl start httpd.service

EPAS Server
# systemctl start edb-as-14.service

PEM agent
systemctl start pemagent.service

=== 설치완료 ==

PEM 서버 접속 웹화면   https://PEM-IP주소:8443/pem/   로그인은 계정은 enterprisedb 및 password 임

O 추진목적과 개선방안 (심플하게)

O 현황 및 로드맵 또는 문제점, 개선방안 등

O 추진내용

O 추진성과  : 정량, 정성

아래 파일을 다운받아 편집하세요! (구독하기 좋아요!)

KT, SK, LG 인터넷가입 요금, 혜택 비교

[법무법인 서앤율] 개인회생/파산 도산전문 변호사에게 맡기세요.

중고 아이폰 최고가 매입 폰가비

전국 원룸 소형이사 무료 견적 비교

전국 이사 무료 견적 비교

인터넷 신규가입과 통신사 갈아타기, 최대혜택은 믿을수 있는 이곳에서!

 

 

 

 

728x90

반응형

LIST

공유하기

게시글 관리

오픈소스 설치 한글(hwp) 보고서 폼

'한글보고서' 카테고리의 다른 글

한글보고서-003-2  (1)	2023.11.18
한글보고서-003-1  (2)	2023.11.18
한글보고서-008  (1)	2023.11.17
한글보고서-007  (1)	2023.11.17
한글보고서-006  (1)	2023.11.17

한글보고서-008

hwpform 2023. 11. 17. 12:47

2023. 11. 17. 12:47

728x90

반응형

O 방향 : 기존에서 개선

O 분석 (3가지) --> 한일

O 실적 : 개량 또는 비개량 

 

--- > 성과의 그래프는 한글보고서-000 (성과그래프).HWP 파일 참조하

 

 

아래 파일을 다운받아 편집하세요

보고서008.hwp

0.03MB

 

 

KT, SK, LG 인터넷가입 요금, 혜택 비교

[법무법인 서앤율] 개인회생/파산 도산전문 변호사에게 맡기세요.

중고 아이폰 최고가 매입 폰가비

전국 원룸 소형이사 무료 견적 비교

전국 이사 무료 견적 비교

인터넷 신규가입과 통신사 갈아타기, 최대혜택은 믿을수 있는 이곳에서!

 

 

 

 

728x90

반응형

LIST

공유하기

게시글 관리

오픈소스 설치 한글(hwp) 보고서 폼

'한글보고서' 카테고리의 다른 글

한글보고서-003-1  (2)	2023.11.18
한글보고서-009  (0)	2023.11.17
한글보고서-007  (1)	2023.11.17
한글보고서-006  (1)	2023.11.17
한글보고서-005  (2)	2023.11.17

한글보고서-007

hwpform 2023. 11. 17. 12:46

2023. 11. 17. 12:46

728x90

반응형

O 추진절차 : PDCA 등

O 성과 : 6개로 정리 

   - A분야 : 과제 , 추진내용, 효과

   - B분야  : 과제 , 추진내용, 효과

   - C분야  : 과제 , 추진내용, 효과

 

아래 파일을 다운받아 편집하세요

보고서007.hwp

0.04MB

 

 

KT, SK, LG 인터넷가입 요금, 혜택 비교

[법무법인 서앤율] 개인회생/파산 도산전문 변호사에게 맡기세요.

중고 아이폰 최고가 매입 폰가비

전국 원룸 소형이사 무료 견적 비교

전국 이사 무료 견적 비교

인터넷 신규가입과 통신사 갈아타기, 최대혜택은 믿을수 있는 이곳에서!

 

 

 

 

728x90

반응형

LIST

공유하기

게시글 관리

오픈소스 설치 한글(hwp) 보고서 폼

'한글보고서' 카테고리의 다른 글

한글보고서-009  (0)	2023.11.17
한글보고서-008  (1)	2023.11.17
한글보고서-006  (1)	2023.11.17
한글보고서-005  (2)	2023.11.17
한글보고서-004 (추진배경 아래로 화살표 양식)  (0)	2023.11.13

PREV 이전 1···456789 NEXT 다음

+ Recent posts

Powered by Tistory, Designed by wallel

Rss Feed and Twitter, Facebook, Youtube, Google+

티스토리툴바

오픈소스 설치 한글(hwp) 보고서 폼구독하기