First of all, MySQL must be configured to use the InnoDB storage engine for the photos database. This can be done in two ways:

• Configuration setting; Edit the my.cnf configuration file (usually located in /etc on *nix systems and add the following lines to the [mysqld] section:

  default-table-type = INNODB 

  After this, restart mysql.

• After creating the database tables: For every database table execute the command

  alter table TABLE_NAME engine = INNODB

  to change the storage engine for that table to INNODB.

Now create a MySQL database

 mysqladmin -u root -p create photoxchange 

Where root is the user name of the administrator and photoxchange is the name of the database.

Create a user on the database by logging in as administrator

 mysql -u root -p photoxchange 

and creating a user that has access to the database

 grant all on * to username identified by 'password'; 

This creates a user that can access the database from the same host the database is running on. If MySQL is running on a different machine than the application server, consult the MySQL manuals for information on how to configure access for that user.

After creating the database check the transaction settings by logging on to the photoxchange database as administrator and executing the command

 show variables 

The value of the tx_isolation variable should be REPEATABLE-READ. If this not the case, set the transaction level globally for all databases by specifying

 transaction-isolation = REPEATABLE-READ 

In the [mysqld] section of the my.cnf file. It is also possible to set the transaction isolation level for one database only using

 SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ 

See the MySQL manuals for more details.

Populate the database by executing the sql scripts provided with the delivery on the database. On *nix systems:

 mysql -u username -p photoxchange < setup.sql 

After this, execute the command show table status; to check that the tables indeed use the InnoDB storage engine.

The photos application will perform the following initializations automatically at startup.

First of all, the database driver for MySQL must be installed by copying the driver jar mysql-connector-java-3.x.y-bin.jar from the MySQL web site to the server/default/lib directory of JBoss.

Next, the datasource must be configured by copying a photos-ds.xml file to the server/default/deploy directory of the application server and choosing the correct username and password.

To configure security, add the following security domain configuration to login-config.xml in the server/default/conf directory of the server:

            <application-policy name="PhotoXChange">
              <authentication>
                <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
                  <module-option name="unauthenticatedIdentity">guest</module-option>
                  <module-option name="dsJndiName">java:/PhotoXChange</module-option>
                  <module-option name="principalsQuery">
                    SELECT PASSWORD FROM USERS WHERE NAME = ?;
                  </module-option>
                  <module-option name="rolesQuery">
                    select g.name, 'Roles' from USERS u, USER_GROUPS ug, GROUPS g 
                    where u.id = ug.user_id and ug.group_id = g.id and u.name = ?
                  </module-option>
                  <module-option name="hashAlgorithm">MD5</module-option>
                  <module-option name="hashEncoding">hex</module-option>
                </login-module>
              </authentication>
            </application-policy>   
          

Note the module option dsJndiName which refers to the previously configured datasource. Also, note the module options hashEncoding and hashAlgorithm which specify that passwords should be stored as a base 16 MD5 hash.

Since most applications and 3rd party products require log4j and glassfish by default does not have this, log4j support must be added as follows:

• Create a directory lib/log onder glassfish and put the log4j jar and log4j.properties file there.
• Add the fully qualified path to the log4j.jar into the classpath of Glassfish together with the directory that contains the log4j.properties file. You can do that in the web UI: Application Server/JVM Settings/Paths and the entries are separated by a return. Use the system path.
• Restart glassfish.

First of all, the database driver for MySQL must be installed by copying the driver jar mysql-connector-java-3.x.y-bin.jar from the MySQL web site to the server/default/lib directory of JBoss. Next, the datasource must be configured by configuring a connection pool and a JDBC resource with JNDI name identical to the previously configured datasource. The connection pool must be configured with the following properties:

• user: The database user name.
• password: The database password.
• URL: For instance jdbc:mysql://localhost:3306/photoxchange is photoxchange is the name of the database.

Configuration of the JDBC resource is straightforward.

To setup security, FlexibleJdbcRealm is required. This requires several steps:

• Copy the FlexibleJdbcRealm to the glassfish lib directory and restart glassfish.
• Edit config/login.conf of the glassfish domain to add mapping of the realm to the flexible JdbcRealm login module:

   PhotoXChangeRealm {
                  org.wamblee.glassfish.auth.FlexibleJdbcLoginModule required; }; 

  Here, PhotoXChangeRealm is the name of the configured securty realm.
• In glassfish administration console in security, select default principal to role mapping to make sure that roles and groups are identical.
• Configure the security realm with the following properties

  Property	Value
  jaas.context	PhotoXChangeRealm
  sql.password	SELECT PASSWORD FROM USERS WHERE NAME = ?
  sql.groups	SELECT g.name FROM USERS u, USER_GROUPS ug, GROUPS g WHERE u.id = ug.user_id and ug.group_id = g.id AND u.name = ?
  datasource.jndi	Datasource JNDI name configured before, e.g. jdbc/PhotoXChange
  password.encoding	MD5
  password.seed.format	{0}
  assign-groups	ALL