c# - 使用Session验证用户名和密码

Question

我在 stackoverflow 和 Google 上四处查看，但无法找到与我的问题相关的答案，因此我将其发布在这里。

我有一个登录页面，用户被引导输入他们的用户名和密码，它们都存储在 MySQL 数据库中。用户名以纯文本形式存储，密码经过哈希处理(使用 CrackStation - https://crackstation.net/hashing-security.htm#aspsourcecode )，并将哈希值存储在数据库中。我能够使用用户名和密码成功让用户登录一次，但我想使用 SESSION，以便用户可以在网站上导航，而不必每次进入不同页面时都登录。我可以轻松地在我的测试环境中使用 SESSION，因为密码以纯文本形式存储，但现在密码被散列后，我无法让 Session 在我的代码中工作。所以我想知道如何才能在 SESSION 中验证密码。

我在登录页面上使用的代码如下:

protected void Page_Load(object sender, EventArgs e)
{
    try
    {
        admin = Convert.ToInt16(Request.QueryString["Admin"]);               
        Instructor = Convert.ToInt16(Request.QueryString["Inst"]);               

        if (Session["username"] == null || (string)(Session["username"]) == "")
        {                   
            token = Request.QueryString["tokenNumber"];

            lblUsername.Visible = true;
            txtUsername.Visible = true;
            lblPassword.Visible = true;
            txtPassword.Visible = true;
            btnlogin.Visible = true;
        }

        else if (Session["username"] != null || (string)(Session["username"]) != "")
        {                   
            username = (string)Session["username"];
            userType = (string)Session["userType"];
            pass = (string)Session["password"];                   

            if (userType == "Participant")
            {                       
                Response.Redirect("/srls/StudentUser");
            }
            else if (userType == "Coordinator")
            {
                Response.Redirect("/srls/CoordinatorUser");                       
            }
            else if (userType == "Instructor")
            {
                Response.Redirect("/srls/InstructorUser");
            }
        }


    }
    catch (Exception exc) //Module failed to load
    {
        Exceptions.ProcessModuleLoadException(this, exc);
    }
}

protected void btnlogin_Click(object sender, System.EventArgs e)
{
    char activation;

    if (Request.QueryString["tokenNum"] != null)
    {
        using (OdbcConnection dbConnection = new OdbcConnection(srlsConnStr))
        {
            dbConnection.Open();
            {
                OdbcCommand dbCommand = new OdbcCommand();
                dbCommand.Connection = dbConnection;
                dbCommand.CommandText = @"SELECT tokenNum FROM srlslogin WHERE user_email_pk = ?";
                dbCommand.Parameters.AddWithValue("@user_email_pk", txtUsername.Text);
                dbCommand.ExecuteNonQuery();

                OdbcDataReader dataReader = dbCommand.ExecuteReader();
                while (dataReader.Read())
                {
                    if (token == dataReader["tokenNum"].ToString())
                    {
                        updateActivationStatus(txtUsername.Text);
                        LoginWithPasswordHashFunction();
                    }
                    else
                    {
                        test.Text = "You are not authorized to login! Please activate your account following the activation link sent to your email " + txtUsername.Text + " !";
                    }
                }
            }
            dbConnection.Close();
        }

    }
    else if (Request.QueryString["tokenNum"] == null)
    {
        using (OdbcConnection dbConnection = new OdbcConnection(srlsConnStr))
        {
            dbConnection.Open();
            {
                OdbcCommand dbCommand1 = new OdbcCommand();
                dbCommand1.Connection = dbConnection;
                dbCommand1.CommandText = @"SELECT * FROM srlslogin WHERE user_email_pk = ?;";

                dbCommand1.Parameters.AddWithValue("@user_email_pk", txtUsername.Text);
                dbCommand1.ExecuteNonQuery();

                OdbcDataReader dataReader1 = dbCommand1.ExecuteReader();
                if (dataReader1.Read())
                {
                    activation = Convert.ToChar(dataReader1["activation_status"]);
                    if (activation == 'Y')
                    {
                        activation status, activation == Y";
                        LoginWithPasswordHashFunction();
                    }
                    else
                    {
                        lblMessage.Text = "Please activate your account following the Activation link emailed to you at <i>" + txtUsername.Text + "</i> to Continue!";
                    }
                }
                else
                {
                    lblMessage.Text = "Invalid Username or Password";
                }
                dataReader1.Close();
            }
            dbConnection.Close();
        }
    }
}

private void LoginWithPasswordHashFunction()
{
    List<string> salthashList = null;
    List<string> usernameList = null;

    try
    {
        using (OdbcConnection dbConnection = new OdbcConnection(srlsConnStr))
        {
            dbConnection.Open();
            {
                OdbcCommand dbCommand = new OdbcCommand();
                dbCommand.Connection = dbConnection;
                dbCommand.CommandText = @"SELECT slowhashsalt, user_email_pk FROM srlslogin WHERE user_email_pk = ?;";

                dbCommand.Parameters.AddWithValue(@"user_email_pk", txtUsername.Text);
                OdbcDataReader dataReader = dbCommand.ExecuteReader();
                while (dataReader.HasRows && dataReader.Read())
                {
                    if (salthashList == null)
                    {
                        salthashList = new List<string>();
                        usernameList = new List<string>();
                    }

                    string saltHashes = dataReader.GetString(dataReader.GetOrdinal("slowhashsalt"));
                    salthashList.Add(saltHashes);

                    string userInfo = dataReader.GetString(dataReader.GetOrdinal("user_email_pk"));

                    usernameList.Add(userInfo);
                }

                dataReader.Close();

                if (salthashList != null)
                {

                    for (int i = 0; i < salthashList.Count; i++)
                    {
                        bool validUser = PasswordHash.ValidatePassword(txtPassword.Text, salthashList[i]);
                        if (validUser == true)
                        {                                    
                            Session["user_email_pk"] = usernameList[i];

                            OdbcCommand dbCommand1 = new OdbcCommand();
                            dbCommand1.Connection = dbConnection;
                            dbCommand1.CommandText = @"SELECT user_status FROM srlslogin WHERE user_email_pk = ?;";

                            dbCommand1.Parameters.AddWithValue("@user_email_pk", txtUsername.Text);
                            dbCommand1.ExecuteNonQuery();

                            OdbcDataReader dataReader1 = dbCommand1.ExecuteReader();
                            while (dataReader1.Read())
                            {
                                user_status = dataReader1["user_status"].ToString();
                                Session["userType"] = user_status;
                            }

                            Response.BufferOutput = true;

                            if (user_status == "Participant")
                            {
                                Response.Redirect("/srls/StudentUser", false);
                            }
                            else if (user_status == "Coordinator")
                            {
                                Response.Redirect("/srls/CoordinatorUser", false);
                            }
                            else if (user_status == "Instructor")
                            {
                                Response.Redirect("/srls/InstructorUser", false);
                            }

                            dataReader1.Close();
                Response.Redirect(/srls/StudentUser) - Goes to Login Page";
                        }
                        else
                        {
                            lblMessage.Text = "Invalid Username or Password! Please Try Again!";
                        }
                    }
                }
            }
            dbConnection.Close();
        }
    }
    catch (Exception ex)
    {

    }

Answer 1

您不应该在 session 中存储用户名和密码。您应该存储用户已成功登录的“事实”。但实际上您甚至不应该自己这样做。 ASP.NET 提供了多种身份验证方法。请查看http://www.asp.net/identity开始吧。