Re: BUG #18615: installer cannot be executed as "nt-autorität\system"

On Sat, Sep 21, 2024 at 3:21 PM <neral85(at)gmx(dot)de> wrote:

> PS C:\> icacls c:\Windows\Temp
> c:\Windows\Temp VORDEFINIERT\Benutzer:(CI)(S,WD,AD,X)
>
> VORDEFINIERT\Administratoren:(F)
>
> VORDEFINIERT\Administratoren:(OI)(CI)(IO)(F)
>
> NT-AUTORITÄT\SYSTEM:(F)
>
> NT-AUTORITÄT\SYSTEM:(OI)(CI)(IO)(F)
>
> ERSTELLER-BESITZER:(OI)(CI)(IO)(F)
>
> Successfully processed 1 files; Failed processing 0 files
>
> PS C:\>
>
>
>
> It looks like installer does set incorrect permissions for its temp folder
> in c:\Windows\Temp\. I can see the folder, e.g. C:\Windows\Temp
> \postgresql_installer_3086eea437.
>
>
>
> PS C:\> icacls C:\Windows\Temp\postgresql_installer_3086eea437\
>
> C:\Windows\Temp\postgresql_installer_3086eea437\DEVICENAME$:(F)
>
>
>
> It should inherit permission from c:\Windows\Temp\.
>
Hi,
Installer has some checks to handle "nt authority\system" users and your
system instead has “nt-autorität\system”.
I'm unable to reproduce the issue as I have "nt authority\system" user.
Right now I'm not sure how to handle the “nt-autorität\system” user. I will
look for the possibilities.

>
> *Von:* Muralikrishna Bandaru <muralikrishna(dot)bandaru(at)enterprisedb(dot)com>
> *Gesendet:* Mittwoch, 18. September 2024 14:58
> *An:* neral85(at)gmx(dot)de; pgsql-bugs(at)lists(dot)postgresql(dot)org
> *Betreff:* Re: BUG #18615: installer cannot be executed as
> "nt-autorität\system"
>
>
>
>
>
>
>
> On Thu, Sep 12, 2024 at 4:19 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 18615
> Logged by: neeral85
> Email address: neral85(at)gmx(dot)de
> PostgreSQL version: 16.4
> Operating system: Windows x64
> Description:
>
> 16.2 could be executed as "nt-autorität\system" while 16.4 cannot be
> executed as "nt-autorität\system"
>
> This is required by patch management software as it runs any installation
> as
> "nt-autorität\system" and not with current login user.
> ----------
> Log started 09/12/2024 at 12:23:00
> Preferred installation mode : unattended
> Trying to init installer in mode unattended
> Mode unattended successfully initialized
> Setting variable whoami from C:\Windows\System32\whoami
> Script exit code: 0
>
> Script output:
> nt-autorität\system
>
> Script stderr:
>
>
> Error copying file from packed archive
> C:/Users/User/tmp/postgresql-16.4-1-windows-x64.exe to
> C:/Windows/Temp/postgresql_installer_a27c6b7106/prerun_checks.vbs
> :Destination not writable
> system's temp folder is not writable by the current user.
> Exiting with code 1
> ------
>
> Hi,
>
> Maybe "nt-autorität\system" user doesn't have the write permission for the
> "C:/Windows/Temp/" folder.
> Can you please run the below icacls command and share the output.
>
>
>
> icacls c:\Windows\Temp
>