Forums

Home » Liferay Portal » English » 2. Using Liferay » General

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Dileep P
MySQL in lIferay6.0.6 community edition
May 19, 2011 4:44 AM
Answer

Dileep P

Rank: New Member

Posts: 17

Join Date: May 5, 2011

Recent Posts

Hi all,

can anybody please guide me through the steps of mysql configuration in liferay 6.. I searched in liferay forums.. but am not able to find the database configuration in ROOT.xml. This is my xml file
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<Context path="" crossContext="true">

<!-- JAAS -->

<!--<Realm
className="org.apache.catalina.realm.JAASRealm"
appName="PortalRealm"
userClassNames="com.liferay.portal.kernel.security.jaas.PortalPrincipal"
roleClassNames="com.liferay.portal.kernel.security.jaas.PortalRole"
/>-->

<!--
Uncomment the following to disable persistent sessions across reboots.
-->

<!--<Manager pathname="" />-->

<!--
Uncomment the following to not use sessions. See the property
"session.disabled" in portal.properties.
-->

<!--<Manager className="com.liferay.support.tomcat.session.SessionLessManagerBase" />-->
</Context>



/****************************************************************************************************************

in some forums it was given that you have to uncomment mysql configuration and comment hsql configuration.. but how?


please help me..


Thanks in advance
Dhrutika Vyas
RE: MySQL in lIferay6.0.6 community edition
May 19, 2011 4:51 AM
Answer

Dhrutika Vyas

Rank: Expert

Posts: 438

Join Date: February 9, 2009

Recent Posts

Dileep P:
Hi all,

can anybody please guide me through the steps of mysql configuration in liferay 6.. I searched in liferay forums.. but am not able to find the database configuration in ROOT.xml. This is my xml file
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<Context path="" crossContext="true">

<!-- JAAS -->

<!--<Realm
className="org.apache.catalina.realm.JAASRealm"
appName="PortalRealm"
userClassNames="com.liferay.portal.kernel.security.jaas.PortalPrincipal"
roleClassNames="com.liferay.portal.kernel.security.jaas.PortalRole"
/>-->

<!--
Uncomment the following to disable persistent sessions across reboots.
-->

<!--<Manager pathname="" />-->

<!--
Uncomment the following to not use sessions. See the property
"session.disabled" in portal.properties.
-->

<!--<Manager className="com.liferay.support.tomcat.session.SessionLessManagerBase" />-->
</Context>



/****************************************************************************************************************

in some forums it was given that you have to uncomment mysql configuration and comment hsql configuration.. but how?


please help me..


Thanks in advance



Hi,

In liferay 6,to configure database you need to overwrite portal-ext.properties.
Below are the properties to connect to MySQL server.

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

For reference you can refer portal.properties.
Regards,
Dhrutika
Dileep P
RE: MySQL in lIferay6.0.6 community edition
May 19, 2011 5:10 AM
Answer

Dileep P

Rank: New Member

Posts: 17

Join Date: May 5, 2011

Recent Posts

HI Dhrutika,

Thank you very much for your quick reply.. but i am searching for portal-ext.properties. Where is it located? Which version of mysql i have to install?

Waiting for your reply

Thanks in advance

Dileep
venky r
RE: MySQL in lIferay6.0.6 community edition
May 19, 2011 5:11 AM
Answer

venky r

Rank: Junior Member

Posts: 52

Join Date: July 25, 2009

Recent Posts

Hi,

Create portal-ext.properties in liferay war web-inf/classes folder and keep below properities 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=
jdbc.default.password=

Restart your server. It will work..

Thanks
Hitoshi Ozawa
RE: MySQL in lIferay6.0.6 community edition
May 19, 2011 6:12 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Instead of searching the forum, you should always try searching Liferay Documentation first.

http://www.liferay.com/documentation/liferay-portal/6.0/administration/-/ai/installing-liferay-for-an-enterpri-4
Dileep P
RE: MySQL in lIferay6.0.6 community edition
May 19, 2011 7:03 AM
Answer

Dileep P

Rank: New Member

Posts: 17

Join Date: May 5, 2011

Recent Posts

HI venky racha,

Thank you very much.. it works for me..........

Dileep
venky r
RE: MySQL in lIferay6.0.6 community edition
May 20, 2011 12:33 AM
Answer

venky r

Rank: Junior Member

Posts: 52

Join Date: July 25, 2009

Recent Posts

Dileep P:
HI venky racha,

Thank you very much.. it works for me..........

Dileep


Welcome Dileep... emoticon enjoy