pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
5+ messages / 3 participants
[nested] [flat]


* Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
@ 2024-07-05 11:21  Harald.Munsch@it.nrw.de
  0 siblings, 2 replies; 5+ messages in thread

From: Harald.Munsch@it.nrw.de @ 2024-07-05 11:21 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: Claudia.Siepmann@it.nrw.de

Hello,

 

when installing PostgreSQL version 16.3.2 on a windows 10 client with the setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in SYSTEM-context, the installation failes with following error-message:

(The error occures directly after starting the installation.)

 

„There has been an error. Unable to write inside TEMP environment path“

 

Even though the system-account has full permissions to this path.

An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM ) on the same client runs succesfully.

 

We want to deploy the software with SCCM, therefore, we need to use the SYSTEM-account.

Can you please provide us with a setup that works in SYSTEM-context ?

 



 



 

 

 

Thank you for your support.

Kind regards

 

Mit freundlichen Grüßen

Harald Munsch

 

-- 

 

Information und Technik

Nordrhein-Westfalen (IT.NRW)

 

 

mailto:harald.munsch@it.nrw.de

 

Attachments:


image001.png (image/png, 8.0K) download
  view image



image002.png (image/png, 4.7K) download
  view image


  smime.p7s (application/pkcs7-signature, 6.4K) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
@ 2024-07-07 10:56  Muhammad Ikram <mmikram@gmail.com>
  parent: Harald.Munsch@it.nrw.de
  1 sibling, 1 reply; 5+ messages in thread

From: Muhammad Ikram @ 2024-07-07 10:56 UTC (permalink / raw)
  To: Harald.Munsch@it.nrw.de; +Cc: pgsql-bugs@lists.postgresql.org; Claudia.Siepmann@it.nrw.de

Hi,

Have you checked whether the system user has the right permissions on Temp
which is being used ? Please navigate to the temp that SYSTEM is using and
check permissions and adjust accordingly.  Right click on the Temp
directory, move to the Security tab and ensure that the system user has
full control permissions.

You may get more detailed logging by trying to install using a terminal.

postgresql-16.3-2-windows-x64.exe /S /L*v %TEMP%\postgresql-install.log

Hope this helps

Regards,
Muhammad Ikram,
Bitnine Global.


On Sun, Jul 7, 2024 at 3:11 PM <Harald.Munsch@it.nrw.de> wrote:

> Hello,
>
>
>
> when installing PostgreSQL version 16.3.2 on a windows 10 client with the
> setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in
> SYSTEM-context, the installation failes with following error-message:
>
> (The error occures directly after starting the installation.)
>
>
>
> *„There has been an error. Unable to write inside TEMP environment path“*
>
>
>
> Even though the system-account has full permissions to this path.
>
> An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM )
> on the same client runs succesfully.
>
>
>
> We want to deploy the software with SCCM, therefore, we need to use the
> SYSTEM-account.
>
> Can you please provide us with a setup that works in SYSTEM-context ?
>
>
>
>
>
>
>
>
>
>
>
> Thank you for your support.
>
> Kind regards
>
>
>
> Mit freundlichen Grüßen
>
> Harald Munsch
>
>
>
> --
>
>
>
> Information und Technik
>
> Nordrhein-Westfalen (IT.NRW)
>
>
>
>
>
> mailto:harald.munsch@it.nrw.de <harald.munsch@it.nrw.de>
>
>
>


-- 
Muhammad Ikram

Attachments:


image001.png (image/png, 8.0K) download
  view image



image002.png (image/png, 4.7K) download
  view image


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
@ 2024-07-08 06:13  Muhammad Ikram <mmikram@gmail.com>
  parent: Muhammad Ikram <mmikram@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Muhammad Ikram @ 2024-07-08 06:13 UTC (permalink / raw)
  To: Harald.Munsch@it.nrw.de; +Cc: pgsql-bugs@lists.postgresql.org; Claudia.Siepmann@it.nrw.de

Hi Harald.Munsch,

Thanks  for sharing it with me. Could you try the solution suggested ?

For quite sometime, I have not worked on Windows so don't have environment
with me to try things for you.

Regards,
Muhammad Ikram


On Mon, Jul 8, 2024 at 11:01 AM <Harald.Munsch@it.nrw.de> wrote:

> Hello,
>
>
>
> thank you for your fast response.
>
>
>
> I checked the permissions: the SYSTEM-account has full permissions to the
> TEMP-folder.
>
>
>
> In the internet i found a correspondence regarding an older version of
> PostgreSQL from a user with a similar problem. Please see following link:
>
>
> https://www.postgresql.org/message-id/SL2P216MB0666FD5553AA70BAE3092060F9D00%40SL2P216MB0666.KORP216...
>
>
>
> Maybe the cause of the current error is similar?
>
>
>
> Kind regards,
>
> Harald
>
>
>
>
>
> *Von:* Muhammad Ikram <mmikram@gmail.com>
> *Gesendet:* Sonntag, 7. Juli 2024 12:57
> *An:* Munsch, Harald (IT.NRW) <Harald.Munsch@it.nrw.de>
> *Cc:* pgsql-bugs@lists.postgresql.org; Siepmann, Claudia (IT.NRW) <
> Claudia.Siepmann@it.nrw.de>
> *Betreff:* Re: Error when installing PostgreSQL 16.3.2 under system
> context NT AUTHORITY\SYSTEM
>
>
>
> Hi,
>
>
>
> Have you checked whether the system user has the right permissions on Temp
> which is being used ? Please navigate to the temp that SYSTEM is using and
> check permissions and adjust accordingly.  Right click on the Temp
> directory, move to the Security tab and ensure that the system user has
> full control permissions.
>
>
>
> You may get more detailed logging by trying to install using a terminal.
>
>
>
> postgresql-16.3-2-windows-x64.exe /S /L*v %TEMP%\postgresql-install.log
>
>
>
> Hope this helps
>
>
>
> Regards,
>
> Muhammad Ikram,
>
> Bitnine Global.
>
>
>
>
>
> On Sun, Jul 7, 2024 at 3:11 PM <Harald.Munsch@it.nrw.de> wrote:
>
> Hello,
>
>
>
> when installing PostgreSQL version 16.3.2 on a windows 10 client with the
> setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in
> SYSTEM-context, the installation failes with following error-message:
>
> (The error occures directly after starting the installation.)
>
>
>
> *„There has been an error. Unable to write inside TEMP environment path“*
>
>
>
> Even though the system-account has full permissions to this path.
>
> An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM )
> on the same client runs succesfully.
>
>
>
> We want to deploy the software with SCCM, therefore, we need to use the
> SYSTEM-account.
>
> Can you please provide us with a setup that works in SYSTEM-context ?
>
>
>
>
>
>
>
>
>
>
>
> Thank you for your support.
>
> Kind regards
>
>
>
> Mit freundlichen Grüßen
>
> Harald Munsch
>
>
>
> --
>
>
>
> Information und Technik
>
> Nordrhein-Westfalen (IT.NRW)
>
>
>
>
>
> mailto:harald.munsch@it.nrw.de <harald.munsch@it.nrw.de>
>
>
>
>
>
> --
>
> Muhammad Ikram
>


-- 
Muhammad Ikram

Attachments:


image001.png (image/png, 4.7K) download
  view image



image002.png (image/png, 8.0K) download
  view image


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
@ 2024-07-08 11:35  Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
  parent: Harald.Munsch@it.nrw.de
  1 sibling, 1 reply; 5+ messages in thread

From: Sandeep Thakkar @ 2024-07-08 11:35 UTC (permalink / raw)
  To: Harald.Munsch@it.nrw.de; +Cc: pgsql-bugs@lists.postgresql.org; Claudia.Siepmann@it.nrw.de

Hi Harald,

Could you execute these commands and share the output in the SYSTEM-context?

whoami
> icacls %TEMP%



On Sun, Jul 7, 2024 at 3:41 PM <Harald.Munsch@it.nrw.de> wrote:

> Hello,
>
>
>
> when installing PostgreSQL version 16.3.2 on a windows 10 client with the
> setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in
> SYSTEM-context, the installation failes with following error-message:
>
> (The error occures directly after starting the installation.)
>
>
>
> *„There has been an error. Unable to write inside TEMP environment path“*
>
>
>
> Even though the system-account has full permissions to this path.
>
> An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM )
> on the same client runs succesfully.
>
>
>
> We want to deploy the software with SCCM, therefore, we need to use the
> SYSTEM-account.
>
> Can you please provide us with a setup that works in SYSTEM-context ?
>
>
>
>
>
>
>
>
>
>
>
> Thank you for your support.
>
> Kind regards
>
>
>
> Mit freundlichen Grüßen
>
> Harald Munsch
>
>
>
> --
>
>
>
> Information und Technik
>
> Nordrhein-Westfalen (IT.NRW)
>
>
>
>
>
> mailto:harald.munsch@it.nrw.de <harald.munsch@it.nrw.de>
>
>
>


-- 
Sandeep Thakkar

Attachments:


image001.png (image/png, 8.0K) download
  view image



image002.png (image/png, 4.7K) download
  view image


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
@ 2024-07-08 12:58  Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
  parent: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Sandeep Thakkar @ 2024-07-08 12:58 UTC (permalink / raw)
  To: Harald.Munsch@it.nrw.de; +Cc: pgsql-bugs@lists.postgresql.org; Claudia.Siepmann@it.nrw.de

OK, I see the system account does have the correct ACL on %TEMP%, so it's
odd the installation is failing. Also, I'm unable to reproduce the issue at
my end.

Could you please run the installer with the command line option
"--debugtrace debug.txt" and share this file? Also, please share
installation log if produced and found at %TEMP%

On Mon, Jul 8, 2024 at 5:14 PM <Harald.Munsch@it.nrw.de> wrote:

> Hello Sandeep,
>
>
>
> here is the output:
>
>
>
> C:\WINDOWS\system32>whoami
>
> nt-autorität\system
>
>
>
> C:\WINDOWS\system32>icacls %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)
>
>
>
>
>
> Harald
>
>
>
>
>
>
>
> *Von:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
> *Gesendet:* Montag, 8. Juli 2024 13:35
> *An:* Munsch, Harald (IT.NRW) <Harald.Munsch@it.nrw.de>
> *Cc:* pgsql-bugs@lists.postgresql.org; Siepmann, Claudia (IT.NRW) <
> Claudia.Siepmann@it.nrw.de>
> *Betreff:* Re: Error when installing PostgreSQL 16.3.2 under system
> context NT AUTHORITY\SYSTEM
>
>
>
> Hi Harald,
>
> Could you execute these commands and share the output in the
> SYSTEM-context?
>
> whoami
> icacls %TEMP%
>
>
>
>
>
> On Sun, Jul 7, 2024 at 3:41 PM <Harald.Munsch@it.nrw.de> wrote:
>
> Hello,
>
>
>
> when installing PostgreSQL version 16.3.2 on a windows 10 client with the
> setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in
> SYSTEM-context, the installation failes with following error-message:
>
> (The error occures directly after starting the installation.)
>
>
>
> *„There has been an error. Unable to write inside TEMP environment path“*
>
>
>
> Even though the system-account has full permissions to this path.
>
> An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM )
> on the same client runs succesfully.
>
>
>
> We want to deploy the software with SCCM, therefore, we need to use the
> SYSTEM-account.
>
> Can you please provide us with a setup that works in SYSTEM-context ?
>
>
>
>
>
>
>
>
>
>
>
> Thank you for your support.
>
> Kind regards
>
>
>
> Mit freundlichen Grüßen
>
> Harald Munsch
>
>
>
> --
>
>
>
> Information und Technik
>
> Nordrhein-Westfalen (IT.NRW)
>
>
>
>
>
> mailto:harald.munsch@it.nrw.de <harald.munsch@it.nrw.de>
>
>
>
>
>
>
> --
>
> Sandeep Thakkar
>
>
>


-- 
Sandeep Thakkar

Attachments:


image001.png (image/png, 4.7K) download
  view image



image002.png (image/png, 8.0K) download
  view image


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

end of thread, other threads:[~2024-07-08 12:58 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-05 11:21 Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM Harald.Munsch@it.nrw.de
2024-07-07 10:56 ` Muhammad Ikram <mmikram@gmail.com>
2024-07-08 06:13   ` Muhammad Ikram <mmikram@gmail.com>
2024-07-08 11:35 ` Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
2024-07-08 12:58   ` Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>

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