Hi Sheldon, You might have more luck on the Torque mailing list, but this should work:
1) Have Tomcat connect to your database using MD5 authentication. Not totally sure how to do this, but it looks like there are some good docs on it (here? http://wiki.apache.org/jakarta-commons/DBCP). You'll at least need a resource section: <Context path="/mywebapp" reloadable="true"> <Resource auth="Container" name="jdbc/db" type="javax.sql.DataSource" password="pw" driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" validationQuery="SELECT 1" username="db" url="jdbc:mysql://localhost/db?autoReconnect=true" maxActive="4"/> <WatchedResource>WEB-INF/web.xml</WatchedResource> </Context> Sounds like you'll need a Realm section to get the MD5 working - check the docs. 2) Have Torque connect to the JNDI instance like this: torque.database.db.adapter = mysql torque.dsfactory.db.factory = org.apache.torque.dsfactory.JndiDataSourceFactory torque.dsfactory.db.jndi.path = java:comp/env/jdbc/db Then you should be good to go! Good luck, David -----Original Message----- From: Sheldon Ross [mailto:[EMAIL PROTECTED] Sent: August-25-07 3:32 PM To: [EMAIL PROTECTED] Subject: Torque md5 Hello In our project we are using a turbine/torque webapp connected to a postgresql database. Right now we are using plain-text user passwords for the database connections via 'torque.dsfactory.db.connection.user=user torque.dsfactory.db.connection.password=password' with the pg_hba.conf setting for our tomcat nodes set to password. We would like to be able to set it to md5 and use md5 hash for added security. Does anyone know if there is a setting to enable torque to connect to postgres using md5 instead of plain-text ? As always any help/suggestions are appreciated! Sheldon Ross _________________________________________________________________ A new home for Mom, no cleanup required. All starts here. http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
