Security

Reply
New Contributor

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

 

 

 

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

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

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

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

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

Super Contributor II

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

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

Sean Rynearson
Occasional Contributor II

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

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
cancel
Showing results for 
Search instead for 
Did you mean: