#!\/bin\/sh<\/p>\n
# written by Joo woo kwon – Oct 4 2007
\necho “\uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 mysql5.0.x apache2.2.x \ubc84\uc804\uc774\uc678\uc5d0\uc11c\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \ub3d9\uc791\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.”
\nsleep 1
\n# \uc0ac\uc6a9\uc790 \uacc4\uc815 \ucd94\uac00
\necho “ftp \uacc4\uc815\uc744 \ucd94\uac00\ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?(y\/n)”<\/p>\n
read answer1<\/p>\n
while [[ “$answer1” != “y” && “$answer1” != “n” && “$answer1” != “Y” && “$answer1” != “N” ]]
\ndo
\necho “\uc798\ubabb \uc785\ub825\ud558\uc168\uc2b5\ub2c8\ub2e4. y \ub098 n \uc73c\ub85c \uc785\ub825\ud574 \uc8fc\uc138\uc694.”
\nread answer1
\ndone<\/p>\n
if [ “$answer1” = y -o “$answer1” = Y ]
\nthen
\necho “\ucd94\uac00\ud560 \uacc4\uc815\uc774\ub984\uc744 \uc785\ub825\ud574 \uc8fc\uc138\uc694.”
\nread username
\necho ” ”
\necho “$username \uc5d0\uc11c \uc0ac\uc6a9\ud560 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud574 \uc8fc\uc138\uc694.”
\nif \/usr\/sbin\/useradd $username; then
\n\/usr\/bin\/passwd $username
\nchmod 701 \/home\/$username
\necho “$username \uacc4\uc815\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.”
\nelse
\necho ” ”
\necho “\uacc4\uc815 \uc0dd\uc131\uc5d0 \uc2e4\ud328 \ud558\uc600\uc2b5\ub2c8\ub2e4. ERROR \ub77c\uc778\uc744 \ud655\uc778 \ud558\uc2dc\uace0 \ub2e4\uc2dc \uc2dc\ub3c4\ud558\uc138\uc694.”
\necho ” ”
\nfi
\nelse [ “$answer1” = n -o “$answer1” = N ]
\necho “ftp \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.”
\nfi<\/p>\n
sleep 1
\necho ” ”<\/p>\n
# Database \ucd94\uac00
\necho “DB \uacc4\uc815\uc744 \ucd94\uac00 \ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?(y\/n)”<\/p>\n
read answer2<\/p>\n
while [[ “$answer2” != “y” && “$answer2” != “n” && “$answer2” != “Y” && “$answer2” != “N” ]]
\ndo
\necho “\uc798\ubabb \uc785\ub825\ud558\uc168\uc2b5\ub2c8\ub2e4. y \ub098 n \uc73c\ub85c \uc785\ub825\ud574 \uc8fc\uc138\uc694.”
\nread answer2
\ndone<\/p>\n
if [ “$answer2” = y -o “$answer2” = Y ]
\nthen<\/p>\n
if netstat -nat | grep LISTEN | grep 3306 1>\/dev\/null
\nthen
\necho “\ucd94\uac00\ud560 DB\uba85\uc744 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nread db
\necho ” ”
\necho “\uc0ac\uc6a9\ud560 DB user\uba85\uc744 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nread db_user
\necho ” ”
\necho “$db_user\uac00 \uc0ac\uc6a9\ud560 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nread passwd
\necho ” ”
\necho “create database $db;” >> query
\necho “use mysql;” >> query
\necho “insert into user (host,user,password) values(‘localhost’,’$db_user’,password(‘$passwd’));” >> query
\necho “insert into db values(‘localhost’,’$db’,’$db_user’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’);” >> query
\necho “flush privileges” >> query
\necho “mysql root\uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825 \ud558\uc138\uc694.”
\necho “mysql root\uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74, \uadf8\ub0e5 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nif \/usr\/local\/mysql\/bin\/mysql -u root -p < query; then
\necho ” ”
\necho “mysql db \ubc0f \uacc4\uc815\uc774 \ucd94\uac00 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 \uc811\uc18d\uc744 \ud558\uc138\uc694.”
\necho ” ”
\necho “\/usr\/local\/mysql\/bin\/mysql -u $db_user -p $db”
\necho ” ”
\nelse
\necho ” ”
\necho “DB \uc0dd\uc131\uc5d0 \uc2e4\ud328 \ud558\uc600\uc2b5\ub2c8\ub2e4. ERROR \ub77c\uc778\uc744 \ud655\uc778 \ud558\uc2dc\uace0 \ub2e4\uc2dc \uc2dc\ub3c4\ud558\uc138\uc694.”
\necho ” ”
\nfi
\nrm -rf query
\nelse
\necho “mysql \ub370\ubaac\uc774 \uc2e4\ud589\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.”
\necho “mysql \ub370\ubaac\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.”
\necho ” ”
\n\/usr\/local\/mysql\/share\/mysql\/mysql.server start
\necho ” ”
\necho “\ucd94\uac00\ud560 DB\uba85\uc744 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nread db
\necho ” ”
\necho “\uc0ac\uc6a9\ud560 DB user\uba85\uc744 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694”
\nread db_user
\necho ” ”
\necho “$db_user\uac00 \uc0ac\uc6a9\ud560 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nread passwd
\necho ” ”
\necho “create database $db;” >> query
\necho “use mysql;” >> query
\necho “insert into user (host,user,password) values(‘localhost’,’$db_user’,password(‘$passwd’));” >> query
\necho “insert into db values(‘localhost’,’$db’,’$db_user’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’);” >> query
\necho “flush privileges” >> query
\necho “mysql root\uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825 \ud558\uc138\uc694.”
\necho “mysql root\uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74, \uadf8\ub0e5 \uc5d4\ud130\ub97c \uce58\uc138\uc694.”
\nif \/usr\/local\/mysql\/bin\/mysql -u root -p < query; then
\necho ” ”
\necho “mysql db \ubc0f \uacc4\uc815\uc774 \ucd94\uac00 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 \uc811\uc18d\uc744 \ud558\uc138\uc694.”
\necho ” ”
\necho “\/usr\/local\/mysql\/bin\/mysql -u $db_user -p $db”
\necho ” ”
\nelse
\necho ” ”
\necho “DB \uc0dd\uc131\uc5d0 \uc2e4\ud328 \ud558\uc600\uc2b5\ub2c8\ub2e4. ERROR \ub77c\uc778\uc744 \ud655\uc778 \ud558\uc2dc\uace0 \ub2e4\uc2dc \uc2dc\ub3c4\ud558\uc138\uc694.”
\necho ” ”
\nfi
\nrm -rf query
\nfi
\nelse [ “$answer2” = n -o “$answer2” = N ]
\necho “DB \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.”
\nfi<\/p>\n
sleep 1
\necho ” ”<\/p>\n
# \uac00\uc0c1\ud638\uc2a4\ud2b8 \ucd94\uac00
\necho “\uac00\uc0c1\ud638\uc2a4\ud2b8 \ucd94\uac00\ub97c \ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?(y\/n)”<\/p>\n
read answer3<\/p>\n
while [[ “$answer3” != “y” && “$answer3” != “n” && “$answer3” != “Y” && “$answer3” != “N” ]]
\ndo
\necho “\uc798\ubabb \uc785\ub825\ud558\uc168\uc2b5\ub2c8\ub2e4. y \ub098 n \uc73c\ub85c \uc785\ub825\ud574 \uc8fc\uc138\uc694.”
\nread answer3
\ndone<\/p>\n
if [ “$answer3” = y -o “$answer3” = Y ]
\nthen<\/p>\n
today=$(date +%y-%m-%d)
\nip=$(ifconfig | grep Bcast | awk ‘{print $2}’|cut -d: -f2)<\/p>\n
echo “\ucd94\uac00\ud560 \ub3c4\uba54\uc778\uc744 \uc785\ub825 \ud558\uc138\uc694. ex) hostway.co.kr”
\nread domain<\/p>\n
echo “DocumentRoot \ub514\ub809\ud1a0\ub9ac\ub97c \uc785\ub825\ud558\uc138\uc694. ex) \/home\/hostway\/public_html”
\nread Documentroot<\/p>\n
echo “\uad00\ub9ac\uc790 e-mail \uc8fc\uc18c\ub97c \uc785\ub825\ud558\uc138\uc694. ex) admin@hostway.co.kr<\/a>” if cat \/usr\/local\/apache2\/conf\/httpd.conf | grep vhost | grep “#” 1>\/dev\/null #!\/bin\/sh # written by Joo woo kwon – Oct 4 2007 echo “\uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 mysql5.0.x apache2.2.x \ubc84\uc804\uc774\uc678\uc5d0\uc11c\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \ub3d9\uc791\ud558\uc9c0 \uc54a\uc744<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/134"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=134"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/134\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=134"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nread “email”<\/p>\n
\nthen
\nperl -pi -e ‘s\/#Include conf\/extra\/httpd-vhosts.conf\/Include conf\/extra\/httpd-vhosts.conf\/g’\u00a0 \/usr\/local\/apache2\/conf\/httpd.conf
\nmv \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf-$today
\necho “NameVirtualHost $ip” > \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ” ” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho “<VirtualHost $ip>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0ServerAdmin $email” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0DocumentRoot $Documentroot” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0ServerName $domain” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0ServerAlias www.$domain<\/a>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0ErrorLog logs\/$domain-error_log” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0CustomLog logs\/$domain-access_log common” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho “<\/VirtualHost>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\nsleep 1
\necho “\uac00\uc0c1\ud638\uc2a4\ud2b8 \ucd94\uac00 \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.”
\necho “ftp \uc811\uc18d\uc744 \ud558\uc154\uc11c $Documentroot \ub514\ub809\ud1a0\ub9ac\uc5d0 \ud648\ud398\uc774\uc9c0 \uc790\ub8cc\ub97c \uc5c5\ub85c\ub4dc \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.”
\n\/usr\/local\/apache2\/bin\/apachectl restart
\nelse
\ncp \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf-$today
\necho ” ” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho “<VirtualHost $ip>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 ServerAdmin $email” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 DocumentRoot $Documentroot” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 ServerName $domain” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 ServerAlias www.$domain<\/a>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 ErrorLog logs\/$domain-error_log” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho ”\u00a0 CustomLog logs\/$domain-access_log common” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\necho “<\/VirtualHost>” >> \/usr\/local\/apache2\/conf\/extra\/httpd-vhosts.conf
\nsleep 1
\necho “\uac00\uc0c1\ud638\uc2a4\ud2b8 \ucd94\uac00 \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.”
\necho “ftp \uc811\uc18d\uc744 \ud558\uc154\uc11c $Documentroot \ub514\ub809\ud1a0\ub9ac\uc5d0 \ud648\ud398\uc774\uc9c0 \uc790\ub8cc\ub97c \uc5c5\ub85c\ub4dc \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.”
\n\/usr\/local\/apache2\/bin\/apachectl restart
\nfi
\nelse [ “$answer3” = n -o “$answer3” = N ]
\necho “\uac00\uc0c1\ud638\uc2a4\ud2b8\ub97c \ucd94\uac00\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.”
\nfi<\/p>\n","protected":false},"excerpt":{"rendered":"