Difference between revisions of "Install SQL Server on Linux"

From Lianjapedia
Jump to: navigation, search
(→‎Lianja ODBC Driver)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
'''Before you start...'''
+
==See Also==
 +
* [http://www.lianja.com/component/rsfiles/files?folder=Linux Downloads for Linux]
 +
* [[:Category:License Management|License Management]]
 +
* [[Lianja Server Manager on Linux]]
  
 +
==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.
 
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.
 +
 +
<pre>$ sudo yum install libnsl</pre>
  
 
==Installation==
 
==Installation==
−
* Make sure root has execute permission on the downloaded file.  If not, change the file permissions from a terminal window or by right clicking on the file and selecting "properties". (chmod +x)
+
* Make sure root has execute permission on the downloaded file.   
−
* As root or using sudo, run the installer. For 64 bit Red Hat / Centos / Fedora, please run the installer in text mode (--mode text)
+
 
−
* Click '''Forward''' to continue
+
Open up a Terminal window. (e.g. on Ubuntu right click on the desktop and select 'Open Terminal').
−
[[File:Linux_Install_ss1.png|link=|Lianja SQL Server Installation]]
+
 
−
* Read the License Agreement
+
Since 5.1 the distro is a compressed tar file.
−
* Use the scrollbar to display the full text
+
 
−
[[File:Linux_Install_ss2.png|link=|Lianja SQL Server Installation]]
+
<pre>
−
* Click a radio button to accept or reject the License Agreement
+
$ cd
−
* Click '''Forward'''
+
$ cd Downloads
−
* If you select '''I accept the agreement''', the installation will continue
+
$ tar xvf LianjaSQLServer-X.X.X-linux-x64-installer.tar.gz
−
[[File:License_ss_yes.png|link=|Lianja SQL Server Installation]]
+
$ chmod +x LianjaSQLServer-X.X.X-linux-x64-installer.bin
−
* If you select '''I do not accept the agreement''', you will be prompted to abort the installation
+
</pre>
−
* If you click '''Yes''' the installation will stop
+
 
−
* If you click '''No''' you will be returned to the License Agreement
+
Prior to 5.1 it was not a compressed tar file.
−
[[File:License_ss_no.png|link=|Lianja SQL Server Installation]]
+
 
−
* After accepting the License Agreement, the installation will continue
+
<pre>
−
* Make sure 'Lianja SQL Server' is checked
+
$ cd
−
* Click '''Forward'''
+
$ cd Downloads
−
[[File:Linux_Install_ss3.png|link=|Lianja SQL Server Installation]]
+
$ chmod +x LianjaSQLServer-X.X.X-linux-x64-installer.bin
−
* Click '''Forward''' to begin the installation
+
</pre>
−
* If you do not want the installation to begin, click '''Cancel'''
+
 
−
[[File:Linux_Install_ss4.png|link=|Lianja SQL  Server Installation]]
+
* As root or using sudo, run the installer.  
−
* Uncheck the box if you do not want to view the Readme File
+
<pre>$ sudo ./LianjaSQLServer-X.X.X-linux-x64-installer.bin</pre>
−
* Click '''Finish'''
+
 
−
[[File:Linux_Install_ss5.png|link=|Lianja SQL Server Installation]]
+
[[{{ns:file}}:l_ss_install1.png|600px|thumb|left|link={{filepath:l_ss_install1.png}}|Installer: Language Selection]]
 +
 
 +
 
 +
 
 +
 
 +
Select the language for installation, then click '''OK''':
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install2.png|600px|thumb|left|link={{filepath:l_ss_install2.png}}|Installer: Welcome]]
 +
 
 +
 
 +
 
 +
 
 +
The welcome page will be displayed.
 +
 
 +
Click '''Forward''':
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install3.png|600px|thumb|left|link={{filepath:l_ss_install3.png}}|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.
 +
 
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install4.png|600px|thumb|left|link={{filepath:l_ss_install4.png}}|Installer: Components]]
 +
 
 +
 
 +
 
 +
 
 +
After accepting the License Agreement, the installation will continue
 +
 
 +
Make sure 'Lianja SQL Server' is checked, then click '''Forward'''.
 +
 
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install5.png|600px|thumb|left|link={{filepath:l_ss_install5.png}}|Installer: Ready to Install]]
 +
 
 +
 
 +
 
 +
 
 +
Click '''Forward''' to begin the installation
 +
 
 +
If you do not want the installation to begin, click '''Cancel'''
 +
 
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install6.png|600px|thumb|left|link={{filepath:l_ss_install6.png}}|Installer: Finished]]
 +
 
 +
 
 +
 
 +
Once the installer has finished, uncheck the box if you do not want to view the Readme File, then click '''Finish'''.
 +
 
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install7.png|600px|thumb|left|link={{filepath:l_ss_install7.png}}|Installer: Readme]]
 +
 
 +
 
 +
 
 +
Click '''OK''' to exit the Readme.
 +
<br clear=all>
 +
 
 +
==Managing the Lianja Server==
 +
[[{{ns:file}}:l_ss_install8.png|600px|thumb|left|link={{filepath:l_ss_install8.png}}|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:
 +
<pre>$ sudo lianja-admin status</pre>
 +
 
 +
<br clear=all>
 +
 
 +
[[{{ns:file}}:l_ss_install9.png|600px|thumb|left|link={{filepath:l_ss_install9.png}}|Managing the Lianja Server]]
 +
 
 +
 
 +
 
 +
Further lianja-admin options are:
 +
<pre>$ sudo lianja-admin start
 +
$ sudo lianja-admin stop
 +
$ sudo lianja-admin restart</pre>
 +
 
 +
<br clear=all>
 +
 
 +
For more information see [[Lianja Server Manager on Linux]].
 +
 
 +
==Lianja ODBC Driver==
 +
The Lianja ODBC Driver requires the unixODBC package.  To install unixODBC:
 +
 
 +
Ubuntu
 +
 
 +
<pre>$ sudo apt-get install unixodbc</pre>
 +
 
 +
RHEL
 +
 
 +
<pre>$ sudo yum install unixODBC</pre>
 +
 
 +
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.
 +
 
 +
<pre>$ sudo cd /opt/lianja/server/dist
 +
$ sudo ./postinstall.sh /opt/lianja/server odbc</pre>
 +
 
 +
For information on setting up ODBC data sources, see [http://www.unixodbc.org/odbcinst.html unixODBC without the GUI].
  
−
==See Also==
 
−
[[:Category:Lianja Server|Lianja Server]], [[:Category:License Management|License Management]]
 
 
[[Category:Installation| ]]
 
[[Category:Installation| ]]
 +
[[Category:Installation on Linux| Lianja SQL Server]]
 +
[[Category:Lianja SQL Server]]

Latest revision as of 13:07, 12 February 2021

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.

Retrieved from "https://www.lianja.com/doc/index.php?title=Install_SQL_Server_on_Linux&oldid=24319"