The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 4,183 other subscribers

Chocolatey: installing Oracle SQL Developer and updating the chocolatey package

Posted by jpluimers on 2021/05/13

Sometimes an install is not just as simple as C:\>choco install --yes oracle-sql-developer.

Edit 20210514:

Note that most of the below pain will be moot in the future as per [Archive.is] Jeff Smith 🍻 on Twitter: “we’re working on removing the SSO requirement, it’s already done for @oraclesqlcl – see here … “ referring to [Wayback] SQLcl now under the Oracle Free Use Terms and Conditions license | Oracle Database Insider Blog

SQLcl, the modern command-line interface for the Oracle Database, can now be downloaded directly from the web without any click-through license agreement.

It means the Oracle acount restriction will be lifted, and downloads will be a lot simpler.

I started with the below failing command, tried a lot of things, then finally almost gave up: Oracle stuff does not want to be automated, which means I should try to less of their stuff.

First of all you need an Oracle account (I dislike companies doing that for free product installs; I’m looking at Embarcadero too) by going to profile.oracle.com:

[WayBack] Chocolatey Gallery | Oracle SQL Developer 18.4.0 (also: gist.github.com/search?l=XML&q=oracle-sql-developer)

Notes

  • This version supports both 32bit and 64bit and subsequently does not have a JDK bundled with it. It has a
    dependency on the jdk8 package to meet the application’s JDK requirement.
  • An Oracle account is required to download this package. See the “Package Parameters” section below for
    details on how to provide your Oracle credentials to the installer. If you don’t have an existing account, you can
    create one for free here: https://profile.oracle.com/myprofile/account/create-account.jspx

Package Parameters

The following package parameters are required:

/Username: – Oracle username
/Password: – Oracle password

(e.g. choco install oracle-sql-developer --params "'/Username:MyUsername /Password:MyPassword'")

To have choco remember parameters on upgrade, be sure to set choco feature enable -n=useRememberedArgumentsForUpgrades.

Then the installation failed fail again: ERROR: The response content cannot be parsed because the Internet Explorer engine is not available, or Internet Explorer's first-launch configuration is not complete. Specify the UseBasicParsing parameter and try again.

The trick is to RUN IEXPLORE.EXE AS ADMINISTRATOR ONCE BEFORE INSTALLING FROM CHOCOLATEY. Who would believe that.

The reason is that the package uses Invoke-WebRequest which requires Internet Explorer and PowerShell 3. Chocolatey packages however need to be able to run on just PowerShell 2 without Invoke-WebRequest.

Maybe using cURL can remedy that; adding a dependency to is is possible, as cURL can be installed via chocolatey: [WayBack] How to Install cURL on Windows – I Don’t Know, Read The Manual. Another alternative might be [WayBack] Replace Invoke-RestMethod in PowerShell 2.0 to use [WayBack] WebRequest Class (System.Net) | Microsoft Docs.

Chocolatey v0.10.13
2 validations performed. 1 success(es), 0 warning(s), and 0 error(s).

Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Progress: Downloading oracle-sql-developer 18.4.0... 100%

oracle-sql-developer v18.4.0 [Approved]
oracle-sql-developer package files install completed. Performing other installation steps.
ERROR: An Oracle account is required to download SQL Developer

* Provide your Oracle credentials as package params to the installer and
  retry the installation:

  choco install oracle-sql-developer --params "'/Username:{userName} /Password:{password}'"

* If you do not have an Oracle account, you can register for one here (it's free):
  https://profile.oracle.com/myprofile/account/create-account.jspx

The install of oracle-sql-developer was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
 See log for details.

Chocolatey installed 0/1 packages. 1 packages failed.
 See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).

Failures
 - oracle-sql-developer (exited -1) - Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
 See log for details.

Not even as C:\>choco install --yes oracle-sql-developer --params "'/Username:oracle-sql-developer@example.org /Password:xyzzy'"

Chocolatey v0.10.13
2 validations performed. 1 success(es), 0 warning(s), and 0 error(s).

Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Progress: Downloading oracle-sql-developer 18.4.0... 100%

oracle-sql-developer v18.4.0 [Approved]
oracle-sql-developer package files install completed. Performing other installation steps.
Redirecting to Oracle Login...
ERROR: The response content cannot be parsed because the Internet Explorer engine is not available, or Internet Explorer's first-launch configuration is not complete. Specify the UseBasicParsing parameter and try again.
The install of oracle-sql-developer was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
 See log for details.

Chocolatey installed 0/1 packages. 1 packages failed.
 See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).

Failures
 - oracle-sql-developer (exited -1) - Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
 See log for details.

Run Internet Explorer once as Administrator

There was only one hit for “choco install” “The response content cannot be parsed because the Internet Explorer engine is not available” – Google Search:

[WayBack] Choco Install fails if IE has never been launched · Issue #93 · MathewSachin/Captura · GitHub

Apparently, the command Invoke-WebRequest https://api.github.com/repos/MathewSachin/Captura/releases/latest fails if IE has never run.
Either the parameter “-UseBasicParsing” should added, or user should be prompted to run IE.
Updating captura also fails under the conditions above.

So at first, I tried all kinds of -UseBasicParsing, but that did not work.

My next try was to run Internet Explorer.

Of course running Internet Explorer does not start when executing iexplore from an elevated Administrator command-line (I elevated as user localAdministrator). You have to run the full command:

C:\>"C:\Program Files\internet explorer\iexplore.exe"

This is known, and such a dependency should not be in a chocolatey package any more: [WayBack] ➂ chocolatey/choco – Gitter

Jeroen Wiert Pluimers  @jpluimers
Oh nice, the dreaded ERROR: The response content cannot be parsed because the Internet Explorer engine is not available, or Internet Explorer's first-launch configuration is not complete. Specify the UseBasicParsing parameter and try again.
The machine is indeed really fresh (:
Kim J. Nordmo   @AdmiringWorm
do not use Invoke-WebRequest for packages that are to be submitted to the community repository.
That would require Powershell v3 to be installed, but the packages on the repository is required to support Powershell v2.
Jeroen Wiert Pluimers  @jpluimers
that was already in the package to be able to download the installer from the oracle site in the beginning.
I am going to put it in the readme though.
Kim J. Nordmo  @AdmiringWorm
then it somehow got missed in the moderation of the package (or it was not known at the time the package was submitted)

Now install works fine

C:\>"C:\ProgramData\chocolatey\choco.exe" install --yes oracle-sql-developer --params "'/Username:oracle-sql-developer@example.org /Password:xyzzy'"
Chocolatey v0.10.13
2 validations performed. 1 success(es), 0 warning(s), and 0 error(s).

Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Progress: Downloading oracle-sql-developer 18.4.0... 100%

oracle-sql-developer v18.4.0 [Approved]
oracle-sql-developer package files install completed. Performing other installation steps.
Redirecting to Oracle Login...
Logging in...
Oracle login successful
Downloading oracle-sql-developer
 from 'https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-18.4.0-376.1900-no-jre.zip?AuthParam=1558371570_b50b44c17e125b5efe26908af333225f'
Progress: 100% - Completed download of C:\Users\localAdministrator\AppData\Local\Temp\chocolatey\oracle-sql-developer\18.4.0\oracle-sql-developerInstall.zip (353.99 MB).
Download of oracle-sql-developerInstall.zip (353.99 MB) completed.
Hashes match.
Extracting C:\Users\localAdministrator\AppData\Local\Temp\chocolatey\oracle-sql-developer\18.4.0\oracle-sql-developerInstall.zip to C:\ProgramData\chocolatey\lib\oracle-sql-developer...
C:\ProgramData\chocolatey\lib\oracle-sql-developer
Setting JDK path in product config...
C:\Users\localAdministrator\AppData\Roaming\sqldeveloper\18.4.0
Creating shortcuts...
 ShimGen has successfully created a gui shim for sqldeveloper.exe
 The install of oracle-sql-developer was successful.
  Software installed to 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'

Chocolatey installed 1/1 packages.
 See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).

Running

You can start sqldeveloper.exe in 3 ways:

  • from the shim in %ProgramData%\chocolatey\bin\sqldeveloper.exe
  • from the regular executables
    • %ProgramData%\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe
    • %ProgramData%\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper.exe

The first time you run sqldeveloper.exe , you need to specify the path to the directory above where java.exe resides without quotes: the JDK Home.

In my case, the exe is in "C:\Program Files\Java\jdk1.8.0_211\bin\java.exe", so I needed to enter C:\Program Files\Java\jdk1.8.0_211, not any of these:

  • "C:\Program Files\Java\jdk1.8.0_211\bin"
  • C:\Program Files\Java\jdk1.8.0_211\bin
  • "C:\Program Files\Java\jdk1.8.0_211"

If you fail, you get error messages like this while trying:

---------------------------
Oracle SQL Developer
---------------------------
Cannot find a Java SE SDK installed at path: "C:\Program Files\Java\jdk1.8.0_211\bin".

---------------------------
OK
---------------------------

This JDK Home directory is maintained in a configuration file under the user running sqldeveloper in the file %APPDATA%\sqldeveloper\18.4.0\product.conf

Updating the package to a new Oracle SQL Developer version

Updating the package to a newer version of Oracle SQL Developer appeared easier than anticipated:

Steps to perform:

  1. Preparing for modification
    1. Sign in on www.oracle.com/webapps/redirect/signon?nexturl=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads
    2. accept cookies
    3. Find the “Version” and take the first three parts and note it
      • in my case it listed “Version 19.1.0.094.2042”, so the first three parts were 19.1.0
    4. Click on the “Accept License Agreement” radio button
    5. Click on the “Windows 32-bit/64-bit” (this is the one without any included JDK)
    6. Take just the filename part and note it
      • in my case it was sqldeveloper-19.1.0.094.2042-no-jre.zip
    7. Calculate the sha1 hash from it (for instance using certUtil -hashfile sqldeveloper-19.1.0.094.2042-no-jre.zip SHA1) and note it
      • in my case it was 2e8778b1110a15d6447afddfe48efc1a885e1410
    8. On the download page, follow the link to “Release Notes” to go to the “Windows Installation Notes”  web page and note it
    9. On the [WayBack] Oracle SQL Developer – Oracle SQL Developer Releases page:
      1. Ensure the version under “Oracle SQL Developer Releases” is the most recent one
        • in my case it was “Oracle SQL Developer Release 19.1”
      2. Under “Learn about Oracle SQL Developer”, note the link to “Get Started” and note it
  2. Modifying the package
    1. Create a fork of [WayBack] github.com/wcarson/chocolatey-packages
    2. Edit the file manual/oracle-sql-developer/oracle-sql-developer.nuspec:
      1. Update the element  oracle-sql-developer.nuspec with the three parts of the version you noted
        • in my case from 18.4.0 to 19.1.0
      2. Update the element releaseNotes with the “Installation notes” URL you noted
        • in my case from https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-v184-5231669.html to https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-191-5458711.html
      3. Update the element docsUrl with the “Learn about Oracle SQL Developer” URL you noted
        • in my case from https://docs.oracle.com/en/database/oracle/sql-developer/18.4/index.html to https://docs.oracle.com/en/database/oracle/sql-developer/19.1/index.html
    3. Edit the file manual/oracle-sql-developer/tools/chocolateyinstall.ps1:
      1. Update the variable $version content with the three parts of the Version
        • in my case from '18.4.0' to '19.1.0'
      2. Update the variable $zipFileName content from the “Windows 32-bit/64-bit” file name (not the full path!) you noted
        • in my case from 'sqldeveloper-18.4.0-376.1900-no-jre.zip' to 'sqldeveloper-19.1.0.094.2042-no-jre.zip'
      3. Update the variable $sha1hash content with the sha1 value you noted
        • in my case from '2536dad95e0390f7202f0c5962a1af99ee3de787' to '2e8778b1110a15d6447afddfe48efc1a885e1410'
    4. Create a new branch in it
      • in my case, I named it sqldeveloper-19.1.0.094.2042-no-jre
    5. Commit the changes in the new branch with a good description
    6. Create a pull request from the commit
  3. Testing (preferably on a different and fresh VM)
    1. as any user, run choco pack in the directory of the .nuspec file
    2. verify the version number in the .nupkg file is correct
      • in my case, it have been should be oracle-sql-developer.19.1.0.nupkg, but not oracle-sql-developer.18.4.0.nupkg
      • if you got the wrong version, delete it, and switch to the right branch; in my case the correct branch was sqldeveloper-19.1.0.094.2042-no-jre
    3. as an elevated Administrator user, run choco install packageName --source "'.;chocolatey'" (replace packageName with the actual name of the package,  also note the dot . in the source argument;
      note chocolatey is the default repository source name for any chocolatey hosted packages which you can see with choco source)

      • The packageName is without .nupkg or version, so these are
      • The install command choco install oracle-sql-developer --debug --verbose --source "'.;chocolatey'"
      • In this case, the command also needs to have these parameters (insert actual values for your credentials): --params "'/Username:{userName} /Password:{password}'"
      • The complete commandline then becomes choco install oracle-sql-developer --debug --verbose --source ".;chocolatey" --params "'/Username:{userName} /Password:{password}'"
      • If you get
        • ERROR: The response content cannot be parsed because the Internet Explorer engine is not available, or Internet Explorer's first-launch configuration is not complete. Specify the UseBasicParsing parameter and try again.
        • then first start iexplore once on that command-prompt.

I assembled the above with great help from:

Logs

Packaging
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco pack
Chocolatey v0.10.13
Attempting to build package from 'oracle-sql-developer.nuspec'.
Successfully created package 'C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer\oracle-sql-developer.18.4.0.nupkg'

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>del oracle-sql-developer.18.4.0.nupkg

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>git checkout sqldeveloper-19.1.0.094.2042-no-jre
Switched to a new branch 'sqldeveloper-19.1.0.094.2042-no-jre'
Branch 'sqldeveloper-19.1.0.094.2042-no-jre' set up to track remote branch 'sqldeveloper-19.1.0.094.2042-no-jre' from 'origin'.

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco pack
Chocolatey v0.10.13
Attempting to build package from 'oracle-sql-developer.nuspec'.
Successfully created package 'C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer\oracle-sql-developer.19.1.0.nupkg'
Installing
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer --debug --verbose --source ".;chocolatey" --params "'/Username:someone@example.org /Password:xxxxxxxxxxxxxxxx'"
... very long log, see below ...

–jeroen

Initial installation failure: dependency jdk8 not found


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer.19.1.0.nupkg –debug –verbose –source ".;chocolatey"
The use of .nupkg or .nuspec in for package name or source is known to cause issues. Please use the package id from the nuspec `<id />` with `-s .` (for local folder where nupkg is found).
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer.19.1.0.nupkg –debug –verbose –source ".;chocolatey"
Received arguments: install oracle-sql-developer.19.1.0.nupkg –debug –verbose –source .;chocolatey
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer.19.1.0.nupkg'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer.19.1.0.nupkg'|Prerelease='False'|
ForceX86='False'|OverrideArguments='False'|NotSilent='False'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|
ListCommand.IdOnly='False'|ListCommand.IncludeRegistryPrograms='False'|
ListCommand.PageSize='25'|ListCommand.Exact='False'|
ListCommand.ByIdOnly='False'|ListCommand.ByTagOnly='False'|
ListCommand.IdStartsWith='False'|ListCommand.OrderByPopularity='False'|
ListCommand.ApprovedOnly='False'|
ListCommand.DownloadCacheAvailable='False'|
ListCommand.NotBroken='False'|
ListCommand.IncludeVersionOverrides='False'|
UpgradeCommand.FailOnUnfound='False'|
UpgradeCommand.FailOnNotInstalled='False'|
UpgradeCommand.NotifyOnlyAvailableUpgrades='False'|
UpgradeCommand.ExcludePrerelease='False'|
NewCommand.AutomaticPackage='False'|
NewCommand.UseOriginalTemplate='False'|SourceCommand.Command='unknown'|
SourceCommand.Priority='0'|SourceCommand.BypassProxy='False'|
SourceCommand.AllowSelfService='False'|
SourceCommand.VisibleToAdminsOnly='False'|
FeatureCommand.Command='unknown'|ConfigCommand.Command='unknown'|
ApiKeyCommand.Remove='False'|PinCommand.Command='unknown'|
OutdatedCommand.IgnorePinned='False'|Proxy.BypassOnLocal='True'|
_ Chocolatey:ChocolateyInstallCommand – Normal Run Mode _
Installing the following packages:
oracle-sql-developer.19.1.0.nupkg
By installing you accept licenses for the packages.
Updating source and package name to handle *.nupkg or *.nuspec file.
[NuGet] Attempting to resolve dependency 'jdk8'.
oracle-sql-developer not installed. An error occurred during installation:
Unable to resolve dependency 'jdk8'.
oracle-sql-developer package files install completed. Performing other installation steps.
No package information as package is null.
No package information to save as package is null.
Sending message 'HandlePackageResultCompletedMessage' out if there are subscribers…
The install of oracle-sql-developer was NOT successful.
oracle-sql-developer not installed. An error occurred during installation:
Unable to resolve dependency 'jdk8'.
Chocolatey installed 0/1 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
– oracle-sql-developer (exited 1) – oracle-sql-developer not installed. An error occurred during installation:
Unable to resolve dependency 'jdk8'.
Sending message 'PostRunMessage' out if there are subscribers…
Exiting with 1
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer.19.1.0 –debug –verbose –source ".;chocolatey"
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer.19.1.0 –debug –verbose –source ".;chocolatey"
Received arguments: install oracle-sql-developer.19.1.0 –debug –verbose –source .;chocolatey
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer.19.1.0'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer.19.1.0'|Prerelease='False'|
ForceX86='False'|OverrideArguments='False'|NotSilent='False'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|
ListCommand.IdOnly='False'|ListCommand.IncludeRegistryPrograms='False'|
ListCommand.PageSize='25'|ListCommand.Exact='False'|
ListCommand.ByIdOnly='False'|ListCommand.ByTagOnly='False'|
ListCommand.IdStartsWith='False'|ListCommand.OrderByPopularity='False'|
ListCommand.ApprovedOnly='False'|
ListCommand.DownloadCacheAvailable='False'|
ListCommand.NotBroken='False'|
ListCommand.IncludeVersionOverrides='False'|
UpgradeCommand.FailOnUnfound='False'|
UpgradeCommand.FailOnNotInstalled='False'|
UpgradeCommand.NotifyOnlyAvailableUpgrades='False'|
UpgradeCommand.ExcludePrerelease='False'|
NewCommand.AutomaticPackage='False'|
NewCommand.UseOriginalTemplate='False'|SourceCommand.Command='unknown'|
SourceCommand.Priority='0'|SourceCommand.BypassProxy='False'|
SourceCommand.AllowSelfService='False'|
SourceCommand.VisibleToAdminsOnly='False'|
FeatureCommand.Command='unknown'|ConfigCommand.Command='unknown'|
ApiKeyCommand.Remove='False'|PinCommand.Command='unknown'|
OutdatedCommand.IgnorePinned='False'|Proxy.BypassOnLocal='True'|
_ Chocolatey:ChocolateyInstallCommand – Normal Run Mode _
Installing the following packages:
oracle-sql-developer.19.1.0
By installing you accept licenses for the packages.
Switching source name chocolatey to actual source value 'https://chocolatey.org/api/v2/&#39;.
Using '.'.
– Supports prereleases? 'True'.
– Is ServiceBased? 'False'.
Using 'https://chocolatey.org/api/v2/&#39;.
– Supports prereleases? 'True'.
– Is ServiceBased? 'True'.
oracle-sql-developer.19.1.0 not installed. The package was not found with the source(s) listed.
Source(s): '.;https://chocolatey.org/api/v2/&#39;
NOTE: When you specify explicit sources, it overrides default sources.
If the package version is a prerelease and you didn't specify `–pre`,
the package may not be found.
Please see https://chocolatey.org/docs/troubleshooting for more
assistance.
Chocolatey installed 0/1 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
– oracle-sql-developer.19.1.0 – oracle-sql-developer.19.1.0 not installed. The package was not found with the source(s) listed.
Source(s): '.;https://chocolatey.org/api/v2/&#39;
NOTE: When you specify explicit sources, it overrides default sources.
If the package version is a prerelease and you didn't specify `–pre`,
the package may not be found.
Please see https://chocolatey.org/docs/troubleshooting for more
assistance.
Sending message 'PostRunMessage' out if there are subscribers…
Exiting with 1
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>

failure to execute helpers.ps1


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer –debug –verbose –source ".;chocolatey"
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer –debug –verbose –source ".;chocolatey"
Received arguments: install oracle-sql-developer –debug –verbose –source .;chocolatey
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer'|Prerelease='False'|
ForceX86='False'|
OverrideArguments='False'|NotSilent='False'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|
ListCommand.IdOnly='False'|ListCommand.IncludeRegistryPrograms='False'|
ListCommand.PageSize='25'|ListCommand.Exact='False'|
ListCommand.ByIdOnly='False'|ListCommand.ByTagOnly='False'|
ListCommand.IdStartsWith='False'|ListCommand.OrderByPopularity='False'|
ListCommand.ApprovedOnly='False'|
ListCommand.DownloadCacheAvailable='False'|
ListCommand.NotBroken='False'|
ListCommand.IncludeVersionOverrides='False'|
UpgradeCommand.FailOnUnfound='False'|
UpgradeCommand.FailOnNotInstalled='False'|
UpgradeCommand.NotifyOnlyAvailableUpgrades='False'|
UpgradeCommand.ExcludePrerelease='False'|
NewCommand.AutomaticPackage='False'|
NewCommand.UseOriginalTemplate='False'|SourceCommand.Command='unknown'|
SourceCommand.Priority='0'|SourceCommand.BypassProxy='False'|
SourceCommand.AllowSelfService='False'|
SourceCommand.VisibleToAdminsOnly='False'|
FeatureCommand.Command='unknown'|ConfigCommand.Command='unknown'|
ApiKeyCommand.Remove='False'|PinCommand.Command='unknown'|
OutdatedCommand.IgnorePinned='False'|Proxy.BypassOnLocal='True'|
_ Chocolatey:ChocolateyInstallCommand – Normal Run Mode _
Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Switching source name chocolatey to actual source value 'https://chocolatey.org/api/v2/&#39;.
Using '.'.
– Supports prereleases? 'True'.
– Is ServiceBased? 'False'.
Package 'oracle-sql-developer' found on source '.'
Using 'https://chocolatey.org/api/v2/&#39;.
– Supports prereleases? 'True'.
– Is ServiceBased? 'True'.
Package 'oracle-sql-developer' found on source 'https://chocolatey.org/api/v2/&#39;
[NuGet] Attempting to resolve dependency 'jdk8'.
Progress: Downloading jdk8 8.0.211… 100%
[NuGet] Installing 'jdk8 8.0.211'.
[NuGet] Added file 'chocolateyInstall.ps1' to folder 'jdk8\tools'.
[NuGet] Added file 'chocolateyUninstall.ps1' to folder 'jdk8\tools'.
[NuGet] Added file 'common.ps1' to folder 'jdk8\tools'.
[NuGet] Added file 'jdk8.nuspec' to folder 'jdk8'.
[NuGet] Added file 'jdk8.nupkg' to folder 'jdk8'.
[NuGet] Successfully installed 'jdk8 8.0.211'.
jdk8 v8.0.211 [Approved]
jdk8 package files install completed. Performing other installation steps.
Contents of 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1':
$script_path = $(Split-Path -parent $MyInvocation.MyCommand.Definition)
$common = $(Join-Path $script_path "common.ps1")
. $common
#installs jdk8
try {
$params = "$env:chocolateyPackageParameters"
$params = (ConvertFrom-StringData $params.Replace(";", "`n"))
out-installdir($params)
if (check-both($params)) {
chocolatey-install $params $true
chocolatey-install $params
out-both($params)
} else {
out-i586($params)
chocolatey-install $params
}
set-path
} catch {
if ($_.Exception.InnerException) {
$msg = $_.Exception.InnerException.Message
} else {
$msg = $_.Exception.Message
}
throw
}
The package jdk8 wants to run 'chocolateyInstall.ps1'.
Note: If you don't run this script, the installation will fail.
Note: To confirm automatically next time, use '-y' or consider:
choco feature enable -n allowGlobalConfirmation
Do you want to run the script?([Y]es/[N]o/[P]rint): yes
Calling built-in PowerShell host with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1' -installArguments '' -packageParameters ''']
Redirecting System.Management.Automation.resources, Version=3.0.0.0, Culture=nl-NL, PublicKeyToken=31bf3856ad364e35, requested by ''
Host version is 5.1.17763.1, PowerShell Version is '5.1.17763.503' and CLR Version is '4.0.30319.42000'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
Loading community extensions
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Register-Application'.
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
VERBOSE: Importing function 'Format-FileSize'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-ChecksumValid'.
VERBOSE: Importing function 'Get-ChocolateyUnzip'.
VERBOSE: Importing function 'Get-ChocolateyWebFile'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-EnvironmentVariable'.
VERBOSE: Importing function 'Get-EnvironmentVariableNames'.
VERBOSE: Importing function 'Get-FtpFile'.
VERBOSE: Importing function 'Get-OSArchitectureWidth'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-PackageParametersBuiltIn'.
VERBOSE: Importing function 'Get-ToolsLocation'.
VERBOSE: Importing function 'Get-UACEnabled'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-VirusCheckValid'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Get-WebFile'.
VERBOSE: Importing function 'Get-WebFileName'.
VERBOSE: Importing function 'Get-WebHeaders'.
VERBOSE: Importing function 'Install-BinFile'.
VERBOSE: Importing function 'Install-ChocolateyDesktopLink'.
VERBOSE: Importing function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Importing function 'Install-ChocolateyFileAssociation'.
VERBOSE: Importing function 'Install-ChocolateyInstallPackage'.
VERBOSE: Importing function 'Install-ChocolateyPackage'.
VERBOSE: Importing function 'Install-ChocolateyPath'.
VERBOSE: Importing function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Importing function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Importing function 'Install-ChocolateyShortcut'.
VERBOSE: Importing function 'Install-ChocolateyVsixPackage'.
VERBOSE: Importing function 'Install-ChocolateyZipPackage'.
VERBOSE: Importing function 'Install-Vsix'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Register-Application'.
VERBOSE: Importing function 'Set-EnvironmentVariable'.
VERBOSE: Importing function 'Set-PowerShellExitCode'.
VERBOSE: Importing function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Importing function 'Test-ProcessAdminRights'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Uninstall-BinFile'.
VERBOSE: Importing function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Uninstall-ChocolateyPackage'.
VERBOSE: Importing function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Importing function 'Update-SessionEnvironment'.
VERBOSE: Importing function 'Write-ChocolateyFailure'.
VERBOSE: Importing function 'Write-ChocolateySuccess'.
VERBOSE: Importing function 'Write-FileUpdateLog'.
VERBOSE: Importing function 'Write-FunctionCallLogMessage'.
VERBOSE: Importing alias 'Add-BinFile'.
VERBOSE: Importing alias 'Generate-BinFile'.
VERBOSE: Importing alias 'Get-InstallRegistryKey'.
VERBOSE: Importing alias 'Get-OSBitness'.
VERBOSE: Importing alias 'Get-ProcessorBits'.
VERBOSE: Importing alias 'Invoke-ChocolateyProcess'.
VERBOSE: Importing alias 'refreshenv'.
VERBOSE: Importing alias 'Remove-BinFile'.
VERBOSE: Importing alias 'Start-ChocolateyProcess'.
Running 'ChocolateyScriptRunner' for jdk8 v8.0.211 with packageScript 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1', packageFolder:'C:\ProgramData\chocolatey\lib\jdk8', installArguments: '', packageParameters: '',
Running 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1'
Running Get-ProcessorBits -compare '64'
Downloading JDK from https://javadl.oracle.com/webapps/download/GetFile/1.8.0_211-b12/478a62b7d4e34b78b671c754eaaf38ab/windows-i586/jdk-8u211-windows-x64.exe
Running Get-ProcessorBits -compare '64'
Running Get-ProcessorBits -compare '64'
Running Get-ProcessorBits -compare '64'
Running Install-ChocolateyInstallPackage -packageName 'jdk8' -fileType 'exe' -silentArgs '/s STATIC=1 ADDLOCAL="ToolsFeature,SourceFeature"' -file 'C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe'
Running Get-ProcessorBits -compare '32'
Installing jdk8…
Running Start-ChocolateyProcessAsAdmin -validExitCodes '0' -workingDirectory 'C:\ProgramData\chocolatey\lib\jdk8\tools' -statements '/s STATIC=1 ADDLOCAL="ToolsFeature,SourceFeature" ' -exeToRun 'C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe'
Test-ProcessAdminRights: returning True
Elevating permissions and running ["C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe" /s STATIC=1 ADDLOCAL="ToolsFeature,SourceFeature" ]. This may take a while, depending on the statements.
Command ["C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe" /s STATIC=1 ADDLOCAL="ToolsFeature,SourceFeature" ] exited with '0'.
Finishing 'Start-ChocolateyProcessAsAdmin'
jdk8 has been installed.
Running Get-ProcessorBits -compare '64'
Running Get-ProcessorBits -compare '64'
Running Install-ChocolateyPath -pathToInstall 'C:\Program Files\Java\jdk1.8.0_211\bin' -pathType 'Machine'
Running Update-SessionEnvironment
VERBOSE: Refreshing environment variables from the registry.
PATH environment variable does not have C:\Program Files\Java\jdk1.8.0_211\bin in it. Adding…
VERBOSE: Choosing not to expand environment names
Test-ProcessAdminRights: returning True
Running Set-EnvironmentVariable -Name 'Path' -Value 'C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\ImageMagick-7.0.8-Q16;;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;%SYSTEMROOT%\System32\OpenSSH\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\Program Files\Mercurial;C:\Program Files\Microsoft VS Code\bin;C:\Program Files\Java\jdk1.8.0_211\bin;' -Scope 'Machine'
Registry type for Path is/will be ExpandString
using System;
using System.Runtime.InteropServices;
namespace Win32
{
public class NativeMethods
{
[DllImport("user32.dll", SetLastError = true, CharSet = CharSet.Auto)]
public static extern IntPtr SendMessageTimeout(
IntPtr hWnd, uint Msg, UIntPtr wParam, string lParam,
uint fuFlags, uint uTimeout, out UIntPtr lpdwResult);
}
}
Running Update-SessionEnvironment
VERBOSE: Refreshing environment variables from the registry.
Running Install-ChocolateyEnvironmentVariable -variableName 'CLASSPATH' -variableValue '.;' -variableType 'Machine'
Test-ProcessAdminRights: returning True
Running Set-EnvironmentVariable -Name 'CLASSPATH' -Value '.;' -Scope 'Machine'
Registry type for CLASSPATH is/will be String
Running Update-SessionEnvironment
VERBOSE: Refreshing environment variables from the registry.
Running Install-ChocolateyEnvironmentVariable -variableName 'JAVA_HOME' -variableValue 'C:\Program Files\Java\jdk1.8.0_211' -variableType 'Machine'
Test-ProcessAdminRights: returning True
Running Set-EnvironmentVariable -Name 'JAVA_HOME' -Value 'C:\Program Files\Java\jdk1.8.0_211' -Scope 'Machine'
Registry type for JAVA_HOME is/will be String
Running Update-SessionEnvironment
VERBOSE: Refreshing environment variables from the registry.
Built-in PowerShell host called with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1' -installArguments '' -packageParameters '''] exited with '0'.
Calling command ['"C:\Windows\System32\shutdown.exe" /a']
Command ['"C:\Windows\System32\shutdown.exe" /a'] exited with '1116'
jdk8 may be able to be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
Logging of values is not turned on by default because it
could potentially expose sensitive data. If you understand the risk,
please see `choco feature -h` for information to turn it on.
The following values have been added/changed (may contain sensitive data):
* ChocolateyLastPathUpdate='[REDACTED]' (User)
* Path='[REDACTED]' (Machine)
* CLASSPATH='[REDACTED]' (Machine)
* JAVA_HOME='[REDACTED]' (Machine)
Capturing package files in 'C:\ProgramData\chocolatey\lib\jdk8'
Found 'C:\ProgramData\chocolatey\lib\jdk8\jdk8.nupkg'
with checksum 'A8535E9B0497A0C5F392701BF73B03D6'
Found 'C:\ProgramData\chocolatey\lib\jdk8\jdk8.nuspec'
with checksum 'ADA433C41A17884028CD02AC2A564B7A'
Found 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyInstall.ps1'
with checksum '05323E0D4448D8F04B423107588755DA'
Found 'C:\ProgramData\chocolatey\lib\jdk8\tools\chocolateyUninstall.ps1'
with checksum 'CEB7702410D1D48BF15A2730D3C81719'
Found 'C:\ProgramData\chocolatey\lib\jdk8\tools\common.ps1'
with checksum '5E971C8323F234184BE7732C464D0979'
Found 'C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe'
with checksum 'C85AABF87700D59296EB5EB715D23CCC'
Found 'C:\ProgramData\chocolatey\lib\jdk8\tools\jdk-8u211-windows-x64.exe.ignore'
with checksum 'BEA07E6D2B8DCE396FE21BAA61B34956'
Attempting to create directory "C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211".
There was no original file at 'C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.registry'
There was no original file at 'C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.files'
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.extra".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.version".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.sxs".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\jdk8.8.0.211\.pin".
Sending message 'HandlePackageResultCompletedMessage' out if there are subscribers…
Attempting to delete file "C:\ProgramData\chocolatey\lib\jdk8\.chocolateyPending".
The install of jdk8 was successful.
Software installed to 'C:\Program Files\Java\jdk1.8.0_211\'
[NuGet] Installing 'oracle-sql-developer 19.1.0'.
[NuGet] Added file 'product.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'product64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'sqldeveloper.exe.gui' to folder 'oracle-sql-developer\sqldeveloper'.
[NuGet] Added file 'sdcli.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sdcli64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sql.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64W.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloperW.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'chocolateyinstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'chocolateyuninstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'helpers.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'product.conf' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'oracle-sql-developer.nuspec' to folder 'oracle-sql-developer'.
[NuGet] Added file 'oracle-sql-developer.nupkg' to folder 'oracle-sql-developer'.
[NuGet] Successfully installed 'oracle-sql-developer 19.1.0'.
oracle-sql-developer v19.1.0
oracle-sql-developer package files install completed. Performing other installation steps.
Setting installer args for oracle-sql-developer
Setting package parameters for oracle-sql-developer
Contents of 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1':
$ErrorActionPreference = 'Stop';
. "$toolsDir/helpers.ps1"
$packageDir = $env:ChocolateyPackageFolder
$toolsDir = Split-Path -parent $MyInvocation.MyCommand.Definition
$params = Get-PackageParameters
$version = '19.1.0'
$zipFileName = 'sqldeveloper-19.1.0.094.2042-no-jre.zip'
$url = "https://download.oracle.com/otn/java/sqldeveloper/$zipFileName&quot;
$sha1hash = '2e8778b1110a15d6447afddfe48efc1a885e1410'
$loginSubmit = 'https://login.oracle.com/oam/server/sso/auth_cred_submit&#39;
$proxy = Get-ChocolateyProxy $url
$packageArgs = @{
packageName = $env:ChocolateyPackageName
unzipLocation = $packageDir
url = ''
checksum = $sha1hash
checksumType = 'sha1'
}
if(!$params['Username'] -or !$params['Password']) {
throw @'
An Oracle account is required to download SQL Developer
* Provide your Oracle credentials as package params to the installer and
retry the installation:
choco install oracle-sql-developer –params "'/Username:{userName} /Password:{password}'"
* If you do not have an Oracle account, you can register for one here (it's free):
https://profile.oracle.com/myprofile/account/create-account.jspx
'@
}
Write-Host 'Redirecting to Oracle Login…'
$loginPage = Invoke-WebRequest -Uri $url -SessionVariable session @proxy
Write-Host 'Logging in…'
$licenseAcceptCookie = New-Object System.Net.Cookie -ArgumentList 'oraclelicense', 'accept-sqldev-cookie', '/', 'oracle.com'
$session.Cookies.Add($licenseAcceptCookie)
$loginFormFields = $loginPage.Forms['LoginForm'].Fields
$loginFormFields.ssousername = $params['Username']
$loginFormFields.password = $params['Password']
try {
Invoke-WebRequest -Uri $loginSubmit -Method Post -WebSession $session -Body $loginFormFields -MaximumRedirection 2 @proxy
}
catch {
$msg = $_.ErrorDetails.Message
if($msg -inotmatch 'AuthParam') {
throw "Oracle login unsuccessful: $_"
}
$packageArgs.url = [regex]::Match($msg, '.*(http.*)\.').Groups[1].Value
$packageArgs.url = $packageArgs.url.Replace('http', 'https')
}
Write-Host 'Oracle login successful'
Write-Debug "Authenticated download URL: $($packageArgs.url)"
Install-ChocolateyZipPackage @packageArgs
Write-Host 'Setting JDK path in product config…'
Write-Debug "JDK Path: $(Get-JdkPath)"
$productConfDir = Join-Path "$($env:APPDATA)" "sqldeveloper/$version"
$productConfPath = Join-Path $productConfDir 'product.conf'
$templatePath = Join-Path $toolsDir 'product.conf'
$template = Get-Content -Path $templatePath -Raw
$template = $template.Replace('%JdkPath%', $(Get-JdkPath))
New-Item -ItemType Directory -Path $productConfDir -ErrorAction SilentlyContinue
try {
$template | Out-File -FilePath $productConfPath -Encoding 'UTF8' -NoClobber
}
catch {
Write-Warning @"
Could not update SQL Developer product config file. It may already exist from a previous install or not be writable.
Check the file to ensure the 'SetJavaHome' path is set correctly. If no file exists at this path, it will
be created upon the first run of SQL Developer
Path: $productConfPath
"@
}
Write-Host 'Creating shortcuts…'
$exePath = Join-Path $packageDir 'sqldeveloper/sqldeveloper.exe'
$desktop = [Environment]::GetFolderPath([Environment+SpecialFolder]::Desktop)
$startMenu = [Environment]::GetFolderPath([Environment+SpecialFolder]::StartMenu)
$shortcut = 'Oracle SQL Developer.lnk'
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $desktop $shortcut) -TargetPath $exePath
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $startMenu "Programs/$shortcut") -TargetPath $exePath
The package oracle-sql-developer wants to run 'chocolateyinstall.ps1'.
Note: If you don't run this script, the installation will fail.
Note: To confirm automatically next time, use '-y' or consider:
choco feature enable -n allowGlobalConfirmation
Do you want to run the script?([Y]es/[N]o/[P]rint): yes
Calling built-in PowerShell host with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters ''']
Redirecting Microsoft.WSMan.Management.resources, Version=3.0.0.0, Culture=nl-NL, PublicKeyToken=31bf3856ad364e35, requested by ''
Host version is 5.1.17763.1, PowerShell Version is '5.1.17763.503' and CLR Version is '4.0.30319.42000'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
Loading community extensions
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Register-Application'.
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
VERBOSE: Importing function 'Format-FileSize'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-ChecksumValid'.
VERBOSE: Importing function 'Get-ChocolateyUnzip'.
VERBOSE: Importing function 'Get-ChocolateyWebFile'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-EnvironmentVariable'.
VERBOSE: Importing function 'Get-EnvironmentVariableNames'.
VERBOSE: Importing function 'Get-FtpFile'.
VERBOSE: Importing function 'Get-OSArchitectureWidth'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-PackageParametersBuiltIn'.
VERBOSE: Importing function 'Get-ToolsLocation'.
VERBOSE: Importing function 'Get-UACEnabled'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-VirusCheckValid'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Get-WebFile'.
VERBOSE: Importing function 'Get-WebFileName'.
VERBOSE: Importing function 'Get-WebHeaders'.
VERBOSE: Importing function 'Install-BinFile'.
VERBOSE: Importing function 'Install-ChocolateyDesktopLink'.
VERBOSE: Importing function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Importing function 'Install-ChocolateyFileAssociation'.
VERBOSE: Importing function 'Install-ChocolateyInstallPackage'.
VERBOSE: Importing function 'Install-ChocolateyPackage'.
VERBOSE: Importing function 'Install-ChocolateyPath'.
VERBOSE: Importing function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Importing function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Importing function 'Install-ChocolateyShortcut'.
VERBOSE: Importing function 'Install-ChocolateyVsixPackage'.
VERBOSE: Importing function 'Install-ChocolateyZipPackage'.
VERBOSE: Importing function 'Install-Vsix'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Register-Application'.
VERBOSE: Importing function 'Set-EnvironmentVariable'.
VERBOSE: Importing function 'Set-PowerShellExitCode'.
VERBOSE: Importing function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Importing function 'Test-ProcessAdminRights'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Uninstall-BinFile'.
VERBOSE: Importing function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Uninstall-ChocolateyPackage'.
VERBOSE: Importing function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Importing function 'Update-SessionEnvironment'.
VERBOSE: Importing function 'Write-ChocolateyFailure'.
VERBOSE: Importing function 'Write-ChocolateySuccess'.
VERBOSE: Importing function 'Write-FileUpdateLog'.
VERBOSE: Importing function 'Write-FunctionCallLogMessage'.
VERBOSE: Importing alias 'Add-BinFile'.
VERBOSE: Importing alias 'Generate-BinFile'.
VERBOSE: Importing alias 'Get-InstallRegistryKey'.
VERBOSE: Importing alias 'Get-OSBitness'.
VERBOSE: Importing alias 'Get-ProcessorBits'.
VERBOSE: Importing alias 'Invoke-ChocolateyProcess'.
VERBOSE: Importing alias 'refreshenv'.
VERBOSE: Importing alias 'Remove-BinFile'.
VERBOSE: Importing alias 'Start-ChocolateyProcess'.
Running 'ChocolateyScriptRunner' for oracle-sql-developer v19.1.0 with packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1', packageFolder:'C:\ProgramData\chocolatey\lib\oracle-sql-developer', installArguments: '', packageParameters: '',
Running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
ERROR: The term '/helpers.ps1' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
at <ScriptBlock>, C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1: line 3
at <ScriptBlock>, C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1: line 48
at <ScriptBlock>, <No file>: line 1
Built-in PowerShell host called with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters '''] exited with '-1'.
Calling command ['"C:\Windows\System32\shutdown.exe" /a']
Command ['"C:\Windows\System32\shutdown.exe" /a'] exited with '1116'
Capturing package files in 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nupkg'
with checksum '7300F8749BED92300029FD6EB0D6AC3F'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nuspec'
with checksum 'A51BB8BE82FDA08ABE4AB1651DD01691'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper.exe.gui'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sql.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
with checksum 'C7C072ECC7EB8F4363EA897D23B3C112'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyuninstall.ps1'
with checksum '4679F0B659414A8DFC9CAB78AED5953F'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\helpers.ps1'
with checksum '1F93E71C31D9FFBD66ACDAC389C178D2'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\product.conf'
with checksum 'CA4A0DA0F6216EE42B18BE735ED6E1FB'
Attempting to create directory "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0".
There was no original file at 'C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files'
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.arguments".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.extra".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.version".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.sxs".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.pin".
Sending message 'HandlePackageResultCompletedMessage' out if there are subscribers…
The install of oracle-sql-developer was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Moving 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
to 'C:\ProgramData\chocolatey\lib-bad\oracle-sql-developer'
Chocolatey installed 1/2 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
– oracle-sql-developer (exited -1) – Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Sending message 'PostRunMessage' out if there are subscribers…
Exiting with -1
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>

Error:

ERROR: The term '/helpers.ps1' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
 at <ScriptBlock>, C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1: line 3
at <ScriptBlock>, C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1: line 48
at <ScriptBlock>, <No file>: line 1
B

Srearches:

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>grep-gnu -inSw helpers *.*
.\tools\chocolateyinstall.ps1:3:. "$toolsDir/helpers.ps1"

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>dir /s /b helpers*.*
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer\tools\helpers.ps1

C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>grep-gnu -inSw toolsDir *.*
.\tools\chocolateyinstall.ps1:3:. "$toolsDir/helpers.ps1"
.\tools\chocolateyinstall.ps1:6:$toolsDir = Split-Path -parent $MyInvocation.MyCommand.Definition
.\tools\chocolateyinstall.ps1:74:$templatePath = Join-Path $toolsDir 'product.conf'

Relevant files:

  1. https://github.com/jpluimers/chocolatey-packages/blob/796b1e4978631daea42d7490fe5602346c482929/manual/oracle-sql-developer/tools/chocolateyinstall.ps1
  2. https://github.com/jpluimers/chocolatey-packages/blob/796b1e4978631daea42d7490fe5602346c482929/manual/oracle-sql-developer/tools/helpers.ps1

Problem is in the first: $toolsDir is used before it is assigned

$ErrorActionPreference = 'Stop';

. "$toolsDir/helpers.ps1"

$packageDir = $env:ChocolateyPackageFolder
$toolsDir = Split-Path -parent $MyInvocation.MyCommand.Definition

$params = Get-PackageParameters

Failure to pass credentials


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer –debug –verbose –source ".;chocolatey"
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer –debug –verbose –source ".;chocolatey"
Received arguments: install oracle-sql-developer –debug –verbose –source .;chocolatey
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer'|Prerelease='False'|
ForceX86='False'|
OverrideArguments='False'|NotSilent='False'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|
ListCommand.IdOnly='False'|ListCommand.IncludeRegistryPrograms='False'|
ListCommand.PageSize='25'|ListCommand.Exact='False'|
ListCommand.ByIdOnly='False'|ListCommand.ByTagOnly='False'|
ListCommand.IdStartsWith='False'|ListCommand.OrderByPopularity='False'|
ListCommand.ApprovedOnly='False'|
ListCommand.DownloadCacheAvailable='False'|
ListCommand.NotBroken='False'|
ListCommand.IncludeVersionOverrides='False'|
UpgradeCommand.FailOnUnfound='False'|
UpgradeCommand.FailOnNotInstalled='False'|
UpgradeCommand.NotifyOnlyAvailableUpgrades='False'|
UpgradeCommand.ExcludePrerelease='False'|
NewCommand.AutomaticPackage='False'|
NewCommand.UseOriginalTemplate='False'|SourceCommand.Command='unknown'|
SourceCommand.Priority='0'|SourceCommand.BypassProxy='False'|
SourceCommand.AllowSelfService='False'|
SourceCommand.VisibleToAdminsOnly='False'|
FeatureCommand.Command='unknown'|ConfigCommand.Command='unknown'|
ApiKeyCommand.Remove='False'|PinCommand.Command='unknown'|
OutdatedCommand.IgnorePinned='False'|Proxy.BypassOnLocal='True'|
_ Chocolatey:ChocolateyInstallCommand – Normal Run Mode _
Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Switching source name chocolatey to actual source value 'https://chocolatey.org/api/v2/&#39;.
Using '.'.
– Supports prereleases? 'True'.
– Is ServiceBased? 'False'.
Package 'oracle-sql-developer' found on source '.'
Using 'https://chocolatey.org/api/v2/&#39;.
– Supports prereleases? 'True'.
– Is ServiceBased? 'True'.
Package 'oracle-sql-developer' found on source 'https://chocolatey.org/api/v2/&#39;
[NuGet] Attempting to resolve dependency 'jdk8'.
[NuGet] Installing 'oracle-sql-developer 19.1.0'.
[NuGet] Added file 'product.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'product64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'sqldeveloper.exe.gui' to folder 'oracle-sql-developer\sqldeveloper'.
[NuGet] Added file 'sdcli.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sdcli64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sql.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64W.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloperW.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'chocolateyinstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'chocolateyuninstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'helpers.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'product.conf' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'oracle-sql-developer.nuspec' to folder 'oracle-sql-developer'.
[NuGet] Added file 'oracle-sql-developer.nupkg' to folder 'oracle-sql-developer'.
[NuGet] Successfully installed 'oracle-sql-developer 19.1.0'.
oracle-sql-developer v19.1.0
oracle-sql-developer package files install completed. Performing other installation steps.
Setting installer args for oracle-sql-developer
Setting package parameters for oracle-sql-developer
Contents of 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1':
$ErrorActionPreference = 'Stop';
$packageDir = $env:ChocolateyPackageFolder
$toolsDir = Split-Path -parent $MyInvocation.MyCommand.Definition
. "$toolsDir/helpers.ps1"
$params = Get-PackageParameters
$version = '19.1.0'
$zipFileName = 'sqldeveloper-19.1.0.094.2042-no-jre.zip'
$url = "https://download.oracle.com/otn/java/sqldeveloper/$zipFileName&quot;
$sha1hash = '2e8778b1110a15d6447afddfe48efc1a885e1410'
$loginSubmit = 'https://login.oracle.com/oam/server/sso/auth_cred_submit&#39;
$proxy = Get-ChocolateyProxy $url
$packageArgs = @{
packageName = $env:ChocolateyPackageName
unzipLocation = $packageDir
url = ''
checksum = $sha1hash
checksumType = 'sha1'
}
if(!$params['Username'] -or !$params['Password']) {
throw @'
An Oracle account is required to download SQL Developer
* Provide your Oracle credentials as package params to the installer and
retry the installation:
choco install oracle-sql-developer –params "'/Username:{userName} /Password:{password}'"
* If you do not have an Oracle account, you can register for one here (it's free):
https://profile.oracle.com/myprofile/account/create-account.jspx
'@
}
Write-Host 'Redirecting to Oracle Login…'
$loginPage = Invoke-WebRequest -Uri $url -SessionVariable session @proxy
Write-Host 'Logging in…'
$licenseAcceptCookie = New-Object System.Net.Cookie -ArgumentList 'oraclelicense', 'accept-sqldev-cookie', '/', 'oracle.com'
$session.Cookies.Add($licenseAcceptCookie)
$loginFormFields = $loginPage.Forms['LoginForm'].Fields
$loginFormFields.ssousername = $params['Username']
$loginFormFields.password = $params['Password']
try {
Invoke-WebRequest -Uri $loginSubmit -Method Post -WebSession $session -Body $loginFormFields -MaximumRedirection 2 @proxy
}
catch {
$msg = $_.ErrorDetails.Message
if($msg -inotmatch 'AuthParam') {
throw "Oracle login unsuccessful: $_"
}
$packageArgs.url = [regex]::Match($msg, '.*(http.*)\.').Groups[1].Value
$packageArgs.url = $packageArgs.url.Replace('http', 'https')
}
Write-Host 'Oracle login successful'
Write-Debug "Authenticated download URL: $($packageArgs.url)"
Install-ChocolateyZipPackage @packageArgs
Write-Host 'Setting JDK path in product config…'
Write-Debug "JDK Path: $(Get-JdkPath)"
$productConfDir = Join-Path "$($env:APPDATA)" "sqldeveloper/$version"
$productConfPath = Join-Path $productConfDir 'product.conf'
$templatePath = Join-Path $toolsDir 'product.conf'
$template = Get-Content -Path $templatePath -Raw
$template = $template.Replace('%JdkPath%', $(Get-JdkPath))
New-Item -ItemType Directory -Path $productConfDir -ErrorAction SilentlyContinue
try {
$template | Out-File -FilePath $productConfPath -Encoding 'UTF8' -NoClobber
}
catch {
Write-Warning @"
Could not update SQL Developer product config file. It may already exist from a previous install or not be writable.
Check the file to ensure the 'SetJavaHome' path is set correctly. If no file exists at this path, it will
be created upon the first run of SQL Developer
Path: $productConfPath
"@
}
Write-Host 'Creating shortcuts…'
$exePath = Join-Path $packageDir 'sqldeveloper/sqldeveloper.exe'
$desktop = [Environment]::GetFolderPath([Environment+SpecialFolder]::Desktop)
$startMenu = [Environment]::GetFolderPath([Environment+SpecialFolder]::StartMenu)
$shortcut = 'Oracle SQL Developer.lnk'
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $desktop $shortcut) -TargetPath $exePath
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $startMenu "Programs/$shortcut") -TargetPath $exePath
The package oracle-sql-developer wants to run 'chocolateyinstall.ps1'.
Note: If you don't run this script, the installation will fail.
Note: To confirm automatically next time, use '-y' or consider:
choco feature enable -n allowGlobalConfirmation
Do you want to run the script?([Y]es/[N]o/[P]rint): yes
Calling built-in PowerShell host with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters ''']
Redirecting System.Management.Automation.resources, Version=3.0.0.0, Culture=nl-NL, PublicKeyToken=31bf3856ad364e35, requested by ''
Host version is 5.1.17763.1, PowerShell Version is '5.1.17763.503' and CLR Version is '4.0.30319.42000'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
Loading community extensions
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Register-Application'.
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
VERBOSE: Importing function 'Format-FileSize'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-ChecksumValid'.
VERBOSE: Importing function 'Get-ChocolateyUnzip'.
VERBOSE: Importing function 'Get-ChocolateyWebFile'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-EnvironmentVariable'.
VERBOSE: Importing function 'Get-EnvironmentVariableNames'.
VERBOSE: Importing function 'Get-FtpFile'.
VERBOSE: Importing function 'Get-OSArchitectureWidth'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-PackageParametersBuiltIn'.
VERBOSE: Importing function 'Get-ToolsLocation'.
VERBOSE: Importing function 'Get-UACEnabled'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-VirusCheckValid'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Get-WebFile'.
VERBOSE: Importing function 'Get-WebFileName'.
VERBOSE: Importing function 'Get-WebHeaders'.
VERBOSE: Importing function 'Install-BinFile'.
VERBOSE: Importing function 'Install-ChocolateyDesktopLink'.
VERBOSE: Importing function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Importing function 'Install-ChocolateyFileAssociation'.
VERBOSE: Importing function 'Install-ChocolateyInstallPackage'.
VERBOSE: Importing function 'Install-ChocolateyPackage'.
VERBOSE: Importing function 'Install-ChocolateyPath'.
VERBOSE: Importing function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Importing function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Importing function 'Install-ChocolateyShortcut'.
VERBOSE: Importing function 'Install-ChocolateyVsixPackage'.
VERBOSE: Importing function 'Install-ChocolateyZipPackage'.
VERBOSE: Importing function 'Install-Vsix'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Register-Application'.
VERBOSE: Importing function 'Set-EnvironmentVariable'.
VERBOSE: Importing function 'Set-PowerShellExitCode'.
VERBOSE: Importing function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Importing function 'Test-ProcessAdminRights'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Uninstall-BinFile'.
VERBOSE: Importing function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Uninstall-ChocolateyPackage'.
VERBOSE: Importing function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Importing function 'Update-SessionEnvironment'.
VERBOSE: Importing function 'Write-ChocolateyFailure'.
VERBOSE: Importing function 'Write-ChocolateySuccess'.
VERBOSE: Importing function 'Write-FileUpdateLog'.
VERBOSE: Importing function 'Write-FunctionCallLogMessage'.
VERBOSE: Importing alias 'Add-BinFile'.
VERBOSE: Importing alias 'Generate-BinFile'.
VERBOSE: Importing alias 'Get-InstallRegistryKey'.
VERBOSE: Importing alias 'Get-OSBitness'.
VERBOSE: Importing alias 'Get-ProcessorBits'.
VERBOSE: Importing alias 'Invoke-ChocolateyProcess'.
VERBOSE: Importing alias 'refreshenv'.
VERBOSE: Importing alias 'Remove-BinFile'.
VERBOSE: Importing alias 'Start-ChocolateyProcess'.
Running 'ChocolateyScriptRunner' for oracle-sql-developer v19.1.0 with packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1', packageFolder:'C:\ProgramData\chocolatey\lib\oracle-sql-developer', installArguments: '', packageParameters: '',
Running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
Running Get-PackageParameters
Parsing $env:ChocolateyPackageParameters and $env:ChocolateyPackageParametersSensitive for parameters
ERROR: An Oracle account is required to download SQL Developer
* Provide your Oracle credentials as package params to the installer and
retry the installation:
choco install oracle-sql-developer –params "'/Username:{userName} /Password:{password}'"
* If you do not have an Oracle account, you can register for one here (it's free):
https://profile.oracle.com/myprofile/account/create-account.jspx
at <ScriptBlock>, C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1: line 26
at <ScriptBlock>, C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1: line 48
at <ScriptBlock>, <No file>: line 1
Built-in PowerShell host called with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters '''] exited with '-1'.
Calling command ['"C:\Windows\System32\shutdown.exe" /a']
Command ['"C:\Windows\System32\shutdown.exe" /a'] exited with '1116'
Capturing package files in 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nupkg'
with checksum '6B85C20E85EDF3AD7578ADA711702DD4'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nuspec'
with checksum 'A51BB8BE82FDA08ABE4AB1651DD01691'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper.exe.gui'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sql.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
with checksum '1F85E2659E9D72684F95398AC6DBBE7C'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyuninstall.ps1'
with checksum '4679F0B659414A8DFC9CAB78AED5953F'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\helpers.ps1'
with checksum '1F93E71C31D9FFBD66ACDAC389C178D2'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\product.conf'
with checksum 'CA4A0DA0F6216EE42B18BE735ED6E1FB'
Attempting to replace "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files"
with "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files.5840.update".
Backup placed at "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files.backup".
Attempting to copy "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files.5840.update"
to "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.files.5840.update".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.arguments".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.extra".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.version".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.sxs".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.pin".
Attempting to delete directory "C:\ProgramData\chocolatey\lib-bad\oracle-sql-developer".
Sending message 'HandlePackageResultCompletedMessage' out if there are subscribers…
The install of oracle-sql-developer was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Moving 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
to 'C:\ProgramData\chocolatey\lib-bad\oracle-sql-developer'
Chocolatey installed 0/1 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
– oracle-sql-developer (exited -1) – Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Sending message 'PostRunMessage' out if there are subscribers…
Exiting with -1
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>

Failure when Internet Explorer (iexplore) has not been run once yet


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer –debug –verbose –source ".;chocolatey" –params "'/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'"
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer –debug –verbose –source ".;chocolatey" –params "'/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'"
Received arguments: install oracle-sql-developer –debug –verbose –source .;chocolatey –params '/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer'|Prerelease='False'|
ForceX86='False'|
OverrideArguments='False'|NotSilent='False'|
PackageParameters='/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|
ListCommand.IdOnly='False'|ListCommand.IncludeRegistryPrograms='False'|
ListCommand.PageSize='25'|ListCommand.Exact='False'|
ListCommand.ByIdOnly='False'|ListCommand.ByTagOnly='False'|
ListCommand.IdStartsWith='False'|ListCommand.OrderByPopularity='False'|
ListCommand.ApprovedOnly='False'|
ListCommand.DownloadCacheAvailable='False'|
ListCommand.NotBroken='False'|
ListCommand.IncludeVersionOverrides='False'|
UpgradeCommand.FailOnUnfound='False'|
UpgradeCommand.FailOnNotInstalled='False'|
UpgradeCommand.NotifyOnlyAvailableUpgrades='False'|
UpgradeCommand.ExcludePrerelease='False'|
NewCommand.AutomaticPackage='False'|
NewCommand.UseOriginalTemplate='False'|SourceCommand.Command='unknown'|
SourceCommand.Priority='0'|SourceCommand.BypassProxy='False'|
SourceCommand.AllowSelfService='False'|
SourceCommand.VisibleToAdminsOnly='False'|
FeatureCommand.Command='unknown'|ConfigCommand.Command='unknown'|
ApiKeyCommand.Remove='False'|PinCommand.Command='unknown'|
OutdatedCommand.IgnorePinned='False'|Proxy.BypassOnLocal='True'|
_ Chocolatey:ChocolateyInstallCommand – Normal Run Mode _
Installing the following packages:
oracle-sql-developer
By installing you accept licenses for the packages.
Switching source name chocolatey to actual source value 'https://chocolatey.org/api/v2/&#39;.
Using '.'.
– Supports prereleases? 'True'.
– Is ServiceBased? 'False'.
Package 'oracle-sql-developer' found on source '.'
Using 'https://chocolatey.org/api/v2/&#39;.
– Supports prereleases? 'True'.
– Is ServiceBased? 'True'.
Package 'oracle-sql-developer' found on source 'https://chocolatey.org/api/v2/&#39;
[NuGet] Attempting to resolve dependency 'jdk8'.
[NuGet] Installing 'oracle-sql-developer 19.1.0'.
[NuGet] Added file 'product.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'product64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\ide\bin'.
[NuGet] Added file 'sqldeveloper.exe.gui' to folder 'oracle-sql-developer\sqldeveloper'.
[NuGet] Added file 'sdcli.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sdcli64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sql.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloper64W.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'sqldeveloperW.exe.ignore' to folder 'oracle-sql-developer\sqldeveloper\sqldeveloper\bin'.
[NuGet] Added file 'chocolateyinstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'chocolateyuninstall.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'helpers.ps1' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'product.conf' to folder 'oracle-sql-developer\tools'.
[NuGet] Added file 'oracle-sql-developer.nuspec' to folder 'oracle-sql-developer'.
[NuGet] Added file 'oracle-sql-developer.nupkg' to folder 'oracle-sql-developer'.
[NuGet] Successfully installed 'oracle-sql-developer 19.1.0'.
oracle-sql-developer v19.1.0
oracle-sql-developer package files install completed. Performing other installation steps.
Setting installer args for oracle-sql-developer
Setting package parameters for oracle-sql-developer
Contents of 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1':
$ErrorActionPreference = 'Stop';
$packageDir = $env:ChocolateyPackageFolder
$toolsDir = Split-Path -parent $MyInvocation.MyCommand.Definition
. "$toolsDir/helpers.ps1"
$params = Get-PackageParameters
$version = '19.1.0'
$zipFileName = 'sqldeveloper-19.1.0.094.2042-no-jre.zip'
$url = "https://download.oracle.com/otn/java/sqldeveloper/$zipFileName&quot;
$sha1hash = '2e8778b1110a15d6447afddfe48efc1a885e1410'
$loginSubmit = 'https://login.oracle.com/oam/server/sso/auth_cred_submit&#39;
$proxy = Get-ChocolateyProxy $url
$packageArgs = @{
packageName = $env:ChocolateyPackageName
unzipLocation = $packageDir
url = ''
checksum = $sha1hash
checksumType = 'sha1'
}
if(!$params['Username'] -or !$params['Password']) {
throw @'
An Oracle account is required to download SQL Developer
* Provide your Oracle credentials as package params to the installer and
retry the installation:
choco install oracle-sql-developer –params "'/Username:{userName} /Password:{password}'"
* If you do not have an Oracle account, you can register for one here (it's free):
https://profile.oracle.com/myprofile/account/create-account.jspx
'@
}
Write-Host 'Redirecting to Oracle Login…'
$loginPage = Invoke-WebRequest -Uri $url -SessionVariable session @proxy
Write-Host 'Logging in…'
$licenseAcceptCookie = New-Object System.Net.Cookie -ArgumentList 'oraclelicense', 'accept-sqldev-cookie', '/', 'oracle.com'
$session.Cookies.Add($licenseAcceptCookie)
$loginFormFields = $loginPage.Forms['LoginForm'].Fields
$loginFormFields.ssousername = $params['Username']
$loginFormFields.password = $params['Password']
try {
Invoke-WebRequest -Uri $loginSubmit -Method Post -WebSession $session -Body $loginFormFields -MaximumRedirection 2 @proxy
}
catch {
$msg = $_.ErrorDetails.Message
if($msg -inotmatch 'AuthParam') {
throw "Oracle login unsuccessful: $_"
}
$packageArgs.url = [regex]::Match($msg, '.*(http.*)\.').Groups[1].Value
$packageArgs.url = $packageArgs.url.Replace('http', 'https')
}
Write-Host 'Oracle login successful'
Write-Debug "Authenticated download URL: $($packageArgs.url)"
Install-ChocolateyZipPackage @packageArgs
Write-Host 'Setting JDK path in product config…'
Write-Debug "JDK Path: $(Get-JdkPath)"
$productConfDir = Join-Path "$($env:APPDATA)" "sqldeveloper/$version"
$productConfPath = Join-Path $productConfDir 'product.conf'
$templatePath = Join-Path $toolsDir 'product.conf'
$template = Get-Content -Path $templatePath -Raw
$template = $template.Replace('%JdkPath%', $(Get-JdkPath))
New-Item -ItemType Directory -Path $productConfDir -ErrorAction SilentlyContinue
try {
$template | Out-File -FilePath $productConfPath -Encoding 'UTF8' -NoClobber
}
catch {
Write-Warning @"
Could not update SQL Developer product config file. It may already exist from a previous install or not be writable.
Check the file to ensure the 'SetJavaHome' path is set correctly. If no file exists at this path, it will
be created upon the first run of SQL Developer
Path: $productConfPath
"@
}
Write-Host 'Creating shortcuts…'
$exePath = Join-Path $packageDir 'sqldeveloper/sqldeveloper.exe'
$desktop = [Environment]::GetFolderPath([Environment+SpecialFolder]::Desktop)
$startMenu = [Environment]::GetFolderPath([Environment+SpecialFolder]::StartMenu)
$shortcut = 'Oracle SQL Developer.lnk'
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $desktop $shortcut) -TargetPath $exePath
Install-ChocolateyShortcut -ShortcutFilePath $(Join-Path $startMenu "Programs/$shortcut") -TargetPath $exePath
The package oracle-sql-developer wants to run 'chocolateyinstall.ps1'.
Note: If you don't run this script, the installation will fail.
Note: To confirm automatically next time, use '-y' or consider:
choco feature enable -n allowGlobalConfirmation
Do you want to run the script?([Y]es/[N]o/[P]rint): yes
Calling built-in PowerShell host with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters '/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'']
Redirecting System.Management.Automation.resources, Version=3.0.0.0, Culture=nl-NL, PublicKeyToken=31bf3856ad364e35, requested by ''
Host version is 5.1.17763.1, PowerShell Version is '5.1.17763.503' and CLR Version is '4.0.30319.42000'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
Loading community extensions
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Register-Application'.
Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'
VERBOSE: Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Exporting function 'Format-FileSize'.
VERBOSE: Exporting function 'Get-ChecksumValid'.
VERBOSE: Exporting function 'Get-ChocolateyUnzip'.
VERBOSE: Exporting function 'Get-ChocolateyWebFile'.
VERBOSE: Exporting function 'Get-EnvironmentVariable'.
VERBOSE: Exporting function 'Get-EnvironmentVariableNames'.
VERBOSE: Exporting function 'Get-FtpFile'.
VERBOSE: Exporting function 'Get-OSArchitectureWidth'.
VERBOSE: Exporting function 'Get-PackageParameters'.
VERBOSE: Exporting function 'Get-PackageParametersBuiltIn'.
VERBOSE: Exporting function 'Get-ToolsLocation'.
VERBOSE: Exporting function 'Get-UACEnabled'.
VERBOSE: Exporting function 'Get-UninstallRegistryKey'.
VERBOSE: Exporting function 'Get-VirusCheckValid'.
VERBOSE: Exporting function 'Get-WebFile'.
VERBOSE: Exporting function 'Get-WebFileName'.
VERBOSE: Exporting function 'Get-WebHeaders'.
VERBOSE: Exporting function 'Install-BinFile'.
VERBOSE: Exporting function 'Install-ChocolateyDesktopLink'.
VERBOSE: Exporting function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Exporting function 'Install-ChocolateyFileAssociation'.
VERBOSE: Exporting function 'Install-ChocolateyInstallPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPackage'.
VERBOSE: Exporting function 'Install-ChocolateyPath'.
VERBOSE: Exporting function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Exporting function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Exporting function 'Install-ChocolateyShortcut'.
VERBOSE: Exporting function 'Install-ChocolateyVsixPackage'.
VERBOSE: Exporting function 'Install-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Install-Vsix'.
VERBOSE: Exporting function 'Set-EnvironmentVariable'.
VERBOSE: Exporting function 'Set-PowerShellExitCode'.
VERBOSE: Exporting function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Exporting function 'Test-ProcessAdminRights'.
VERBOSE: Exporting function 'Uninstall-BinFile'.
VERBOSE: Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Exporting function 'Uninstall-ChocolateyPackage'.
VERBOSE: Exporting function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Exporting function 'Update-SessionEnvironment'.
VERBOSE: Exporting function 'Write-ChocolateyFailure'.
VERBOSE: Exporting function 'Write-ChocolateySuccess'.
VERBOSE: Exporting function 'Write-FileUpdateLog'.
VERBOSE: Exporting function 'Write-FunctionCallLogMessage'.
VERBOSE: Exporting function 'Get-AppInstallLocation'.
VERBOSE: Exporting function 'Get-AvailableDriveLetter'.
VERBOSE: Exporting function 'Get-EffectiveProxy'.
VERBOSE: Exporting function 'Get-PackageCacheLocation'.
VERBOSE: Exporting function 'Get-WebContent'.
VERBOSE: Exporting function 'Register-Application'.
VERBOSE: Exporting function 'Install-WindowsUpdate'.
VERBOSE: Exporting function 'Test-WindowsUpdate'.
VERBOSE: Exporting alias 'Get-ProcessorBits'.
VERBOSE: Exporting alias 'Get-OSBitness'.
VERBOSE: Exporting alias 'Get-InstallRegistryKey'.
VERBOSE: Exporting alias 'Generate-BinFile'.
VERBOSE: Exporting alias 'Add-BinFile'.
VERBOSE: Exporting alias 'Start-ChocolateyProcess'.
VERBOSE: Exporting alias 'Invoke-ChocolateyProcess'.
VERBOSE: Exporting alias 'Remove-BinFile'.
VERBOSE: Exporting alias 'refreshenv'.
VERBOSE: Importing function 'Format-FileSize'.
VERBOSE: Importing function 'Get-AppInstallLocation'.
VERBOSE: Importing function 'Get-AvailableDriveLetter'.
VERBOSE: Importing function 'Get-ChecksumValid'.
VERBOSE: Importing function 'Get-ChocolateyUnzip'.
VERBOSE: Importing function 'Get-ChocolateyWebFile'.
VERBOSE: Importing function 'Get-EffectiveProxy'.
VERBOSE: Importing function 'Get-EnvironmentVariable'.
VERBOSE: Importing function 'Get-EnvironmentVariableNames'.
VERBOSE: Importing function 'Get-FtpFile'.
VERBOSE: Importing function 'Get-OSArchitectureWidth'.
VERBOSE: Importing function 'Get-PackageCacheLocation'.
VERBOSE: Importing function 'Get-PackageParameters'.
VERBOSE: Importing function 'Get-PackageParametersBuiltIn'.
VERBOSE: Importing function 'Get-ToolsLocation'.
VERBOSE: Importing function 'Get-UACEnabled'.
VERBOSE: Importing function 'Get-UninstallRegistryKey'.
VERBOSE: Importing function 'Get-VirusCheckValid'.
VERBOSE: Importing function 'Get-WebContent'.
VERBOSE: Importing function 'Get-WebFile'.
VERBOSE: Importing function 'Get-WebFileName'.
VERBOSE: Importing function 'Get-WebHeaders'.
VERBOSE: Importing function 'Install-BinFile'.
VERBOSE: Importing function 'Install-ChocolateyDesktopLink'.
VERBOSE: Importing function 'Install-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Install-ChocolateyExplorerMenuItem'.
VERBOSE: Importing function 'Install-ChocolateyFileAssociation'.
VERBOSE: Importing function 'Install-ChocolateyInstallPackage'.
VERBOSE: Importing function 'Install-ChocolateyPackage'.
VERBOSE: Importing function 'Install-ChocolateyPath'.
VERBOSE: Importing function 'Install-ChocolateyPinnedTaskBarItem'.
VERBOSE: Importing function 'Install-ChocolateyPowershellCommand'.
VERBOSE: Importing function 'Install-ChocolateyShortcut'.
VERBOSE: Importing function 'Install-ChocolateyVsixPackage'.
VERBOSE: Importing function 'Install-ChocolateyZipPackage'.
VERBOSE: Importing function 'Install-Vsix'.
VERBOSE: Importing function 'Install-WindowsUpdate'.
VERBOSE: Importing function 'Register-Application'.
VERBOSE: Importing function 'Set-EnvironmentVariable'.
VERBOSE: Importing function 'Set-PowerShellExitCode'.
VERBOSE: Importing function 'Start-ChocolateyProcessAsAdmin'.
VERBOSE: Importing function 'Test-ProcessAdminRights'.
VERBOSE: Importing function 'Test-WindowsUpdate'.
VERBOSE: Importing function 'Uninstall-BinFile'.
VERBOSE: Importing function 'Uninstall-ChocolateyEnvironmentVariable'.
VERBOSE: Importing function 'Uninstall-ChocolateyPackage'.
VERBOSE: Importing function 'Uninstall-ChocolateyZipPackage'.
VERBOSE: Importing function 'Update-SessionEnvironment'.
VERBOSE: Importing function 'Write-ChocolateyFailure'.
VERBOSE: Importing function 'Write-ChocolateySuccess'.
VERBOSE: Importing function 'Write-FileUpdateLog'.
VERBOSE: Importing function 'Write-FunctionCallLogMessage'.
VERBOSE: Importing alias 'Add-BinFile'.
VERBOSE: Importing alias 'Generate-BinFile'.
VERBOSE: Importing alias 'Get-InstallRegistryKey'.
VERBOSE: Importing alias 'Get-OSBitness'.
VERBOSE: Importing alias 'Get-ProcessorBits'.
VERBOSE: Importing alias 'Invoke-ChocolateyProcess'.
VERBOSE: Importing alias 'refreshenv'.
VERBOSE: Importing alias 'Remove-BinFile'.
VERBOSE: Importing alias 'Start-ChocolateyProcess'.
Running 'ChocolateyScriptRunner' for oracle-sql-developer v19.1.0 with packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1', packageFolder:'C:\ProgramData\chocolatey\lib\oracle-sql-developer', installArguments: '', packageParameters: '/Username:someone@example.org /Password:xxxxxxxxxxxxxxx',
Running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
Running Get-PackageParameters
Parsing $env:ChocolateyPackageParameters and $env:ChocolateyPackageParametersSensitive for parameters
Adding package param 'Username'='someone@example.org'
Adding package param 'Password'='xxxxxxxxxxxxxxx'
Redirecting to Oracle Login…
VERBOSE: GET https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-19.1.0.094.2042-no-jre.zip with 0-byte payload
VERBOSE: received 3903-byte response of content type text/html;charset=UTF-8
ERROR: The response content cannot be parsed because the Internet Explorer engine is not available, or Internet Explorer's first-launch configuration is not complete. Specify the UseBasicParsing parameter and try again.
at <ScriptBlock>, C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1: line 41
at <ScriptBlock>, C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1: line 48
at <ScriptBlock>, <No file>: line 1
Built-in PowerShell host called with ['[System.Threading.Thread]::CurrentThread.CurrentCulture = '';[System.Threading.Thread]::CurrentThread.CurrentUICulture = ''; & import-module -name 'C:\ProgramData\chocolatey\helpers\chocolateyInstaller.psm1'; & 'C:\ProgramData\chocolatey\helpers\chocolateyScriptRunner.ps1' -packageScript 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1' -installArguments '' -packageParameters '/Username:someone@example.org /Password:xxxxxxxxxxxxxxx''] exited with '-1'.
Calling command ['"C:\Windows\System32\shutdown.exe" /a']
Command ['"C:\Windows\System32\shutdown.exe" /a'] exited with '1116'
Capturing package files in 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nupkg'
with checksum '6B85C20E85EDF3AD7578ADA711702DD4'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\oracle-sql-developer.nuspec'
with checksum 'A51BB8BE82FDA08ABE4AB1651DD01691'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper.exe.gui'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\ide\bin\product64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sdcli64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sql.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe.ignore'
with checksum 'D41D8CD98F00B204E9800998ECF8427E'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'
with checksum '1F85E2659E9D72684F95398AC6DBBE7C'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyuninstall.ps1'
with checksum '4679F0B659414A8DFC9CAB78AED5953F'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\helpers.ps1'
with checksum '1F93E71C31D9FFBD66ACDAC389C178D2'
Found 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\product.conf'
with checksum 'CA4A0DA0F6216EE42B18BE735ED6E1FB'
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.arguments".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.extra".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.version".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.sxs".
Attempting to delete file "C:\ProgramData\chocolatey\.chocolatey\oracle-sql-developer.19.1.0\.pin".
Attempting to delete directory "C:\ProgramData\chocolatey\lib-bad\oracle-sql-developer".
Sending message 'HandlePackageResultCompletedMessage' out if there are subscribers…
The install of oracle-sql-developer was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Moving 'C:\ProgramData\chocolatey\lib\oracle-sql-developer'
to 'C:\ProgramData\chocolatey\lib-bad\oracle-sql-developer'
Chocolatey installed 0/1 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
– oracle-sql-developer (exited -1) – Error while running 'C:\ProgramData\chocolatey\lib\oracle-sql-developer\tools\chocolateyinstall.ps1'.
See log for details.
Sending message 'PostRunMessage' out if there are subscribers…
Exiting with -1
C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>

Success


C:\Users\jeroenp\Versioned\github\jpluimers\chocolatey-packages\manual\oracle-sql-developer>choco install oracle-sql-developer –debug –verbose –source ".;chocolatey" –params "'/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'"
Chocolatey v0.10.13
Chocolatey is running on Windows v 10.0.17763.0
Attempting to delete file "C:/ProgramData/chocolatey/choco.exe.old".
Attempting to delete file "C:\ProgramData\chocolatey\choco.exe.old".
Command line: "C:\ProgramData\chocolatey\choco.exe" install oracle-sql-developer –debug –verbose –source ".;chocolatey" –params "'/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'"
Received arguments: install oracle-sql-developer –debug –verbose –source .;chocolatey –params '/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'
RemovePendingPackagesTask is now ready and waiting for PreRunMessage.
Sending message 'PreRunMessage' out if there are subscribers…
[Pending] Removing all pending packages that should not be considered installed…
Performing validation checks.
Global Configuration Validation Checks:
– Package Exit Code / Exit On Reboot = Checked
System State Validation Checks:
Reboot Requirement Checks:
– Pending Computer Rename = Checked
– Pending Component Based Servicing = Checked
– Pending Windows Auto Update = Checked
– Pending File Rename Operations = Checked
– Pending Windows Package Installer = Checked
– Pending Windows Package Installer SysWow64 = Checked
The source '.;chocolatey' evaluated to a 'normal' source type
NOTE: Hiding sensitive configuration data! Please double and triple
check to be sure no sensitive data is shown, especially if copying
output to a gist for review.
Configuration: CommandName='install'|
CacheLocation='C:\Users\jeroenp\AppData\Local\Temp\chocolatey'|
ContainsLegacyPackageInstalls='True'|
CommandExecutionTimeoutSeconds='2700'|WebRequestTimeoutSeconds='30'|
Sources='.;chocolatey'|SourceType='normal'|Debug='True'|Verbose='True'|
Trace='False'|Force='False'|Noop='False'|HelpRequested='False'|
UnsuccessfulParsing='False'|RegularOutput='True'|QuietOutput='False'|
PromptForConfirmation='True'|AcceptLicense='False'|
AllowUnofficialBuild='False'|Input='oracle-sql-developer'|
AllVersions='False'|SkipPackageInstallProvider='False'|
PackageNames='oracle-sql-developer'|Prerelease='False'|
ForceX86='False'|
OverrideArguments='False'|NotSilent='False'|
PackageParameters='/Username:someone@example.org /Password:xxxxxxxxxxxxxxx'|
ApplyPackageParametersToDependencies='False'|
ApplyInstallArgumentsToDependencies='False'|IgnoreDependencies='False'|
AllowMultipleVersions='False'|AllowDowngrade='False'|
ForceDependencies='False'|Information.PlatformType='Windows'|
Information.PlatformVersion='10.0.17763.0'|
Information.PlatformName='Windows 10'|
Information.ChocolateyVersion='0.10.13.0'|
Information.ChocolateyProductVersion='0.10.13'|
Information.FullName='choco, Version=0.10.13.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb'|
Information.Is64BitOperatingSystem='True'|
Information.Is64BitProcess='True'|Information.IsInteractive='True'|
Information.UserName='jeroenp'|
Information.UserDomainName='X9SRI3F-W10P-NL'|
Information.IsUserAdministrator='True'|
Information.IsUserSystemAccount='False'|
Information.IsUserRemoteDesktop='False'|
Information.IsUserRemote='True'|
Information.IsProcessElevated='True'|
Information.IsLicensedVersion='False'|Information.LicenseType='Foss'|
Features.AutoUninstaller='True'|Features.ChecksumFiles='True'|
Features.AllowEmptyChecksums='False'|
Features.AllowEmptyChecksumsSecure='True'|
Features.FailOnAutoUninstaller='False'|
Features.FailOnStandardError='False'|Features.UsePowerShellHost='True'|
Features.LogEnvironmentValues='False'|Features.LogWithoutColor='False'|
Features.VirusCheck='False'|
Features.FailOnInvalidOrMissingLicense='False'|
Features.IgnoreInvalidOptionsSwitches='True'|
Features.UsePackageExitCodes='True'|
Features.UseEnhancedExitCodes='True'|
Features.UseFipsCompliantChecksums='False'|
Features.ShowNonElevatedWarnings='True'|
Features.ShowDownloadProgress='True'|
Features.StopOnFirstPackageFailure='False'|
Features.UseRememberedArgumentsForUpgrades='False'|
Features.IgnoreUnfoundPackagesOnUpgradeOutdated='False'|
Features.SkipPackageUpgradesWhenNotInstalled='False'|
Features.RemovePackageInformationOnUninstall='False'|
Features.ExitOnRebootDetected='False'|
Features.LogValidationResultsOnWarnings='True'|
Features.ScriptsCheckLastExitCode='False'|
ListCommand.LocalOnly='False'|