We’re reviewing the Liferay portal (www.liferay.com) with an all-in-one bundle that uses an integrated HSQL database that supports only one connection at a time. We would like to install a full-fledged version that will use a MySQL database to support mu
We’re reviewing the Liferay portal with an all-in-one bundle that uses an integrated HSQL database that supports only one connection at a time. We would like to install a full-fledged version that will use a MySQL database to support multiple connections in production use. The documentation looks comprehensive but is a bit overwhelming. Which of the seven configuration packages would you recommend, and are there any pitfalls we should be aware of during installation?
Given the choice of installing Liferay with Tomcat, Geronimo + Tomcat, Jetty, JBoss + Jetty, JBoss + Tomcat, Resin or Websphere, I would recommend Tomcat as the most straightforward installation procedure. If you started with the Tomcat all-in-one bundle and are familiar with Tomcat data source definitions, you can adjust the HSQL definition to point to your MySQL database and use the ‘liferay create-mysql.sql’ script to initialize MySQL. After that, make sure the MySQL JDBC connector jar is installed in Tomcat’s common library folder. To start from scratch with a fresh Tomcat installation, first get the basic Tomcat installation from tomcat.apache.org running and then follow the step-by-step instructions in the Liferay Installation Guide. Watch out for path settings, placing the MySQL JDBC connector jar where Tomcat can find it, and making sure that your firewall is not blocking the port on which Tomcat listens, which is usually Port 8080.
