12-19-2013 03:52 AM
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?
-- Found something helpful, important, or cool? Click the Kudos Star in a post.
-- Problem Solved? Click "Accept as Solution" in a post.
Solved! Go to Solution.
12-19-2013 12:50 PM
A couple things you need to do..
1. make sure you have appexternal password set
2. custom properties on the sql SSL
--Give Kudos: found something helpful, important, or cool? Click Kudos Star in a post.
--Problem Solved? Click "Accepted Solution" in a post.
04-25-2015 09:01 PM
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