Posted on 2013/01/03 23:35
Filed Under Programming/PHP

DNS server, DNS service  

현재 등록된 1.8.5 버전 기준으로, MySQL에 적용할 수 없는 잘못된 테이블 생성 쿼리문을 작성합니다.

따라서 tc 가 설치된 폴더의  setup.php 파일을 아래와 같이 수정합니다.

행의 위치는 버젼에 따라 조금씩 차이는 있으나, 대략 1133 행 근처입니다.

사용자 삽입 이미지

$charset = 'TYPE=MyISAM DEFAULT CHARSET=utf8';

를 아래와 같이 변경

$charset = 'DEFAULT CHARSET=utf8';

한 후 저장합니다.

2013/01/03 23:35 2013/01/03 23:35

Posted on 2012/11/28 14:03
Filed Under Linux/설정방법

DNS server, DNS service  

About istatd

istatd is a daemon serving statistics to your iStat iPhone application from Linux, Solaris & FreeBSD. istatd collects data such as CPU, memory, network and disk usage and keeps the history. Once connecting from the iPhone and entering the lock code this data will be sent to the iPhone and shown in fancy graphs.

What is iStat for iPhone?

iStat is a iPhone application developed by Bjango ( With iStat you can remotely monitor CPU, memory, disks, uptime and load averages from any Mac, Linux or Solaris computer from your iPhone. You can download iStat in iTunes App Store.

How to install

These steps assume you are logged in as root and have GNU build tools installed together with libxml2.

1) Download istatd-x.x.x.tar.gz

   # wget

2) Extract tar ball

   # tar -xvf istatd-0.5.8.tar.gz

3) Install dependencies

   istatd requires GNU build tools, libxml2 and libxml2-devel.
   Depending on your distribution these packages can be diffrently named.

   # yum install libxml2-devel

   # apt-get install libxml2-dev

4) Build istatd

   # cd istatd-x.x.x

   Here you can configure where you want your binary and config to end up (default /usr/local).
   # ./configure
   # ./configure --prefix=/ --sysconfdir=/etc
   # ./configure --prefix=/usr/local/istatd

   # make
   # make install

5) Add user and configure directories

   # useradd istat
   # groupadd -g 150 istat 
   # useradd istat -d /usr/local/istatd -u 150 -g 150 -s /sbin/nologin -g istat

   # mkdir -p /var/{run,cache}/istat
   # chown istat.istat /var/{run,cache}/istat

6) Configure your config to match your needs and system

   # vim /etc/istat.conf
   # vi /usr/local/istatd/etc/istat.conf

   Note: Don't forget to change your server_code.

7) Fire it up

   # /usr/bin/istatd -d
   # /usr/local/istatd/bin/istatd -d
2012/11/28 14:03 2012/11/28 14:03

Posted on 2012/09/23 01:44
Filed Under Linux/설정방법

DNS server, DNS service  

CentOS 상에 MySQL5.5.25 Source Compile 설치.
1. 해당 시스템 상에 root 계정으로 로그인

2. 으로 부터 MySQL-5.5.25.tar.gz 소스 파일 다운로드.

3. wget 다운로드
    MySQL 5.5 버전부터는 크로스 플랫폼을 지원을 위해서 configure 대신 cmake 유틸리티로 변경되었음.

    – tar -zxvf cmake-2.8.8.tar.gz
    -  cd cmake-2.8.8
    -  ./bootstrap
    -  make
    -  make install
    위 설치가 완료되면, /usr/local/bin/cmake 가 생성된 것을 확인할 수 있다.

4. tar -zxvf  MySQL-5.5.25.tar.gz

5. 컴파일 실행


    5.1 cmake 실행 도중,

               — Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH)
                   CMake Error at cmake/readline.cmake:83 (MESSAGE):
                   Curses library not found.  Please install appropriate package, 와 같은 에러 발생 시,

              yum -y install ncurses-devel  실행.

6. make && make install

7. groupadd mysql && useradd -g mysql -d /MySQL -s /bin/false mysql

8. cd /MySQL

9. chown -R mysql.mysql .

10. ./scripts/mysql_install_db —user=mysql

11. chown -R root .

12. chown -R mysql data

13. install -m 755 /MySQL/support-files/my-innodb-heavy-4G.cnf /etc/my.cnf

     vi /etc/my.cnf
       default-storage-engine = InnoDB

     install -m 755 /MySQL/support-files/mysql.server /etc/rc.d/init.d/mysql
     chkconfig —add mysql
     chkconfig —level 3 mysql on
     chkconfig —level 5 mysql on
     /etc/rc.d/init.d/mysql start

     /MySQL/bin/mysql -u root -p mysql
        update user set password=password(‘12345’) where user=‘root’;
         flush privileges;
     /MySQL/bin/mysql -u root -p 12345 
2012/09/23 01:44 2012/09/23 01:44


by CoCo



· Total
: 882337
· Today
: 26
· Yesterday
: 133