Spring Security 即使凭据正确也不登录用户

c6ubokkw  于 2021-09-29  发布在  Java
关注(0)|答案(1)|浏览(299)

谁能指出我的错误吗。我无法使用注册用户登录起初我以为这是因为我正在加密密码,但即使现在我已经删除了编码,用户仍然无法使用明文密码登录?
这是我的web.xml:

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
id="WebApp_ID" version="2.5">
<display-name>SgaWebApp</display-name>
<welcome-file-list>
    <welcome-file>login.jsp</welcome-file>
</welcome-file-list>
<servlet>
    <display-name>dispatcher</display-name>
    <servlet-name>dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:com/sga/app/xml/dispatcher-servlet.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
    <servlet-name>dispatcher</servlet-name>
    <url-pattern>/</url-pattern>
    <url-pattern>*.css</url-pattern>
</servlet-mapping>
<resource-ref>
    <res-ref-name>jdbc/springSgaDb</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>
<listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
            classpath:com/sga/app/xml/security-context.xml
            classpath:com/sga/app/xml/dao-context.xml
            classpath:com/sga/app/xml/service-context.xml
        </param-value>
</context-param>

<filter>
    <display-name>springSecurityFilterChain</display-name>
    <filter-name>springSecurityFilterChain</filter-name>
    <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping>
    <filter-name>springSecurityFilterChain</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>
<session-config>
    <session-timeout>60</session-timeout>
</session-config>

my login.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link href="${pageContext.request.contextPath}/static/css/main.css"
rel="stylesheet" type="text/css">
<title>SGA-login page</title>
</head>
<body onload='document.f.j_username.focus();'>
<div class="wrapper">
    <!-- Form -->
    <div class="login">
        <h2 class="customLoginFormHeader">Login with Username and
            Password</h2>

        <c:if test="${param.error != null}">
            <p class="errorCustomLogin">Login failed. Please try your
                username/password again.</p>
        </c:if>

        <form name='f'
            action='${pageContext.request.contextPath}/j_spring_security_check'
            method='POST' class="loginForm">
            <table>
                <tr class="loginFormTableRow">
                    <td class="tdCustomLogin">Username:</td>
                    <td><input type='text' name='j_username'
                        class="usernameInputCustomLogin"></td>
                </tr>
                <tr class="loginFormTableRow">
                    <td class="tdCustomLogin">Password:</td>
                    <td><input type='password' name='j_password'
                        class="passwordInputCustomLogin" /></td>
                </tr>
                <tr class="loginFormTableRow">
                    <td class="tdRememberMeHeader">Remember me:</td>
                    <td><input type="checkbox"
                        name='_spring_security_remember_me' checked="checked"
                        class="rememberMeCustomLogin" /></td>
                </tr>
                <tr class="loginFormTableRow">
                    <td colspan='2'><input type="submit" value="Login"
                        class="customLoginSubmitButton" /></td>
                </tr>
            </table>
        </form>
    </div>
</div>
</body>
</html>

my security-context.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:security="http://www.springframework.org/schema/security"
xsi:schemaLocation="http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security.xsd
    http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

<security:authentication-manager>
    <security:authentication-provider>
        <security:jdbc-user-service
            data-source-ref="dataSource" id="jdbcUserService" />
    </security:authentication-provider>
</security:authentication-manager>
<security:http use-expressions="true">
    <security:logout logout-success-url="/login"
        invalidate-session="true" />
    <security:intercept-url pattern="/admin"
        access="hasRole('ROLE_ADMIN')" />
    <security:intercept-url pattern="/admin"
        access="permitAll" />
    <security:intercept-url pattern="/login"
        access="permitAll" />
    <security:intercept-url pattern="/" access="permitAll" />
    <security:intercept-url pattern="/static/**"
        access="permitAll" />
    <security:intercept-url pattern="/customloginform"
        access="permitAll" />
    <security:intercept-url pattern="/error"
        access="permitAll" />
    <security:intercept-url pattern="/register"
        access="permitAll" />
    <security:intercept-url pattern="/createaccount"
        access="permitAll" />
    <security:intercept-url pattern="/accountcreated"
        access="permitAll" />
    <security:intercept-url pattern="/contactus"
        access="permitAll" />
    <security:intercept-url pattern="/denied"
        access="permitAll" />
    <security:intercept-url pattern="/menu"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/roundanalysis"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/roundanalysiserrorpage"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/analysisoutcome"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/viewmystats"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/userstats"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/clubstats"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/allstats"
        access="isAuthenticated()" />
    <security:intercept-url pattern="/**" access="denyAll" />
    <security:form-login login-page="/customloginform"
        default-target-url="/menu" authentication-failure-url="/customloginform?error=true" />
    <security:access-denied-handler
        error-page="/denied" />
    <security:remember-me key="sgaAppKey"
        user-service-ref="jdbcUserService" />
</security:http>
<security:global-method-security
    secured-annotations="enabled"></security:global-method-security>

还有我的登录:

@Repository
@Component("usersDAO")
@Transactional
public class UsersDAO {

private NamedParameterJdbcTemplate jdbc;

@Autowired
private SessionFactory sessionFactory;

public Session session() {
    return sessionFactory.getCurrentSession();
}

@Transactional
public boolean createUser(UserBean user) {
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("username", user.getUsername());
    params.addValue("email", user.getEmail());
    params.addValue("password", user.getPassword());
    params.addValue("forename", user.getForename());
    params.addValue("surname", user.getSurname());
    params.addValue("homeclub", user.getHomeclub());
    params.addValue("authority", user.getAuthority());
    return jdbc
            .update("insert into users (username, email, password, forename, surname, homeclub, authority) values (:username, :email, :password, :forename, :surname, :homeclub, :authority)",
                    params) == 1;
}

@Autowired
public void setDataSource(DataSource jdbc) {
    this.jdbc = new NamedParameterJdbcTemplate(jdbc);
}

public boolean exists(String username) {
    return jdbc.queryForObject(
            "select count(*) from users where username=:username",
            new MapSqlParameterSource("username", username), Integer.class) > 0;
}

public List<UserBean> getAllUsers() {
    return jdbc.query("select * from users",
            BeanPropertyRowMapper.newInstance(UserBean.class));
}

}
以下是控制台输出:

DEBUG - Request is to process authentication
DEBUG - Authentication attempt using org.springframework.security.authentication.dao.DaoAuthenticationProvider
DEBUG - Executing prepared SQL query
DEBUG - Executing prepared SQL statement [select username,password,enabled from users where username = ?]
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - Returning JDBC Connection to DataSource
DEBUG - Executing prepared SQL query
DEBUG - Executing prepared SQL statement [select username,authority from authorities where username = ?]
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - Returning JDBC Connection to DataSource
DEBUG - User 'Harry12345' has no authorities and will be treated as 'not found'
DEBUG - User 'Harry12345' not found
DEBUG - Authentication request failed: org.springframework.security.authentication.BadCredentialsException: Bad credentials
DEBUG - Updated SecurityContextHolder to contain null Authentication
DEBUG - Delegating to authentication failure handler org.springframework.security.web.authentication.SimpleUrlAuthenticationFailureHandler@65d201b5
DEBUG - Interactive login attempt was unsuccessful.
DEBUG - Cancelling cookie
DEBUG - Redirecting to /customloginform?error=true
DEBUG - Redirecting to '/SgaWebApp/customloginform?error=true'
xmq68pz9

xmq68pz91#

日志输出清楚地显示了问题:

DEBUG - User 'Harry12345' has no authorities and will be treated as 'not found'

因此,它找到了该用户,但没有找到任何与他相关的权限。
违约 <security:jdbc-user-service /> 需要至少一个与每个用户关联的权限。这些权限应按照37.1用户模式中的定义表示。
如果您需要不同的用户和权限数据表示(例如 authority 字段),您需要实现自定义 UserDetailsService 相反

相关问题