Apelon DTS 3.5 Installation
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
to make all the DTS scripts in the bin directory executable
sudo sh makeScriptsExecutable.sh
- It's convenient to change to the apelon-dts-3.5-linux/bin directory and run
- 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]
and restart mysql afterwards
lower_case_table_names=1 default-storage-engine=InnoDB max_allowed_packet=100M character-set-server=utf8 collation-server=utf8_general_ci
- 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
./kbcreate.sh
- If MySQL is not yet installed:
- Now run the dts server (from within apelon-dts-3.5-linux/bin)
sudo ./dts.sh start
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.