#title R-Stuido Server 설치하기

{{{
R설치
sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
sudo yum install tcl
sudo yum clean all
sudo yum install R

R-Stuio 설치
wget http://download2.rstudio.org/rstudio-server-0.97.449-x86_64.rpm
sudo yum install --nogpgcheck rstudio-server-0.97.449-x86_64.rpm

ODBC 설치
wget http://download.microsoft.com/download/B/C/D/BCDD264C-7517-4B7D-8159-C99FC5535680/RedHat6/msodbcsql-11.0.2270.0.tar.gz
tar -xzf msodbcsql-11.0.2270.0.tar.gz
cd msodbcsql-11.0.2270.0

다음의 주소에서 다운로드 --> ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz
unixODBC 다시 인스톨 --> http://msdn.microsoft.com/ko-kr/library/hh568449.aspx --> unixODBC-2.3.0 버전으로...

./build_dm.sh --download-url=file://unixODBC-2.3.0.tar.gz
쪼메 기둘림...

cd /tmp/unixODBC.19477.9801.16933/unixODBC-2.3.0
sudo make install

cd /home/dw_admin/msodbcsql-11.0.2270.0
sudo ./install.sh install
sudo odbcinst -q -d -n "ODBC Driver 11 for SQL Server"
sudo odbcinst -q -d -n "MSSQL36"

FreeTDS 설치
sudo yum install freetds


sudo vi /etc/odbc.ini

[SQLSERVER_36]
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Server=192.168.201.36,1433



테스트..
isql -v SQLSERVER_36 로그인 패스워드



install.packages("RODBC")
library("RODBC")

conn <- odbcConnect("SQLSERVER_36",uid="reader", pwd="rd456$%^")
sqlQuery(conn, sql1)




wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm
 
yum install R


install.packages("gtools")
install.packages("gdata")
install.packages("caTools")
install.packages("gplots", pkgs="/home/dwa2007/gplots_2.11.0.1.tar.gz", repos = NULL)
install.packages("ROCR")

}}}