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?
mssql-server: Depends on libjemalloc1 which is a virtual package and is not provided by any available package
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:
- 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
- Install it:
sudo dpkg -i libjemalloc1_3.6.0-11_amd64.deb
- Now run the apt command to install ms-sql server:
sudo apt-get install mssql-server
Hope this works for you.
1Thanks 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 KDec 8, 2018 at 22:52
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.
libjemalloc1package was replaced in 18.10 with