{"id":901,"date":"2018-08-07T14:54:09","date_gmt":"2018-08-07T23:54:09","guid":{"rendered":"\/blog\/?p=901"},"modified":"2023-09-21T09:37:29","modified_gmt":"2023-09-21T00:37:29","slug":"appdefender-%ec%84%a4%ec%b9%98%eb%a5%bc-%ec%9c%84%ed%95%9c-vertica-database-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=901","title":{"rendered":"AppDefender \uc124\uce58\ub97c \uc704\ud55c Vertica Database \uc124\uce58"},"content":{"rendered":"<p>Download Vertica:&nbsp;<a href=\"https:\/\/my.vertica.com\/download\/vertica\/community-edition\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/my.vertica.com\/download\/vertica\/community-edition\/<\/a><\/p>\n<p>HPE Application Defender\uac00 \uc124\uce58\ub418\uae30 \uc804\uc5d0 Vertica DB\uac00 \uba3c\uc800 \uc124\uce58 \ub418\uace0 DB \uc0dd\uc131\uae4c\uc9c0 \uc644\ub8cc \ub418\uc5b4\uc57c \ud55c\ub2e4.<br>\n&nbsp;<\/p>\n<p>\u25a0 \uad6c\uc131 \ubaa9\ud45c \ubc0f \ud658\uacbd<\/p>\n<p>Vertica DB\ub294 \uc544\ub798 3\uac1c\uc758 \ud074\ub7ec\uc2a4\ud130\ub97c \uad6c\uc131\ud558\uba70 OS\ub294 CentOS 6.9 x86_64\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n<p>10.10.10.41 : Vertica DB #1<br>\n10.10.10.42 : Vertica DB #2<br>\n10.10.10.43 : Vertica DB #3<\/p>\n<p>&nbsp;<\/p>\n<p>\u25a0 Vertica DB \uc124\uce58<br>\n&nbsp;<\/p>\n<p>1. Vertica DB #1,#2,#3\uc5d0\uc11c \uc544\ub798\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c root \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">#!\/bin\/bash\n###########################################################\n#\n# Vertica Database \uc124\uce58 \uc2a4\ud06c\ub9bd\ud2b8 (root\ub85c \uc2e4\ud589)\n#\n# \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 CentOS 6.9 x86_64\uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ub418\uc5c8\uc74c.\n#\n# Vertica #2, #3\uc740 vertica rpm\uc774 \uae30 \uc124\uce58\ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0\n# rpm -e vertica \ub97c \uc2e4\ud589\ud558\uc5ec rpm\uc744 \uc0ad\uc81c\ud55c\ub2e4.\n#\n###########################################################\nUIDGID=8000\n\n###########################################################\n#\n# \uc0ac\uc6a9\uc790 \ucd94\uac00\n#\n###########################################################\ngroupdel verticadba\ngroupdel dbadmin\nuserdel -r dbadmin\ngroupadd -g ${UIDGID} verticadba\nadduser -u ${UIDGID} -g verticadba -c \"Vertica Database\" -d \/home\/dbadmin dbadmin\necho \"################################################\"\necho \"#\"\necho \"# PLEASE, ENTER NEW dbadmin PASSWORD.\"\necho \"#\"\necho \"################################################\"\npasswd dbadmin\nchown -R dbadmin:verticadba \/opt\n\n###########################################################\n#\n# \uc2dc\uc2a4\ud15c \uc14b\ud305\n#\n###########################################################\necho \"SELINUX=disabled\" >> \/etc\/selinux\/config\necho \"\" >> \/etc\/sysctl.conf\necho \"# Vertica DB Section\" >> \/etc\/sysctl.conf\necho \"vm.swappiness = 1\" >> \/etc\/sysctl.conf\necho \"kernel.pid_max = 524288\" | tee -a \/etc\/sysctl.conf\necho \"vm.max_map_count = 252472\" | tee -a \/etc\/sysctl.conf\necho \"fs.file-max = 65536\" | tee -a \/etc\/sysctl.conf\nsysctl -p\n\necho \"# Vertica DB Section\" >> \/etc\/pam.d\/su\necho \"session         required        pam_limits.so\" >> \/etc\/pam.d\/su\n\necho \"# Vertica DB Section\" >> \/etc\/security\/limits.conf\necho \"dbadmin   -       nproc   4096\" >> \/etc\/security\/limits.conf\necho \"dbadmin   -       nice    0\" >> \/etc\/security\/limits.conf\necho \"dbadmin   soft    nofile  65536\" >> \/etc\/security\/limits.conf\necho \"dbadmin   hard    nofile  65536\" >> \/etc\/security\/limits.conf\n\necho \"\" >> \/etc\/rc.d\/rc.local\necho \"# Vertica DB Section\" >> \/etc\/rc.d\/rc.local\necho \"echo deadline > \/sys\/block\/sda\/queue\/scheduler\" >> \/etc\/rc.d\/rc.local\necho \"echo always > \/sys\/kernel\/mm\/transparent_hugepage\/enabled\" >> \/etc\/rc.d\/rc.local\necho \"\/sbin\/blockdev --setra 2048 \/dev\/sda\" >> \/etc\/rc.d\/rc.local\necho \"\/sbin\/blockdev --setra 2048 \/dev\/mapper\/vg_centos6-lv_root\" >> \/etc\/rc.d\/rc.local\necho \"\/usr\/sbin\/setenforce 0\" >> \/etc\/rc.d\/rc.local\necho \"if test -f \/sys\/kernel\/mm\/redhat_transparent_hugepage\/enabled; then\" >> \/etc\/rc.d\/rc.local\necho \"   echo never > \/sys\/kernel\/mm\/redhat_transparent_hugepage\/enabled\" >> \/etc\/rc.d\/rc.local\necho \"fi\" >> \/etc\/rc.d\/rc.local\n\necho \"\">> \/home\/dbadmin\/.bash_profile\necho \"# Vertica DB Section\">> \/home\/dbadmin\/.bash_profile\necho \"PATH=\/opt\/vertica\/bin:\/opt\/vertica\/sbin:\/opt\/vconsole\/bin:\/opt\/vconsole\/sbin:\\$PATH\">> \/home\/dbadmin\/.bash_profile\necho \"export PATH\">> \/home\/dbadmin\/.bash_profile\necho \"export TZ=\\\"Asia\/Seoul\\\"\">> \/home\/dbadmin\/.bash_profile\n\n###########################################################\n#\n# \ud328\ud0a4\uc9c0 \uc124\uce58\n#\n###########################################################\nyum -y install dialog\nyum -y install ntp\nyum -y install pstack\nyum -y install mcelog\nyum -y install sysstat\nyum -y install tzdata\nchown -R dbadmin:verticadba \/opt\nchkconfig --level 2345 ntpd on\nchkconfig --level 2345 iptables off\n\n###########################################################\n#\n# \uc2dc\uac04 \ub3d9\uae30\ud654\n#\n###########################################################\nrdate -s time.bora.net\nhwclock --systohc\n\nclear\necho \"################################################\"\necho \"#\"\necho \"# PLEASE, REBOOT THIS SYSTEM\"\necho \"#\"\necho \"################################################\"\n<\/pre>\n\n\n<p><!-- \/wp:post-content --><br>\n<!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p>&nbsp;<\/p>\n<p>2. Vertica DB #1\uc5d0\uc11c \uc544\ub798\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec Vertica RPM \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud55c\ub2e4.<\/p>\n<p><!-- wp:syntaxhighlighter\/code {\"language\":\"bash\"} --><\/p>\n<pre class=\"wp-block-syntaxhighlighter-code\">#!\/bin\/bash\n###########################################################\n#\n# Vertica Database \uc124\uce58 \uc2a4\ud06c\ub9bd\ud2b8 (root\ub85c \uc2e4\ud589)\n#\n# \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 CentOS 6.9 x86_64\uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ub418\uc5c8\uc74c.\n#\n###########################################################\n\n###########################################################\n#\n# \ud328\ud0a4\uc9c0 \uc124\uce58\n#\n###########################################################\nrpm -Uvh vertica-console-9.0.1-0.x86_64.RHEL6.rpm\nrpm -Uvh vertica-9.0.1-0.x86_64.RHEL6.rpm\n<\/pre>\n<p><!-- \/wp:syntaxhighlighter\/code --><br>\n<!-- \/wp:syntaxhighlighter\/code --><br>\n<!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p>&nbsp;<\/p>\n<p>3. Vertica DB #1\uc5d0\uc11c \uc544\ub798\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec ssh \ud0a4\ub97c \ub9cc\ub4e4\uace0 #2\uc640 #3\uc5d0 \ubd84\ubc30\ud55c\ub2e4.<\/p>\n<p><!-- wp:syntaxhighlighter\/code {\"language\":\"bash\"} --><\/p>\n<pre class=\"wp-block-syntaxhighlighter-code\">#!\/bin\/sh\n###########################################################\n#\n# Vertica Database ssh key \uc124\uce58 \uc2a4\ud06c\ub9bd\ud2b8 (root\ub85c \uc2e4\ud589)\n#\n# \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 CentOS 6.9 x86_64\uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ub418\uc5c8\uc74c.\n#\n###########################################################\nVERTICA2_IP=10.10.10.42\nVERTICA3_IP=10.10.10.43\n\nmkdir -p ~\/.ssh\n\necho ssh-keygen\nssh-keygen -q -t rsa -f ~\/.ssh\/vid_rsa -N ''\ncat ~\/.ssh\/vid_rsa.pub &gt; ~\/.ssh\/vauthorized_keys2\ncat ~\/.ssh\/vid_rsa.pub &gt;&gt; ~\/.ssh\/authorized_keys\nchmod 600 ~\/.ssh\/*\n\nclear\necho ssh-mkdir: root@${VERTICA2_IP} password ?\nssh root@${VERTICA2_IP} \"mkdir -p ~\/.ssh\"\necho ssh-mkdir: root@${VERTICA3_IP} password ?\nssh root@${VERTICA3_IP} \"mkdir -p ~\/.ssh\"\n\nclear\necho scp: root@${VERTICA2_IP} password ?\nscp -r ~\/.ssh\/vauthorized_keys2 root@${VERTICA2_IP}:~\/.ssh\/.\necho scp: root@${VERTICA3_IP} password ?\nscp -r ~\/.ssh\/vauthorized_keys2 root@${VERTICA3_IP}:~\/.ssh\/.\n\nclear\necho ssh-cat: root@${VERTICA2_IP} password ?\nssh root@${VERTICA2_IP} \"cat ~\/.ssh\/vauthorized_keys2 &gt;&gt; ~\/.ssh\/authorized_keys; chmod 600 ~\/.ssh\/authorized_keys\"\necho ssh-cat: root@${VERTICA3_IP} password ?\nssh root@${VERTICA3_IP} \"cat ~\/.ssh\/vauthorized_keys2 &gt;&gt; ~\/.ssh\/authorized_keys; chmod 600 ~\/.ssh\/authorized_keys\"\n\nclear\necho ssh-rm\nssh -i ~\/.ssh\/vid_rsa root@${VERTICA2_IP} \"rm ~\/.ssh\/vauthorized_keys2\"\nssh -i ~\/.ssh\/vid_rsa root@${VERTICA3_IP} \"rm ~\/.ssh\/vauthorized_keys2\"\n\nrm ~\/.ssh\/vauthorized_keys2\n\nclear\necho \"VerticaDB Private Key file: ~\/.ssh\/vid_rsa\"\n<\/pre>\n<p><!-- \/wp:syntaxhighlighter\/code --><br>\n<!-- \/wp:syntaxhighlighter\/code --><br>\n<!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p>&nbsp;<\/p>\n<p>4. Vertica DB #1,#2,#3\uc744 \ubaa8\ub450 \ub9ac\ubd80\ud305 \ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>5. https:\/\/10.10.10.41:5450\uc5d0\uc11c \uc811\uc18d\ud558\uc5ec \uc544\ub798\uc640 \uac19\uc740 \uacfc\uc815\uc73c\ub85c \ud074\ub7ec\uc2a4\ud130\uc640 DB\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install00.png\" data-file-srl=\"6966\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0066.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install01.png\" data-file-srl=\"6967\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0439.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install02.png\" data-file-srl=\"6968\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0548.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install03.png\" data-file-srl=\"6969\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0218.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install04.png\" data-file-srl=\"6970\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0906.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install05.png\" data-file-srl=\"6971\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0014.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install06.png\" data-file-srl=\"6972\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0949.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install07.png\" data-file-srl=\"6973\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0839.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install08.png\" data-file-srl=\"6974\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0827.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install09.png\" data-file-srl=\"6975\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0566.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install10.png\" data-file-srl=\"6976\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0100.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install11.png\" data-file-srl=\"6977\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0007.png\"><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" alt=\"vertica_install12.png\" data-file-srl=\"6978\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0056.png\"><\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Download Vertica:&nbsp;https:\/\/my.vertica.com\/download\/vertica\/community-edition\/ HPE Application Defender\uac00 \uc124\uce58\ub418\uae30 \uc804\uc5d0 Vertica DB\uac00 \uba3c\uc800 \uc124\uce58 \ub418\uace0 DB \uc0dd\uc131\uae4c\uc9c0 \uc644\ub8cc \ub418\uc5b4\uc57c \ud55c\ub2e4. &nbsp; \u25a0 \uad6c\uc131 \ubaa9\ud45c \ubc0f \ud658\uacbd Vertica DB\ub294 \uc544\ub798 3\uac1c\uc758 \ud074\ub7ec\uc2a4\ud130\ub97c \uad6c\uc131\ud558\uba70 OS\ub294 CentOS 6.9 x86_64\ub97c \uc0ac\uc6a9\ud55c\ub2e4. 10.10.10.41 : Vertica DB #1 10.10.10.42 : Vertica DB #2 10.10.10.43 : Vertica DB #3 &nbsp; \u25a0 Vertica DB \uc124\uce58 &nbsp; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-901","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=901"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/901\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}