Difference between revisions of "Install SQL Server on Linux"
Barrymavin (Talk | contribs) (→Installation) |
Yvonne.milne (Talk | contribs) (→Before you start...) |
||
Line 8: | Line 8: | ||
The Lianja SQL Server includes the Lianja SQL Server and the Lianja ODBC Driver. | The Lianja SQL Server includes the Lianja SQL Server and the Lianja ODBC Driver. | ||
+ | |||
+ | ===RHEL / Centos 8.x=== | ||
+ | The required '''libnsl''' package is no longer provided in the OS glibc package, so should be installed separately. | ||
+ | |||
+ | <pre>$ sudo yum install libnsl</pre> | ||
==Installation== | ==Installation== |
Revision as of 10:24, 15 January 2020
Contents
See Also
Before you start...
Do not run the Lianja SQL Server installer if you have already installed the Lianja Cloud Server. The Lianja Cloud Server installer includes the Lianja Cloud Server, the Lianja SQL Server and the Lianja ODBC Driver.
The Lianja SQL Server includes the Lianja SQL Server and the Lianja ODBC Driver.
RHEL / Centos 8.x
The required libnsl package is no longer provided in the OS glibc package, so should be installed separately.
$ sudo yum install libnsl
Installation
- Make sure root has execute permission on the downloaded file.
Open up a Terminal window. (e.g. on Ubuntu right click on the desktop and select 'Open Terminal').
Since 5.1 the distro is a compressed tar file.
$ cd $ cd Downloads $ tar xvf LianjaSQLServer-X.X.X-linux-x64-installer.tar.gz $ chmod +x LianjaSQLServer-X.X.X-linux-x64-installer.bin
Prior to 5.1 it was not a compressed tar file.
$ cd $ cd Downloads $ chmod +x LianjaSQLServer-X.X.X-linux-x64-installer.bin
- As root or using sudo, run the installer.
$ sudo ./LianjaSQLServer-X.X.X-linux-x64-installer.bin
Select the language for installation, then click OK:
The welcome page will be displayed.
Click Forward:
Read the License Agreement using the scrollbar to display the full text
Click a radio button to accept or reject the License Agreement, then click Forward
If you select I accept the agreement, the installation will continue.
If you select I do not accept the agreement, you will be prompted to abort the installation.
If you click Yes the installation will stop, if you click No you will be returned to the License Agreement.
After accepting the License Agreement, the installation will continue
Make sure 'Lianja SQL Server' is checked, then click Forward.
Click Forward to begin the installation
If you do not want the installation to begin, click Cancel
Once the installer has finished, uncheck the box if you do not want to view the Readme File, then click Finish.
Click OK to exit the Readme.
Managing the Lianja Server
The lianja_admin command is used to manage the Lianja Server and must be run as root or using sudo.
To check that the Lianja Server is running:
$ sudo lianja-admin status
Further lianja-admin options are:
$ sudo lianja-admin start $ sudo lianja-admin stop $ sudo lianja-admin restart
For more information see Lianja Server Manager on Linux.
Lianja ODBC Driver
The Lianja ODBC Driver requires the unixODBC package. To install unixODBC:
Ubuntu
$ sudo apt-get install unixodbc
RHEL
# yum install unixODBC
Now init the ODBC definitions for Lianja. This will define the Lianja ODBC driver in /etc/odbcinst.ini and the lianja_southwind DSN in /etc/odbc.ini.
$ cd /opt/lianja/server/dist $ ./postinstall.sh /opt/lianja/server odbc
For information on setting up ODBC data sources, see unixODBC without the GUI.