Mint-Athena

Download Mint-Athena

Get the mint-athena release from github

Database Setup

Windows

Installation

Just follow the one click installer for windows. After finishing, you should have a running PostgreSQL 8.4. The system might work with version 9 and newer, but is not tested with it.

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 athena 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 "athena, public" as the Variable Value. Click OK to store the new User/Role.

Disconnect from the server.

Create a connection with the new athena user.

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

Create a database

Click on the athena connection after that a tree appears. Right click on "Databases" and select "New Database..." and set the following.

Select the athena database and click the SQL toolbar button. Select File -> Open, locate the createSchema.sql in your athena 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.

Your athena database is ready.

Unix Based Operating System

Create a database

sudo -u postgres createdb -E UTF8 athena

Login

sudo -u postgres psql athena

create a user for the application

create user athena password 'athena' login;

set the user's search path

alter role athena set search_path to athena,public;

and grant database to the user

grant all on database athena to athena;

Logout with

\q

Locate the createSchema.sql in your athena installation

Login again as athena

psql -h localhost -U athena athena

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

\i createSchema.sql

That should setup the schema!

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

Extract the downloaded files in TOMCAT_HOME/webapps/mint directory. After that, create directory (TOMCAT_HOME/webapps/mint/WEB-INF) /lib and add the required jar files.

Use ant to build the project

ant -Dappname=mint

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

http://localhost:8080/mint

Your browser should show the Mint-Athena login page shown below.

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

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

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

athenaLogin.png (48.2 KB) Nikos Simou, 02/13/2012 07:20 PM

createDB.png (63.7 KB) Nikos Simou, 02/13/2012 07:20 PM

mintlogin.png (64.5 KB) Nikos Simou, 02/13/2012 07:20 PM

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

roleNameAthena.png (41.3 KB) Nikos Simou, 02/13/2012 11:04 PM

newConnectionathena.png (34.1 KB) Nikos Simou, 02/13/2012 11:15 PM

newDatabaseAthena.png (35.7 KB) Nikos Simou, 02/13/2012 11:18 PM