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

      ./kbcreate.sh
      

• 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.