AppFuseOnJBoss

This is version 1. It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

AppFuse Security (e-mail on January 26th)

Setting up AppFuse security in JBoss I was surprise how easy it was. I am starting to become a JBoss fan. (I still prefer Resin.)

    <application-policy name = "appfuse">
       <authentication>
          <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
             flag = "required">
             <module-option name = "dsJndiName">jdbc/mysql</module-option>
             <module-option name = "principalsQuery">
	     select password from app_user where username=?
	     </module-option>
             <module-option name = "rolesQuery">
	     select role_name, 'Roles' from user_role where username=?
	     </module-option>

	   </login-module>
       </authentication>
    </application-policy>
}}

It took me less time to setup Security than it did for me to setup logging. (Which is a bit of a nightmare!)

The above assumes you have a database driver mapped under jdbc/mysql.

Create DS file as follows, and put it in the deploy dir:
(C:\tools\jboss-3.2.3\server\default\deploy/mysql-ds.xml)

{{{
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/mysql</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/mysql</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password></password>
  </local-tx-datasource>
</datasources>

jboss-web.xml		355 bytes
mysql-ds.xml		992 bytes
log4j.xml		5811 bytes
login-config.xml		6280 bytes