https://issues.apache.org/bugzilla/show_bug.cgi?id=53047
--- Comment #2 from Dennis Verbeek <dverb...@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-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org
