This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Portals and Portlets and the fly likes MySQL Configuration on Liferay Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Portals and Portlets
Bookmark "MySQL Configuration on Liferay" Watch "MySQL Configuration on Liferay" New topic
Author

MySQL Configuration on Liferay

Allan Cheong
Ranch Hand

Joined: Nov 12, 2009
Posts: 71

I've downloaded and extracted Liferay bundled with Tomcat 6. Started Tomcat with no issue. However, I decided to use MySQL for the database so I create the database lportal in MySQL and created the file portal-ext.properties in the root directory of Liferay.

This is the content of portal-ext.properties:



Then I start the webserver again. I can see that tables and data are created in MySQL. But when http://localhost:8080 is opened, nothing is displayed. The page is white.

Tomcat console shows very long exceptions. How can I log this exception to a log file? And anyone knows what is causing this problem?


SCJP6, SCJD, OCJWCD5
V N K Srujan Kollisetty
Greenhorn

Joined: Jul 19, 2010
Posts: 2
C:\liferay\bundles\liferay-portal-tomcat-6.0-5.2.3\portal-ext.properties. This is the file need to be modified. Below properties need to be added in that file.

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=root



Thanks,
Srujan Kollisetty
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL Configuration on Liferay