MySQL 5.1 Database and Liferay Portal on Red Hat Linux 4

After Installation and Configuration of MySQL 5.1 in a Red Hat Linux Machine, this post will now help you connect your own Liferay Portal to your installed MySQL 5.1.

• 1. See my previous post, after configuring MySQL 5.1 you have to create a table that will be use by liferay.

mysql> create database lportal character set utf8; This line will create a database named "lportal" with a character set of utf8, meaning it can accept Special and Chinese characters.

• 2. Create a file named portal-ext.properties on your directory : {liferay}\{tomcat}\webapps\ROOT\WEB-INF\classes folder put this lines for its content.

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

• 3. To run your own Liferay Portal, JAVA SDK must Install.

export JAVA_HOME=[directory]/[folder]/[of]/[java]/jdk1.6.0_12 export PATH=$JAVA_HOME\bin:$PATH

• 4. Delete the sevencogs-theme and sevencogs-hook folder from {liferay}\{tomcat}\webapps\ folder.

Type: rm –rf sevencogs-theme rm –rf sevencogs-hook Thanks for Jeannette lim for this commands. hehehe

• 5. To run your own Liferay portal, simply follow these lines.

[root@localhost ~]# cd [liferay]/liferay-portal-5.2.2/tomcat-6.0.18/bin ‘you must directly go to directory folder of bin. [root@localhost ~]# ./startup.sh ‘you will need to issue another command to start liferay [root@localhost ~]# tail -f ../logs/catalina.out ‘Liferay will start as usual. Because this is the first time Liferay will be launched ‘against your new MySQL database, it will take some extra time creating all of the tables ‘it needs in the database.

• 6. Once the messages have stopped scrolling, by typing http://localhost:8080 on the address bar of your browser you will see the main page of your liferay portal.

Sources:

• Liferay Portal Administrator’s Guide for 5.1
• Macuha.com's Liferay for Windows.