...
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
| Code Block |
|---|
| language | bash |
|---|
| title | Dockerfile lines that refer dts_dump_file.sql |
|---|
|
...
# 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 |
| Code Block |
|---|
| language | bash |
|---|
| title | config_mysql.sh that refer dts_dump_dile.sql |
|---|
|
...
__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
} |
...
| Code Block |
|---|
| language | bash |
|---|
| title | Build image |
|---|
|
sudo docker build -t="opencds/apelon:centos6" . |
| Code Block |
|---|
| language | bash |
|---|
| title | Create container |
|---|
|
sudo docker run -d --name apelon opencds/apelon:centos6 |
Apelon browser will be available on x.x.x.x:8081/dtstreebrowser
starting server on x.x.x.x:6666
Use the following access details:
Secure socket:
username:opencds.guest
password:welcome2opencds
host:actual ipaddress
port: 6666
References
ApelonDTS
http://apelon-dts.sourceforge.net/
...