8

I'm trying to install SQL Server 2017 on Ubuntu 18.10 and encountering an error that libjemalloc1 isnt available. I've seen another answer that says that libjemalloc1 should be in universe for 18.04, but it doesnt look like it's available for 18.10 in ubuntu universe. Is there a solution for this? Has anyone done anything to get it working?

Joshua K
  • 311
  • 2
  • 10
  • Yes there is a solution: The `libjemalloc1` package was replaced in 18.10 with `libjemalloc2`. – user535733 Nov 13 '18 at 04:08
  • thanks, but it still says i need libjemalloc1 even though i installed libjemalloc2 – Joshua K Nov 13 '18 at 04:11
  • 2
    According to https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-linux-2017, SQL Server 2017 is not supported by Microsoft upon Ubuntu 18.10. Since MS owns the software and created their own deb package to distribute, then MS could provide the updated package compatible with 18.10....if they wish to. Talk to MS support. – user535733 Nov 13 '18 at 04:21
  • ah, that looks like an answer to me. i see. – Joshua K Nov 13 '18 at 04:23
  • 1
    Look at the docker version of sqlserver for linux, run without issues with little to none configuration. – bistoco Dec 05 '18 at 17:30

2 Answers2

11

I'm assuming you've followed the installation steps given on Microsoft's SQL server installation page right upto the point where you faced the error.

Here is a workaround:

  1. Download the latest version of libjemalloc (this one is for Ubuntu 18.04) from this mirror here - http://ftp.osuosl.org/pub/ubuntu/pool/universe/j/jemalloc/libjemalloc1_3.6.0-11_amd64.deb
  2. Install it: sudo dpkg -i libjemalloc1_3.6.0-11_amd64.deb
  3. Now run the apt command to install ms-sql server: sudo apt-get install mssql-server

Hope this works for you.

Sandeep S. Sandhu
  • 226
  • 4
  • 8
  • 1
    Thanks Sandeep. This allowed me to install it. Now I need to overcome this error `Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection. ` – Joshua K Dec 08 '18 at 22:52
2

I have found that MSSQL is also compatible with libjemalloc2. If you prefer to not install older packages, you can instead rebuild Microsoft's package with updated dependencies as outlined here: How do I install MS SQL for ubuntu 18.04 LTS?

Note that you will need to also run 

sed -i -e 's#libjemalloc1#libjemalloc2#g' newpkg/DEBIAN/control

in step 4 to update the libjemalloc dependency so that it will work in Ubuntu 18.10.

Dylan Smith
  • 121
  • 2