tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 53047] JDBCRealm allRolesMode="authOnly" still needs role table
Date Tue, 10 Apr 2012 10:29:13 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53047

--- Comment #2 from Dennis Verbeek <dverbeek@hotmail.com> 2012-04-10 10:29:13 UTC ---
When userRoleTable is not defined the JDBCRealm simply queries table "null".
allRolesMode="authOnly" ... It's in the title!

<Realm className="org.apache.catalina.realm.JDBCRealm" allRolesMode="authOnly"
digest="MD5" driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql:mydb" connectionName="myname"
connectionPassword="mypw" userTable="tomcat_user" userNameCol="login"
userCredCol="password" userRoleTable="tomcat_role" roleNameCol="role" />

Apr 10, 2012 11:50:00 AM org.apache.catalina.realm.JDBCRealm getRoles
SEVERE: Exception performing authentication
org.postgresql.util.PSQLException: ERROR: relation "tomcat_role" does not exist

<Realm className="org.apache.catalina.realm.JDBCRealm" allRolesMode="authOnly"
digest="MD5" driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql:mydb" connectionName="myname"
connectionPassword="mypw" userTable="tomcat_user" userNameCol="login"
userCredCol="password" />

Apr 10, 2012 12:02:55 PM org.apache.catalina.realm.JDBCRealm getRoles
SEVERE: Exception performing authentication
org.postgresql.util.PSQLException: ERROR: syntax error at or near "null"

<security-constraint>
   ...
   <auth-constraint>
      <description></description>
      <role-name>*</role-name>
   </auth-constraint>
</security-constraint>

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org


Mime
View raw message