| <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" lang="en"><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/><link rel="stylesheet" href="../../jacoco-resources/report.css" type="text/css"/><link rel="shortcut icon" href="../../jacoco-resources/report.gif" type="image/gif"/><title>JdbcRealm.java</title><link rel="stylesheet" href="../../jacoco-resources/prettify.css" type="text/css"/><script type="text/javascript" src="../../jacoco-resources/prettify.js"></script></head><body onload="window['PR_TAB_WIDTH']=4;prettyPrint()"><div class="breadcrumb" id="breadcrumb"><span class="info"><a href="../../jacoco-sessions.html" class="el_session">Sessions</a></span><a href="../../index.html" class="el_report">Apache Shiro :: Jar Bundle</a> > <a href="../index.html" class="el_bundle">shiro-core</a> > <a href="index.source.html" class="el_package">org.apache.shiro.realm.jdbc</a> > <span class="el_source">JdbcRealm.java</span></div><h1>JdbcRealm.java</h1><pre class="source lang-java linenums">/* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| package org.apache.shiro.realm.jdbc; |
| |
| import org.apache.shiro.authc.*; |
| import org.apache.shiro.authz.AuthorizationException; |
| import org.apache.shiro.authz.AuthorizationInfo; |
| import org.apache.shiro.authz.SimpleAuthorizationInfo; |
| import org.apache.shiro.config.ConfigurationException; |
| import org.apache.shiro.realm.AuthorizingRealm; |
| import org.apache.shiro.subject.PrincipalCollection; |
| import org.apache.shiro.util.ByteSource; |
| import org.apache.shiro.util.JdbcUtils; |
| import org.slf4j.Logger; |
| import org.slf4j.LoggerFactory; |
| |
| import javax.sql.DataSource; |
| import java.sql.Connection; |
| import java.sql.PreparedStatement; |
| import java.sql.ResultSet; |
| import java.sql.SQLException; |
| import java.util.Collection; |
| import java.util.LinkedHashSet; |
| import java.util.Set; |
| |
| |
| /** |
| * Realm that allows authentication and authorization via JDBC calls. The default queries suggest a potential schema |
| * for retrieving the user's password for authentication, and querying for a user's roles and permissions. The |
| * default queries can be overridden by setting the query properties of the realm. |
| * <p/> |
| * If the default implementation |
| * of authentication and authorization cannot handle your schema, this class can be subclassed and the |
| * appropriate methods overridden. (usually {@link #doGetAuthenticationInfo(org.apache.shiro.authc.AuthenticationToken)}, |
| * {@link #getRoleNamesForUser(java.sql.Connection,String)}, and/or {@link #getPermissions(java.sql.Connection,String,java.util.Collection)} |
| * <p/> |
| * This realm supports caching by extending from {@link org.apache.shiro.realm.AuthorizingRealm}. |
| * |
| * @since 0.2 |
| */ |
| <span class="fc" id="L57">public class JdbcRealm extends AuthorizingRealm {</span> |
| |
| //TODO - complete JavaDoc |
| |
| /*-------------------------------------------- |
| | C O N S T A N T S | |
| ============================================*/ |
| /** |
| * The default query used to retrieve account data for the user. |
| */ |
| protected static final String DEFAULT_AUTHENTICATION_QUERY = "select password from users where username = ?"; |
| |
| /** |
| * The default query used to retrieve account data for the user when {@link #saltStyle} is COLUMN. |
| */ |
| protected static final String DEFAULT_SALTED_AUTHENTICATION_QUERY = "select password, password_salt from users where username = ?"; |
| |
| /** |
| * The default query used to retrieve the roles that apply to a user. |
| */ |
| protected static final String DEFAULT_USER_ROLES_QUERY = "select role_name from user_roles where username = ?"; |
| |
| /** |
| * The default query used to retrieve permissions that apply to a particular role. |
| */ |
| protected static final String DEFAULT_PERMISSIONS_QUERY = "select permission from roles_permissions where role_name = ?"; |
| |
| <span class="fc" id="L84"> private static final Logger log = LoggerFactory.getLogger(JdbcRealm.class);</span> |
| |
| /** |
| * Password hash salt configuration. <ul> |
| * <li>NO_SALT - password hashes are not salted.</li> |
| * <li>CRYPT - password hashes are stored in unix crypt format.</li> |
| * <li>COLUMN - salt is in a separate column in the database.</li> |
| * <li>EXTERNAL - salt is not stored in the database. {@link #getSaltForUser(String)} will be called |
| * to get the salt</li></ul> |
| */ |
| <span class="pc" id="L94"> public enum SaltStyle {NO_SALT, CRYPT, COLUMN, EXTERNAL};</span> |
| |
| /*-------------------------------------------- |
| | I N S T A N C E V A R I A B L E S | |
| ============================================*/ |
| protected DataSource dataSource; |
| |
| <span class="fc" id="L101"> protected String authenticationQuery = DEFAULT_AUTHENTICATION_QUERY;</span> |
| |
| <span class="fc" id="L103"> protected String userRolesQuery = DEFAULT_USER_ROLES_QUERY;</span> |
| |
| <span class="fc" id="L105"> protected String permissionsQuery = DEFAULT_PERMISSIONS_QUERY;</span> |
| |
| <span class="fc" id="L107"> protected boolean permissionsLookupEnabled = false;</span> |
| |
| <span class="fc" id="L109"> protected SaltStyle saltStyle = SaltStyle.NO_SALT;</span> |
| |
| /*-------------------------------------------- |
| | C O N S T R U C T O R S | |
| ============================================*/ |
| |
| /*-------------------------------------------- |
| | A C C E S S O R S / M O D I F I E R S | |
| ============================================*/ |
| |
| /** |
| * Sets the datasource that should be used to retrieve connections used by this realm. |
| * |
| * @param dataSource the SQL data source. |
| */ |
| public void setDataSource(DataSource dataSource) { |
| <span class="fc" id="L125"> this.dataSource = dataSource;</span> |
| <span class="fc" id="L126"> }</span> |
| |
| /** |
| * Overrides the default query used to retrieve a user's password during authentication. When using the default |
| * implementation, this query must take the user's username as a single parameter and return a single result |
| * with the user's password as the first column. If you require a solution that does not match this query |
| * structure, you can override {@link #doGetAuthenticationInfo(org.apache.shiro.authc.AuthenticationToken)} or |
| * just {@link #getPasswordForUser(java.sql.Connection,String)} |
| * |
| * @param authenticationQuery the query to use for authentication. |
| * @see #DEFAULT_AUTHENTICATION_QUERY |
| */ |
| public void setAuthenticationQuery(String authenticationQuery) { |
| <span class="nc" id="L139"> this.authenticationQuery = authenticationQuery;</span> |
| <span class="nc" id="L140"> }</span> |
| |
| /** |
| * Overrides the default query used to retrieve a user's roles during authorization. When using the default |
| * implementation, this query must take the user's username as a single parameter and return a row |
| * per role with a single column containing the role name. If you require a solution that does not match this query |
| * structure, you can override {@link #doGetAuthorizationInfo(PrincipalCollection)} or just |
| * {@link #getRoleNamesForUser(java.sql.Connection,String)} |
| * |
| * @param userRolesQuery the query to use for retrieving a user's roles. |
| * @see #DEFAULT_USER_ROLES_QUERY |
| */ |
| public void setUserRolesQuery(String userRolesQuery) { |
| <span class="nc" id="L153"> this.userRolesQuery = userRolesQuery;</span> |
| <span class="nc" id="L154"> }</span> |
| |
| /** |
| * Overrides the default query used to retrieve a user's permissions during authorization. When using the default |
| * implementation, this query must take a role name as the single parameter and return a row |
| * per permission with three columns containing the fully qualified name of the permission class, the permission |
| * name, and the permission actions (in that order). If you require a solution that does not match this query |
| * structure, you can override {@link #doGetAuthorizationInfo(org.apache.shiro.subject.PrincipalCollection)} or just |
| * {@link #getPermissions(java.sql.Connection,String,java.util.Collection)}</p> |
| * <p/> |
| * <b>Permissions are only retrieved if you set {@link #permissionsLookupEnabled} to true. Otherwise, |
| * this query is ignored.</b> |
| * |
| * @param permissionsQuery the query to use for retrieving permissions for a role. |
| * @see #DEFAULT_PERMISSIONS_QUERY |
| * @see #setPermissionsLookupEnabled(boolean) |
| */ |
| public void setPermissionsQuery(String permissionsQuery) { |
| <span class="nc" id="L172"> this.permissionsQuery = permissionsQuery;</span> |
| <span class="nc" id="L173"> }</span> |
| |
| /** |
| * Enables lookup of permissions during authorization. The default is "false" - meaning that only roles |
| * are associated with a user. Set this to true in order to lookup roles <b>and</b> permissions. |
| * |
| * @param permissionsLookupEnabled true if permissions should be looked up during authorization, or false if only |
| * roles should be looked up. |
| */ |
| public void setPermissionsLookupEnabled(boolean permissionsLookupEnabled) { |
| <span class="fc" id="L183"> this.permissionsLookupEnabled = permissionsLookupEnabled;</span> |
| <span class="fc" id="L184"> }</span> |
| |
| /** |
| * Sets the salt style. See {@link #saltStyle}. |
| * |
| * @param saltStyle new SaltStyle to set. |
| */ |
| public void setSaltStyle(SaltStyle saltStyle) { |
| <span class="fc" id="L192"> this.saltStyle = saltStyle;</span> |
| <span class="pc bpc" id="L193" title="1 of 4 branches missed."> if (saltStyle == SaltStyle.COLUMN && authenticationQuery.equals(DEFAULT_AUTHENTICATION_QUERY)) {</span> |
| <span class="fc" id="L194"> authenticationQuery = DEFAULT_SALTED_AUTHENTICATION_QUERY;</span> |
| } |
| <span class="fc" id="L196"> }</span> |
| |
| /*-------------------------------------------- |
| | M E T H O D S | |
| ============================================*/ |
| |
| protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken token) throws AuthenticationException { |
| |
| <span class="fc" id="L204"> UsernamePasswordToken upToken = (UsernamePasswordToken) token;</span> |
| <span class="fc" id="L205"> String username = upToken.getUsername();</span> |
| |
| // Null username is invalid |
| <span class="pc bpc" id="L208" title="1 of 2 branches missed."> if (username == null) {</span> |
| <span class="nc" id="L209"> throw new AccountException("Null usernames are not allowed by this realm.");</span> |
| } |
| |
| <span class="fc" id="L212"> Connection conn = null;</span> |
| <span class="fc" id="L213"> SimpleAuthenticationInfo info = null;</span> |
| try { |
| <span class="fc" id="L215"> conn = dataSource.getConnection();</span> |
| |
| <span class="fc" id="L217"> String password = null;</span> |
| <span class="fc" id="L218"> String salt = null;</span> |
| <span class="pc bpc" id="L219" title="2 of 5 branches missed."> switch (saltStyle) {</span> |
| case NO_SALT: |
| <span class="fc" id="L221"> password = getPasswordForUser(conn, username)[0];</span> |
| <span class="fc" id="L222"> break;</span> |
| case CRYPT: |
| // TODO: separate password and hash from getPasswordForUser[0] |
| <span class="nc" id="L225"> throw new ConfigurationException("Not implemented yet");</span> |
| //break; |
| case COLUMN: |
| <span class="fc" id="L228"> String[] queryResults = getPasswordForUser(conn, username);</span> |
| <span class="fc" id="L229"> password = queryResults[0];</span> |
| <span class="fc" id="L230"> salt = queryResults[1];</span> |
| <span class="fc" id="L231"> break;</span> |
| case EXTERNAL: |
| <span class="fc" id="L233"> password = getPasswordForUser(conn, username)[0];</span> |
| <span class="fc" id="L234"> salt = getSaltForUser(username);</span> |
| } |
| |
| <span class="pc bpc" id="L237" title="1 of 2 branches missed."> if (password == null) {</span> |
| <span class="nc" id="L238"> throw new UnknownAccountException("No account found for user [" + username + "]");</span> |
| } |
| |
| <span class="fc" id="L241"> info = new SimpleAuthenticationInfo(username, password.toCharArray(), getName());</span> |
| |
| <span class="fc bfc" id="L243" title="All 2 branches covered."> if (salt != null) {</span> |
| <span class="fc" id="L244"> info.setCredentialsSalt(ByteSource.Util.bytes(salt));</span> |
| } |
| |
| <span class="nc" id="L247"> } catch (SQLException e) {</span> |
| <span class="nc" id="L248"> final String message = "There was a SQL error while authenticating user [" + username + "]";</span> |
| <span class="nc bnc" id="L249" title="All 2 branches missed."> if (log.isErrorEnabled()) {</span> |
| <span class="nc" id="L250"> log.error(message, e);</span> |
| } |
| |
| // Rethrow any SQL errors as an authentication exception |
| <span class="nc" id="L254"> throw new AuthenticationException(message, e);</span> |
| } finally { |
| <span class="fc" id="L256"> JdbcUtils.closeConnection(conn);</span> |
| <span class="fc" id="L257"> }</span> |
| |
| <span class="fc" id="L259"> return info;</span> |
| } |
| |
| private String[] getPasswordForUser(Connection conn, String username) throws SQLException { |
| |
| String[] result; |
| <span class="fc" id="L265"> boolean returningSeparatedSalt = false;</span> |
| <span class="fc bfc" id="L266" title="All 2 branches covered."> switch (saltStyle) {</span> |
| case NO_SALT: |
| case CRYPT: |
| case EXTERNAL: |
| <span class="fc" id="L270"> result = new String[1];</span> |
| <span class="fc" id="L271"> break;</span> |
| default: |
| <span class="fc" id="L273"> result = new String[2];</span> |
| <span class="fc" id="L274"> returningSeparatedSalt = true;</span> |
| } |
| |
| <span class="fc" id="L277"> PreparedStatement ps = null;</span> |
| <span class="fc" id="L278"> ResultSet rs = null;</span> |
| try { |
| <span class="fc" id="L280"> ps = conn.prepareStatement(authenticationQuery);</span> |
| <span class="fc" id="L281"> ps.setString(1, username);</span> |
| |
| // Execute query |
| <span class="fc" id="L284"> rs = ps.executeQuery();</span> |
| |
| // Loop over results - although we are only expecting one result, since usernames should be unique |
| <span class="fc" id="L287"> boolean foundResult = false;</span> |
| <span class="fc bfc" id="L288" title="All 2 branches covered."> while (rs.next()) {</span> |
| |
| // Check to ensure only one row is processed |
| <span class="fc bfc" id="L291" title="All 2 branches covered."> if (foundResult) {</span> |
| <span class="fc" id="L292"> throw new AuthenticationException("More than one user row found for user [" + username + "]. Usernames must be unique.");</span> |
| } |
| |
| <span class="fc" id="L295"> result[0] = rs.getString(1);</span> |
| <span class="fc bfc" id="L296" title="All 2 branches covered."> if (returningSeparatedSalt) {</span> |
| <span class="fc" id="L297"> result[1] = rs.getString(2);</span> |
| } |
| |
| <span class="fc" id="L300"> foundResult = true;</span> |
| } |
| } finally { |
| <span class="fc" id="L303"> JdbcUtils.closeResultSet(rs);</span> |
| <span class="fc" id="L304"> JdbcUtils.closeStatement(ps);</span> |
| <span class="fc" id="L305"> }</span> |
| |
| <span class="fc" id="L307"> return result;</span> |
| } |
| |
| /** |
| * This implementation of the interface expects the principals collection to return a String username keyed off of |
| * this realm's {@link #getName() name} |
| * |
| * @see #getAuthorizationInfo(org.apache.shiro.subject.PrincipalCollection) |
| */ |
| @Override |
| protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principals) { |
| |
| //null usernames are invalid |
| <span class="pc bpc" id="L320" title="1 of 2 branches missed."> if (principals == null) {</span> |
| <span class="nc" id="L321"> throw new AuthorizationException("PrincipalCollection method argument cannot be null.");</span> |
| } |
| |
| <span class="fc" id="L324"> String username = (String) getAvailablePrincipal(principals);</span> |
| |
| <span class="fc" id="L326"> Connection conn = null;</span> |
| <span class="fc" id="L327"> Set<String> roleNames = null;</span> |
| <span class="fc" id="L328"> Set<String> permissions = null;</span> |
| try { |
| <span class="fc" id="L330"> conn = dataSource.getConnection();</span> |
| |
| // Retrieve roles and permissions from database |
| <span class="fc" id="L333"> roleNames = getRoleNamesForUser(conn, username);</span> |
| <span class="fc bfc" id="L334" title="All 2 branches covered."> if (permissionsLookupEnabled) {</span> |
| <span class="fc" id="L335"> permissions = getPermissions(conn, username, roleNames);</span> |
| } |
| |
| <span class="nc" id="L338"> } catch (SQLException e) {</span> |
| <span class="nc" id="L339"> final String message = "There was a SQL error while authorizing user [" + username + "]";</span> |
| <span class="nc bnc" id="L340" title="All 2 branches missed."> if (log.isErrorEnabled()) {</span> |
| <span class="nc" id="L341"> log.error(message, e);</span> |
| } |
| |
| // Rethrow any SQL errors as an authorization exception |
| <span class="nc" id="L345"> throw new AuthorizationException(message, e);</span> |
| } finally { |
| <span class="pc" id="L347"> JdbcUtils.closeConnection(conn);</span> |
| <span class="fc" id="L348"> }</span> |
| |
| <span class="fc" id="L350"> SimpleAuthorizationInfo info = new SimpleAuthorizationInfo(roleNames);</span> |
| <span class="fc" id="L351"> info.setStringPermissions(permissions);</span> |
| <span class="fc" id="L352"> return info;</span> |
| |
| } |
| |
| protected Set<String> getRoleNamesForUser(Connection conn, String username) throws SQLException { |
| <span class="fc" id="L357"> PreparedStatement ps = null;</span> |
| <span class="fc" id="L358"> ResultSet rs = null;</span> |
| <span class="fc" id="L359"> Set<String> roleNames = new LinkedHashSet<String>();</span> |
| try { |
| <span class="fc" id="L361"> ps = conn.prepareStatement(userRolesQuery);</span> |
| <span class="fc" id="L362"> ps.setString(1, username);</span> |
| |
| // Execute query |
| <span class="fc" id="L365"> rs = ps.executeQuery();</span> |
| |
| // Loop over results and add each returned role to a set |
| <span class="fc bfc" id="L368" title="All 2 branches covered."> while (rs.next()) {</span> |
| |
| <span class="fc" id="L370"> String roleName = rs.getString(1);</span> |
| |
| // Add the role to the list of names if it isn't null |
| <span class="pc bpc" id="L373" title="1 of 2 branches missed."> if (roleName != null) {</span> |
| <span class="fc" id="L374"> roleNames.add(roleName);</span> |
| } else { |
| <span class="nc bnc" id="L376" title="All 2 branches missed."> if (log.isWarnEnabled()) {</span> |
| <span class="nc" id="L377"> log.warn("Null role name found while retrieving role names for user [" + username + "]");</span> |
| } |
| } |
| <span class="fc" id="L380"> }</span> |
| } finally { |
| <span class="pc" id="L382"> JdbcUtils.closeResultSet(rs);</span> |
| <span class="pc" id="L383"> JdbcUtils.closeStatement(ps);</span> |
| <span class="fc" id="L384"> }</span> |
| <span class="fc" id="L385"> return roleNames;</span> |
| } |
| |
| protected Set<String> getPermissions(Connection conn, String username, Collection<String> roleNames) throws SQLException { |
| <span class="fc" id="L389"> PreparedStatement ps = null;</span> |
| <span class="fc" id="L390"> Set<String> permissions = new LinkedHashSet<String>();</span> |
| try { |
| <span class="fc" id="L392"> ps = conn.prepareStatement(permissionsQuery);</span> |
| <span class="fc bfc" id="L393" title="All 2 branches covered."> for (String roleName : roleNames) {</span> |
| |
| <span class="fc" id="L395"> ps.setString(1, roleName);</span> |
| |
| <span class="fc" id="L397"> ResultSet rs = null;</span> |
| |
| try { |
| // Execute query |
| <span class="fc" id="L401"> rs = ps.executeQuery();</span> |
| |
| // Loop over results and add each returned role to a set |
| <span class="fc bfc" id="L404" title="All 2 branches covered."> while (rs.next()) {</span> |
| |
| <span class="fc" id="L406"> String permissionString = rs.getString(1);</span> |
| |
| // Add the permission to the set of permissions |
| <span class="fc" id="L409"> permissions.add(permissionString);</span> |
| <span class="fc" id="L410"> }</span> |
| } finally { |
| <span class="pc" id="L412"> JdbcUtils.closeResultSet(rs);</span> |
| <span class="fc" id="L413"> }</span> |
| |
| <span class="fc" id="L415"> }</span> |
| } finally { |
| <span class="pc" id="L417"> JdbcUtils.closeStatement(ps);</span> |
| <span class="fc" id="L418"> }</span> |
| |
| <span class="fc" id="L420"> return permissions;</span> |
| } |
| |
| protected String getSaltForUser(String username) { |
| <span class="fc" id="L424"> return username;</span> |
| } |
| |
| } |
| </pre><div class="footer"><span class="right">Created with <a href="http://www.eclemma.org/jacoco">JaCoCo</a> 0.7.7.201606060606</span></div></body></html> |
