This repository has been archived by the owner on Nov 9, 2017. It is now read-only.

Database Setup

Jump to bottom

Alex Eng edited this page Mar 25, 2015 · 10 revisions

How to configure MySQL database for Zanata

Install MySQL

Install MySQL client - yum install mysql
Install MySQL server - yum install mysql-server
Run mysql_secure_installation for initial setup

JDBC Driver

You will need to install the MySql JDBC driver, Connector/J into JBoss AS.
Download it from http://www.mysql.com/products/connector/j/
Then, untar/unzip it and extract the jar file.
Copy the jar file into $JBOSS_HOME/server/default/lib. Or
Download through Maven. Jar file will be in ~/.m2/repository/mysql/mysql-connector-java/5.1.9/mysql-connector-java-5.1.9.jar Or
run yum install mysql-connector-java.
create shortcut sudo ln -sf /usr/share/java/mysql-connector-java.jar $DEPLOYMENTS_DIR/mysql-connector-java.jar

Setup for Zanata

Create a database in MySQL, named zanata, make sure you enable utf8 support when creating the database: CREATE DATABASE zanata /*!40100 DEFAULT CHARACTER SET utf8 */;
Start the MySQL database by running /etc/init.d/mysqld start from the command line
To package Zanata build with MySQL database, use maven profile mysql during build. mvn -Pmysql clean install

Setup for Exploded WAR deployment

For deployment of an exploded war, MySql username and password should be updated in $USER_HOME/.m2/settings.xml as described in JBoss Setup