geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aaron Mulder (JIRA)" <...@geronimo.apache.org>
Subject [jira] Resolved: (GERONIMO-1758) Can not use Realm with SQL database over connection pool
Date Mon, 07 Aug 2006 23:36:14 GMT
     [ 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

        

Mime
View raw message