Databases
StackOverflow2013
Postsdbo
POGrails spring-security-core plugin expects a username column in the role table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGrails spring-security-core plugin expects a username column in the role table
    primarykey
    data
    text
    <p>I have a really strange problem. I've installed the spring-security-core 1.0.1 in my Grails 1.3.6 application and configured it according to the tutorial - tables are created orderly and populated by BootStrap.groovy. I'm using a PostgreSQL 8.4 database --the whole thing is running on my localhost. Now, the bootstrap works perfectly, but when I try to login I get an exception which says </p> <pre><code>org.hibernate.exception.SQLGrammarException: could not execute query </code></pre> <p>and further down:</p> <pre><code>Caused by: org.postgresql.util.PSQLException: ERROR: Column »username« does not exist </code></pre> <p>The query that fails is the following:</p> <pre><code>select authrole0_.id as id1_, authrole0_.version as version1_, authrole0_.authority as authority1_ from auth_role authrole0_ where username=? </code></pre> <p>and this is OK, because the auth_role table is not supposed to have username column. But why does Hibernate expect a username column, where it shouldn't be one? </p> <p>Any clues as how to resolve this?</p> <p>I've tried two different hibernate diaclects with no effect. I've noticed that the mapping of the table is somehow curious - with the lookup table mapped as well. Unfortunately it says in the documentation of the plugin that I'm not supposed to change it, because the class is needed by the plugin. </p> <p>My classes look like that:</p> <pre><code>class AuthUser { String username String password boolean active boolean accountExpired boolean accountLocked boolean passwordExpired static mapping = { cache true username column: '`username`' password column: '`password`' } Set&lt;AuthRole&gt; getAuthorities() { UserRole.findAllByUser(this).collect { it.role } as Set } } import java.util.Set; class AuthRole { String authority static constraints = { authority blank: false, unique: true } } import org.apache.commons.lang.builder.HashCodeBuilder class UserRole implements Serializable { AuthRole role AuthUser user boolean equals(other) { if (!(other instanceof UserRole)) { return false } other.user?.id == user?.id &amp;&amp; other.role?.id == role?.id } int hashCode() { def builder = new HashCodeBuilder() if (role) builder.append(role.id) if (user) builder.append(user.id) builder.toHashCode() } static UserRole get(long roleId, long userId) { find 'from UserRole where role.id=:roleId and user.id=:userId', [roleId: roleId, userId: userId] } static UserRole create(AuthRole role, AuthUser user, boolean flush = false) { new UserRole(role: role, user: user).save(flush: flush, insert: true) } static boolean remove(AuthRole role, AuthUser user, boolean flush = false) { UserRole instance = UserRole.findByRoleAndUser(role, user) instance ? instance.delete(flush: flush) : false } static void removeAll(AuthRole role) { executeUpdate 'DELETE FROM UserRole WHERE role=:role', [role: role] } static void removeAll(AuthUser user) { executeUpdate 'DELETE FROM UserRole WHERE user=:user', [user: user] } static mapping = { id composite: ['user', 'role'] version false } } </code></pre> <p>They are pretty much the way the plugin created them.</p> <p>Thanks, al</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USal.
    1. USal.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COFor some reason (perhaps I've edieted it) I had the wrong class in my Config.groovy. Instead of: grails.plugins.springsecurity.authority.className = 'auth.AuthRole' I had: grails.plugins.springsecurity.authority.className = 'auth.AuthUser' After fixing it I get the following exception: 2011-01-26 15:35:47,077 [http-9000-1] ERROR [/aquaWell].[default] - Servlet.service() for servlet default threw exception groovy.lang.MissingPropertyException: No such property: enabled for class: auth.AuthUser
      singulars
      1. POGrails spring-security-core plugin expects a username column in the role table
      1. USal.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload