Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssM7S-007sxN-3W for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Sep 2024 12:55:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ssM7P-005MNd-Hg for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Sep 2024 12:55:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srwlt-00EzTo-8W for pgsql-bugs@lists.postgresql.org; Sat, 21 Sep 2024 09:51:22 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srwlr-000Jd6-6A for pgsql-bugs@lists.postgresql.org; Sat, 21 Sep 2024 09:51:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.de; s=s31663417; t=1726912272; x=1727517072; i=neral85@gmx.de; bh=xTnEogBNpJVSempkT6oD8SiZBQuGXtzwJrb/LRHVSNQ=; h=X-UI-Sender-Class:From:To:References:In-Reply-To:Subject:Date: Message-ID:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=H64UQ6uliZRIL06g/DT9ULKYcEa1ZVXuc1iyPTvoJe6PyrK+MHs/Th4VzpR4ZAfo FsNIUaju6Q1hRMttOdFLNM3L5mpsULnBD9ITdfJE7sN7+Zg30Z6m5T1JcSp7on8L2 g1fMhdsGm9YSTIpQBA0ohr61/3w8XA2gm5aj54EtowvXUQFiRgIKIP6PeZ4ExoKrT X+nCZd0EuLF6yF3YFHOzymIxm9lP1NPJnJPDd6Ggp7xhn4CDcp3v1kPEusebxkKT8 dNZVRVcOvxM7wX6EKjtj5dBmkU6EWEcH8uwLXU86Cca1iYMg1ep8l2WBZvzE1bf2e KFlN+7fSuCOz/9j20A== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from iscuew36 ([24.134.121.41]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MjS5A-1s76V33iXK-00fPFc; Sat, 21 Sep 2024 11:51:11 +0200 From: To: "'Muralikrishna Bandaru'" , References: <18615-4bc7fdf205fa1a83@postgresql.org> In-Reply-To: Subject: =?utf-8?Q?AW:_BUG_#18615:_installer_cannot?= =?utf-8?Q?_be_executed_as_=22nt-autorit=C3=A4t\sy?= =?utf-8?Q?stem=22?= Date: Sat, 21 Sep 2024 11:51:10 +0200 Message-ID: <000c01db0c0b$ca5a4a10$5f0ede30$@gmx.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01DB0C1C.8DE56400" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQKfZ9MLuSCVQwyU2vTS5wcTYklL+ALTg0hWsMKqhfA= Content-Language: de X-Provags-ID: V03:K1:efqtfIZw+MwYSMYWGusqg8HyI4qyTTBxBbZgUvdZgAuUHHeL4am 4NlSgE5N82uf4CShpNQHu+l/7KTn1CEN5P7Y67Mwm0doPyzYtxK5DRM86wYRiWum+paeSVX Z7C6gWuCsCgJA82PNZXeo+FDD/Q5NPm8evPbZG/phn8kJEYMwCvPw+/Zxzb+9XapXFJhlLb SnOHsuf5/mYq7gG3QTihA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:RZyEE1jRtdQ=;4V1MNDj0jLKs9QKW4Ah4k1DdB/l fPHp2vWAEa0dL27yJETY5dzUuyf0jhxRCRiAQ7er71h1pGMMLubUUMKBnl72NSL/eNTCP0ZGt KQ2GSLCfMlqMS+cUcxcgDkoAjsCy89M3p+Lsni4tkAmScm6k3wq5a6LhzqbwV4CiJBxv9dFtX OUkGcs5qAWWB/sNa7XbIkbusFPa3DHrGEOzU5S37kYe+08CNXHcVgHunZKM1r/eRDAPXJsSIf 9vSUSsYjH/PM/RQ7PzLmNI0Yt4GpBaHAHmgEyicCRhJpVtznVovxwY19L9SRHEzjiGZ69wNZG 3CqVcFlxtr3VimoBWS5jbdaG02iFdH2qtA3eyUaqzp+OtTdY8J0r7XifGMhePIw97URFsQxwx Acwk3Jxb++d/RBbWqKhkVpZLQWeuTHh8uBPIvzOgJYnwRoGdXuu6EqfOCK3gQg1Evr5Xb2j/B hBOcu3kqgQxOrm9zEJ4DhI0TDMh3ZNifgMH4t2IzMnlWXSOhAAjMuHJKBHMoJ3oW2mV4htWev F7HKk2MEfwts9mtyuAjFpKjgW7HuZGge7Lhw3UCxa8LsxUdoOOVsHN4XGkOjfjydBV9fhCyJh 8sX6Xw7sWag4Qam4UnGzUVgJwDdu7l06v5NvzhcX5pnq0Qs1TX/vnL57lK9vEYQrB1PeaSY59 uhcPABxUCREjy5syBtkZwrG1EIazNyAM6j6qIZSvKurA9+49fIQQvh9+bEF6JRDAU0hQyvNfC YX3ur7HR2v5ORQTFmYtyYIlx2PAJbOPwEhSnPGP4SP6MqyCynczdp97gkZ5hCnNePvtwo1u/R KeR33LaYKGaHqu5H+VdPA+jg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_000D_01DB0C1C.8DE56400 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable 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=C3=84T\SYSTEM:(F) NT-AUTORIT=C3=84T\SYSTEM:(OI)(CI)(IO)(F) ERSTELLER-BESITZER:(OI)(CI)(IO)(F) Successfully processed 1 files; Failed processing 0 files PS C:\> =20 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. =20 PS C:\> icacls C:\Windows\Temp\postgresql_installer_3086eea437\ C:\Windows\Temp\postgresql_installer_3086eea437\DEVICENAME$:(F) =20 It should inherit permission from c:\Windows\Temp\. =20 Von: Muralikrishna Bandaru =20 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=C3=A4t\system" =20 =20 =20 On Thu, Sep 12, 2024 at 4:19=E2=80=AFPM PG Bug reporting form = > wrote: The following bug has been logged on the website: Bug reference: 18615 Logged by: neeral85 Email address: neral85@gmx.de =20 PostgreSQL version: 16.4 Operating system: Windows x64 Description: =20 16.2 could be executed as "nt-autorit=C3=A4t\system" while 16.4 cannot = be executed as "nt-autorit=C3=A4t\system" This is required by patch management software as it runs any = installation as "nt-autorit=C3=A4t\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=20 Script exit code: 0 Script output: nt-autorit=C3=A4t\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=C3=A4t\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. =20 icacls c:\Windows\Temp ------=_NextPart_000_000D_01DB0C1C.8DE56400 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

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=C3=84T\SYSTEM:(F)

      =           = NT-AUTORIT=C3=84T\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=C3=A4t\system"

 

 

 

On = Thu, Sep 12, 2024 at 4:19=E2=80=AFPM PG Bug reporting form <noreply@postgresql.org> = wrote:

The following bug has been logged on the = website:

Bug reference:      18615
Logged = by:          neeral85
Email address:  =     neral85@gmx.de
PostgreSQL version: = 16.4
Operating system:   Windows x64
Description:  =      

16.2 could be executed as = "nt-autorit=C3=A4t\system" while 16.4 cannot be
executed as = "nt-autorit=C3=A4t\system"

This is required by patch = management software as it runs any installation = as
"nt-autorit=C3=A4t\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=C3=A4t\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=C3=A4t\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

------=_NextPart_000_000D_01DB0C1C.8DE56400--