How can I configure the MySQL database?

[spirit]

Hello,
OSEC is a very good project as open social container. There is "Using
a Different Database" section but I am not clear what are the steps to
follow. Could you please tell me.

Thanks

[mfra...@mitre.org]

1) Follow the instructions on the GettingStarted wiki page

2) Stop the tomcat container and navigate to $TOMCAT_HOME/webapps/
portal/

3) Add the mysql jdbc drivers to WEB-INF/lib

4) Replace the bean in WEB-INF/dataSource.xml with the following:

<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-
method="close">
<property name="driverClassName"
value="com.mysql.jdbc.Driver" />
</bean>

5) Change line 55 of WEB-INF/applicationContext.xml to read:


p:databasePlatform="org.eclipse.persistence.platform.database.MySQLPlatform"

Hope this helps.

-Matt