Identityserver4: How to configure IdentityServer with MySQL database?

Created on 7 Jul 2020  路  7Comments  路  Source: IdentityServer/IdentityServer4

Question

Hello, gays. Main SQL server of NET Core is MySQL. This is fact, because Net Core is an exactly Linux platform. There are nothing another goal to use Net Core environment rather than in Linux, because Net Framework working perfectly in Windows environment. But I don't see any example about configuration MySQL database with IdentityServer, only stubs and demo with MSSQL on Windows platform. How to force working IdentityServer with MySQL DB? It seems to me AddConfigurationStore and AddOperationalStore is missing for MySQL. What methods need to use for replacement to connect MySQL DB? Or IdentityServer is not possible to implement in real Net Core environment because this is Net Framework program only?

question

Most helpful comment

I assume the fact that you sound rude and aggressive is a language/translation problem.

To reiterate: Our library targets EF. If you favourite database has an EF provider, you can use it. If not, implement the IClientStore and IResourceStore interfaces using your favourite data access API. That's all we have.

All 7 comments

Our library targets EF. If you favourite database has an EF provider, you can use it.

FYI MSSQL run on linux https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15
Our library targets EF. If you favourite database has an EF provider, you can use it.

and what? my question about configure IdentityServer for main Net Core environment - for MySQL, this is number one and main purpose for any Net core programs, if it is impossible for any reason (and we can not see any workable example from developers for main working environment MySQL + IdentityServer) this means IdentityServer is only stupid scam, this means this is Windows program, not NET CORE program. Andalso without IdentityServer we can configure Net Core + JWT + MySQL perfectly - https://github.com/ViacheslavUKR/CallMicroservicesFromBlazorWithJwtProtection - where is workable example from IdentityServer developers for main Net Core Sql server? Nobody has interest for Ms SQL or InMemoryDatabase in NetCore.

I assume the fact that you sound rude and aggressive is a language/translation problem.

To reiterate: Our library targets EF. If you favourite database has an EF provider, you can use it. If not, implement the IClientStore and IResourceStore interfaces using your favourite data access API. That's all we have.

In case anyone sees this and thinks it's not possible... I use IdentityServer on linux (lambda) with MySQL (AWS RDS Aurora).

We used IdentityServer with Azure Table Storage at my previous job. That's a much bigger difference than another SQL DB. (In case someone is interested - no I don't have the source code, and it was never open sourced unfortunately.)

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

wangkanai picture wangkanai  路  3Comments

Aravind1729 picture Aravind1729  路  3Comments

ekarlso picture ekarlso  路  3Comments

user1336 picture user1336  路  3Comments

brockallen picture brockallen  路  3Comments