pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: neral85@gmx.de
To: 'Muralikrishna Bandaru' <muralikrishna.bandaru@enterprisedb.com>
To: pgsql-bugs@lists.postgresql.org
Subject: AW: BUG #18615: installer cannot be executed as "nt-autorität\system"
Date: Sat, 21 Sep 2024 11:51:10 +0200
Message-ID: <000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de> (raw)
In-Reply-To: <CA+uec8DOzrYOrq8gzK5kSROTtJYL-GMSFiXPeP+NiHZA0D23Wg@mail.gmail.com>
References: <18615-4bc7fdf205fa1a83@postgresql.org>
	<CA+uec8DOzrYOrq8gzK5kSROTtJYL-GMSFiXPeP+NiHZA0D23Wg@mail.gmail.com>

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\.

 

Von: Muralikrishna Bandaru <muralikrishna.bandaru@enterprisedb.com> 
Gesendet: Mittwoch, 18. September 2024 14:58
An: neral85@gmx.de; pgsql-bugs@lists.postgresql.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@postgresql.org <mailto:noreply@postgresql.org> > wrote:

The following bug has been logged on the website:

Bug reference:      18615
Logged by:          neeral85
Email address:      neral85@gmx.de <mailto:neral85@gmx.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

view thread (2+ messages)  latest in thread

Message-ID: <000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de>
Permalink:  ../000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de/
Also on:    postgresql.org/message-id/000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: neral85@gmx.de, muralikrishna.bandaru@enterprisedb.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: AW: BUG #18615: installer cannot be executed as "nt-autorität\system"
  In-Reply-To: <000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox