Security

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

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. 

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.

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

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

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.

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