Security

Reply
New Contributor
Posts: 2
Registered: ‎11-09-2013

Clearpass Policy Manager with external MS SQL DB for Guests

Hi,

I’m new the Aruba world have a problem with the authentication methods fort the guest users.

We setup a new cp server with iap controller in our environment.  I configured the ipa with the cp for the guests at first with the local cp database, everything works J

 

But I want to import my guest’s ids from the access system database where everybody had to check in. so I configured the external sql db source. In this database I have a table with the guest id and code from the chip card. I want to use these two fields for my guest login.

The problem is when use pap (clear) as methods for authentication I get this error:

PAP: CLEAR TEXT password check failed

When I change pap to md5 and convert the password field in the sql table I get this:

Cannot select appropriate authentication method

Whats wrong in my configuration?

 

 

thanks

daniel

 

 

 

Aruba
Posts: 233
Registered: ‎11-19-2009

Re: Clearpass Policy Manager with external MS SQL DB for Guests

[ Edited ]

Can you paste the SQL query he is using to retrieve the password from the DB and also  may i know if  password is stored in cleartext in the DB ?

 

thank you. 

New Contributor
Posts: 2
Registered: ‎11-09-2013

Re: Clearpass Policy Manager with external MS SQL DB for Guests

[ Edited ]

hi,

 

this is the query i use.

 

select Password from dbo.GuestUser where User = '%{Authentication:Username}'

 

in the password field the md5 hash is stored.

 

Contributor II
Posts: 67
Registered: ‎06-29-2014

Re: Clearpass Policy Manager with external MS SQL DB for Guests

hi,

 

am trying to do same urs configuration,

 

i want ti integrate clearpass with external sql server,

 

could you please show me how did u configure sql query and the alias name on your clearpass??

 

thank you

Chief Airhead
Posts: 1,009
Registered: ‎07-13-2010

Re: Clearpass Policy Manager with external MS SQL DB for Guests

@sriram.subramanian do you have an answer for this question?

Sean Rynearson | Chief Airhead
Aruba, a Hewlett Packard Enterprise Company
Occasional Contributor II
Posts: 20
Registered: ‎03-07-2014

Re: Clearpass Policy Manager with external MS SQL DB for Guests

hi sir

 

i have also same issue when integration with the MS SQL DB, can you show me how you do it, i also encounter same error as you mention in your 1st post.

 

any one can help.

 

Occasional Contributor II
Posts: 20
Registered: ‎03-07-2014

Re: Clearpass Policy Manager with external MS SQL DB for Guests

can you share configuration sir? i have also same case but failed,

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