Get HTTPS ready for ClearPass Onboard!

By trent posted Oct 11, 2012 04:10 PM

Kudos

Learn how to setup HTTPS when configuring Onboard to pull credentials from an Active Directory. Video touches on using an HTTPS connection between Onboard and the Policy Manager.

This is a good thing to know when setting up "Core" Onboard functionality.

3 comments

5 views

Comments

boneyard

Dec 08, 2012 08:50 AM

am i missing something here? the title is about onboard and https, while the content as explained at the start is about using clearpass guest database as authentication source.

trent

Oct 17, 2012 08:50 PM

Hi Schoate,

Here you go.

select username AS User_Password from useraccount LEFT JOIN userextra uxmac ON (uxmac.user_id=useraccount.id AND uxmac.attribute='mac') LEFT JOIN userextra uxmac_auth ON (uxmac_auth.user_id=useraccount.id AND uxmac_auth.attribute='mac_auth') WHERE uxmac_auth.value='1' AND username ilike '%{Connection:Client-Mac-Address-NoDelim}';

Schoate

Oct 15, 2012 05:10 PM

Can you post the SQL command that you used in this video?

Blogs