How to deploy Rstudio server on a linux server, configure SQL Server on the ODBC Remote Access win server

How to deploy Rstudio server on a Linux server, configure ODBC after you remotely access SQL Server through the RODBC package

background: before writing an article that mentions the recent deployment of Rstudio server (building the analytics environment for the data Analysis Team), it took one weeks to set it up. Also yy to this biological son up a loaded name, Mozart, Bach and so on, and yy out the following scene {Jenny, you put the model to Mozart to run a version of the latest results come out ... Ah ha is not a special force lattice. Oh haha ... I am a deployed Rstudio server, this is free, but Rstudio Sererv Pro is charged, what is the difference between the two, see official website description.

Deployment Prerequisites:

The following prerequisites are required:

1. Requires a Linux server (CentOS, version 6.5, 64 bit, 4 cores, 16G RAM)

2. Install SECURECRT on the PC for remote connection to the Linux server. (SecureCRT is an SSH-enabled terminal emulator, which is simply the software that logs on to UNIX or Linux server hosts under Windows)

How 3.Rstudio server is deployed. (official deployment Help documentation)

To download and install the package:

The help document gives a EPEL link (epel:extra Packages for Enterprise Linux), logs on to the Linux server, and downloads the package with root privileges. (wget command Download)

Find the package downloads that match your server version, r and Rstudio server's installation package are all inside, and some commonly used Rstudio company developed R packages such as Ggplot2,dplyr and so on are included. After downloading the installation, install your downloaded package with the ' RPM-IVH ' command, you will be prompted whether to install all 150 packages, select Yes, and then complete the installation.

Install Rstudio Server Basic no pits, less than two hours to be finished.

After loading, you can directly access the browser input: 172.31.127.136:8787 can jump directly to the Rstudio server login page, 172.31.127.136 is your Linux server ip,8787 is Rstudio Server port number, (similar to the SQL Server port number is the 1433,tableau server port number is the 8000,hue port number is 8888)

To create a user:

Next is to create a user, there is an article Zhang Dan teacher wrote multiplayer online collaboration R Development Rstudio server first creates a user group, then adds members to the group, and then posts his code:

~ sudo groupadd hadoop ~ sudo useradd hadoop -g hadoop;~ sudo passwd hadoop ~ sudo adduser hadoop sudo~ sudo mkdir /home/hadoop ~ sudo chown -R hadoop:hadoop /home/hadoop

Interested students can read the original text directly.

To configure ODBC on Linux:

The biggest pit that the entire deployment process encounters is: How to access the SQL Server database on another win server in Rstudio server. It took 3, 4 days to get it done.

The solution to this problem is to configure ODBC on a Linux server, access the SQL Server database through the RODBC package, and ask colleagues if they have some experience to offer to me, and when I say they are surprised at Linux configuration ODBC, they all say, why not configure JDBC ...

Without fruit, so that their own online search for various documents, Kung Fu, find a key article on Linux configuration Unixodbc and FreeTDS access MS SQL Server.

Overall is

Install two things: 1. Install unixodbc;2. Install FreeTDS;

Modified the parameters of three files: odbcinst.ini;freetds.conf; Odbc.ini; For details on how to operate, refer to configuring UNIXODBC and FreeTDS on Linux to access MS SQL Server.

If you are accessing SQL Server from a PC of the win system, it is very simple to configure ODBC. (Two kinds of authentication methods, one is NT, one is account name + password, both methods are very convenient)

The Rstudio server on the Linux server is accessing the database through the user name + password.

#---------

UnixODBC provides Linux support for ODBC, but it is only an ODBC manager, and the ODBC driver for this database is provided to connect to the actual database.

FreeTDS is a free ODBC driver for connecting MS SQL Server and Sybase under Linux
Note that you must first install the UnixODBC and then install the FreeTDS

#---------

Summarize:

Not often with the Linux command, what command does not, direct Baidu, like a crawler when using regular, direct Baidu is learning can be.

Above.

How to deploy Rstudio server on a linux server, configure SQL Server on the ODBC Remote Access win server