Installing tinyPM on Tomcat 6.0.x

These instructions will lead you through the process of installing tinyPM from WAR file that can be downloaded from http://www.tinypm.com/download in Tomcat 6.0.x as a web application. For Tomcat 6.0 use tinypm-2.x-tomcat6.0.zip distribution.

This instruction assumes that you have Tomcat and MySql already installed on your server. If you are installing on CentOS or Ubuntu you can find detailed instructions contributed by our users: Ubuntu http://support.tinypm.com/forum/posts.jsf?forumId=1&topicId=48 CentOS http://blog.ccielogs.com/2010/06/29/how-to-install-tinypm-on-centos/

Requirements

To install tinyPM you need to have the following software installed on your server:

1. Java Runtime Environment (JRE) 6.0
http://java.sun.com/javase/downloads/index.jsp

2. The latest version of Apache Tomcat 6.0.x
http://tomcat.apache.org/download-60.cgi

3. The latest version of MySQL 5.0.x
http://dev.mysql.com/downloads/mysql/5.0.html

4. MySQL Connector/J 5.1.x (the JDBC driver for MySQL Server) which you need to put (or symlink) in %CATALINA_HOME%/lib directory along with other tinyPM dependencies
http://dev.mysql.com/downloads/connector/j

tinyPM Memory Settings tinyPM requires at least 256MB of RAM to be set for the JVM Heap Size. You can do it by adding following params to your java options: -server -Xms256m -Xmx512m -XX:MaxPermSize=256m -XX:+UseParallelGC You can set the second option (-Xmx) to the highest amount available in your system.

tinyPM Database Installation

1. Create a new database for tinyPM in your MySQL:

CREATE DATABASE tinypmdb CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';

2. Create a user with SELECT, UPDATE, INSERT, LOCK TABLES and DELETE rights:

GRANT SELECT, UPDATE, INSERT, LOCK TABLES, DELETE ON tinypmdb.* TO 'username'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

3. Run scripts creating tinyPM database schema and data (instructions provided here are for mysql console application):

\u tinypmdb
\. %PATH_TO_INSTALL_FOLDER%/sql/mysql/create_schema-2.x.sql
\. %PATH_TO_INSTALL_FOLDER%/sql/mysql/create_data-2.x.sql

Tomcat 6.0.x Dependencies

1. You need to put all jar files from 'dependency' directory and downloaded MySQL JDBC driver in (unless you have them already):

%CATALINA_HOME%/lib

tinyPM 2.x depends on the latest releases of JavaMail (1.4.2) and Java Activation Framework (1.1.1). It's recomended to update your Tomcat installation with the two JAR file from: dependencies/mail.jar dependencies/activation.jar Otherwise you may experience some problems in using mail notifications in tinyPM, especially with SMTP servers using self-signed certificates.

tinyPM Installation (as web application in Tomcat 6.0.x)

1. Stop your Tomcat server

We recommend not to use auto deployment features from Tomcat

2. Create your tinyPM directory in Tomcat webapps folder:

%CATALINA_HOME%/webapps/tinypm

3. Unzip tinypm.war to your %CATALINA_HOME%/webapps/tinypm directory.

4. Modify tinyPM database configuration file and set your username and password (and databse name if you've chosen to use different name than tinypmdb).
You can find this file in:

%CATALINA_HOME%/webapps/tinypm/WEB-INF/classes/hibernate.properties

5. Start your Tomcat server.

6. Point your browser to http://localhost:8080/tinypm and login as:

• user: admin
• password: admin

Congratulations! Your tinyPM is up and running!

tinyPM License and Support

To create new projects and users you will need to obtain a valid license at:

http://dev.tinypm.com/support

The license should be installed using tinyPM settings page after logging into the system as an administrator.

Mail Server Settings

Before creating first users remember to setup your mail server settings in tinyPM (settings page). This way your users will receive e-mail notifications with their account details.

Troubleshooting

By default tinyPM uses ERROR logging level to avoid flooding your log files. If you have problems with your tinyPM installation you can change logging level to a more verbose INFO level by editing Log4J settings in:

%CATALINA_HOME%/webapps/tinypm/WEB-INF/classes/log4j.properties

If this documentation doesn't solve your problem or has left you with any questions, please don't hesitate to contact us at support@tinypm.com