azure - 连接/添加数据库时,将 ASP.NET Core 应用程序部署到 Azure 失败
问题描述
我正在尝试使用 Azure SQL 数据库将使用 EF Core 和 Identity 的 ASP.NET Core 3.1 应用程序部署到 Azure。它构建成功但部署失败并出现以下错误:
Trackily -> C:\Users\szapt\source\repos\sprzeng\Trackily\Trackily\bin\Release\netcoreapp3.1\Trackily.dll
Trackily -> C:\Users\szapt\source\repos\sprzeng\Trackily\Trackily\bin\Release\netcoreapp3.1\Trackily.Views.dll
Trackily -> C:\Users\szapt\source\repos\sprzeng\Trackily\Trackily\obj\Release\netcoreapp3.1\PubTmp\Out\
Generating Entity framework SQL Scripts...
Executing command: dotnet ef migrations script --idempotent --output "C:\Users\szapt\source\repos\sprzeng\Trackily\Trackily\obj\Release\netcoreapp3.1\PubTmp\EFSQLScripts\Trackily.Areas.Identity.Data.TrackilyContext.sql" --context Trackily.Areas.Identity.Data.TrackilyContext
Generating Entity framework SQL Scripts completed successfully
Adding sitemanifest (sitemanifest).
Adding database (data source=tcp:trackilydbserver.database.windows.net,1433;initial catalog=Trackily_db;user id=trackilydb@trackilydbserver)
C:\Program Files\dotnet\sdk\3.1.400\Sdks\Microsoft.NET.Sdk.Publish\targets\PublishTargets\Microsoft.NET.Sdk.Publish.MSDeploy.targets(140,5): Warning : Cannot connect to the database 'Trackily_db'.
Retrying operation 'Add' on object dbFullSql (data source=tcp:trackilydbserver.database.windows.net,1433;initial catalog=Trackily_db;user id=trackilydb@trackilydbserver). Attempt 1 of 10.
C:\Program Files\dotnet\sdk\3.1.400\Sdks\Microsoft.NET.Sdk.Publish\targets\PublishTargets\Microsoft.NET.Sdk.Publish.MSDeploy.targets(140,5): Warning : The database 'Trackily_db' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=tcp:trackilydbserver.database.windows.net,1433;initial catalog=Trackily_db;user id=trackilydb@trackilydbserver). Attempt 2 of 10.
C:\Program Files\dotnet\sdk\3.1.400\Sdks\Microsoft.NET.Sdk.Publish\targets\PublishTargets\Microsoft.NET.Sdk.Publish.MSDeploy.targets(140,5): Warning : The database 'Trackily_db' could not be created.
...(this continues for 10 attempts)...
C:\Program Files\dotnet\sdk\3.1.400\Sdks\Microsoft.NET.Sdk.Publish\targets\PublishTargets\Microsoft.NET.Sdk.Publish.MSDeploy.targets(140,5): Error : Web deployment task failed. ((2020-08-08 6:08:21 PM) An error occurred when the request was processed on the remote computer.)
(2020-08-08 6:08:21 PM) An error occurred when the request was processed on the remote computer.
The database 'Trackily_db' could not be created.
Login failed for user 'trackilydb'.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Web.Deployment.SqlServerDatabaseProvider.AddHelper(DeploymentObject source)
Publish failed to deploy.
这是我第一次部署应用程序并使用 Azure,我按照以下说明进行操作:
这样做。
我目前认为将我在本地使用 EF Core 进行的迁移应用到 Azure SQL 可能存在问题。但是,关于此的信息让我感到困惑,似乎应该使用以下发布设置自动应用迁移:
到目前为止,在开发应用程序时,我只使用了带有 EF Core 和 Identity 的本地 SQL 数据库(我相信是 SQL Server Express LocalDB)。
应用设置.json
{
"ConnectionStrings": {
"TrackilyContextConnection": "Server=(localdb)\\mssqllocaldb;Database=Trackily;Trusted_Connection=True;MultipleActiveResultSets=true"
},
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft": "Warning",
"Microsoft.Hosting.Lifetime": "Information"
}
},
"AllowedHosts": "*"
}
启动.cs
public class Startup
{
private readonly IWebHostEnvironment _env;
public Startup(IConfiguration configuration, IWebHostEnvironment env)
{
Configuration = configuration;
_env = env;
}
public IConfiguration Configuration { get; }
public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext<TrackilyContext>(options =>
options.UseSqlServer(
Configuration.GetConnectionString("TrackilyContextConnection")));
services.AddDefaultIdentity<TrackilyUser>(options => options.SignIn.RequireConfirmedAccount = false)
.AddEntityFrameworkStores<TrackilyContext>();
if (_env.IsDevelopment())
{
services.Configure<IdentityOptions>(options =>
{
options.Password.RequireDigit = false;
options.Password.RequireLowercase = false;
options.Password.RequireNonAlphanumeric = false;
options.Password.RequireUppercase = false;
options.Password.RequiredLength = 3;
options.Password.RequiredUniqueChars = 0;
options.Lockout.AllowedForNewUsers = false;
});
}
else
{
services.Configure<IdentityOptions>(options =>
{
options.Password.RequireNonAlphanumeric = false;
options.Password.RequireUppercase = false;
options.User.AllowedUserNameCharacters =
"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-.";
options.User.RequireUniqueEmail = true;
});
}
services.AddScoped<TicketService>();
services.AddScoped<UserTicketService>();
services.AddScoped<CommentService>();
services.AddScoped<ProjectService>();
services.AddScoped<UserProjectService>();
services.AddAuthorization(options =>
{
options.AddPolicy(
"TicketEditPrivileges",
policyBuilder => policyBuilder.AddRequirements(
new TicketEditPrivilegesRequirement()
));
options.AddPolicy(
"ProjectEditPrivileges",
policyBuilder => policyBuilder.AddRequirements(
new ProjectEditPrivilegesRequirement()));
options.AddPolicy(
"ProjectDetailsPrivileges",
policyBuilder => policyBuilder.AddRequirements(
new ProjectDetailsPrivilegesRequirement()));
options.AddPolicy(
"ProjectDeletePrivileges",
policyBuilder => policyBuilder.AddRequirements(
new ProjectDeletePrivilegesRequirement()));
});
services.AddScoped<IAuthorizationHandler, TicketEditPrivilegesUserIdHandler>();
services.AddScoped<IAuthorizationHandler, ProjectEditPrivilegesProjectIdHandler>();
services.AddScoped<IAuthorizationHandler, ProjectDetailsPrivilegesProjectIdHandler>();
services.AddScoped<IAuthorizationHandler, ProjectDeletePrivilegesProjectIdHandler>();
}
public static void Configure(IApplicationBuilder app, IWebHostEnvironment env, UserManager<TrackilyUser> userManager)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.Use(async (context, next) =>
{
await next();
if (context.Response.StatusCode == 404)
{
context.Request.Path = "/Home/Error/404";
await next();
}
});
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
endpoints.MapRazorPages();
});
DbSeeder.SeedUsers(userManager);
}
}
程序.cs
public class Program
{
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
}
public static IHostBuilder CreateHostBuilder(string[] args) =>
Host.CreateDefaultBuilder(args)
.ConfigureWebHostDefaults(webBuilder =>
{
webBuilder.UseStartup<Startup>();
});
}
我尝试appsettings
使用 Azure 门户上提供的连接字符串将连接字符串更改为以 Azure SQL 数据库为目标,但这并没有解决部署问题。或者,我认为问题可能是将应用程序连接到 Azure SQL 数据库,但我不确定为什么设置连接字符串不能解决此问题。
任何直接的帮助或指出我正确的方向将不胜感激。
解决方案
我能够解决我的问题(尽管我尝试了很多事情,但我不确定是哪一个专门解决了它)。
对于可能遇到类似问题的其他人,我会尝试以下步骤:
检查您是否使用在数据库的 Azure 页面上找到的连接字符串。您应该使用您的管理员用户名和密码,而不是数据库用户名和密码。
添加代码以
Configure
在Startup.cs
. 例如,services.BuildServiceProvider().GetService<YourDbContextName>().Database.Migrate();
。从 Visual Studio 的 SQL Server 对象资源管理器中连接到 Azure SQL 数据库。您可以按照此处的指南https://medium.com/net-core/deploy-an-asp-net-core-app-with-ef-core-and-sql-server-to-azure-e11df41a4804这样做.
推荐阅读
- excel - 定义范围的值的错误类型不匹配
- android - Android:特殊字符在传递给restful服务时导致问题
- eclipse - 无法打开日食。显示错误已发生
- java - 当我想运行这个程序而不是作为应用程序运行时,它会显示为“作为配置运行”。为什么会这样问
- python - 为什么我无法自动执行此代码?
- java - 无法在 IntelliJ 中管理 Maven 配置文件
- json - JSON写入中的Xcode无效顶级类型
- node.js - 使用猫鼬时如何定义具有“NumberLong”或“NumberInt”类型的模式?
- smtp - nodemailer 使用 SMTP 发送多封电子邮件导致连接关闭错误
- sql - 如何查找选择转换失败的值