Installation script for tinypm on Ubuntu 10.04 and 10.10

tinypm.sh

#! /bin/sh

TINYPMVERSION=2.2.3

# from /etc/init.d/tomcat6
NAME=tomcat6
# Directory where the Tomcat 6 binary distribution resides
CATALINA_HOME=/usr/share/$NAME
# Directory for per-instance configuration files and webapps
CATALINA_BASE=/var/lib/$NAME

#install system packages
apt-get -y install default-jre tomcat6 tomcat6-admin tomcat6-common mysql-server-5.1 mysql-client-5.1 libmysql-java openjdk-6-jdk


wget http://www.tinypm.com/downloads/tinypm-$TINYPMVERSION-tomcat6.0.zip
unzip tinypm-$TINYPMVERSION-tomcat6.0.zip

cat  > tinypmdb.sql <<EOF 
CREATE DATABASE tinypmdb CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';

GRANT SELECT, UPDATE, INSERT, DELETE ON tinypmdb.* TO 'username'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
\u tinypmdb
\. sql/mysql/create_schema-2.2.3.sql
\. sql/mysql/create_data-2.2.3.sql
EOF

# enter your mysql root password here
mysql -u root -p < tinypmdb.sql 

cp dependencies/* $CATALINA_HOME/lib/

mkdir $CATALINA_BASE/webapps/tinypm
unzip tinypm.war -d $CATALINA_BASE/webapps/tinypm/

cd /usr/share/tomcat6/lib
ln -s ../../java/mysql-connector-java.jar  mysql-connector-java.jar

# edit $CATALINA_HOME/webapps/tinypm/WEB-INF/classes/hibernate.properties and enter your mysql login and password
# then sudo /etc/init.d/tocat6 start
# point your browser to http://ocalhost:8080/tinypm/