Public Repository

Last pushed: a year ago
Short Description
SysAid Server conatianer
Full Description

Suggested use of the SysAid Server Docker container:-

This SysAid Server Docker container has a default config ready to be used with the sysaid DB container but you can use the DB_setup command to point it at your own MySQL or MsSQL servers if you choose, other DB servers can be used but need to be set manually in the sysaid/conf/serverConf.xml file. It is suggested that use the docker volume option to store the data and config external to the Docker containers in order to make it simple to to upgrade in the future without worring about overwritting your data.

Preparation:-

Create directories in which the data & config will be stored and place in the conf dir your activation.xml License file. You can also place here the whole conf from an other SysAid system.

#mkdir -p /sysaid/data /sysaid/files/conf /sysaid/files/logs /sysaid/files/attachments /sysaid/backup/; chmod -R 777 /sysaid/*

#cp activation.xml sysaid/files/conf/

** Setup / Initialisation If using your own DB server:-

Make sure you have an empty DB for SysAid on your DB server and have DB login credentials setup for it as owner.

NOTE if the DB is an existing SysAid DB then DO NOT run the DB_init step (the second command) on it as it is already initalised

Setup DB config script

docker run -it --rm -v /sysaid/files:/sysaid-files sysaid/sysaid_14.4 DB_setup

Initialise the DB. Do NOT do this for existing the SysAid DBs

docker run -it --rm -v /sysaid/files:/sysaid-files sysaid/sysaid_14.4 DB_init sysaid changeit

Run the SysAid server and set it to auto restart

docker run -d --restart=always -p 80:8080 -v /sysaid/files:/sysaid-files --name sysaid_Server sysaid/sysaid_14.4 start

** Setup / Initialisation If using sysaid provided DB server container:-

If you already have a MySQL data files place them in the /sysaid/data directory but if this is the case DO NOT run the DB_init step (the second command) on it as the SysAid DB is already initalised.

Start DB server. Will create DB automatically /data empty and setup default_db and login admin:masterkey

docker run -d --restart=always -v /sysaid/data:/data --name db sysaid/maria_db

#Initialise the SysAid DB. Do NOT do this for existing SysAid DBs
docker run -it --rm --link db:db -v /sysaid/files:/sysaid-files sysaid/sysaid_14.4 DB_init sysaid changeit

Run the SysAid server and set it to auto restart

docker run -d --restart=always --link db:db -p 80:8080 -v /sysaid/files:/sysaid-files --name sysaid_Server sysaid/sysaid_14.4 start

COMPLETE:

You should now be able to connect you browser to this server at port 80 and login with sysaid:changeit. You can change the sysaid connection port by specifying a different port instead of 80 in the -p paramiter.

use docker help to see other usfull docker commands. key commands to read up on are 'docker ps -a', 'docker images', docker rm, docker rmi, docker stop

UPGRADE:

find latest release

docker search sysaid/sysaid

Pull down the latest release

docker pull sysaid/sysaid_<ver>

stop the SysAid server container

docker stop sysaid_Server

Backup SysAid dataBase (with mysqldump) and attachments (sysaid/attachments dir) & config (sysaid/conf , sysaid/CustomHTMLs & sysaid/*logo.png)

docker run -it --link db:db sysaid/maria_db mysqldump -h db -u admin -p masterkey default_db |gzip > /sysaid/backup/20date '+%y%m%d%H%M'.sql.gz
rsync -a -b --delete --backup-dir=/sysaid/backup/files/20date '+%y%m%d%H%m' sysaid/files/{conf,attachments,CustomHTMLs,logo.} /sysaid/backup

start new SysAid Server based on newly pulled SysAid Server image. Same as last time you ran the container above but with newer images name.

docker run -d --restart=always --link maria_db -p 80:8080 -v /sysaid/conf:/sysaid-webapp/WEB-INF/conf -v /sysaid/logs:/sysaid-webapp/WEB-INF/logs --name sysaidServer sysaid/sysaid<newVersion>

Docker Pull Command
Owner
sysaid

Comments (0)