Security

Reply
MVP
Posts: 765
Registered: ‎03-25-2009

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.
Aruba
Posts: 1,542
Registered: ‎06-12-2012

Re: ClearPass - database access

A couple things you need to do..

 

1. make sure you have appexternal password set

 

appexternal.png

 

 

 

2. custom properties on the sql SSL

 

dbvis1.png

 

dbvis2.png

 

 

Thank You,
Troy

--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
Posts: 68
Registered: ‎12-14-2012

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
Posts: 571
Registered: ‎04-17-2009

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.
Thanks,

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