myblogspace sriram

1)Creating a JDBC Connection Pool and JNDI Resource
a)login http://localhost:4848
b)Configuration->JDBC->Connection Pool->New
c)Enter, Name:test/Liferay, ResourceType=javax.sql.Datasource
d)Navigate to additional properties and specify the following
User:lportal Password:abc123
Url:"jdbc:mysql://localhost:3306/lportal"
Port:3306
Note(lportal database and user lportal are already created in mysql,see step 2 to know how they are created)

e)Configuration->JDBC->Resources->New Here use the above created connection pool
f)Navigate to the coonection pool and click Ping to check if is succesfull

2)Mysql preconfiguration

a)Login as root: mysql -u root -p or mysql -u root
b)Create a database lportal:create database lportal;
c)Create user lportal :create user lportal@localhost identified by 'pass';
d)Provide Admin rights for the lportal user: grant all privileges on lportal.* to lportal@'localhost' identified by 'pass'
Note:When liferay starts up it automatically creates as necessary tables under lportal databases This can be seen using following commands after loggin in as lportal

a)use database lportal; b)select * from lportal