Can not use Realm with SQL database over connection pool
--------------------------------------------------------
Key: GERONIMO-1758
URL: http://issues.apache.org/jira/browse/GERONIMO-1758
Project: Geronimo
Type: Bug
Components: security
Versions: 1.0
Environment: Basic install
Reporter: Torsten Markwardt
i have tested with integrated derby. configuration (userSelect etc.) was bad
stored for SQLLoginModule. On the map the map was stored the entries
userSelect, dataSourceApplication, groupSelect and dataSourceName with key
"{userSelect" and the value "<userSelectQuery>,[
,]dataSourceApplication=<dataSourceApplication>,[ ,]groupSelect=<groupSelect>,[
,]dataSourceName=<dataSourceName>".
Ergo ... i can not use SQL based realm :-(
here a debug hack to view:
# options.KeySet list
03:22:30,390 ERROR [] DEBUG: 000: 0: {userSelect
03:22:30,390 ERROR [] DEBUG: 000: 1:
org.apache.geronimo.security.realm.GenericSecurityRealm.KERNEL
03:22:30,390 ERROR [] DEBUG: 000: 2:
org.apache.geronimo.security.realm.GenericSecurityRealm.CLASSLOADER
03:22:30,390 ERROR [] DEBUG: 000: 3:
org.apache.geronimo.security.realm.GenericSecurityRealm.SERVERINFO
# options
03:22:30,390 ERROR [] DEBUG: 001: options={{userSelect=SELECT u.login,
u.password, u.passwordmethod FROM login_users AS u WHERE u.login=?,
dataSourceApplication=null, groupSelect=SELECT u.login, g.name FROM l
ogin_users AS u, login_groups AS g, login_group_members AS r WHERE
u.id=r.user_id AND g.id = r.group_id AND u.login=?,
dataSourceName=jdbc/WebConfDatabase}},
org.apache.geronimo.security.realm.Generic
SecurityRealm.KERNEL=geronimo,
org.apache.geronimo.security.realm.GenericSecurityRealm.CLASSLOADER=[org.apache.geronimo.kernel.config.MultiParentClassLoader
id=SecurityRealm-webconf-realm], org.apache
.geronimo.security.realm.GenericSecurityRealm.SERVERINFO=[org.apache.geronimo.system.serverinfo.ServerInfo$$EnhancerByCGLIB$$5eff278f:
geronimo.server:J2EEApplication=null,J2EEModule=geronimo/j2ee-sys
tem/1.0/car,J2EEServer=geronimo,j2eeType=GBean,name=ServerInfo]}
# Error on SQLLoginModule.initialize -> properties.put( "jdbcUser",
options.get( USER))
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
