BUG #17091: Cannot install with EDB installer when username contains diacritics
The following bug has been logged on the website:
Bug reference: 17091
Logged by: Paul Guyot
Email address: pguyot@kallisys.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.
Hi,
Le mer. 7 juil. 2021 à 19:39, PG Bug reporting form <noreply@postgresql.org>
a écrit :
The following bug has been logged on the website:
Bug reference: 17091
Logged by: Paul Guyot
Email address: pguyot@kallisys.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:
${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.
On 8 Jul 2021, at 08:50, Guillaume Lelarge <guillaume@lelarge.info <mailto:guillaume@lelarge.info>> wrote:
Hi,
Le mer. 7 juil. 2021 à 19:39, PG Bug reporting form <noreply@postgresql.org <mailto:noreply@postgresql..org>> a écrit :
The following bug has been logged on the website:Bug reference: 17091
Logged by: Paul Guyot
Email address: pguyot@kallisys.net <mailto:pguyot@kallisys.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
Le jeu. 8 juil. 2021 à 09:35, Paul Guyot <pguyot@kallisys.net> a écrit :
On 8 Jul 2021, at 08:50, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Hi,
Le mer. 7 juil. 2021 à 19:39, PG Bug reporting form <
noreply@postgresql.org <noreply@postgresql..org>> a écrit :The following bug has been logged on the website:
Bug reference: 17091
Logged by: Paul Guyot
Email address: pguyot@kallisys.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:
${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.