We are trying to manage the password for onboarded postgres account.But its not happening.

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

We are trying to manage the password for onboarded postgres account.But its not happening.

L3 Networker

We are trying to manage the password for onboarded postgres account.We used following link to download plugin and prerequisites:

https://community.cyberark.com/marketplace/s/#a352J000000dZISQA2-a392J000001Z3gRQAS

 

https://community.cyberark.com/marketplace/s/#a3550000000EiAkAAK-a3950000000jjTBAAY

When i pushed the verify then i got following error:

 

ImmediateTask. Failure Description: CACPM344E Verifying Password Safe: **********, Folder: Root, Object: Database-****************** failed (try #0). Code: 2103, Error: Error when verifypass to User ************ on Server ***************. State: IM002 Native error: 0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified  

 

Then i added the PMODBC.exe in CPM Plugin parameter of platfrom(after comparing another plugin in environment) then the change/verify process is not starting. In short i am not able to change/verify the account's password.

8 REPLIES 8

L6 Presenter

Hi @Nitin C​,

 

please specify if you use DSN or Connection string.

 

Nino

L5 Sessionator

Try DNS-LESS and it should work fine

L7 Applicator

Hi @Nitin C​ 

 

Why this might be happening ?

 

The above error you have shared suggets an issue with the ODBC driver configuration or the plugin parameters for managing the PostgreSQL account in the Platform Policy.

 

What are the possible solutions?

 

Please validate the following on CPM sever

 

  • ODBC connection
  • Validate whether Data Source Name (DSN) is missing or incorrectly specified
  • Validate whether the PostgreSQL ODBC driver is installed or not.

 

 

Also please refer to the following KB.

 

https://community.cyberark.com/s/article/How-to-manage-PostgreSQL-account-using-CPM

 

 

Hope the above information helps !

 

L3 Networker

Hi All,

I installed psqlodbc-setup.exe. Then i tested for connection while adding the DNS. Here i am getting sometimes FATAL error for database does not exist or password authentication failed for user. But i checked with database team that username, password and database all are correct. Still the test connection is failing.

 

Thanks.

L3 Networker

Hi All,

 

I am able to make test connection while adding the DNS in CPM connector server.

I imported the postgresql platform then i pushed for verification but the Process is not getting to complete.

I am getting below message 'This account is scheduled for immediate verification.'

 

Thanks,

Nitin

L5 Sessionator

whatever the installation files you have kept in CPM, just make sure those are in environmental variables. ODBC (32 bit) and other installation had to be done in admin mode. As well as you had to install x86 and x64 Microsoft c++ redistributable so that software would work fine.

L3 Networker

Hi All,

I am able to verify my sysadmin account.But when i push for change/reconcile i am getting error with various codes e.g.,Code: 2108, Error: Error in reading xml file;Code: 2103, Error: hat host and accepting TCP/IP connections?

Thanks,

Nitin

L3 Networker

Hi All,

 

I set the ReconcileWinExtraConnectionString to No ,after this i am getting  (Error: CACPM071E Error creating password operation process (error 1260).).

Thanks

Nitin

  • 172 Views
  • 8 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!