Note: The following steps were performed in an Ubuntu machine.
Download apelon-docker project
git clone https://bitbucket.org/opencds/apelon-docker.git
Download apelon dts
cd apelon-docker wget http://sourceforge.net/projects/apelon-dts/files/dts-linux/3.5.2/apelon-dts-3.5.2.203-linux-mysql.tar.gz
Transfer Apelon content from other databases
If you need to transfer content from another database you can place your dts_dump_file.sql file in apelon-docker folder and uncomment the lines that refer to dts_dump_file.sql on Dockerfile and config_mysql.sh. This blog note describes how to migrate Apelon content from MS-SQL to MySQL
... # Set up MySQL #ADD dts_dump_file.sql /dts_dump_file.sql ADD config_mysql.sh /config_mysql.sh RUN chmod 755 /config_mysql.sh RUN /config_mysql.sh; rm config_mysql.sh #RUN rm dts_dump_file.sql ADD my.cnf /etc/my.cnf
... __start_mysql() { echo "Running the start_mysql function." mysqladmin -u root password mysqlPassword mysql -uroot -pmysqlPassword -e "CREATE SCHEMA IF NOT EXISTS dts DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;" mysql -uroot -pmysqlPassword -e "CREATE USER 'dts'@'localhost' IDENTIFIED BY 'dts';" mysql -uroot -pmysqlPassword -e "GRANT ALL PRIVILEGES ON dts.* TO 'dts'@'localhost' WITH GRANT OPTION;" mysql -uroot -pmysqlPassword -e "FLUSH PRIVILEGES;" #mysql -uroot -pmysqlPassword dts < /dts_dump_file.sql killall mysqld sleep 10 }
Build and deploy container
sudo docker build -t="opencds/apelon:centos6" .
sudo docker run -d --name apelon opencds/apelon:centos6
Access ApelonDTS on the Browser
Apelon browser will be available on x.x.x.x:8081/dtstreebrowser
starting server on x.x.x.x:6666
Find out the ipaddress of the container:
sudo docker inspect apelon | grep IPAddress
Secure socket:
username:opencds.guest
password:welcome2opencds
host:actual ipaddress
port: 6666
References
ApelonDTS
http://apelon-dts.sourceforge.net/
Migrate MS-SQL apelon tontent to MySQL
http://salrod.blogspot.co.uk/2015/02/migrate-ms-sql-apelon-content-to-mysql.html