Alfresco on Glassfish
By MandyWaite on Oct 10, 2008
I recently posted an updated version of this walkthrough that covers Alfresco 3.2r2.
This walkthrough is for OpenSolaris, it was made on the b98 development build but I'd expect it to work on the release version of 2008.05. It probably works on all other platforms as well with some changes to the pathnames and some of the commands. I'll work on something similar for Solaris, Ubuntu and for Windows.
I've posted a shorter version for those who have previously tried to get it working but were just missing the vital ingredient.
I'm going to assume you are doing this as a non-root user. If you do this as root, just drop the pfexec statement from any commands you issue.
First install Glassfish and MySQL:
$ pfexec pkg refresh $ pfexec pkg install glassfishv2 $ pfexec pkg install SUNWmysql5
Unlike with the best tutorials, I won't first remind you to turn your system on or not to install the packages if they are already installed.
OpenSolaris has this nifty feature called SMF but we haven't yet managed to hook the installation of packages up such that Services are automatically registered with it yet although that should be there in the November release. For now run the following to register it:
$ pfexec svccfg import /var/svc/manifest/application/database/mysql.xml
and then start the MySQL service:
$ pfexec svcadm enable mysql
This will do all of the work required to get MySQL up and running for the first time. Now create a DB and a user to access it with.
$ /usr/mysql/50/bin/mysqladmin -u root create alfresco
$ /usr/mysql/50/bin/mysql -u root
mysql> grant all privileges on alfresco.\* to 'alfresco'@'%' identified by 'alfresco'; Query OK, 0 rows modified (0.00sec)
mysql> grant all privileges on alfresco.\* to 'alfresco'@'localhost' identified by 'alfresco'; Query OK, 0 rows modified (0.00sec)
Now setup a Glassfish domain:
$ pfexec /usr/sbin/asadmin create-domain --adminport 4848 domain1
You need a JDBC MySQL driver:
$ wget http://mysql.osuosl.org/Downloads/Connector-J/mysql-connector-java-5.1.6.tar.gz
The URL used for the MySQL JDBC driver is just one of many mirrors. You might be better off going to http://dev.mysql.com/downloads/connector/j/5.1.html and choosing where to get it from.
Unpack this somewhere and copy mysql-connector-java-5.1.6-bin.jar to the Glassfish domain's lib directory:
$ pfexec cp mysql-connector-java-5.1.6-bin.jar /var/appserver/domains/domain1/lib
While you are doing this you may as well create an alfresco directory in the same place, you'll need it later.
$ pfexec mkdir /var/appserver/domains/domain1/lib/classes/alfresco
Alfresco War file and configuration
This testing was done with Alfresco labs 3b, it should work with other versions, but if it doesn't post a comment on this blog and I'll look into it.
Next we'll need the Alfresco War file, which you can probably get like this:
$ wget http://us.dl.alfresco.com/build-1164/alfresco-labs-war-3b.tar.gz
But as that looks like a URI than might have been created by
SkyNet a machine, you may need to fallback to going here:
Once you have it, extract the bundle somewhere, you won't need it after the setup is finished.You now need to setup the Alfresco bits that aren't contained in the WAR file. From the directory in which you unpacked the Alfresco bundle, copy the entire contents of the extensions directory to the directory you created earlier:
$ pfexec cp -r extensions/\* /var/appserver/domains/domain1/lib/classes/alfresco
You don't want to copy over the extensions directory itself, just it's contents (extension and messages directories).
Alfresco needs somewhere to keep all of it's documents and indexes. This is usually named alf_data, if you don't specify a path to alf_data or the path doesn't exist it will create one for you... somewhere. Let's not leave things to chance and create one and then configure Alfresco to find it:
$ pfexec mkdir /var/alfresco/alf_data
Now cd to /var/appserver/domains/domain1/lib/classes/alfresco/extension and modify the config files so that Alfresco can find alf_data and can find the database. The files that need changing are:
In custom-repository.properties do the following:
Uncomment the dir.root line and change it's path to /var/alfresco/alf_data
Uncomment the db.username and db.password lines
The last part of the file has sections for specific databases, by default it's setup to use Derby. Comment out the lines for derby and uncomment the lines for MySQL
db.driver=org.apache.derby.jdbc.EmbeddedDriver db.url=jdbc:derby:data/derby_data/alfrescocreate=true ... ... #db.driver=org.gjt.mm.mysql.Driver #db.url=jdbc:mysql://localhost/alfresco
#db.driver=org.apache.derby.jdbc.EmbeddedDriver #db.url=jdbc:derby:data/derby_data/alfrescocreate=true ... ... db.driver=org.gjt.mm.mysql.Driver db.url=jdbc:mysql://localhost/alfresco
In custom-hibernate-dialog.properties, comment out the line for Derby and uncomment the line for MySQL
The Glassfish specific deployment descriptor
Now for the fun bit. Go to the directory in which you unpacked the Alfresco bundle, create a directory called WEB-INF and in that create a file called sun-web.xml with the following contents:
<?xml version="1.0" encoding="UTF-8"?> <!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> <class-loader delegate="false"/> <property name="useMyFaces" value="true"/> </sun-web-app>
and then add that file to the alfresco.war file:
$ jar uvf alfresco.war WEB-INF/sun-web.xml adding: WEB-INF/sun-web.xml(in = 316) (out= 236)(deflated 25%)
You're now ready to start Glassfish and deploy alfresco.war to the Glassfish domain:
$ pfexec /usr/bin/asadmin start-domain domain1 $ /usr/sbin/asadmin deploy alfresco.war Please enter the admin user name>admin Please enter the admin password> Command deploy executed successfully
Now you should be able to fire up a browser and connect to Alfresco at http://localhost:8080/afresco
This really just covers the basics and uses a clean OpenSolaris install just to show what actually needs to be done to get it working. Hopefully it can be extrapolated from to help install Alfresco on Glassfish in more complicated scenarios. I'll post this on the Alfresco forums once I'm happy that nothing silly creeped in. Hopefully we can extend this to cover different setups and configurations.
At some point it would be nice to show how to get the PDF to Flash functionality working as currently that's missing,
Check that it's using the MySQL database that you created by connecting to MySQL through the mysql command and looking to see if the Alfresco database has a bunch of tables. Also check that /var/alfresco/alf_data contains directories if it doesn't then it probably hasn't picked up the configuration in /var/appserver/domains/domain1/lib/classes/alfresco/extensions. Check that you've used the correct path and that the changes that you made to custom-repository.properties and custom-hibernate-dialog.properties are correct.
Remember to stop and start MySQL (if you need to) using svcadm.
The sun-web.xml file has along line in it, if you cut and paste make sure that it doesn't get split across multiple lines.
If you see any issues or mistakes then post a comment on this blog.