mssql-tools port is outdated

[breiter (Brian Reiter)]

Hello,

I belatedly realized that bcp is now available from Microsoft for macOS but I am not excited about switching to Homebrew just to use it, nor to maintain the package manually by inspecting their formula. I was happy to discover that MacPorts has mssql-tools.

$ cat $(port dir mssql-tools)/Portfile|grep version
version             14.0.6.0
$ sudo port fetch -v mssql-tools
--->  Fetching distfiles for mssql-tools
--->  Attempting to fetch mssql-tools-14.0.6.0.tar.gz from http://jnb.za.distfiles.macports.org/distfiles/mssql-tools

The portfile specifies version 14.0.6.0 but the Homebroew forumula specifies version 17.2.0.1.

​https://github.com/Microsoft/homebrew-mssql-release/blob/master/Formula/mssql-tools.rb

  url "https://download.microsoft.com/download/F/D/1/FD16AA69-F27D-440E-A15A-6C521A1972E6/mssql-tools-17.2.0.1.tar.gz"
  version "17.2.0.1"

I tried updating the Portfile to set version 17.2.0.1 and it works.

--- Portfile	2019-02-13 15:01:07.000000000 +0200
+++ Portfile.bak	2019-02-13 14:41:03.000000000 +0200
@@ -1,7 +1,7 @@
 PortSystem          1.0
 
 name                mssql-tools
-version             17.2.0.1
+version             14.0.6.0
 categories          databases
 platforms           darwin
 supported_archs     x86_64
@@ -14,12 +14,12 @@
 homepage            https://msdn.microsoft.com/en-us/library/ms162773.aspx
 master_sites        http://download.microsoft.com/download/F/D/1/FD16AA69-F27D-440E-A15A-6C521A1972E6/
 
-checksums           rmd160  dbe46dd41fe6c59c805af84880de757e2c822dfd \
-                    sha256  4d0c30602d2207efde54ff77ebf17f71cd67735edba95f40be54a365db943819
+checksums           rmd160  0dd2ce7c4c827a050c86f7767607548fe12d1c12 \
+                    sha256  b31cfe98ff3c8f60a98fd02a1ebbe7cf7a2172320239adccd073ad3870786bf9
                     
 depends_run         port:msodbcsql
 
-worksrcdir          ${name}-${version}      
+worksrcdir          ${name}-13.1.7.0      
 use_configure       no
                     
 build               {

$ sudo port -v install mssql-tools
--->  Computing dependencies for mssql-tools.
--->  Fetching archive for mssql-tools
--->  mssql-tools-17.2.0.1_0.darwin_18.x86_64.tbz2 doesn't seem to exist in /opt/local/var/macports/incoming/verified
--->  Attempting to fetch mssql-tools-17.2.0.1_0.darwin_18.x86_64.tbz2 from http://jnb.za.packages.macports.org/packages/mssql-tools
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch mssql-tools-17.2.0.1_0.darwin_18.x86_64.tbz2 from https://packages.macports.org/mssql-tools
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch mssql-tools-17.2.0.1_0.darwin_18.x86_64.tbz2 from http://mse.uk.packages.macports.org/sites/packages.macports.org/mssql-tools
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   297  100   297    0     0    706      0 --:--:-- --:--:-- --:--:--   705
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Fetching distfiles for mssql-tools
--->  Verifying checksums for mssql-tools
--->  Checksumming mssql-tools-17.2.0.1.tar.gz
--->  Extracting mssql-tools
--->  Extracting mssql-tools-17.2.0.1.tar.gz
Executing:  cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work" && /usr/bin/gzip -dc '/opt/local/var/macports/distfiles/mssql-tools/mssql-tools-17.2.0.1.tar.gz' | /usr/bin/tar -xf - 
--->  Configuring mssql-tools
--->  Building mssql-tools
--->  Staging mssql-tools into destroot
. changed
	gid expected 0 found 80 modified
./usr missing (created)
. missing (directory not created: File exists)
./Applications missing (created)
./Developer missing (created)
./Library missing (created)
. changed
	gid expected 80 found 0 modified
./bin missing (created)
./etc missing (created)
./include missing (created)
./lib missing (created)
./lib/pkgconfig missing (created)
./libexec missing (created)
./sbin missing (created)
./share missing (created)
./share/doc missing (created)
./share/info missing (created)
./share/man missing (created)
./share/man/cat1 missing (created)
./share/man/cat2 missing (created)
./share/man/cat3 missing (created)
./share/man/cat4 missing (created)
./share/man/cat5 missing (created)
./share/man/cat6 missing (created)
./share/man/cat7 missing (created)
./share/man/cat8 missing (created)
./share/man/cat9 missing (created)
./share/man/catl missing (created)
./share/man/catn missing (created)
./share/man/man1 missing (created)
./share/man/man2 missing (created)
./share/man/man3 missing (created)
./share/man/man4 missing (created)
./share/man/man5 missing (created)
./share/man/man6 missing (created)
./share/man/man7 missing (created)
./share/man/man8 missing (created)
./share/man/man9 missing (created)
./share/man/manl missing (created)
./share/man/mann missing (created)
./share/nls missing (created)
./share/nls/C missing (created)
./share/nls/af_ZA.ISO8859-1 missing (created)
./share/nls/af_ZA.ISO8859-15 missing (created)
./share/nls/bg_BG.CP1251 missing (created)
./share/nls/cs_CZ.ISO8859-2 missing (created)
./share/nls/da_DK.ISO8859-1 missing (created)
./share/nls/da_DK.ISO8859-15 missing (created)
./share/nls/de_AT.ISO8859-1 missing (created)
./share/nls/de_AT.ISO8859-15 missing (created)
./share/nls/de_CH.ISO8859-1 missing (created)
./share/nls/de_CH.ISO8859-15 missing (created)
./share/nls/de_DE.ISO8859-1 missing (created)
./share/nls/de_DE.ISO8859-15 missing (created)
./share/nls/el_GR.ISO8859-7 missing (created)
./share/nls/en_AU.ISO8859-1 missing (created)
./share/nls/en_AU.ISO8859-15 missing (created)
./share/nls/en_AU.US-ASCII missing (created)
./share/nls/en_CA.ISO8859-1 missing (created)
./share/nls/en_CA.ISO8859-15 missing (created)
./share/nls/en_CA.US-ASCII missing (created)
./share/nls/en_GB.ISO8859-1 missing (created)
./share/nls/en_GB.ISO8859-15 missing (created)
./share/nls/en_GB.US-ASCII missing (created)
./share/nls/en_NZ.ISO8859-1 missing (created)
./share/nls/en_NZ.ISO8859-15 missing (created)
./share/nls/en_NZ.US-ASCII missing (created)
./share/nls/en_US.ISO8859-1 missing (created)
./share/nls/en_US.ISO8859-15 missing (created)
./share/nls/es_ES.ISO8859-1 missing (created)
./share/nls/es_ES.ISO8859-15 missing (created)
./share/nls/et_EE.ISO8859-15 missing (created)
./share/nls/fi_FI.ISO8859-1 missing (created)
./share/nls/fi_FI.ISO8859-15 missing (created)
./share/nls/fr_BE.ISO8859-1 missing (created)
./share/nls/fr_BE.ISO8859-15 missing (created)
./share/nls/fr_CA.ISO8859-1 missing (created)
./share/nls/fr_CA.ISO8859-15 missing (created)
./share/nls/fr_CH.ISO8859-1 missing (created)
./share/nls/fr_CH.ISO8859-15 missing (created)
./share/nls/fr_FR.ISO8859-1 missing (created)
./share/nls/fr_FR.ISO8859-15 missing (created)
./share/nls/hi_IN.ISCII-DEV missing (created)
./share/nls/hr_HR.ISO8859-2 missing (created)
./share/nls/hu_HU.ISO8859-2 missing (created)
./share/nls/is_IS.ISO8859-1 missing (created)
./share/nls/is_IS.ISO8859-15 missing (created)
./share/nls/it_CH.ISO8859-1 missing (created)
./share/nls/it_CH.ISO8859-15 missing (created)
./share/nls/it_IT.ISO8859-1 missing (created)
./share/nls/it_IT.ISO8859-15 missing (created)
./share/nls/ja_JP.SJIS missing (created)
./share/nls/ja_JP.eucJP missing (created)
./share/nls/ko_KR.eucKR missing (created)
./share/nls/la_LN.ISO8859-1 missing (created)
./share/nls/la_LN.ISO8859-15 missing (created)
./share/nls/la_LN.ISO8859-2 missing (created)
./share/nls/la_LN.ISO8859-4 missing (created)
./share/nls/la_LN.US-ASCII missing (created)
./share/nls/lt_LT.ISO8859-4 missing (created)
./share/nls/nl_BE.ISO8859-1 missing (created)
./share/nls/nl_BE.ISO8859-15 missing (created)
./share/nls/nl_NL.ISO8859-1 missing (created)
./share/nls/nl_NL.ISO8859-15 missing (created)
./share/nls/no_NO.ISO8859-1 missing (created)
./share/nls/no_NO.ISO8859-15 missing (created)
./share/nls/pl_PL.ISO8859-2 missing (created)
./share/nls/pt_BR.ISO8859-1 missing (created)
./share/nls/pt_PT.ISO8859-1 missing (created)
./share/nls/pt_PT.ISO8859-15 missing (created)
./share/nls/ro_RO.ISO8859-2 missing (created)
./share/nls/ru_RU.CP866 missing (created)
./share/nls/ru_RU.ISO8859-5 missing (created)
./share/nls/ru_RU.KOI8-R missing (created)
./share/nls/sk_SK.ISO8859-2 missing (created)
./share/nls/sl_SI.ISO8859-2 missing (created)
./share/nls/sv_SE.ISO8859-1 missing (created)
./share/nls/sv_SE.ISO8859-15 missing (created)
./share/nls/tr_TR.ISO8859-9 missing (created)
./share/nls/uk_UA.ISO8859-5 missing (created)
./share/nls/uk_UA.KOI8-U missing (created)
./share/nls/zh_CN.eucCN missing (created)
./share/nls/zh_TW.Big5 missing (created)
./share/skel missing (created)
./var missing (created)
./var/cache missing (created)
./var/db missing (created)
./var/log missing (created)
./var/run missing (created)
./var/spool missing (created)
./www missing (created)
xinstall: chdir(/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/mssql-tools-17.2.0.1/bin)
xinstall: sqlcmd -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/bin/sqlcmd
xinstall: bcp -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/bin/bcp
xinstall: mkdir /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources
xinstall: mkdir /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources/en_US
xinstall: chdir(/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/mssql-tools-17.2.0.1/share/resources/en_US)
xinstall: BatchParserGrammar.dfa -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources/en_US/BatchParserGrammar.dfa
xinstall: BatchParserGrammar.llr -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources/en_US/BatchParserGrammar.llr
xinstall: bcp.rll -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources/en_US/bcp.rll
xinstall: SQLCMD.rll -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/resources/en_US/SQLCMD.rll
xinstall: mkdir /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/doc/mssql-tools
xinstall: chdir(/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/mssql-tools-17.2.0.1/usr/share/doc/mssql-tools/)
xinstall: LICENSE.txt -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/doc/mssql-tools//LICENSE.txt
xinstall: THIRDPARTYNOTICES.txt -> /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot/opt/local/share/doc/mssql-tools//THIRDPARTYNOTICES.txt
--->  Installing mssql-tools @17.2.0.1_0
Executing:  cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mssql-tools/mssql-tools/work/destroot" && /usr/bin/tar -cvf - . | /usr/bin/bzip2 -c9 > /opt/local/var/macports/software/mssql-tools/mssql-tools-17.2.0.1_0.darwin_18.x86_64.tbz2 
a .
a ./+STATE
a ./+PORTFILE
a ./+CONTENTS
a ./+DESC
a ./+COMMENT
a ./opt
a ./opt/local
a ./opt/local/bin
a ./opt/local/share
a ./opt/local/share/resources
a ./opt/local/share/doc
a ./opt/local/share/doc/mssql-tools
a ./opt/local/share/doc/mssql-tools/THIRDPARTYNOTICES.txt
a ./opt/local/share/doc/mssql-tools/LICENSE.txt
a ./opt/local/share/resources/en_US
a ./opt/local/share/resources/en_US/BatchParserGrammar.dfa
a ./opt/local/share/resources/en_US/bcp.rll
a ./opt/local/share/resources/en_US/BatchParserGrammar.llr
a ./opt/local/share/resources/en_US/SQLCMD.rll
a ./opt/local/bin/sqlcmd
a ./opt/local/bin/bcp
--->  Activating mssql-tools @17.2.0.1_0
x ./
x ./+STATE
x ./+PORTFILE
x ./+CONTENTS
x ./+DESC
x ./+COMMENT
x ./opt/
x ./opt/local/
x ./opt/local/bin/
x ./opt/local/share/
x ./opt/local/share/resources/
x ./opt/local/share/doc/
x ./opt/local/share/doc/mssql-tools/
x ./opt/local/share/doc/mssql-tools/THIRDPARTYNOTICES.txt
x ./opt/local/share/doc/mssql-tools/LICENSE.txt
x ./opt/local/share/resources/en_US/
x ./opt/local/share/resources/en_US/BatchParserGrammar.dfa
x ./opt/local/share/resources/en_US/bcp.rll
x ./opt/local/share/resources/en_US/BatchParserGrammar.llr
x ./opt/local/share/resources/en_US/SQLCMD.rll
x ./opt/local/bin/sqlcmd
x ./opt/local/bin/bcp
--->  Cleaning mssql-tools
--->  Removing work directory for mssql-tools
--->  Scanning binaries for linking errors
--->  No broken files found.                             
--->  No broken ports found.

[breiter (Brian Reiter)]

Actually, something is not right because bcp doesn't wrk after all of that.

$ bcp
Unable to locate driver dynamic library. BCP cannot continue.

[mf2k (Frank Schima)]

In the future, please fill in the Port field and add the port maintainer(s) to Cc (port info --maintainers mssql-tools), if any.

[roederja]

Port updated

[mf2k (Frank Schima)]

changeset:e30cf97cf71e6d40af1c07c3c0b035c48d2e81be/macports-ports