geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Torsten Markwardt (JIRA)" <>
Subject [jira] Created: (GERONIMO-1758) Can not use Realm with SQL database over connection pool
Date Wed, 22 Mar 2006 02:30:01 GMT
Can not use Realm with SQL database over connection pool

         Key: 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:
03:22:30,390 ERROR [] DEBUG: 000: 2:
03:22:30,390 ERROR [] DEBUG: 000: 3:
# 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, FROM l
ogin_users AS u, login_groups AS g, login_group_members AS r WHERE AND
= r.group_id AND u.login=?, dataSourceName=jdbc/WebConfDatabase}},
id=SecurityRealm-webconf-realm], org.apache[org.apache.geronimo.system.serverinfo.ServerInfo$$EnhancerByCGLIB$$5eff278f:
# 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:
For more information on JIRA, see:

View raw message