Drupal on GlassFish using Quercus

I will explain how to get Drupal running on GlassFish in 10 minutes.

Requirements:

• MySQL 5.0.67+
  
• Drupal 6.9
• GlassFish V 2.1
• NetBeans 6.5
• Quercus 3.1.2

Database:

1. Create the Drupal user in the database.
   

   GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON drupal.* TO 'drupal'@'localhost' IDENTIFIED BY 'drupal';

   Note: This is not secure and should only be used for demo.
   


2. Create a new database in mySQL called drupal.
   

   create database drupal character set utf8;

Quercus:

Download and extract the quercus-3.2.1.war file.

jar -xvf quercus-3.2.1.war WEB-INF

Drupal:

1. Download and extract Drupal 6.9
2. Copy the WEB-INF directory and files from the Quercus into the Drupal directory.

NetBeans:

1. Create a new project in NetBeans. Choose Java Web and Web Application with Existing Sources.
   
   


2. Fill in the Name and location properties for the project.
   
   Note: Please make sure that you choose a different folder for the project files. Please see the image below as an example.
   
   


3. Next select the application server, and set the Context Path. I renamed my context to /drupal
   
   


4. Next select the Web Pages folder. This should be the top directory of the Drupal directory you extracted. This is the directory which contains index.php.
   
   


5. Click Finish


6. Open the project and navigate to the Web Pages folder. Navigate to the sites --> default directory. Right click on the default.settings.php file and copy. Paste the file back into the directory. Right click on the file it should be named something like default.settings_1.php, rename the file to settings.
   
   Note: NetBeans will append the .php to the end of the file.
   
   


7. Right click on the project and select Properties. This will bring up the project properties. Select the Libraries Category. Here you will see the files that were included from Quercus 3.1.2 which were in the WEB-INF/lib directory.


8. Click on Add Library and select MySQL JDBC Driver. Click OK.
   
   


9. Finally Run Main Project (F6).

Drupal Configuration:

If you were successful, you should see the Drupal Configuration page.

1. Select Install Drupal in English (You may choose differently based on your requirements).



2. Fill in the database with the information we created earlier.
   
   
   • Check mysqli
   • Database Name: drupal
   • Database Username : drupal
   • Database Password: drupal
   
   
   Click Save and Continue.
   
   


3. That will complete the database installation and bring up the Site Configuration Screen. Fill in the values and click Save and Continue.
   
   


4. Finished. You should get an Installation Complete screen. Click on your new site.
   
   Note: My installation has an error message because I don't have SMTP configured on my Mac.
   
   

Congratulations! You have Drupal 6.9 running on Quercus 3.1.2 on GlassFish 2.1.

Quercus PHP 3.2.1 on GlassFish 2.1

I am trying to consolidate a number of applications running on various platforms to GlassFish, if possible. So far I have been incredibly successful with Ruby using JRuby. Our project tracking software (bugs/news/wiki/forums/repository browser) are running on Redmine using JRuby.

Based on the success of using Ruby (RoR), I decided to trying moving some PHP applications over to GlassFish.

I read a great blog article by Ludovic Champenois called 100% Java Quercus PHP engine running in GlassFish Java EE 5 Application Server It describes how to use an open source engine called Quercus from Caucho. I tried to follow the directions, but could not get it to work. I imagine because the versions of GlassFish application server and Quercus may have been different. I was not deterred.

I came across a follow-up article by Arun Gupta called PHP in GlassFish using Caucho Quercus. This article was the missing link. The major difference being the placement of the jar files in the domain/domainXX/lib directory.

Here are the application versions I used to get a functional Caucho Quercus PHP implementation running on GlassFish v 2.1

Mac OS X 10.5.6 (Intel x86)

• GlassFish v 2.1 Build 60e ( 2.1 FCS)
• Quercus 3.2.1
• Java(TM) SE Runtime Environment (build 1.6.0_07-b06-146) Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_07-b06-56, mixed mode)

Mac OS X 10.5.6 (PowerPC)

• GlassFish v 2.1 Build 60e ( 2.1 FCS)
• Quercus 3.2.1
• jsr223-api.jar (Project Phobos) Required for Java SE 5.
• Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_16-b06-284) Java HotSpot(TM) Client VM (build 1.5.0_16-133, mixed mode, sharing)

When I created my projects I used the following web.xml It is based on the example web.xml in the Quercus 3.2.1 war file.

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<session-config>
   <session-timeout>
       30
   </session-timeout>
</session-config>

<description>Caucho Technology's PHP Implementation</description>
<servlet>
   <servlet-name>Quercus Servlet</servlet-name>
   <servlet-class>com.caucho.quercus.servlet.QuercusServlet</servlet-class>
<!-- Specifies the encoding Quercus should use to read in PHP scripts.
    -->
<!--
    <init-param>
      <param-name>script-encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    -->

<!-- Tells Quercus to use the following JDBC database and to ignore the
         arguments of mysql_connect().
    -->
<!--
    <init-param>
      <param-name>database</param-name>
      <param-value>jdbc/test</param-value>
    </init-param>
    -->

<!--
    <init-param>
      <param-name>ini-file</param-name>
      <param-value>WEB-INF/php.ini</param-value>
    </init-param>
    -->
</servlet>

<servlet-mapping>
   <servlet-name>Quercus Servlet</servlet-name>
   <url-pattern>*.php</url-pattern>
</servlet-mapping>
<welcome-file-list>
   <welcome-file>index.php</welcome-file>
</welcome-file-list>
</web-app>

This arrangement will allow you run a large number of applications including XWiki, and Drupal. Unfortunately for me, it can not run phpLDAPadmin which I needed.