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:

3 comments:

Anonymous said...

dating sims games [url=http://loveepicentre.com/]affiliate dating free program[/url] adultsinglesmeet http://loveepicentre.com/ euro asian dating sites

Anonymous said...

Laptop Adapter [url=http://www.hqlaptopbatteries.com/-1800-s207-laptopbatterymodel77.html]Buy Cheap Laptop Battery[/url] Clevo Laptop http://www.hqlaptopbatteries.com/dq-02k6739-6-high-quality41.html laptop price
Samsung laptop battery [url=http://www.hqlaptopbatteries.com/battery-3508wlmi-batterytype1.html]compare laptop prices[/url] compare laptops http://www.hqlaptopbatteries.com/-a150-bb1-laptopbatterymodel1603.html compare laptop prices
buy laptops [url=http://www.hqlaptopbatteries.com/page97.html]notebook battery[/url] Compaq laptop battery http://www.hqlaptopbatteries.com/-m6000-laptopbatterymodel834.html AC Adapter

Anonymous said...

Hello. And Bye. Thank you very much.