Configure MYSQL for project websynergy on GlassFish V3 in 60 seconds

Courtesy : Raju uppalapati from the portal team.

Goal : Making websynergy to work with mysql instead of the default hsql database

Pre-requisite :

1. Install WebSynergy

2. Install mysql running on port 3306. Username : root and password :<password>. Create a database "lportal" in it. From the sql command line client, use the command "create database lportal; "

 


 

  Accessing websynergy portal :

1. cd to glassfish-synergy/glassfish/bin and run asadmin start-domain

2. Access http://localhost:8585 and login with username: paul@example.com  and password: paul to check whether websynergy is up and running.

 


 

 Installing the admin console for the GlassFish V3 :

1. Access http://localhost:8585/admin , Download and install the adminconsole. Login as anonymous. Please go through this blog for more information on installing admin console for Glassfish V3

 


 

 Changing the existing jdbc connection pool so that it points to mysql :

1. Follow the following screencast to change the existing jdbc hsql connection pool to point to mysql

2. Restart the domain using "asadmin stop-domain" and "asadmin start-domain" commands

2. Login to websynergy http://localhost:8585. Now it uses mysql to store the user data.

 


 

 Also Check Out :

GlassFish Version 3 Community Efforts

 


 

 

Comments:

This was really very very helpful.
Thanks Siddesh Kamath.

Regards
Ayaz

Posted by Ayaz Pasha on May 28, 2008 at 04:07 AM IST #

PS: you have to execute this statement after creating database 'lportal'

"create user lportal"

See this wiki page for more detailed instruction
http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Building+and+Installing+Liferay+Source+Code+on+Glassfish+v2+and+MySQL;jsessionid=ACFF84A19604342633654070D20F4E0A

Posted by Rajesh on September 26, 2008 at 10:40 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

siddeshk123

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today