IdentityServer / IdentityServer2

[deprecated] Thinktecture IdentityServer is a light-weight security token service built with .NET 4.5, MVC 4, Web API and WCF.
Other
410 stars 291 forks source link

Identity Server + Oracle integration #795

Closed pravinbhosale01 closed 9 years ago

pravinbhosale01 commented 10 years ago

Hi, Working around Identity server and Authorization server since few days. Everything worked very smooth with SQL Server. Now working on integrating identity server DBs with our existing Oracle database. Here are few points I did to do so...

We were looking for connection string and data provider to set in ConnectionString.config file to use oracle db;

We found that EF6 is not having providers to interact with Oracle. And the option available is- to use Devart (third party provider).

We got connected to Oracle DB, Also We got few errors for table names or column names used in Identity server schema are longer that 30 Characters. (Oracle supports them to be shorter than 30 characters), So we changed them to be shorter.

It worked, We got tables of Identity server created in Our Oracle DB(As Identity server has 'EF Code-first' implementation).

Now are at a point where we can see InitialConfiguration view (https://localServerXXXXXX/IdSrv/initialconfiguration)

When we type Username password for creating Default accounts on Identity server we get Error stating "Column name 'FailedPasswordAttemptWindowStart' in table 'Memberships' is too long (32 characters). An identifier with more than 30 characters was specified." (again due to Oracle supports Max 30 characters)

idsrv

This would be one column name used by 'System.Web.Security.Membership' class and there would be few more. Now the question is How to change schema used by Membership class?

Can you please comment on the path we are following and steps we took to get this configuration working? Also, If you can suggest better alternate way to get Identity and Authorization server working with Oracle, that would be really helpful.

brockallen commented 10 years ago

That's Microsoft's library -- you'd have to speak to them.

An alternative is to use MembershipReboot:

https://github.com/thinktecture/Thinktecture.IdentityServer.v2/tree/master/samples/MembershipRebootUserRepository