Amy Roh's Blog

February 2006 Archives

Roller 2.1 on GlassFish

Deploying Roller 2.1 on GlassFish.

STEP 1: Prerequisites

STEP 2: Download\Install GlassFish

STEP 3: Download\Install Roller

Step 3.1 : Download Roller

1. Download Roller 2.1. 
   (The official Roller 2.1 release should be out very soon.  For now, you'll have to get it from its subversion repository and build it yourself). 


2. Unpack the downloaded TAR file.
   

Step 3.2 : Minor changes to Roller

STEP 4: Create Roller tables in your database

Now you need to create a new database, create a user with appropriate privileges, and use an SQL script to create the database tables required to run Roller. To do this, login to your database and run one of the Roller database creation scripts located in Roller's WEB-INF/dbscripts directory.

• WEB-INF/dbscripts/mysql/creatdb.sql - creates tables for MySQL
• WEB-INF/dbscripts/derby/createdb.sql - creates tables for Derby
• WEB-INF/dbscripts/postgresql/creatdb.sql - creates tables for PostgreSQL

The examples below show you how you might do this using MySQL, assuming your Roller user will have username scott and password tiger. For more information on MySQL, refer to the MySQL Reference Manual.

Make sure you enable UTF-8 support in MySQL (see page Setting Up UTF8 on MySQL for details).

UNIX example

 % cd <temp_dir>/roller/WEB-INF/dbscripts/mysql
 % mysql -u root -p
 password: *****
 mysql> create database roller;
 mysql> grant all on roller.* to scott@'%' identified by 'tiger';
 mysql> grant all on roller.* to scott@localhost identified by 'tiger';
 mysql> use roller;
 mysql> source createdb.sql
 mysql> quit

Windows example, from an MS-DOS or Command Prompt window:

 C> cd <temp_dir>\roller\WEB-INF\dbscripts\mysql
 C> mysql -u root -p
 password: *****
 mysql> create database roller;
 mysql> grant all on roller.* to scott@'%' identified by 'tiger';
 mysql> grant all on roller.* to scott@'localhost' identified by 'tiger';
 mysql> use roller;
 mysql> source createdb.sql
 mysql> quit

Notes:

MySQL users, don't forget to call "flush privileges" and make sure that your MySQL installation hasn't set the skip-networking option. Connector/J can only access MySQL via TCP/IP. The MySQL command line tool however doesn't use TCP/IP sockets by default. To check whether your connect works, use anything other than "localhost" as host, for example:

 mysql roller -h 127.0.0.1 -u scott -ptiger

STEP 5: JDBC connection

Step 5.1 : JDBC driver jar

Step 5.2 : JDBC Connection Pool Setting

Create JDBC Connection Pool (Admin GUI -> Application Server -> Resources -> JDBC -> Connection Pools)

<jdbc-connection-pool allow-non-component-callers="false"
datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
<property name="user" value="scott"/>
<property name="port" value="3306"/>
<property name="password" value="tiger"/>
<property name="databaseName" value="roller"/>
<property name="serverName" value="localhost"/>
</jdbc-connection-pool>

Step 5.3 : JDBC Resource Setting

<jdbc-resource enabled="true"
jndi-name="jdbc/rollerdb" object-type="user" pool-name="MySQL"/>

STEP 6: Deploy Roller to GlassFish

Step 6.1: sun-web.xml 

<?xml version="1.0" encoding="UTF-8"?>

<!--
 Copyright 2004-2005 Sun Microsystems, Inc. All rights reserved.
 Use is subject to license terms.
-->

<!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Application Server 8.1 Servlet 2.4//EN" "http://www.sun.com/software/appserver/dtds/sun-web-app_2_4-1.dtd">

<sun-web-app>

<session-config>
<session-manager>
</session-manager>
</session-config>

<resource-ref>
<res-ref-name>jdbc/rollerdb</res-ref-name>
<jndi-name>jdbc/rollerdb</jndi-name>
</resource-ref>

<class-loader delegate="false"/>

</sun-web-app>

Step 6.2: Create war file

Step 6.3: Deploy roller.war to GlassFish

Step 6.4: Security permission

// permission for Roller: file upload, log setting, etc :

grant codeBase "file:${com.sun.aas.installRoot}/domains/domain1/applications/j2ee-modules/roller/-" {
permission java.security.AllPermission;
};

grant codeBase "file:${com.sun.aas.installRoot}/domains/domain1/generated/jsp/j2ee-modules/roller/-" {
permission java.security.AllPermission;
};

This work is licensed under a Creative Commons License.