Download Mint

Get the mint release from github and make sure that you have installed JAVA v1.6 and Tomcat 6.

Database Setup



Just follow the one click installer PostgreSQL 8.4 for windows. After finishing, you should have a running PostgreSQL 8.4.

Create a user

Start the pgadmin tool that came with the installation. It should show the Server which was just installed. Double click on it to connect as the postgres user. Use the password you were asked to create in the installation process.

Right click on "Login Roles" and make "New Login Role...".

Name the user mint and give him a password.

Check "Can create database objects" in "Role privileges" tab.

Go to the Variables tab and select the search_path Variable name. Enter "mint, public" as the Variable Value. Click OK to store the new User/Role.

Disconnect from the server.

Create a connection with the new mint user.

Click on the power plug and in the window "New Server Registration", and enter the following

Create a database

Click on the mint connection after that a tree appears. Right click on "Databases" and select "New Database..." and set the following. (NOTE: Select the collation and the character type installed in your system.)

Select the mint database and click the SQL toolbar button. Select File -> Open, locate the createSchema.sql (.\Mint\src\main\webapp\WEB-INF\src) in your mint installation and load it. If you feel like it, edit the default organization and the admin password in the sql file. (You can do it later in the tool as well.) Execute the file with the green triangle "Execute Query" button in the toolbar.

Repeat the same procedure for the file upgrade_sql_thesauri_1_3.sql.

Your mint database is ready.

Unix Based Operating System

Make sure that you have installed JAVA v1.6, Tomcat 6 and PostgresSQL 8.4. (NOTE: If you don't feel familiar with the terminal you can follow the windows - pgadmin tool instructions.)

Create a database

sudo -u postgres createdb -E UTF8 mint


sudo -u postgres psql mint

create a user for the application

create user mint password 'mint' login;

set the user's search path

alter role mint set search_path to mint,public;

and grant database to the user

grant all on database mint to mint;

Logout with


Locate the createSchema.sql in your mint installation (/Mint/src/main/webapp/WEB-INF/src)

Login again as mint

psql -h localhost -U mint mint

and read in the schema. Its helpful to be in the directory with the createSchema.sql

\i createSchema.sql

That should setup the schema! Run the update

\i upgrade_sql_thesauri_1_3.sql

After that, edit the postgresql.conf file - which is normally kept in the data directory (initdb installs a default copy there) - by setting

#constraint_exclusion = off
constraint_exclusion = on

to enable quick xml_node table searches for uploads.

Deploy Web App

Make sure that you have downloaded Maven.

Go to the location where you have downloaded mint (./mint/) and execute.

mvn package

Copy the produced mint-1.0-SNAPSHOT.war file from ./mint/target/ to TOMCAT_HOME/webapps/.

You should be able to access it, by default, at path /mint-1.0-SNAPSHOT. To verify that the deployment succeeded, start tomcat and point your browser at


Your browser should show the Mint login page shown below. (NOTE: Your login and password are set in the createSchema.sql )

Congratulations you have just installed MINT. You are now ready to use it

NewRole.png (79.8 KB) Nikos Simou, 02/13/2012 11:26 PM

PgAdmin.png (69.9 KB) Nikos Simou, 02/13/2012 11:26 PM

roleName.png (27.1 KB) Nikos Simou, 02/13/2012 11:26 PM

rolePrivileges.png (25.9 KB) Nikos Simou, 02/13/2012 11:26 PM

createDBMint.png (84.7 KB) Nikos Simou, 02/13/2012 11:26 PM

newConnection.png (23.9 KB) Nikos Simou, 02/13/2012 11:26 PM

roleVariables.png (26.2 KB) Nikos Simou, 02/13/2012 11:26 PM

mintLogin.png (316 KB) Nikos Simou, 02/20/2012 11:10 AM

newDatabase.png (113 KB) Nikos Simou, 02/20/2012 11:10 AM