Re: BUG #17091: Cannot install with EDB installer when username contains diacritics

From: Paul Guyot <pguyot(at)kallisys(dot)net>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17091: Cannot install with EDB installer when username contains diacritics
Date: 2021-07-08 07:35:53
Message-ID: DFD94310-7A44-4C3E-97BC-7CCE8CA157C5@kallisys.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 8 Jul 2021, at 08:50, Guillaume Lelarge <guillaume(at)lelarge(dot)info <mailto:guillaume(at)lelarge(dot)info>> wrote:
>
> Hi,
>
> Le mer. 7 juil. 2021 à 19:39, PG Bug reporting form <noreply(at)postgresql(dot)org <mailto:noreply(at)postgresql(dot)(dot)org>> a écrit :
> The following bug has been logged on the website:
>
> Bug reference: 17091
> Logged by: Paul Guyot
> Email address: pguyot(at)kallisys(dot)net <mailto:pguyot(at)kallisys(dot)net>
> PostgreSQL version: 13.3
> Operating system: Windows 10
> Description:
>
> A user has diacritics in her account name (her first name is Jaunė with last
> character being U+0117).
>
> Installation with latest EDB Installer fails with the following message (in
> French) :
> > Une erreur s'est produite
> > Erreur dans l'execution de C:\\Windows\System32\icacls
> "C:\\Users\...\Temp/postgresql_installer_random" /T /Q /grand
> "azuread\jaune(OI)(CI)F": azuread\jaune: Le mappage entre les noms de compte
> et les ID de sécurité n'a pas été effectué.
>
> When exected in a shell, the reported icacls command line fails with the
> same error message.
>
> I believe the install script fails here:
> https://github.com/EnterpriseDB/edb-installers/blob/2bb85e7ef6203a48989991ab659c961a72aa05b6/server/installer.xml.in#L139 <https://github.com/EnterpriseDB/edb-installers/blob/2bb85e7ef6203a48989991ab659c961a72aa05b6/server/installer.xml.in#L139>
>
> ${whoami} is taken from C:\\Windows\System32\whoami
>
> Interestingly, when invoking C:\\Windows\System32\whoami in the shell, we
> get the username with diacritics (azuread\jaunė) instead of the username
> without diacritics in the error message. To be more precise, there are
> diacritics in the paths and these appear properly in the error message.
>
> When executed with this username, the icacls command line returns another
> error (which would translate to "Access refused"), but I guess this is
> because the command line was not executed with the proper rights.
>
>
> You should report this to EDB. There's nothing the community can do about this.

Guillaume,

Thank you for your reply!
I am confused about the status of EDB installers and archives as they are the only download option referred from postgresql.org <http://postgresql.org/> website:
https://www.postgresql.org/download/windows/ <https://www.postgresql.org/download/windows/>

Is there an officially supported alternative installation path for Windows?
For example, is it possible to install PostgreSQL on Windows from the EDB zip archive also mentioned on this postgresql.org <http://postgresql.org/> page?

Regards,

Paul

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Guillaume Lelarge 2021-07-08 07:49:17 Re: BUG #17091: Cannot install with EDB installer when username contains diacritics
Previous Message Guillaume Lelarge 2021-07-08 06:50:11 Re: BUG #17091: Cannot install with EDB installer when username contains diacritics