New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Publish in Windows Store #60

Closed
ansgarbecker opened this Issue Dec 29, 2017 · 9 comments

Comments

Projects
None yet
2 participants
@ansgarbecker
Collaborator

ansgarbecker commented Dec 29, 2017

Expected behavior

HeidiSQL available in Windows Store.

Current behavior

Not found there.

With Microsoft's DesktopAppConverter, it should be possible to wrap the HeidiSQL installer in what they expect to be in a .appx file.

Some docs for this conversion:

After that "conversion", it should be published.

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Dec 29, 2017

Collaborator

Here's a forum reporter asking for that too.

What I yet did was:

  1. download the Windows 10 SDK
  2. install Desktop App Converter from the store
  3. activated the "Container" feature, in "Activate Windows features" dialog
  4. downloaded the latest Win10 image container from https://aka.ms/converterimages
  5. start DesktopAppConverter with admin privileges
  6. extend the downloaded image using this ps-command:
    DesktopAppConverter -Setup -BaseImage C:\Users\Ansgar\Downloads\Windows_InsiderPreview_DAC_16299.wim
  7. try to create the appx package with this command:
    DesktopAppConverter -Installer c:\heidisql\apxtemp\HeidiSQL_9.5.0.5196.exe -Destination c:\heidisql\appx\ -PackageName "HeidiSQL" -InstallerArguments "/VERYSILENT /LOG=<log_folder>\install.log" -Publisher "CN=Ansgar Becker" -Version 9.5.0.5196 -MakeAppx -Verbose

The converter starts and complains about nothing, but then hangs at this message:

[2017-12-29T15:37:28] Running installer command in Isolated Environment
[2017-12-29T15:37:28] Command line: "C:\shared\installer\HeidiSQL_9.5.exe" /VERYSILENT /LOG=C:\shared\logs\install.log /DIR=expand:{userpf}\HeidiSQL
[2017-12-29T15:37:30] Waiting for installer process to complete inside Isolated Environment

So, my guess is the isolated image environment starts the HeidiSQL installer but then the /VERYSILENT flag does not work as expected somehow.

Collaborator

ansgarbecker commented Dec 29, 2017

Here's a forum reporter asking for that too.

What I yet did was:

  1. download the Windows 10 SDK
  2. install Desktop App Converter from the store
  3. activated the "Container" feature, in "Activate Windows features" dialog
  4. downloaded the latest Win10 image container from https://aka.ms/converterimages
  5. start DesktopAppConverter with admin privileges
  6. extend the downloaded image using this ps-command:
    DesktopAppConverter -Setup -BaseImage C:\Users\Ansgar\Downloads\Windows_InsiderPreview_DAC_16299.wim
  7. try to create the appx package with this command:
    DesktopAppConverter -Installer c:\heidisql\apxtemp\HeidiSQL_9.5.0.5196.exe -Destination c:\heidisql\appx\ -PackageName "HeidiSQL" -InstallerArguments "/VERYSILENT /LOG=<log_folder>\install.log" -Publisher "CN=Ansgar Becker" -Version 9.5.0.5196 -MakeAppx -Verbose

The converter starts and complains about nothing, but then hangs at this message:

[2017-12-29T15:37:28] Running installer command in Isolated Environment
[2017-12-29T15:37:28] Command line: "C:\shared\installer\HeidiSQL_9.5.exe" /VERYSILENT /LOG=C:\shared\logs\install.log /DIR=expand:{userpf}\HeidiSQL
[2017-12-29T15:37:30] Waiting for installer process to complete inside Isolated Environment

So, my guess is the isolated image environment starts the HeidiSQL installer but then the /VERYSILENT flag does not work as expected somehow.

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Jan 3, 2018

Collaborator

Looks like the isolated container asks for admin privileges.
How do I prevent the UAC prompt waiting forever?

Collaborator

ansgarbecker commented Jan 3, 2018

Looks like the isolated container asks for admin privileges.
How do I prevent the UAC prompt waiting forever?

ansgarbecker added a commit that referenced this issue Jan 3, 2018

Introduce a separate installer script for creating an installer which…
… can run without admin privileges, and which has the install directory set to the current user's Program Files directory. Relevant for issue #60
@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Jan 3, 2018

Collaborator

Ok, there are obvously two things to fix in the [Setup] section of an InnoSetup install script:

  • DefaultDirName={userpf}\{#ProgName}
  • PrivilegesRequired=lowest

The first one says: use C:\Users\MyName\AppData\Local\Programs\ as default target directory, not C:\Program files\.
The second one tells the installer not to request an UAC dialog to come up.

Additionally, in the [Registry] section, writing to registry keys other then HKEY_CURRENT_USER results in warning messages. These can be suppressed/ignored by using Flags: noerror.

I have just created a separate installer with the above configuration. But using the Desktop App Converter, I just still get this damned waiter:

AUSFÜHRLICH: Running installer command in Isolated Environment
AUSFÜHRLICH: Command line: "C:\shared\installer\HeidiSQL_9.5_appx.exe" /VERYSILENT /LOG=C:\shared\logs\install.log
AUSFÜHRLICH: Waiting for installer process to complete inside Isolated Environment

and then... nothing happens any more. :(

Collaborator

ansgarbecker commented Jan 3, 2018

Ok, there are obvously two things to fix in the [Setup] section of an InnoSetup install script:

  • DefaultDirName={userpf}\{#ProgName}
  • PrivilegesRequired=lowest

The first one says: use C:\Users\MyName\AppData\Local\Programs\ as default target directory, not C:\Program files\.
The second one tells the installer not to request an UAC dialog to come up.

Additionally, in the [Registry] section, writing to registry keys other then HKEY_CURRENT_USER results in warning messages. These can be suppressed/ignored by using Flags: noerror.

I have just created a separate installer with the above configuration. But using the Desktop App Converter, I just still get this damned waiter:

AUSFÜHRLICH: Running installer command in Isolated Environment
AUSFÜHRLICH: Command line: "C:\shared\installer\HeidiSQL_9.5_appx.exe" /VERYSILENT /LOG=C:\shared\logs\install.log
AUSFÜHRLICH: Waiting for installer process to complete inside Isolated Environment

and then... nothing happens any more. :(

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Jan 7, 2018

Collaborator

I just got some steps further.
I managed to create an appx package, by not using the installer:

DesktopAppConverter -Installer c:\heidisql\apxtemp\ -AppExecutable heidisql.exe
  -Destination c:\heidisql\appx\ -PackageName "HeidiSQL" -Publisher "CN=Ansgar Becker"
  -Version 0.0.0.0 -MakeAppx -Verbose -Sign

I uploaded that package in the dev center, and got various errors.

  • One was that I was not allowed to submit packages converted with the DesktopBride, so I asked MS per form to give me this privilege. Just waiting for an answer now.
  • Another error was that the -Version parameter must not contain something other than 0.0.0.0 - very strange.
  • Then, my publisher name contained a comma "Ansgar Becker, Software Development", but commas are not allowed in one publisher name. So I changed my publisher name in the dev center to "Ansgar Becker", saved it, but I still get this error. Perhaps this takes some time to finalize.
    Update: there is a warning when changing it:

Warning: If you change your publisher display name your account will undergo an additional review, and you'll need to re-package and re-submit your apps with the new name.

  • The last one which I cannot find a workaround for is this one:

Package acceptance validation error: You don't have permissions to specify the following namespaces in the appx manifest file of the package HeidiSQL.appx: restricted namespace: http://schemas.microsoft.com/appx/manifest/foundation/windows10/restrictedcapabilities

Collaborator

ansgarbecker commented Jan 7, 2018

I just got some steps further.
I managed to create an appx package, by not using the installer:

DesktopAppConverter -Installer c:\heidisql\apxtemp\ -AppExecutable heidisql.exe
  -Destination c:\heidisql\appx\ -PackageName "HeidiSQL" -Publisher "CN=Ansgar Becker"
  -Version 0.0.0.0 -MakeAppx -Verbose -Sign

I uploaded that package in the dev center, and got various errors.

  • One was that I was not allowed to submit packages converted with the DesktopBride, so I asked MS per form to give me this privilege. Just waiting for an answer now.
  • Another error was that the -Version parameter must not contain something other than 0.0.0.0 - very strange.
  • Then, my publisher name contained a comma "Ansgar Becker, Software Development", but commas are not allowed in one publisher name. So I changed my publisher name in the dev center to "Ansgar Becker", saved it, but I still get this error. Perhaps this takes some time to finalize.
    Update: there is a warning when changing it:

Warning: If you change your publisher display name your account will undergo an additional review, and you'll need to re-package and re-submit your apps with the new name.

  • The last one which I cannot find a workaround for is this one:

Package acceptance validation error: You don't have permissions to specify the following namespaces in the appx manifest file of the package HeidiSQL.appx: restricted namespace: http://schemas.microsoft.com/appx/manifest/foundation/windows10/restrictedcapabilities

ansgarbecker added a commit that referenced this issue Jan 31, 2018

Disable SSH tunnel connections on Windows 10 S, as a requirement for …
…publishing HeidiSQL in the Windows App store, #60.

ansgarbecker added a commit that referenced this issue Feb 3, 2018

ansgarbecker added a commit that referenced this issue Feb 6, 2018

ansgarbecker added a commit that referenced this issue Feb 6, 2018

Issue #60: Try to fix non-working RunningOnWindows10S, by passing the…
… current OS version numbers to GetProductInfo()

ansgarbecker added a commit that referenced this issue Feb 6, 2018

Issue #60: Store snippets in C:\Users\anse\Documents\HeidiSQL\Snippet…
…s by default, not C:\Users\anse\AppData\Roaming\HeidiSQL\Snippets
@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Feb 17, 2018

Collaborator

Just uploaded the first valid package in Microsoft's dev center, with the help of Marc - thanks a lot for his help here.

Now HeidiSQL awaits certification.

Collaborator

ansgarbecker commented Feb 17, 2018

Just uploaded the first valid package in Microsoft's dev center, with the help of Marc - thanks a lot for his help here.

Now HeidiSQL awaits certification.

@ansgarbecker ansgarbecker added this to the v9.6 milestone Feb 18, 2018

@wwelborn

This comment has been minimized.

Show comment
Hide comment
@wwelborn

wwelborn Feb 20, 2018

Hey @ansgarbecker, HeidiSQL is showing up in the store (at least in the US) but hitting the Get button and trying to download it throws this error:
image

Based on the error message, it might be something you want to open a ticket against with MS. :)

wwelborn commented Feb 20, 2018

Hey @ansgarbecker, HeidiSQL is showing up in the store (at least in the US) but hitting the Get button and trying to download it throws this error:
image

Based on the error message, it might be something you want to open a ticket against with MS. :)

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Feb 20, 2018

Collaborator

Here in Germany it is not even listed, at least not as an app page in the store, only in the auto-suggest-pulldown on the search menu. The status of the review process in the dev center is still:

  • Can get packages: yes
  • Can see Store listing: pending
Collaborator

ansgarbecker commented Feb 20, 2018

Here in Germany it is not even listed, at least not as an app page in the store, only in the auto-suggest-pulldown on the search menu. The status of the review process in the dev center is still:

  • Can get packages: yes
  • Can see Store listing: pending
@wwelborn

This comment has been minimized.

Show comment
Hide comment
@wwelborn

wwelborn Feb 20, 2018

I just tried again and this time it was able to download and install. Isn't global CDN propagation fun?
image

Thank you for releasing it through the store as well!

wwelborn commented Feb 20, 2018

I just tried again and this time it was able to download and install. Isn't global CDN propagation fun?
image

Thank you for releasing it through the store as well!

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Feb 20, 2018

Collaborator

Yes!! See it now! Hehe, but that CDN is definitely no fun! :)

Collaborator

ansgarbecker commented Feb 20, 2018

Yes!! See it now! Hehe, but that CDN is definitely no fun! :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment