Skip to content

Instantly share code, notes, and snippets.

@redmoon512

redmoon512/shiro.ini

Forked from dominicfarr/shiro.ini
Created May 7, 2018 06:54
Show Gist options
  • Save redmoon512/4f43b39001cae05b9db060a4552986ae to your computer and use it in GitHub Desktop.
Save redmoon512/4f43b39001cae05b9db060a4552986ae to your computer and use it in GitHub Desktop.
Download ZIP
example jdbcRealm configured in shiro.ini
Raw
shiro.ini
[main]
ds = com.mysql.jdbc.Driver
ds.serverName = localhost
ds.user = user
ds.password = password
ds.databaseName = db_name
jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm.dataSource = $ds
jdbcRealm.permissionsLookupEnabled = true
jdbcRealm.authenticationQuery = "SELECT password FROM users WHERE user_name = ?"
jdbcRealm.userRolesQuery = "SELECT role_name FROM user_rolesWHERE user_name = ?"
jdbcRealm.permissionsQuery = "SELECT permission FROM roles_permissions WHERE role_name = ?"
authc = org.apache.shiro.web.filter.authc.PassThruAuthenticationFilter
authc.loginUrl = /login/
[urls]
/login/ = authc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment