MySQL.jl install error

General Usage
1

I got the following error while installing MySQL.jl on windows 10.

(@v1.3) pkg> add MySQL
   Updating registry at `C:\Users\zhangly\.juliapro\JuliaPro_v1.3.1-1\registries\JuliaPro`
tar: Can't convert a path to a wchar_t string: Unknown error
tar: Error exit delayed from previous errors.
┌ Warning: could not download https://pkg.juliacomputing.com/registries
└ @ Pkg.Types C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Types.jl:874
  Resolving package versions...
Downloading artifact: OpenSpecFun
Cannot set property. Property setting is supported only on core types in this language mode.
At line:1 char:1
+ [System.Net.ServicePointManager]::SecurityProtocol =
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertySetterNotSupportedInConstrainedLanguage

New-Object : Cannot create type. Only core types are supported in this language mode.
At line:3 char:15
+ $webclient = (New-Object System.Net.Webclient);
+               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : PermissionDenied: (:) [New-Object], PSNotSupportedException
    + FullyQualifiedErrorId : CannotCreateTypeConstrainedLanguage,Microsoft.PowerShell.Commands.NewObjectCommand

The property 'UseDefaultCredentials' cannot be found on this object. Verify that the property exists and can be set.
At line:4 char:1
+ $webclient.UseDefaultCredentials = $true;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertyNotFound

The property 'Credentials' cannot be found on this object. Verify that the property exists and can be set.
At line:5 char:1
+ $webclient.Proxy.Credentials = $webclient.Credentials;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertyNotFound

You cannot call a method on a null-valued expression.
At line:6 char:1
+ $webclient.Headers.Add("user-agent", "Pkg.jl (https://github.com/Juli ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:7 char:1
+ $webclient.Headers.Add("Authorization", "Bearer eyJhbGciOiJSUzI1NiIsI ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:8 char:1
+ $webclient.Headers.Add("Julia-Pkg-Protocol", "1.0");
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:9 char:1
+ $webclient.Headers.Add("Julia-Version", "1.3.1");
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:10 char:1
+ $webclient.Headers.Add("Julia-System", "x86_64-w64-mingw32-libgfortra ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:11 char:1
+ $webclient.Headers.Add("Julia-Client-UUID", "ddad2f50-0ee6-4490-9b80- ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:12 char:1
+ $webclient.Headers.Add("Julia-Salt-Hash", "4fce66b883fcd7ca23a0cabe57 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:13 char:1
+ $webclient.Headers.Add("Julia-Project-Hash", "8c7593c42118f2942b1a39a ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:14 char:1
+ $webclient.Headers.Add("Julia-CI-Variables", "APPVEYOR=n;CI=n;CIRCLEC ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:15 char:1
+ $webclient.Headers.Add("Julia-Interactive", "true");
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:16 char:1
+ $webclient.DownloadFile("https://pkg.juliacomputing.com/artifact/e062 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
Downloading artifact: OpenSpecFun
Cannot set property. Property setting is supported only on core types in this language mode.
At line:1 char:1
+ [System.Net.ServicePointManager]::SecurityProtocol =
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertySetterNotSupportedInConstrainedLanguage

New-Object : Cannot create type. Only core types are supported in this language mode.
At line:3 char:15
+ $webclient = (New-Object System.Net.Webclient);
+               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : PermissionDenied: (:) [New-Object], PSNotSupportedException
    + FullyQualifiedErrorId : CannotCreateTypeConstrainedLanguage,Microsoft.PowerShell.Commands.NewObjectCommand

The property 'UseDefaultCredentials' cannot be found on this object. Verify that the property exists and can be set.
At line:4 char:1
+ $webclient.UseDefaultCredentials = $true;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertyNotFound

The property 'Credentials' cannot be found on this object. Verify that the property exists and can be set.
At line:5 char:1
+ $webclient.Proxy.Credentials = $webclient.Credentials;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertyNotFound

You cannot call a method on a null-valued expression.
At line:6 char:1
+ $webclient.Headers.Add("user-agent", "Pkg.jl (https://github.com/Juli ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:7 char:1
+ $webclient.DownloadFile("https://github.com/JuliaBinaryWrappers/OpenS ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
ERROR: Unable to automatically install 'OpenSpecFun' from 'C:\Users\zhangly\.juliapro\JuliaPro_v1.3.1-1\packages\OpenSpecFun_jll\XrUb6\Artifacts.toml'
Stacktrace:
 [1] error(::String) at .\error.jl:33
 [2] #ensure_artifact_installed#42(::Pkg.BinaryPlatforms.Platform, ::Bool, ::Bool, ::typeof(Pkg.Artifacts.ensure_artifact_installed), ::String, ::Dict{String,Any}, ::String) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Artifacts.jl:894
 [3] (::Pkg.Artifacts.var"#kw##ensure_artifact_installed")(::NamedTuple{(:platform, :verbose, :quiet_download),Tuple{Pkg.BinaryPlatforms.Windows,Bool,Bool}}, ::typeof(Pkg.Artifacts.ensure_artifact_installed), ::String, ::Dict{String,Any}, ::String) at .\none:0
 [4] #ensure_all_artifacts_installed#47(::Pkg.BinaryPlatforms.Platform, ::Nothing, ::Bool, ::Bool, ::Bool, ::typeof(Pkg.Artifacts.ensure_all_artifacts_installed), ::String) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Artifacts.jl:958
 [5] #ensure_all_artifacts_installed at .\none:0 [inlined]
 [6] #download_artifacts#40(::Pkg.BinaryPlatforms.Windows, ::Bool, ::typeof(Pkg.Operations.download_artifacts), ::Pkg.Types.Context, ::Array{String,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Operations.jl:615
 [7] #download_artifacts at .\none:0 [inlined]
 [8] #download_artifacts#35(::Pkg.BinaryPlatforms.Windows, ::Bool, ::typeof(Pkg.Operations.download_artifacts), ::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Operations.jl:594
 [9] (::Pkg.Operations.var"#kw##download_artifacts")(::NamedTuple{(:platform,),Tuple{Pkg.BinaryPlatforms.Windows}}, ::typeof(Pkg.Operations.download_artifacts), ::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at .\none:0
 [10] #add#74(::Pkg.Types.PreserveLevel, ::Pkg.BinaryPlatforms.Windows, ::typeof(Pkg.Operations.add), ::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}, ::Array{Base.UUID,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\Operations.jl:1090
 [11] #add at .\none:0 [inlined]
 [12] #add#28(::Pkg.Types.PreserveLevel, ::Pkg.BinaryPlatforms.Windows, ::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}, ::typeof(Pkg.API.add), ::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\API.jl:159
 [13] add(::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\API.jl:112
 [14] #add#27 at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\API.jl:109 [inlined]
 [15] add(::Array{Pkg.Types.PackageSpec,1}) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\API.jl:109
 [16] do_cmd!(::Pkg.REPLMode.Command, ::REPL.LineEditREPL) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\REPLMode\REPLMode.jl:403
 [17] #do_cmd#21(::Bool, ::typeof(Pkg.REPLMode.do_cmd), ::REPL.LineEditREPL, ::String) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\REPLMode\REPLMode.jl:381
 [18] do_cmd at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\REPLMode\REPLMode.jl:376 [inlined]
 [19] (::Pkg.REPLMode.var"#24#27"{REPL.LineEditREPL,REPL.LineEdit.Prompt})(::REPL.LineEdit.MIState, ::Base.GenericIOBuffer{Array{UInt8,1}}, ::Bool) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\Pkg\src\REPLMode\REPLMode.jl:542
 [20] #invokelatest#1 at .\essentials.jl:709 [inlined]
 [21] invokelatest at .\essentials.jl:708 [inlined]
 [22] run_interface(::REPL.Terminals.TextTerminal, ::REPL.LineEdit.ModalInterface, ::REPL.LineEdit.MIState) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\REPL\src\LineEdit.jl:2306
 [23] run_frontend(::REPL.LineEditREPL, ::REPL.REPLBackendRef) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\REPL\src\REPL.jl:1045
 [24] run_repl(::REPL.AbstractREPL, ::Any) at C:\Users\julia\AppData\Local\Julia-1.3.1\share\julia\stdlib\v1.3\REPL\src\REPL.jl:201
 [25] (::Base.var"#770#772"{Bool,Bool,Bool,Bool})(::Module) at .\client.jl:382
 [26] #invokelatest#1 at .\essentials.jl:709 [inlined]
 [27] invokelatest at .\essentials.jl:708 [inlined]
 [28] run_main_repl(::Bool, ::Bool, ::Bool, ::Bool, ::Bool) at .\client.jl:366
 [29] exec_options(::Base.JLOptions) at .\client.jl:304
 [30] _start() at .\client.jl:460

The version information:

Julia Version 1.3.1
Commit 2d5741174c (2019-12-30 21:36 UTC)
Platform Info:
  OS: Windows (x86_64-w64-mingw32)
  CPU: Intel(R) Core(TM) i7-7600U CPU @ 2.80GHz
  WORD_SIZE: 64
  LIBM: libopenlibm
  LLVM: libLLVM-6.0.1 (ORCJIT, skylake)
Environment:
  JULIA_DEPOT_PATH = C:\Users\zhangly\.juliapro\JuliaPro_v1.3.1-1;C:\JuliaPro-1.3.1-1\Julia-1.3.1\local\share\julia;C:\JuliaPro-1.3.1-1\Julia-1.3.1\share\julia
  JULIA_PKG_SERVER = pkg.juliacomputing.com
  JULIA_PKG_TOKEN_PATH = C:\Users\zhangly\.juliapro\token.toml
2

I tried in plain Julia 1.3.1 and installation worked without any problems.
It may be a JuliaPro issue.

3

I tried this on JuliaPro 1.3.1, and it worked without problems.

@zhangliye in a few of your recent messages, there is a tar: Can't convert a path to a wchar_t string: Unknown error which we have never seen before. Google doesn’t show anything other than your messages on discourse! So this is very strange.

Is there something special about your windows install??

4

@oheil Thanks for your reply! I have tried the plain version. The problem is still there.

@avik Thanks! Days before, the IT staff came to my office and updated the system for the security problem, which is for all the staff of the Institute. wchar t string: UnKnown error occurs for many days, after I install Julia 1.3.1 and no this issue on Julia1.1.

I guess there is something wrong with my network, such as firewall suggested by some friends. However, after shutting down all the firewalls, and the problem is still there.

Moreover, the error message is not so readable for me and is very difficult to understand. I do not know what the error message means.

5

Can you open a windows cmd and type tar and return.
To see if there is a windows tar command called. If it is there try tar -h
Post the output of this test.

Same here, but good error messages is an unsolved IT problem for itself :wink:

6

You may also try busybox tar

7

@oheil The tar command message is as follows.

image
image562×511 13.8 KB

Sorry, I do not know how to use busybox bar in windows command.

Thanks!

8

ok, I have the same output, I think this is not the problem…

9

I guess it would be related to the firewall of the company. I cannot ping github.com although there is no problem of git command and visit the page using the browser Chrome.

image

IT solved this for me and can use Git as before. However, MySQL.jl still have the same problem. I encountered several other installation problem, all of which need to download compiled files. This may be caused by the"constrained model" of Powershell, which may block julia downloading the needed file. I just guess and the problem is still there. I do not know how to change PowerShell to “Full language” mode.

10

Not necessarily. Your firewall may just filter ICMP-Pakets. Others protocols are typically not affected by this.

11

Can you download
https://github.com/JuliaBinaryWrappers/OpenSpecFun_jll.jl/releases/download/OpenSpecFun-v0.5.3+2/OpenSpecFun.v0.5.3.i686-w64-mingw32-libgfortran3.tar.gz

This is whats downloaded when installing OpenSpecFun.
Try to download it and than try to depack it with
tar -xvf OpenSpecFun.v0.5.3.i686-w64-mingw32-libgfortran3.tar.gz
in a CMD window.
If all this works you may copy the depacked files into

C:\Users\zhangly\.juliapro\JuliaPro_v1.3.1-1\artifacts\18d8540b8658a2390206aed03430bf5b9b9fcdb0\

You need to create this folder 18d8540b8658a2390206aed03430bf5b9b9fcdb0

After this try again with add MySQL
(I don’t know it pkg is smart enough to not download OpenSpecFun again if it is already present, but maybe it is)

12

I think the problem is related to the PowerShell. Because for the similar laptop of my colleague in the same network, they works fine for Python and other language and git. The only problem is from reported from Julia language.

After trying many times, I found a solution. Use Julia from WSL Ubuntu18 on windows 10. All the problems are solved. I use VS code as editor in Windows and run the VS code server on WSL. All the functions including debug work well. I also install Jupyter and Python in WSL and used Jupyter as the IDE in Windows10. The work flow is similar as before.

Hope this would help the people use Julia in the company as me, and Julia community cold solve this one day. Just as Atom, which cannot install extension in the company caused by similar reason. Currently, the problem is solved.