IdentityServer结合Mysql

IdentityServer4 是为 Asp.Net Core 2.0+ 系列量身打造的一款基于 OpenID Connect 和 OAuth 2.0 认证框架，官网提供了对应持久化到SQL Server数据库的方法。但是在持久化到Mysql数据库时，会出现 Specified key was too long 的错误。我们可以通过重写 OnModelCreating 方法的方式解决问题。

1. 使用 MySql.EntityFrameworkCore

2. ConfigureServices 添加代码如下:

   const string connectionString = @"Server=ip;database=databasename;uid=userid;pwd=password;";
   var migrationsAssembly = typeof(Startup).GetTypeInfo().Assembly.GetName().Name;
   var mysqlVersion = new MySqlServerVersion(new Version(8, 0, 21));
   services.AddIdentityServer()
                   .AddDeveloperSigningCredential()
                   // 客户端和资源的数据库存储
                   // ConfigurationDbContext
                   // dotnet ef migrations add ConfigDbContext -c ConfigurationDbContext -o Data/Migrations/IdentityServer/ConfiguragtionDb
                   // dotnet ef database update -c ConfigurationDbContext
                   .AddConfigurationStore(opt =>
                   {
                       opt.ConfigureDbContext = context =>
                       {
                           context.UseMySQL(_Options.DbEntity.ConnectionString, sql => sql.MigrationsAssembly(migrationsAssembly));
                       };
                   })
                   // 令牌和授权码的数据库存储
                   // PersistedGrantDbContext
                   // dotnet ef migrations add OperationContext -c PersistedGrantDbContext  -o Data/Migrations/IdentityServer/OperationDb
                   // dotnet ef database update -c PersistedGrantDbContext
                   .AddOperationalStore(opt =>
                   {
                       opt.ConfigureDbContext = context =>
                           context.UseMySQL(_Options.DbEntity.ConnectionString, sql => sql.MigrationsAssembly(migrationsAssembly));
                       opt.EnableTokenCleanup = true;
                       opt.TokenCleanupInterval = 30;
                   });
   
               services.AddIdentityServerDbContext<ConfigurationDbContext>(options =>
                       {
                           options.ConfigureDbContext = builder => builder.UseMySQL(_Options.DbEntity.ConnectionString, db => db.MigrationsAssembly(migrationsAssembly));
                       })
                       .AddIdentityServerDbContext<PersistedGrantDbContext>(options =>
                       {
                           options.ConfigureDbContext = builder => builder.UseMySQL(_Options.DbEntity.ConnectionString, db => db.MigrationsAssembly(migrationsAssembly));
                       });
   
               // 更改Identity中关于用户和角色的处理到Entityframework
               // dotnet ef migrations add UserStoreContext -c OdinIdentityEntities -o Data/Migrations/IdentityServer/UserDb
               // dotnet ef database update -c OdinIdentityEntities
           }

3. 安装包如下

   IdentityServer4
   
   IdentityServer4.EntityFramework
   
   Microsoft.EntityFrameworkCore.Tools
   
   Microsoft.AspNet.Identity.EntityFramework
   
   Microsoft.EntityFrameworkCore
   
   IdentityServer4.AspNetIdentity
   

4. 添加 ApplicationDbContext.cs、ApplicationUser.cs 和 ApplicationRole.cs

public class ApplicationDbContext : Microsoft.AspNetCore.Identity.EntityFrameworkCore.IdentityDbContext<ApplicationUser, ApplicationRole, Guid>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {
    }
    public DbSet<IdUser> IdentityUsers { get; set; }
    public DbSet<IdUser> IdentityRoles { get; set; }
    public DbSet<IdentityUserClaim> IdentityUserClaim { get; set; }
    // 其他表
    protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);
        // mysql 修改索引长度 解决  Specified key was too long; max key length is 3072 bytes
        builder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
                  {
                      b.Property<string>("Id")
                          .HasColumnType("varchar(256)");
                  });
       	builder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
              {
                  b.Property<string>("Id")
                      .HasColumnType("varchar(256)");
              });
       builder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
              {
                  b.Property<string>("LoginProvider")
                          .HasColumnType("varchar(256)");

                  b.Property<string>("ProviderKey")
                      .HasColumnType("varchar(256)");
              });
       builder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
                  {

                      b.Property<string>("LoginProvider")
                          .HasColumnType("varchar(256)");

                      b.Property<string>("Name")
                          .HasColumnType("varchar(256)");
                  });
       builder.Entity("OdinOIS.Models.DbModels.IdentityUserStore.IdentityUserClaim", b =>
              {
                  b.Property<string>("ClaimId")
                      .HasColumnType("varchar(256)");

              });
    }
}

public class ApplicationUser : Microsoft.AspNetCore.Identity.IdentityUser<Guid>
{
    //可以在这里扩展
}

public class ApplicationRole : Microsoft.AspNetCore.Identity.IdentityRole<Guid>
{

}

5. 控制台输入

   dotnet ef migrations add ConfigDbContext -c ConfigurationDbContext -o Date\Migrations\IdentityServer\ConfiguragtionDb
   
   dotnet ef database update ConfigDbContext -c ConfigurationDbContext
   
   dotnet ef migrations add ConfigDbContext -c PersistedGrantDbContext -o Date\Migrations\IdentityServer\PersistedGrantDb
   
   dotnet ef database update ConfigDbContext -c PersistedGrantDbContext
   
   dotnet ef migrations add UserStoreContext -c OdinIdentityEntities -o Data/Migrations/IdentityServer/UserDb
   
   dotnet ef database update -c OdinIdentityEntities