From: | "Ware, Christopher M(dot) (LARC-D318)[RSES]" <christopher(dot)m(dot)ware(at)nasa(dot)gov> |
---|---|
To: | Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Manika Singhal <manika(dot)singhal(at)enterprisedb(dot)com> |
Subject: | RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing |
Date: | 2024-08-02 11:38:55 |
Message-ID: | SA9PR09MB5376B254B3CBAA07442F73A7ACB32@SA9PR09MB5376.namprd09.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The same user was used. I obfuscated the username for privacy reasons and apparently didn’t use the same name in the obfuscation between tries.
What is strange is the same install works on a Win10 system and a Windows 11 laptop. I’m only having trouble on the Microsoft Surface Pro 9. Almost seems like the installer is looking at hardware or OS type and not recognizing it properly.
I have tried previous version of the installer on the Surface Pro as well and they all have the same error. It just seems to be something with this type of hardware or OS version.
Thanks,
Chris
From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Sent: Friday, August 2, 2024 4:02 AM
To: Ware, Christopher M. (LARC-D318)[RSES] <christopher(dot)m(dot)ware(at)nasa(dot)gov>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org; Manika Singhal <manika(dot)singhal(at)enterprisedb(dot)com>
Subject: Re: [EXTERNAL] Re: BUG #18528: Installer displays error when installing
CAUTION: This email originated from outside of NASA. Please take care when clicking links or opening attachments. Use the "Report Message" button to report suspicious messages to the NASA SOC.
Hi Chris,
Did you install the installer with a different username this time around? As per the earlier installation log the user was 'domain\username' and with the new installation log, it is ndc\USER.
Also, looking at this error, it seems the ACLs are not allowed to create a directory inside $installdir which seems very strange to me.
Failed to create the data directory (C:\Program Files\PostgreSQL\15\data)
I'm not sure if any commits in 15.7 are causing this. Could you once try installing the previous version of 15? The v15.5 can be downloaded from this URL: https://sbp.enterprisedb.com/getfile.jsp?fileid=1258790
On Wed, Jul 31, 2024 at 6:30 PM Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>> wrote:
Apology for the delayed response. Thank you for the details. I'll check and revert in a day or two
On Wed, Jul 10, 2024 at 10:01 PM Ware, Christopher M. (LARC-D318)[RSES] <christopher(dot)m(dot)ware(at)nasa(dot)gov<mailto:christopher(dot)m(dot)ware(at)nasa(dot)gov>> wrote:
I have some more information to share on the installation issue.
I was able to find a partial work-around for the installation issue on the surface Pro 9 system running windows 10. (As a side note, the installation worked without issue on a laptop running windows 11.)
Once I started the installer, I waited for the first error message box to pop up that had the “Retry, Ignore, Cancel” option on it (while watching the user/appdata/local/temp folder.) Once the folder appeared, I ran the following command from an administrator command prompt window: takeown /F c:\users\USER\appdata\local\temp\postgresql_installer_XXXXXXXXXX (where XXXXXXXXXX is the hex value the installer used). After the command was run (choosing ‘y’ to accept), I clicked on the ‘Retry’ button of the message box. The installation was then able to proceed. I didn’t have any other issues until the end of the installer when I received a message box about a problem running post-install step, screen shot attached.
I also noticed several more postgresql_installer_xxxxxxxxxx folders were created, all with the same permissions problem.
It almost seems like the installer doesn’t recognize the hardware or something and not applying permissions correctly. I have Cygwin installed on the system and using it to get a listing of the folders that have the permission problem it lists the folder as owned by Administrators and the group of Domain Users. The actual permissions seen are “d---rwx---+” which is no permissions for user, read, write and execute for group, and no permissions for other.
I don’t know why the installer would put incorrect permissions on the folders it creates. I’m also assuming that the attached screen shot of the last error received is due to the same permissions problem for later steps in the install process that creates the additional folders.
One other piece of information is that looking at the permissions of the folder after I ran the takeown command on it, cygwin shows “drwxr-x---” with an “Unknown+User” and “Unknown+Group” but apparently it doesn’t care about who the user is, just the permissions that the OS has to follow.
I have also attached the log files generated during this partial work-around attempt.
Thanks,
Chris
From: Ware, Christopher M. (LARC-D318)[RSES]
Sent: Wednesday, July 3, 2024 8:12 AM
To: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>>; pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing
This is a newly purchased system. This is the first time I’ve tried to install PostgreSQL on it.
I initially tried to install 15.7 and when that failed I tried the 14 and 16 version installers. Both had the same behavior. I even tried the version 12 installer, but it also gave the same errors.
I had deleted all the previous directories that were created, so I had to run the install again this morning. Log file for this run is attached and the results for the icacls command is below.
I will add that in order to delete the directory/folder that the installer creates I have to double click the folder at which time it says I don’t have permissions and asks if I want to permanently grant permissions.
Output of the icacls command:
C:\Windows\system32>icacls c:\Users\cmware\AppData\Local\Temp\postgresql_installer_a879bd9971
c:\Users\username\AppData\Local\Temp\postgresql_installer_a879bd9971 LA-3544-SPRO9-1\username:(F)
Successfully processed 1 files; Failed processing 0 files
C:\Windows\system32>
Thank you,
Chris
From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>>
Sent: Tuesday, July 2, 2024 10:42 PM
To: Ware, Christopher M. (LARC-D318)[RSES] <christopher(dot)m(dot)ware(at)nasa(dot)gov<mailto:christopher(dot)m(dot)ware(at)nasa(dot)gov>>; pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: [EXTERNAL] Re: BUG #18528: Installer displays error when installing
CAUTION: This email originated from outside of NASA. Please take care when clicking links or opening attachments. Use the "Report Message" button to report suspicious messages to the NASA SOC.
Hi,
Thanks for the report. Can you please confirm if the earlier versions (<=15.6) were installed fine on this server?
The forward slashes usually work on windows as well. Could you please share the installation log which must have been created in the system temp with either the name installbuilder or install-postgresql?
Also, on the command line if you can please get the output of:
> icacls C:/Users/username/AppData/Local/Temp/postgresql_installer_f34465eff3
On Wed, Jul 3, 2024 at 1:13 AM PG Bug reporting form <noreply(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:
The following bug has been logged on the website:
Bug reference: 18528
Logged by: Chris Ware
Email address: christopher(dot)m(dot)ware(at)nasa(dot)gov<mailto:christopher(dot)m(dot)ware(at)nasa(dot)gov>
PostgreSQL version: 15.7
Operating system: Windows 11
Description:
This probably isn't the right place to submit this finding, but I couldn't
find any other place to submit it.
If this is not the correct forum for this kind of support, can you please
redirect me to the correct place?
I'm trying to install the PostgreSQL 15.7 installer onto a Microsoft Surface
Pro 9 running Windows 10.
I'm running as an administrator, and I've also clicked "Run as
Administrator" as well. I receive the following two errors:
1: "Error copying from packed archive
c:/Install/folder/postgresql-15.7.2-windows-x64.exe to
C:/Users/username/AppData/Local/Temp/postgresql_installer_f34465eff3/prerun_checks.vbs:Destination
not writable"
2. "There has been an error. system's temp folder is not writable by the
current user."
The error messages have forward slashes '/' instead of back slashes '\'.
Not sure it that makes a difference or not.
The installer does appear to work on Desktop type computers.
Since I am an administrator on the system and the installer is trying to
write files to the directory owned by this user, it seems to be a problem
with the installer on this type of hardware.
Any assistance is appreciated.
Chris
--
Sandeep Thakkar
--
Sandeep Thakkar
--
Sandeep Thakkar
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2024-08-02 12:04:24 | Re: BUG #18564: Incorrect sorting with using NULLS LAST (NULLS FIRST) |
Previous Message | Muhammad Waqas | 2024-08-02 11:28:54 | Re: upgrade to pgAdmin 4 v8.10 Released |