Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: MS SQL Server on v15

  1. #11

    Thumbs up Re: MS SQL Server on v15

    If you attempt to install MS SQL Server 2017, you will encounter these error messages:

    Error message:

    Problem: nothing provides openssl < 1.1.0 needed by mssql-server-14.0.3192.2-2.x86_64

    Additional rpm output:
    touch: cannot touch '/var/lib/rpm-state/mssql-sqlagent-disable': No such file or directory

    Hence, to install MS SQL Server 2017 into OpenSuse 15.1, follow these steps:

    1) sudo zypper install python-2.7.14-lp151.9.1

    --Download openssl-1.0.2 and install (reboot)

    2) sudo zypper remove openssl

    3) sudo zypper install /home/Downloads/openssl-1.0.2j-38.1.x86_64.rpm
    Note: Select Option 1

    -- After reboot, download the following the required additional rpm files:

    4) sudo zypper install --oldpackage /home/Downloads/openldap2-2.4.44-18.1.x86_64.rpm
    Note: Select Option 2

    5) sudo zypper install --oldpackage /home/Downloads/libldap-2_4-2-2.4.44-18.1.x86_64.rpm
    Note:Select Option 1

    6) sudo zypper install --oldpackage /home/Downloads/openldap2-client-2.4.44-18.1.x86_64.rpm

    7) sudo mkdir /var/lib/rpm-state/

    8) sudo zypper install mssql-server

    9) sudo /opt/mssql/bin/mssql-conf setup

    10) systemctl status mssql-server
    Note: to verify installation and mssql is running

    ------------------------------------------
    Install the SQL Server command-line tools
    ------------------------------------------

    11) sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/prod.repo

    12) sudo zypper --gpg-auto-import-keys refresh

    13) sudo zypper install mssql-tools unixODBC-devel
    Note: (Select option 1)

    14) echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

    15) echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

    16 source ~/.bashrc

    [Refer to document at 'https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-suse?view=sql-server-2017']

    I created a database and a few database objects with success!

    I will stress the installation soon enough!!

    Have fun!!

  2. #12

    Default Re: MS SQL Server on v15

    Addendum to the post-installation of MS SQL Server 2017:

    ------------------------------------------
    Azure Data Studio INSTALL
    ------------------------------------------

    --Refer to https://docs.microsoft.com/en-us/sql...ver-linux-2017

    --Download file from URL
    https://docs.microsoft.com/en-us/sql...ver-linux-2017

    sudo rpm -ivh /home/Downloads/azuredatastudio-linux-1.9.0.rpm

    ------------------------------------------
    Visual Studio Code INSTALL
    ------------------------------------------

    --Refer to https://docs.microsoft.com/en-us/sql...ver-linux-2017

    sudo zypper install code

    -OR-

    --Download file from URL
    https://code.visualstudio.com/

    rpm -ivh /home/Downloads/code-1.36.1-1562627663.el7.x86_64.rpm

    --Install mssql extension (refer to instructions)

    ------------------------------------------
    Node.js INSTALL
    ------------------------------------------

    sudo zypper --gpg-auto-import-keys addrepo -f https://download.opensuse.org/reposi...es:nodejs.repo

    sudo zypper install nodejs4

    ------------------------------------------
    PowerShell Core on Linux INSTALL
    ------------------------------------------

    --Refer to https://docs.microsoft.com/en-us/pow...w=powershell-6

    --Check for dependencies and install as necessary
    sudo zypper info curl tar gzip libopenssl1_0_0 libicu60_2

    --Download file
    https://github.com/PowerShell/PowerS...nux-x64.tar.gz

    sudo mkdir -p /data/microsoft/powershell/6.2.0

    sudo tar zxf "/home/Downloads/powershell-6.2.0-linux-x64.tar.gz" -C /data/microsoft/powershell/6.2.0

    sudo chmod +x /data/microsoft/powershell/6.2.0/pwsh

    sudo ln -s /data/microsoft/powershell/6.2.0/pwsh /usr/bin/pwsh

    Notes: No issues yet! Hope Microsoft will create a new MS SQLServer release for OpenSuse 15.x soon!!

  3. #13
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,133
    Blog Entries
    2

    Default Re: MS SQL Server on v15

    openssl 1.02 is in the OSS,
    So,
    All those steps to uninstall and install related to openssl can likely be replaced with the following single command, and select option 1
    For anyone who might care, note that this downgrades your system openssl from 1.1.0 to 1.0.2 (as of today).
    Code:
    zypper in openssl-1_0_0
    I'm not clear on your requirement to possibly downgrade your ldap2, did you really find that necessary and could that be because you're running an old version of AD?

    Regarding adding new PATH to access the location of your User Tools...
    Generally I keep my User paths separate from my system paths, anything that should be specific to a logged in User generally points to a location in that User's directory tree while anything that points to a location that requires root permissions I consider equivalent to "system" so would be configured for system-wide access.
    Perhaps someone might comment if my reasoning is flawed,
    But consistent with my personal policy, I'd configure those PATH additions in an /etc/profile.local file instead of as a BASHrc configuration.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  4. #14

    Default Re: MS SQL Server on v15

    Howdy,

    All steps identified originated from six or seven complete installs of OpenSuse 15.1 to eliminate any library and/or dependency issues after many failed MS SQL Server 2017 installations. My goal was to provide everyone the working steps for a clean MS SQL Server 2017 on Linux installation on a fresh OpenSuse 15.1 installation (before any other software installs).

    1) MS SQL Server 2017 on Linux WILL NOT run with current packages of 'openssl', 'openldap2', 'libldap', and 'openldap2-client' and these MUST be downgraded to match OpenSuse 42.3.
    2) Keeping these packages from being updated and maintaining them at these levels ARE a must--otherwise, MS SQL Server breaks again. (Been there and done that too!)
    3) As for the paths, I kept things simple for others--these can be changed to match your environments.

    Also, my database environments exist apart from the User and System paths and are segmented into a designated areas comprised on two 4Tb partitions that will house Oracle 12c, MS SQL Server 2017, PostgreSQL 10, and Neo4j 3.5 databases. As such, one partition named 'data' is where I installed PowerShell (i.e. /data/microsoft/powershell/) and is also where MS SQL Server and Neo4j databases exist as well.

    I still have a lot of work to do...the data migrations will be fun...and hopefully boring!

  5. #15
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    2,518

    Talking Re: MS SQL Server on v15

    Quote Originally Posted by ArDrakho View Post
    1) MS SQL Server 2017 on Linux WILL NOT run with current packages of 'openssl', 'openldap2', 'libldap', and 'openldap2-client' and these MUST be downgraded to match OpenSuse 42.3.
    2) Keeping these packages from being updated and maintaining them at these levels ARE a must--otherwise, MS SQL Server breaks again. (Been there and done that too!)
    I suspect that, holding the versions of openssl, openldap2, libldap and openldap2-client to match what the Redmond folks feel that they need, will be a “no deal” …

    • Why don't you suggest that, some special SSL and LDAP packages matching the Leap 42.3 versions – to suit the needs of the Redmond world – be produced/packaged and appropriately named …

    May I suggest the following names?
    * MS-SQL-openssl
    * MS-SQL-openldap2
    * MS-SQL-libldap
    * MS-SQL-openldap2-client

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •