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 31, 2015 · 10 revisions

Zanata has been thoroughly tested against MySQL 5.5 and the Zanata team therefore recommends that you install and use this version with 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 it's UTF8. 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