ClearPass - database access

I'm trying to connect to a ClearPass databases to see how and what exactly is saved so I can hopefully use some of that with a custom query to satisfy customer requests.


One such customer request resulted in a blacklist-user-db query that polls the user_id from one of its tables and then does some amazing magic with that. These queries usualy come from Aruba support.


Now, having received such a query again I'd like to adapt it a little bit and for that I'd need a look into the table and records itself to see what I can actualy use.


For this I downloaded DbVisualizer and plugged in the database settings I could find for the database source. 

This however does not let me in.


Has any tinkered with (looked into) a ccpm database like this succesfully?

Care to share a tip or 2?

Koen (ACMX #351 | ACDX #547 | ACCP)

-- Found something helpful, important, or cool? Click the Kudos Star in a post.
-- Problem Solved? Click "Accept as Solution" in a post.

Re: ClearPass - database access

A couple things you need to do..


1. make sure you have appexternal password set






2. custom properties on the sql SSL







Thank You,

--Give Kudos: found something helpful, important, or cool? Click Kudos Star in a post.

--Problem Solved? Click "Accepted Solution" in a post.
Frequent Contributor I

Re: ClearPass - database access

I hate to resurect an old thread but I thought this might be the best place to add this


I have the following version of dbVisualizer 


Product: DbVisualizer Free 9.2.6 [Build #2447]
OS: Mac OS X
OS Version: 10.10.2
OS Arch: x86_64
Java Version: 1.7.0_80
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Vendor: Oracle Corporation

And have not been able to set up the SSL settings referenced above - I was able to make this work on my older installation on Mavericks - I am now on Yosimite and the latest version. Has something changed or have I missed something, The driver used is the standard posgreSQL and it will not allow any changes


Screen Shot 2015-04-25 at 10.57.12 PM.png 

Aruba Employee

Re: ClearPass - database access

I'll take a look at it and respond to this thread later. In the mean time, I recommend using pgAdmin3 to connect to the ClearPass databases.

Zach Jennings
Search Airheads
Showing results for 
Search instead for 
Did you mean: