Update to new version, fixing build with OpenSSL 1.1 by using Ubuntu Xenial's SQL Server

3 files changed, 47 insertions, 20 deletions

diff --git a/.SRCINFO b/.SRCINFO
index b2422a959de0..1c1d67f83afe 100644
--- a/.SRCINFO
+++ b/.SRCINFO
@@ -1,17 +1,23 @@
 pkgbase = mssql-server
 	pkgdesc = Microsoft SQL Server for Linux
-	pkgver = 14.0.200.24
-	pkgrel = 2
+	pkgver = 14.0.600.250
+	pkgrel = 1
 	url = https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux
 	install = mssql-server.install
 	arch = x86_64
 	license = unknown
-	makedepends = rpmextract
 	depends = python2-configparser
 	depends = numactl
-	noextract = mssql-server-14.0.200.24-2.x86_64.rpm
-	source = https://packages.microsoft.com/rhel/7/mssql-server/mssql-server-14.0.200.24-2.x86_64.rpm
-	md5sums = d498ce2395cca3d094152bc84a9575e5
+	depends = sssd
+	depends = openssl-1.0>=1.0.2.k-4
+	noextract = libjemalloc1_3.6.0-9ubuntu1_amd64.deb
+	noextract = libc++1_3.7.0-1_amd64.deb
+	source = https://packages.microsoft.com/ubuntu/16.04/mssql-server/pool/main/m/mssql-server/mssql-server_14.0.600.250-2_amd64.deb
+	source = http://mirrors.kernel.org/ubuntu/pool/universe/j/jemalloc/libjemalloc1_3.6.0-9ubuntu1_amd64.deb
+	source = http://mirrors.kernel.org/ubuntu/pool/universe/libc/libc++/libc++1_3.7.0-1_amd64.deb
+	sha256sums = c8d30b898f02c9f0eb2a5268f693bd87ed68bb553b454a632a8c00745d761bbd
+	sha256sums = 50fd3720d129ad7d659b311bb8436169b851f3671112ef53bf5d03580d4947f1
+	sha256sums = 416f5c17bd9ac8727808918dd2e1af04078691772c5f3f16afb497e33dfc9fd6
 
 pkgname = mssql-server
 
diff --git a/PKGBUILD b/PKGBUILD
index e38273de477e..b86658c16cd0 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -1,23 +1,44 @@
-# Maintainer: Aleksey Kamenskikh <aleksey.kamenskikh@gmail.com>
+# Maintainer: Gabriel Morrison Lima Dantas <gabrielmldantas@gmail.com>
+# Contributor: Aleksey Kamenskikh <aleksey.kamenskikh@gmail.com>
 pkgname=mssql-server
-pkgver=14.0.200.24
+pkgver=14.0.600.250
 _prodver=${pkgver}-2
-pkgrel=2
+pkgrel=1
 pkgdesc="Microsoft SQL Server for Linux"
 arch=('x86_64')
 url="https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux"
 license=('unknown')
-depends=(python2-configparser numactl)
-makedepends=(rpmextract)
-source=("https://packages.microsoft.com/rhel/7/$pkgname/$pkgname-$_prodver.x86_64.rpm")
-md5sums=('d498ce2395cca3d094152bc84a9575e5')
-noextract=("$pkgname-$_prodver.x86_64.rpm")
+depends=(python2-configparser numactl sssd 'openssl-1.0>=1.0.2.k-4')
+source=("https://packages.microsoft.com/ubuntu/16.04/mssql-server/pool/main/m/mssql-server/${pkgname}_${_prodver}_amd64.deb"
+        "http://mirrors.kernel.org/ubuntu/pool/universe/j/jemalloc/libjemalloc1_3.6.0-9ubuntu1_amd64.deb"
+        "http://mirrors.kernel.org/ubuntu/pool/universe/libc/libc++/libc++1_3.7.0-1_amd64.deb")
+
+sha256sums=('c8d30b898f02c9f0eb2a5268f693bd87ed68bb553b454a632a8c00745d761bbd'
+            '50fd3720d129ad7d659b311bb8436169b851f3671112ef53bf5d03580d4947f1'
+            '416f5c17bd9ac8727808918dd2e1af04078691772c5f3f16afb497e33dfc9fd6')
+noextract=('libjemalloc1_3.6.0-9ubuntu1_amd64.deb'
+           'libc++1_3.7.0-1_amd64.deb')
 install=$pkgname.install
 
 package() {
-  cd "$pkgdir"
-  rpmextract.sh $srcdir/$pkgname-$_prodver.x86_64.rpm
-  ln -s /usr/lib/libssl.so.1.0.0 usr/lib/libssl.so.10
-  ln -s /usr/lib/libcrypto.so.1.0.0 usr/lib/libcrypto.so.10
-  sed 's/^exec/exec python2/' opt/mssql/bin/mssql-conf -i
+  tar -xf data.tar.xz
+  mkdir jemalloc
+  cd jemalloc
+  ar x $srcdir/libjemalloc1_3.6.0-9ubuntu1_amd64.deb
+  tar -xf data.tar.xz
+  cd $srcdir
+  mkdir libc++
+  cd libc++
+  ar x $srcdir/libc++1_3.7.0-1_amd64.deb
+  tar -xf data.tar.xz
+  cd $pkgdir
+  mv $srcdir/opt .
+  mv $srcdir/usr .
+  mv $srcdir/lib usr/
+  mv $srcdir/jemalloc/usr/lib/x86_64-linux-gnu/libjemalloc.so.1 opt/mssql/lib/
+  mv $srcdir/libc++/usr/lib/x86_64-linux-gnu/libc++.so.1 opt/mssql/lib/
+  mv $srcdir/libc++/usr/lib/x86_64-linux-gnu/libc++.so.1.0 opt/mssql/lib/
+  for i in $(ls opt/mssql/lib/mssql-conf/*.py); do
+      sed 's/#!\/usr\/bin\/python/#!\/usr\/bin\/python2/' $i -i
+  done
 }
diff --git a/mssql-server.install b/mssql-server.install
index 4c42e807d162..e0b8c406d7ef 100644
--- a/mssql-server.install
+++ b/mssql-server.install
@@ -1,4 +1,4 @@
 post_install()
 {
-  echo "Now run /opt/mssql/bin/sqlservr-setup"
+  echo "Now run /opt/mssql/bin/mssql-conf setup"
 }