CPM Postgre/ODBC connection with SSL

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

CPM Postgre/ODBC connection with SSL

L4 Transporter

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%';

1 accepted solution

Accepted Solutions

L4 Transporter

answer is in the description:)

View solution in original post

3 REPLIES 3

L4 Transporter

answer is in the description:)

L1 Bithead

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.

That is no exact error message

  • 1 accepted solution
  • 1298 Views
  • 3 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!