Skip to content

Installation of jobsworth on Windows

janek42 edited this page Jul 22, 2022 · 18 revisions

MySQL

Download MySQL from MySQL web site. You can use Windows (x86, 64-bit), ZIP Archive for manual start/stop for testing. Extract zip archive in folder and create new data folder in same folder with bin.

Sample my.ini file

[mysqld]
basedir = ../
datadir = ../data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server = utf8
collation-server = utf8_unicode_ci
skip-character-set-client-handshake

Initialize MySQL

In command promt go to MySQL folder and run below commands.
cd bin
mysqld --defaults-file=../my.ini --initialize-insecure

Start MySQL

You can start MySQL in standalone mode with below command.
cd bin
mysqld.exe --defaults-file=../my.ini --standalone

Tomcat

Download Tomcat from Apache web site. You can use 64-bit Windows zip version.
Extract zip archive in folder.

Configuration

Edit conf\tomcat-users.xml configuration file. Add below line to tomcat-users element:
<role rolename="manager-gui"/>
<role rolename="admin-gui"/>
<user username="tomcat" password="s3cret" roles="manager-gui,admin-gui"/>
Edit webapps\manager\WEB-INF\web.xml configuration file. Set max-file-size and max-request-size to 82428800 for uploading war file.

Installing jobsworth

Start Tomcat from command line using startup.bat file in bin folder.
Open your browser and go to http://localhost:8080/manager/
Type user name and pass (admin/s3cret) for login.
Browse jobsworth's ROOT.war file from WAR file to deploy section and deploy.

jobsworth configuration

Edit conf\context.xml and remove existing configuration in Context element and add jobsworth configuration given in sample.
Change db settings.
storeroot and cache_path path must be setted. Also folders must be created.

Creating jobsworth database

Go to MySQL bin folder and use below command for opening MySQL command line tool.
mysql.exe -u root
Type below command for create database.
CREATE DATABASE jobsworth CHARACTER SET utf8 COLLATE utf8_unicode_ci;

First run

Shutdown Tomcat with using shutdown.bat file and start with again start.bat.
Open jobsworth in your browser http://localhost:8080/
Use "admin" as username and use "password" for password.