From: | Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com> |
---|---|
To: | "Ware, Christopher M(dot) (LARC-D318)[RSES]" <christopher(dot)m(dot)ware(at)nasa(dot)gov> |
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 08:02:28 |
Message-ID: | CANFyU96=NbYax9wh80iLCv5VLZ8VWhWeaNOEmGL--fp6VJZHGQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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> 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> 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>;
>> 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>
>> *Sent:* Tuesday, July 2, 2024 10:42 PM
>> *To:* Ware, Christopher M. (LARC-D318)[RSES] <christopher(dot)m(dot)ware(at)nasa(dot)gov>;
>> 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> 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
>> 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 | Todor Kostadinov | 2024-08-02 10:17:36 | upgrade to pgAdmin 4 v8.10 Released |
Previous Message | David G. Johnston | 2024-08-02 05:45:33 | Re: Inconsistency of timezones in postgresql |