[ http://issues.apache.org/jira/browse/GERONIMO-1758?page=all ]
Aaron Mulder resolved GERONIMO-1758. ------------------------------------ Fix Version/s: 1.1 Resolution: Cannot Reproduce Assignee: Aaron Mulder If I create a SQL security realm through the console, and point it at a data source defined elsewhere in the console, it works OK. Please post your security realm deployment plan and reopen this issue if you're still having problems. > Can not use Realm with SQL database over connection pool > -------------------------------------------------------- > > Key: GERONIMO-1758 > URL: http://issues.apache.org/jira/browse/GERONIMO-1758 > Project: Geronimo > Issue Type: Bug > Security Level: public(Regular issues) > Components: security > Affects Versions: 1.0 > Environment: Basic install > Reporter: Torsten Markwardt > Assigned To: Aaron Mulder > Fix For: 1.1 > > > 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