Page 1 of 1

PostgreSQL 9.5.4-1 install fail

PostPosted: Wed Apr 11, 2018 12:30 am
by Igor Riđanović
The PostgreSQL 9.5.4-1 bundled with Resolve 14.3 and 15 Beta 1 Windows versions fails to install when the security policy for passwords is strict.

We have a domain wide security policy mandated by the studios where passwords are required to have certain length and structure. The installer supplies "DaVinci" as the password argument for the newly created "postgres" user to the postgresql-9.5.4-1-windows_x64.exe installer :

Code: Select all
--servicepassword DaVinci


But "DaVinci" does not meet the minimal requirements and Windows 10 aborts creation of the "postgres" user. You can refer to the excerpt from the ResolveInstallLog.txt below.

We can not alter the domain password policy. The workaround is to temporarily disconnect from the domain, install Resolve, and join the domain again.

However, it would be easier if the default password were more complex, or if there was a way for end users to edit the installation script that contains the password string.

2018-04-10 11:40:42 -- Executable: C:\Users\editor\AppData\Local\Temp\{DD43BA6D-EC6C-4F90-8348-D57FE5ED9267}\postgresql-9.5.4-1-windows_x64.exe
2018-04-10 11:40:42 -- Additional command-line parameters: --mode unattended --unattendedmodeui minimal --servicepassword DaVinci --superpassword DaVinci --superaccount postgres --serviceaccount postgres --debuglevel 4 --locale "English, United States"
2018-04-10 11:40:42 Executing: C:\Users\editor\AppData\Local\Temp\{DD43BA6D-EC6C-4F90-8348-D57FE5ED9267}\postgresql-9.5.4-1-windows_x64.exe --mode unattended --unattendedmodeui minimal --servicepassword DaVinci --superpassword DaVinci --superaccount postgres --serviceaccount postgres --debuglevel 4 --locale "English, United States"
2018-04-10 11:41:08 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1): DIALOG CLOSED
2018-04-10 11:41:08 Component 'postgresql-9.5.4-1-windows_x64.exe' return code 1 (0x1).
2018-04-10 11:41:08 *** Component 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): ERROR - Error executing 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): 1 (0x1)
2018-04-10 11:41:08 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1)' FAILED: Error executing 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): 1 (0x1)
2018-04-10 11:42:15 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1): FAILED, ABORTING
2018-04-10 11:42:15 *** Failed to install one or more components, reloading components (reload_on_error).

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Mon Jun 18, 2018 5:24 pm
by DakotaHoosier
Did you get this fixed for your install? I'm having the same problem and looking for the next step.

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Sat Jul 07, 2018 3:27 am
by Darryl
I think this is a bug somewhere in the install process, either BMD or Windows. I have the same issue, and I got around it by installing PostgreSQL independently of Resolve, with the same user ID and password. No issues at all with the install even in a domain with complexity requirements on the password. but a bit of work in the Project Manager in Resolve to switch over from local database to the PostgreSQL db. Early days, but I have installed v10 of PostgreSQL and can't see any issues with that.

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Thu Jul 12, 2018 6:11 am
by Peter Chamberlain
Darryl, interesting that you have v10 working. Please note its not currently tested or formally supported as yet so id be keen to hear of issues when you have them.

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Tue Nov 10, 2020 10:34 am
by stephan.hassenpflug
Hi Together,

this issue still exist. I tried with version 17 and 16.
I also unplugged my laptop from the internet...
Still same error message.

Rgds
Stephan

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Sat Feb 06, 2021 12:12 am
by Phil86
I've just installed it and had this issue (followed by another issue, but that's a different post).

You don't need to disconnect from the internet - you need to remove your machine from the domain (in my case I was using a laptop from work) and log into it as a local admin, then do the install, then you can re-join the domain again.

I've read since, you can just install Postgre from their site before you install DaVinci, but didn't try that.

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Mon Feb 08, 2021 2:26 am
by Danfree
Stephan -

I am experiencing the same problem. I contacted Da Vinci support and they said to talk to people on the forum.

This sucks.

Re: PostgreSQL 9.5.4-1 install fail

PostPosted: Sun Jul 18, 2021 2:53 am
by SavvyMatthew
So I had the same issue, there is a group policy that needs to be disabled temporarily to allow the install see the attached picture below. Make sure to turn it back on after install. ( Note once you click apply and ok its applied)

BMCC-Password Complexity.png
Screenshot of GPO for Install.
BMCC-Password Complexity.png (72.96 KiB) Viewed 1873 times