RE: [JBoss-dev] OracleLoginModule

[Sonnek, Ryan]

out of curiosity, could you say how you did this?  i'm assuming that you're authenticating to the DBA_USERS and DBA_USER_ROLES tables, and this is something that i tried a while back.  i got stuck being able to hash my login modules password to match oracles.  there was no documentation on what algorithm they were using, and so after trying a few, i gave up.  this is something that i am HIGHLY interested in, and would love to take a look at.

 

congratulations on the hard work.

Ryan

-----Original Message-----
From: David Jencks [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 9:04 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] OracleLoginModule

I'm very interested in this login module. Can you supply it as a "patch" in the sourceforge tracker? Otherwise I may lose track of it before I can review and commit it.

Offhand it seems to me that the LoginModule should only work if the criteria was ByContainer. Are you calling ds.getConnection() or ds.getConnection(user, pw)? Can you check the code in XAManagedConnectionFactory.matchManagedConnection and BaseWrapperManagedConnectionFactory.getConnectionProperties to see if it is obvious why the match is failing? You might need to modify the OracleXAManagedConnectionFactory to provide more suitable matching behavior. (I'm looking at jboss head for these classes).

thanks

david jencks

Hi guys,

I wrote a login module specific for Oracle DataBase, that try to authenticate a user on Oracle DataSource and map Oracle Role on J2ee Role. I think it could be very interesting for guys that have jboss and Oracle together, because you could manage roles and user just in one enviroment.

I tried it on my enviroment and seems to work only if I set in Oracle-xa-service.xml

<attribute name="Criteria">ByApplication</attribute>

If I set it to ByContainer I get this error:

15:14:02,562 WARN  [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.adapter.jdbc.xa.oracle.XAOracleManagedConnection@462631

And connection still Opened on the DB.

Could you please explain me what's happen. Thank you in advance

BTW I attached my source, what about it? Couldn't it be useful for anyone?

<image.tiff>

<OracleServerLoginModule.java>