IT Evangelist (IT 전도사)

 추후 다른 관리자가 사용하기 용이하기 위하여 대부분 시스템을 yum을 이용하여 설치

(qmail관련은 제외)

작업환경

CentOS release 5.5 (Final)

Linux version 2.6.18-194.26.1.el5 (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48))

#명령어

회색 입력되어있는값

빨간색 입력해야되는값

노란색 변경되는값

초록색 주석

#wget http://dev.centos.org/centos/5/CentOS-Testing.repo
#mv CentOS-Testing.repo /etc/yum.repos.d/

# yum update "kernel*"

#yum remove sendmail

#yum install -y bind bind-utils bind-libs bind-chroot caching-nameserver//네임서버 바인드 설치

#ln -s /var/named/chroot/etc/named.caching-nameserver.conf  //심볼릭 링크연결

#vi /var/named/chroot/etc/named.caching-nameserver.conf  //named.caching-nameserver.conf 설정 변경

# vi /var/named/chroot/etc/named.rfc1912.zones               //named.rfc1912.zones 설정 변경 

zone "도메인네임" IN {
        type master;
        file "존파일이름";
        allow-update { none; };
};

# vi /var/named/chroot/var/named/zone-도메인네임        //각각의 도메인에 대한 zone 파일 생성

$TTL    0
@               IN SOA  ns.도메인.       webmaster.도메인. (
                                1               ; serial
                                3H              ; refresh
                                15M             ; retry
                                1W              ; expire
                                0 )            ; minimum(TTL)

                IN NS           ns.도메인.
                IN MX   10      mail.도메인.
@               IN A            ip

www             IN A            ip

#yum -y install mysql mysql-server   //MySQL 설치

#chkconfig --levels 235 mysqld on   //부팅시 MySQL 자동실행등록

#vi /etc/my.cnf                              //PHP ver 5 이상과 Apache 2.x utf-8과 euckr 같이 사용하기 설정 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

#UTF-8과 EUCKR을 같이 사용하기 위한 설정 //추가부분 시작
character-set-server=euckr
default-character-set=euckr
default-collation=euckr_korean_ci
character-set-client-handshake=false

#Error메시지 언어 - 주석이면 영문
language = /usr/share/mysql/korean          //추가부분 끝

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#/etc/init.d/mysql start                   //MySQL 시작

#mysqladmin -u root password 암호 //MySQL 처음 설치시 설정할 암호를 입력

#mysql -u root -p                           //mysql접속
Enter password:암호                     

mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name                  | Value                                |
+--------------------------+----------------------------+
| character_set_client          | euckr                                 |  //euc-kr 페이지는 기본으로 그냥 사용 가능하고

| character_set_connection  | euckr                                 |
| character_set_database    | euckr                                  |
| character_set_filesystem   | binary                                 |
| character_set_results       | euckr                                  |
| character_set_server        | euckr                                  |

| character_set_system       | utf8                                     |  //utf-8 페이지는 set names utf8 쿼리 실행해야 함

| character_sets_dir            | /usr/share/mysql/charsets/ |
| collation_connection         | euckr_korean_ci                  |
| collation_database           | euckr_korean_ci                   |
| collation_server               | euckr_korean_ci                   |
| completion_type               | 0                                        |
| concurrent_insert             | 1                                        |
| connect_timeout               | 10                                      |
+--------------------------+----------------------------+
14 rows in set (0.02 sec)

#yum -y install httpd//아파치 설치

#chkconfig --levels 235 httpd on   //부팅시 아파치 자동실행등록

#vi /etc/httpd/conf/httpd.conf      //모든 언어셋 서비스 가능하게 하기

AddDefaultCharset off                 //AddDefaultCharset을 UTF-8에서 off로 변경

#/etc/init.d/httpd start                   //아파치 시작

#yum --enablerepo=c5-testing freetds //freetds 설치

#vi /etc/freetds.conf   //설정파일 편집

host = 접속할 IP

port = 1433
tds version = 8.0  // MsSQL 2000=8.0
client Charset = UTF-8

# tsql -H IP -p 1433 -U DB계정 -P 비밀번호 //SQL Server 접속 테스트

#yum --enablerepo=c5-testing install php php-mysql php-mssql php-gd php-imap php-odbc php-pear php-xml php-xmlrpc php-devel //PHP 설치
#echo '<?php phpinfo();?>' > var/www/html/phpinfo.php //테스트페이지 생성
#vi /etc/php.ini

extension=mssql.so

extension=imap.so 

#/etc/init.d/httpd restart              //아파치 재시작

#wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm

#rpm -Uvh "rpmforge-release-0.5.2-2.el5.rf.i386.rpm" 

#wget http://sourceforge.net/projects/phpmyadmin/files%2FphpMyAdmin%2F3.3.8.1%2FphpMyAdmin-3.3.8.1-all-languages.tar.gz
#tar -xvf phpMyAdmin-3.3.8.1-all-languages.tar.gz
#mv phpMyAdmin-3.3.8.1-all-languages /var/www/html/phpMyAdmin
# cp config.sample.inc.php config.inc.php
#vi config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'http'; //cookie http로 수정

#/etc/init.d/httpd restart              //아파치 재시작