NAS

WD My Cloud에 Mysql 설치하기

우성군 13 22059 0

0. 펌웨어 버전 확인하기


apt-get 명령어를 사용하는 모든 강좌는 펌웨어 v03.xx.xx-xxx 에서만 가능합니다.


v04.xx.xx-xxx 버전에서는 무조건 벽돌되니 주의하시길 바랍니다.


펌웨어 다운그레이드 강좌는


http://www.wsgvet.com/iomega/1006


위 링크를 참조하세요.


1. 들어가며


Mysql은 그누보드 같은 홈페이지나, Piwigo 같은 DB가 필요한 서비스에 필수적인 패키지입니다.


My Cloud가 성능은 낮지만 가벼운 웹서버는 충분히 돌릴 수 있습니다.


기존 소스리스트 그대로 설치가 가능하니 따로 글을 올립니다.



2. 소스리스트 확인하기


이전 트랜스미션 설치할 때 sid로 소스리스트를 수정하셨다면 기존 wheezy로 돌리는게 낫습니다.


sid에서도 설치될 것 같지만 아무래도 wheezy 기반이라 wheezy에서 하는게 낫겠죠.



nano /etc/apt/sources.list


위 명령어로 소스리스트를 수정합니다.



deb http://ftp.us.debian.org/debian/ wheezy main

#deb http://ftp.us.debian.org/debian/ sid main

#deb http://ftp.us.debian.org/debian/ experimental main

#deb-src http://ftp.us.debian.org/debian/ wheezy main


위와 같이 되어 있다면 그냥 컨트롤 + X 로 나오면 됩니다.


혹시 다르다면 컨트롤 + K로 다 지우고 


위의 내용을 넣고 컨트롤 + O, 엔터, 컨트롤 + X 로 저장 후 빠져나옵니다.


수정했다면


apt-get update


위 명령어로 소스리스트를 업데이트합니다.



3. mysql 패키지 설치하기



apt-get install mysql-server mysql-client


위 명령어로 설치합니다.


처음에 Do you want to continue [Y/n]? 물어보면 y 엔터누르면 됩니다.


그리고 중간에 파란 화면에 암호를 넣는 부분이 있는데 Mysql DB서버 암호를 설정하는 부분이니 꼭 기억해야 합니다.


같은 암호를 두번 넣으면 됩니다.



WDMyCloud:~# apt-get install mysql-server mysql-client

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

  heirloom-mailx libaio1 libdbd-mysql-perl libhtml-template-perl libmysqlclient18 mysql-client-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5

Suggested packages:

  exim4 mail-transport-agent libipc-sharedcache-perl libterm-readkey-perl tinyca

Recommended packages:

  mailx

The following NEW packages will be installed:

  heirloom-mailx libaio1 libdbd-mysql-perl libhtml-template-perl libmysqlclient18 mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5

  mysql-server-core-5.5

0 upgraded, 11 newly installed, 0 to remove and 77 not upgraded.

Need to get 8205 kB of archives.

After this operation, 83.9 MB of additional disk space will be used.

Do you want to continue [Y/n]? y

Get:1 http://ftp.us.debian.org/debian/ wheezy/main libaio1 armhf 0.3.109-3 [8864 B]

Get:2 http://ftp.us.debian.org/debian/ wheezy/main mysql-common all 5.5.31+dfsg-0+wheezy1 [85.3 kB]

Get:3 http://ftp.us.debian.org/debian/ wheezy/main libmysqlclient18 armhf 5.5.31+dfsg-0+wheezy1 [636 kB]

Get:4 http://ftp.us.debian.org/debian/ wheezy/main libdbd-mysql-perl armhf 4.021-1+b1 [120 kB]

Get:5 http://ftp.us.debian.org/debian/ wheezy/main mysql-client-5.5 armhf 5.5.31+dfsg-0+wheezy1 [1617 kB]

Get:6 http://ftp.us.debian.org/debian/ wheezy/main mysql-server-core-5.5 armhf 5.5.31+dfsg-0+wheezy1 [3495 kB]

Get:7 http://ftp.us.debian.org/debian/ wheezy/main mysql-server-5.5 armhf 5.5.31+dfsg-0+wheezy1 [1760 kB]

Get:8 http://ftp.us.debian.org/debian/ wheezy/main heirloom-mailx armhf 12.5-2 [243 kB]

Get:9 http://ftp.us.debian.org/debian/ wheezy/main libhtml-template-perl all 2.91-1 [72.0 kB]

Get:10 http://ftp.us.debian.org/debian/ wheezy/main mysql-client all 5.5.31+dfsg-0+wheezy1 [83.4 kB]

Get:11 http://ftp.us.debian.org/debian/ wheezy/main mysql-server all 5.5.31+dfsg-0+wheezy1 [83.6 kB]

Fetched 8205 kB in 3min 15s (41.9 kB/s)

Preconfiguring packages ...

Selecting previously unselected package libaio1:armhf.

dpkg: warning: files list file for package 'libxau6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libssh2-1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblockfile1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkrb5-3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libwrap0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtagc0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libcap2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libglib2.0-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgphoto2-port0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpng12-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtalloc2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libevent-2.0-5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libedit2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libldap-2.4-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-client3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgphoto2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtag1c2a:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblua5.1-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpkcs11-helper1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpcre3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-common3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libsensors4:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libx11-6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libnfsidmap2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libbsd0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-common-data:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libjpeg8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libsasl2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libcurl3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtirpc1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkrb5support0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'librtmp0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpcap0.8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libdevmapper1.02.1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libexpat1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libltdl7:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkeyutils1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libreadline5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libantlr3c-3.2-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libasound2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxcb1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtdb1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxpm4:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtag1-vanilla:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblzo2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libogg0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfontconfig1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libmagic1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libk5crypto3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgssglue1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libunistring0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libwbclient0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfuse2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgssapi-krb5-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libparted0debian1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgd2-xpm:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libconfuse0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libexif12:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libffi5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libflac8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libdbus-1-3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxml2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfreetype6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxdmcp6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpam-cap:armhf' missing; assuming package has no files currently installed

(Reading database ... 24825 files and directories currently installed.)

Unpacking libaio1:armhf (from .../libaio1_0.3.109-3_armhf.deb) ...

Selecting previously unselected package mysql-common.

Unpacking mysql-common (from .../mysql-common_5.5.31+dfsg-0+wheezy1_all.deb) ...

Selecting previously unselected package libmysqlclient18:armhf.

Unpacking libmysqlclient18:armhf (from .../libmysqlclient18_5.5.31+dfsg-0+wheezy1_armhf.deb) ...

Selecting previously unselected package libdbd-mysql-perl.

Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_armhf.deb) ...

Selecting previously unselected package mysql-client-5.5.

Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.31+dfsg-0+wheezy1_armhf.deb) ...

Selecting previously unselected package mysql-server-core-5.5.

Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.31+dfsg-0+wheezy1_armhf.deb) ...

Processing triggers for man-db ...

Setting up mysql-common (5.5.31+dfsg-0+wheezy1) ...

Selecting previously unselected package mysql-server-5.5.

dpkg: warning: files list file for package 'libxau6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libssh2-1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblockfile1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkrb5-3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libwrap0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtagc0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libcap2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libglib2.0-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgphoto2-port0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpng12-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtalloc2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libevent-2.0-5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libedit2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libldap-2.4-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-client3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgphoto2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtag1c2a:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblua5.1-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpkcs11-helper1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpcre3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-common3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libsensors4:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libx11-6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libnfsidmap2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libbsd0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libavahi-common-data:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libjpeg8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libsasl2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libcurl3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtirpc1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkrb5support0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'librtmp0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpcap0.8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libdevmapper1.02.1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libexpat1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libltdl7:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libkeyutils1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libreadline5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libantlr3c-3.2-0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libasound2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxcb1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtdb1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxpm4:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libtag1-vanilla:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'liblzo2-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libogg0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfontconfig1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libmagic1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libk5crypto3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgssglue1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libunistring0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libwbclient0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfuse2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgssapi-krb5-2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libparted0debian1:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libgd2-xpm:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libconfuse0:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libexif12:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libffi5:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libflac8:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libdbus-1-3:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxml2:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libfreetype6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libxdmcp6:armhf' missing; assuming package has no files currently installed

dpkg: warning: files list file for package 'libpam-cap:armhf' missing; assuming package has no files currently installed

(Reading database ... 25018 files and directories currently installed.)

Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.31+dfsg-0+wheezy1_armhf.deb) ...

Selecting previously unselected package heirloom-mailx.

Unpacking heirloom-mailx (from .../heirloom-mailx_12.5-2_armhf.deb) ...

Selecting previously unselected package libhtml-template-perl.

Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.91-1_all.deb) ...

Selecting previously unselected package mysql-client.

Unpacking mysql-client (from .../mysql-client_5.5.31+dfsg-0+wheezy1_all.deb) ...

Selecting previously unselected package mysql-server.

Unpacking mysql-server (from .../mysql-server_5.5.31+dfsg-0+wheezy1_all.deb) ...

Processing triggers for man-db ...

Setting up libaio1:armhf (0.3.109-3) ...

Setting up libmysqlclient18:armhf (5.5.31+dfsg-0+wheezy1) ...

Setting up libdbd-mysql-perl (4.021-1+b1) ...

Setting up mysql-client-5.5 (5.5.31+dfsg-0+wheezy1) ...

Setting up mysql-server-core-5.5 (5.5.31+dfsg-0+wheezy1) ...

Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...

[ ok ] Stopping MySQL database server: mysqld.

131225 19:42:12 [Note] Plugin 'FEDERATED' is disabled.

131225 19:42:12 InnoDB: The InnoDB memory heap is disabled

131225 19:42:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins

131225 19:42:12 InnoDB: Compressed tables use zlib 1.2.7

131225 19:42:12 InnoDB: Using Linux native AIO

131225 19:42:12 InnoDB: Initializing buffer pool, size = 128.0M

131225 19:42:12 InnoDB: Completed initialization of buffer pool

131225 19:42:12 InnoDB: highest supported file format is Barracuda.

131225 19:42:13  InnoDB: Waiting for the background threads to start

131225 19:42:14 InnoDB: 5.5.31 started; log sequence number 1595675

131225 19:42:14  InnoDB: Starting shutdown...

131225 19:42:15  InnoDB: Shutdown completed; log sequence number 1595675

[ ok ] Starting MySQL database server: mysqld . ..

[info] Checking for tables which need an upgrade, are corrupt or were

not closed cleanly..

Setting up heirloom-mailx (12.5-2) ...

update-alternatives: using /usr/bin/heirloom-mailx to provide /usr/bin/mailx (mailx) in auto mode

Setting up libhtml-template-perl (2.91-1) ...

Setting up mysql-client (5.5.31+dfsg-0+wheezy1) ...

Setting up mysql-server (5.5.31+dfsg-0+wheezy1) ...

Processing triggers for libc-bin ...

WDMyCloud:~#


위와 같이 진행됩니다.


설치가 완료되었습니다.


wheezy에서 할 수 있는 것은 이게 끝입니다.


다음 강좌는 sid로 소스리스트를 업데이트하고 php관련 소스를 설치할 예정입니다.

, , , ,

13 Comments
우성군 2015.01.04 21:06  
넵 ㅎㅎ 저도 잘 쓰고 있습니다.

성공하셨다니 다행이네요!
이상덕 2015.05.13 02:32  
최신 펌웨어에서는 적용 안되는건가요?? ㅠㅠ 그누보드5 사용하고 싶은데 벽돌 될까봐요~!
우성군 2015.05.14 00:00  
최신 펌웨어에서는 불가능합니다.ㅜ ㅜ

WD커뮤니티에 최신펌웨어에서도 설치 가능한 패키지가 있던데요.

한번 시도해보세요.
Facebook Twitter GooglePlus KakaoStory NaverBand