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

Le jeu. 8 juil. 2021 à 09:35, Paul Guyot <pguyot(at)kallisys(dot)net> a écrit :

>
>
> On 8 Jul 2021, at 08:50, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>
> Hi,
>
> Le mer. 7 juil. 2021 à 19:39, PG Bug reporting form <
> noreply(at)postgresql(dot)org <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
>> 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
>>
>> ${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 website:
> https://www.postgresql.org/download/windows/
>
>

Well, this mailing list is only about issues on the PostgreSQL source code.
Issues with installers, and packages (such as .deb or .rpm) should be
opened with the relative project (EDB for some installers,
yum.postgresql.org for RPM packages, etc).

Is there an officially supported alternative installation path for Windows?
>

There are no installers officially supported by the community. As far as I
remember, it was too much work. The PostgreSQL community officially
supports compilation on Windows.

For example, is it possible to install PostgreSQL on Windows from the EDB
> zip archive also mentioned on this postgresql.org page?
>
>
Yes, though there are more steps to do than just decompress the archive
(for example, create the Windows service).

--
Guillaume.