- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
12-15-2020 01:40 AM
I couldn't find any guide here so I'm posting my solutions for this topic:
The changes must be done under the platform's/policy's "Additional policy settings"
if SSL must be used:
Driver={PostgreSQL UNICODE};Server=%ADDRESS%;[Database=%DATABASE%;]Uid=%USER%;Pwd=%LOGONPASSWORD%;[Port=%PORT%];SSLmode=require
If SSL with full certificate validation is required:
Driver={PostgreSQL UNICODE};Server=%ADDRESS%;[Database=%DATABASE%;]Uid=%USER%;Pwd=%LOGONPASSWORD%;[Port=%PORT%];SSLmode=verify-full;pqopt={sslrootcert=D:\\Software\\Certificates\\cachain.pem}
If username includes "-" (minus/hypen), enclose the username in the command with doublequotes:
ALTER USER "%USER%" WITH PASSWORD '%NEWPASSWORD%';
12-15-2020 01:41 AM
answer is in the description:)
08-25-2022 08:18 AM
I am getting this exact error after using your solution.
uery The CPM is trying to change this password because its status matches the following search criteria: ResetImmediately,OneTimePassword.
08-25-2022 12:19 PM
That is no exact error message
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

