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


  • 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:


$ sudo apt-get install unixodbc


# 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
$ ./ /opt/lianja/server odbc

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