Apelon DTS 3.5 Installation
The following is a quick guide to installing Apelon DTS on Ubuntu from the command line for MySQL.
- Download Apelon DTS and extract the archive: e.g.
cd /opt/
sudo mkdir apelon-dts-3.5-linux
cd apelon-dts-3.5-linux
sudo tar -zxf apelon-dts-3.5.2.203-linux-mysql.tar.gz
|
- It's convenient to change to the apelon-dts-3.5-linux/bin directory and run
sudo sh makeScriptsExecutable.sh
|
to make all the DTS scripts in the bin directory executable
- Setup the database
- If MySQL is not yet installed:
sudo apt-get install mysql-server
|
- Create a user in MySQL for DTS, either through a program such as MySQL Workbench, or using the commands
mysql> create user 'dts'@'localhost' identified by 'password';
mysql> grant all privileges on *.* to 'dts'@'localhost' with grant option;
|
- Edit the MySQL config file /etc/mysql/my.conf and add the following lines under the section titled [mysqld]
lower_case_table_names=1
default-storage-engine=InnoDB
max_allowed_packet=100M
character-set-server=utf8
collation-server=utf8_general_ci
|
and restart mysql afterwards
- Create a new database for DTS in MySQL:
mysql> create database dts;
|
- The next step is to create the DTS schema using the schema creation tool:
- in apelon-dts-3.5-linux/bin/kb, edit the files named source-connection.xml and target-connection.xml, and ensure that the connection properties are setup for mysql
- run the utility located in the folder apelon-dts-3.5-linux/bin/kb/create
- Now run the dts server (from within apelon-dts-3.5-linux/bin)
And that's it. DTS should now be up and running. If you get stuck, you can also consult the more comprehensive documentation available at http://apelon-dts.sourceforge.net/documents.html.
See also Jembi TS Web Browser Installation
Backups
This script can be used to create a dump of the MySQL database in use by DTS.
To restore MySQL using a backup, simply execute the following command:
mysql dts -u dts --password=password < backup.sql
|
where backup.sql is the unzipped backup file.