Install SQL Server on Linux

From Lianjapedia
Jump to: navigation, search

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
Installer: Language Selection



Select the language for installation, then click OK:

Installer: Welcome



The welcome page will be displayed.

Click Forward:

Installer: License



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.


Installer: Components



After accepting the License Agreement, the installation will continue

Make sure 'Lianja SQL Server' is checked, then click Forward.


Installer: Ready to Install



Click Forward to begin the installation

If you do not want the installation to begin, click Cancel


Installer: Finished


Once the installer has finished, uncheck the box if you do not want to view the Readme File, then click Finish.


Installer: Readme


Click OK to exit the Readme.

Managing the Lianja Server

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


Managing the Lianja Server


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

$ sudo 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.

$ sudo cd /opt/lianja/server/dist
$ sudo ./postinstall.sh /opt/lianja/server odbc

For information on setting up ODBC data sources, see unixODBC without the GUI.