setup on Ubuntu with Tomcat 5.5 and postgres SQL (or Mysql)
sudo aptitude update
sudo aptitude upgrade
sudo reboot
########## TOMCAT SETUP ######################
apt-get install tomcat5.5 libtomcat5.5-java libapache2-mod-jk tomcat5.5-admin tomcat5.5-webapps
ildiscepolo.wordpress.com/2007/08/20/installare-tomcat-55-dai-repository-di-ubuntu-correggendo-i-bug/
1) Installa:
8.04) sudo aptitude install sun-java6-jdk tomcat5.5 libaxis-java libwsdl4j-java libcommons-discovery-java
9.10) sudo aptitude install sun-java6-jdk tomcat6 libaxis-java libwsdl4j-java libcommons-discovery-java libtomcat6-java libapache2-mod-jk tomcat6-admin tomcat6-examples vim
2) Setta la JAVA_HOME di default su tomcat:
sudo gedit /etc/default/tomcat5.5
Scommenta la linea:
JAVA_HOME=/usr/lib/jvm/java-6-sun
JAVA_OPTS="-Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl \
-Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl \
-Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl \
-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl"
Prova a lanciare il servizio con:
sudo /etc/init.d/tomcat5.5 start
E ad andare all’indirizzo:
8.04)
localhost:8180
9.10)
localhost:8080
my.opera.com/subjam/blog/install-tomcat-5-5-in-debian-and-ubuntu
Configuration for using Tomcat Manager (http://localhost:8180/manager/html) and Tomcat Administration (http://localhost:8180/admin).
Edit /usr/share/tomcat5.5/conf/tomcat-users.xml and include the following:
8.04) vim /usr/share/tomcat5.5/conf/tomcat-users.xml
9.10) vim /var/lib/tomcat6/conf/tomcat-users.xml
<user username="fabio" password="fabio" fullName="fabio" roles="admin,manager"/>
8.04)
vim /etc/tomcat5.5/policy.d/05mondrian.policy
grant codeBase "file:${catalina.home}/webapps/mondrian/-" {
permission java.security.AllPermission;
};
9.10)
vim /etc/tomcat6/policy.d/05mondrian.policy
grant codeBase "file:/var/lib/tomcat6/webapps/mondrian/-" {
permission java.security.AllPermission;
};
sudo /etc/init.d/tomcat5.5 restart
########## TOMCAT SETUP ######################
########## MYSQL SETUP ######################
sudo aptitude install libmysql-java
i A mysql-client-5.0 mysql-common mysql-server-5.
dpkg -L libmysql-java
/.
/usr
/usr/share
/usr/share/java
/usr/share/java/mysql-connector-java-5.1.5.jar
/usr/share/doc
/usr/share/doc/libmysql-java
/usr/share/doc/libmysql-java/changelog.gz
/usr/share/doc/libmysql-java/README.Debian
/usr/share/doc/libmysql-java/copyright
/usr/share/doc/libmysql-java/changelog.Debian.gz
/usr/share/doc/libmysql-java/EXCEPTIONS-CONNECTOR-J.gz
/usr/share/java/mysql-connector-java.jar
/usr/share/java/mysql-5.1.5.jar
/usr/share/java/mysql.jar
root@server804:/var/log/tomcat5.5#
mysqladmin create foodmart
mysql
mysql> grant all privileges on *.* to 'foodmart'@'localhost' identified by 'foodmart';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
########## MYSQL SETUP ######################
########## POSTGRES SETUP ######################
web page: https://help.ubuntu.com/community/PostgreSQL
Installo postgres:
8.04) apt-get install postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
9.10) apt-get install postgresql-8.4 postgresql-client-8.4 postgresql-client-common postgresql-common
Setto la password per postgress:
sudo -u postgres psql postgres
\password postgres
postgres
\q
Creo db foodmart:
sudo -u postgres createdb foodmart
www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html
8.04)
sudo -
vim /etc/postgresql/8.3/main/pg_hba.conf
host all all 192.168.1.0 255.255.255.0 trust
vim /etc/postgresql/8.3/main/postgresql.conf
listen_addresses='*'
9.10)
sudo -
vim /etc/postgresql/8.4/main/pg_hba.conf
host all all 192.168.1.0 255.255.255.0 trust
vim /etc/postgresql/8.4/main/postgresql.conf
listen_addresses='*'
########## POSTGRES SETUP ######################
apt-get install unzip
########## MONDRIAN SETUP ######################
cd /opt/
mv /home/fabio/mondrian-3.1.5.13307.zip .
unzip mondrian-3.1.5.13307.zip
ln -sf /opt/mondrian-3.1.5.13307 /mondrian
cd /opt/
8.04) wget -vc jdbc.postgresql.org/download/postgresql-8.3-605.jdbc3.jar
9.10) wget -vc jdbc.postgresql.org/download/postgresql-8.4-701.jdbc4.jar
wget -vc downloads.sourceforge.net/project/eigenbase/eigenbase-resgen/eigenbase-resgen-1.3/eigenbase-resgen-1.3.0.11875.zip
wget -vc downloads.sourceforge.net/project/eigenbase/eigenbase-commons/eigenbase-commons-1.0/eigenbase-properties-1.0.zip
aptitude install libcommons-logging-java liblog4j1.2-java
unzip eigenbase-properties-1.0.zip
unzip eigenbase-resgen-1.3.0.11875.zip
unzip eigenbase-xom-1.3.0.11999.jar.zip
cp eigenbase-properties-1.0/lib/eigenbase-properties.jar /mondrian/lib/
cp resgen/lib/* /mondrian/lib/
cp postgresql-8.3-605.jdbc3.jar /mondrian/lib/
cd /mondrian/
aptitude search log4
dpkg -L liblog4j1.2-java|grep jar
/usr/share/java/log4j-1.2.15.jar
/usr/share/java/log4j-1.2.jar
dpkg -L libcommons-logging-java|grep logging.jar
/usr/share/java/commons-logging.jar
ln -sf /usr/share/java/log4j-1.2.jar /mondrian/lib/log4j.jar
ln -sf /usr/share/java/commons-logging.jar /mondrian/lib/commons-logging.jar
ls -al /mondrian/lib/
total 24708
drwxr-xr-x 2 root root 4096 2010-02-22 23:34 .
drwxr-xr-x 5 root root 4096 2010-02-22 21:25 ..
-rw-r--r-- 1 root root 8042 2010-01-12 15:45 aggregates.dtd
lrwxrwxrwx 1 root root 35 2010-02-22 21:32 commons-logging.jar -> /usr/share/java/commons-logging.jar
-rw-r--r-- 1 root root 1070 2010-01-12 15:45 datasourcesconfig.dtd
-rw-r--r-- 1 root root 13655 2010-02-22 20:21 eigenbase-properties.jar
-rw-r--r-- 1 root root 60559 2010-02-22 20:22 eigenbase-resgen.jar
-rw-r--r-- 1 root root 95276 2010-02-22 20:21 eigenbase-xom-1.3.0.11999.jar
-rw-r--r-- 1 root root 95028 2010-02-22 20:22 eigenbase-xom.jar
lrwxrwxrwx 1 root root 32 2010-02-22 21:32 log4j.jar -> /usr/share/java/log4j-1.2.15.jar
-rw-r--r-- 1 root root 14790 2010-01-12 15:45 mondrian.dtd
-rw-r--r-- 1 root root 2710028 2010-01-12 15:46 mondrian.jar
-rw-r--r-- 1 root root 2835759 2010-01-12 15:47 mondrian-jdk14.jar
-rw-r--r-- 1 root root 17308098 2010-01-12 15:46 mondrian.war
-rw-r--r-- 1 root root 435932 2010-01-12 15:47 olap4j-jdk14.jar
-rw-r--r-- 1 root root 448014 2010-02-22 20:22 postgresql-8.3-605.jdbc3.jar
-rw-r--r-- 1 root root 475468 2009-07-01 07:39 postgresql-8.3-605.jdbc4.jar
-rw-r--r-- 1 root root 510170 2009-07-01 07:39 postgresql-8.4-701.jdbc4.jar
-rw-r--r-- 1 root root 181671 2009-01-14 19:19 retroweaver-rt.jar
#postgres version
8.04)
java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/mondrian/lib/postgresql-8.3-605.jdbc4.jar" \
mondrian.test.loader.MondrianFoodMartLoader \
-verbose -tables -data -indexes \
-jdbcDrivers=org.postgresql.Driver \
-outputJdbcURL="jdbc:postgresql://localhost/foodmart" \
-outputJdbcUser="postgres" \
-outputJdbcPassword="postgres" \
-inputFile=/mondrian/demo/FoodMartCreateData.sql
9.10)
java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/mondrian/lib/postgresql-8.4-701.jdbc4.jar" \
mondrian.test.loader.MondrianFoodMartLoader \
-verbose -tables -data -indexes \
-jdbcDrivers=org.postgresql.Driver \
-outputJdbcURL="jdbc:postgresql://localhost/foodmart" \
-outputJdbcUser="postgres" \
-outputJdbcPassword="postgres" \
-inputFile=/mondrian/demo/FoodMartCreateData.sql
#mysql version
java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/usr/share/java/mysql-connector-java.jar" \
mondrian.test.loader.MondrianFoodMartLoader \
-verbose -tables -data -indexes \
-jdbcDrivers=com.mysql.jdbc.Driver \
-inputFile=/mondrian/demo/FoodMartCreateData.sql \
-outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"
8.04)
cp /mondrian/lib/mondrian.war /var/lib/tomcat5.5/webapps/
cp /mondrian/lib/postgresql-8.3-605.jdbc4.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib
/etc/init.d/tomcat5.5 restart
localhost/manager
9.10)
cp /mondrian/lib/mondrian.war /var/lib/tomcat6/webapps/
cp /mondrian/lib/postgresql-8.4-701.jdbc4.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib
/etc/init.d/tomcat6 restart
localhost/manager
8.04)
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/mondrian.properties
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/mondrian.properties INIZIO ################
# Allow the use of aggregates
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.native.topcount.enable=true
mondrian.native.filter.enable=true
# mondrian.properties
mondrian.result.limit=50000
# For XML/A JSPs
mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver;Catalog=/WEB-INF/queries/FoodMart.xml;
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/mondrian.properties FINE################
cp /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/mondrian.properties /var/lib/tomcat5.5/webapps/mondrian/mondrian.properties
9.10)
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/mondrian.properties
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/mondrian.properties INIZIO ################
# Allow the use of aggregates
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.native.topcount.enable=true
mondrian.native.filter.enable=true
# mondrian.properties
mondrian.result.limit=50000
# For XML/A JSPs
mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver;Catalog=/WEB-INF/queries/FoodMart.xml;
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/mondrian.properties FINE################
cp /var/lib/tomcat6/webapps/mondrian/WEB-INF/mondrian.properties /var/lib/tomcat6/webapps/mondrian/mondrian.properties
8.04)
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/web.xml
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/web.xml INIZIO ################
sostituire le 2:
<context-param>
<param-name>connectString</param-name>
<param-value>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver;Catalog=/WEB-INF/queries/FoodMart.xml;</param-value>
</context-param>
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/web.xml FINE ################
9.10)
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/web.xml
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/web.xml INIZIO ################
sostituire le 2:
<context-param>
<param-name>connectString</param-name>
<param-value>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver;Catalog=/WEB-INF/queries/FoodMart.xml;</param-value>
</context-param>
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/web.xml FINE ################
8.04)
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/datasources.xml INIZIO ################
<?xml version="1.0"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName>
<DataSourceDescription>Mondrian FoodMart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8180>/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver</DataSourceInfo>
<!-- DataSourceInfo>Provider=mondrian; Jdbc=jdbc:postgresql://localhost/foodmart; JdbcUser=postgres; JdbcPassword=postgres; JdbcDrivers=org.postgresql.Driver; Catalog=/WEB-INF/queries/FoodMa
rt.xml</DataSourceInfo -->
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver</DataSourceInfo>
<Definition>/WEB-INF/queries/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
######### /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/datasources.xml FINE ################
9.10)
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/datasources.xml
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/datasources.xml INIZIO ################
<?xml version="1.0"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName>
<DataSourceDescription>Mondrian FoodMart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080>/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver</DataSourceInfo>
<!-- DataSourceInfo>Provider=mondrian; Jdbc=jdbc:postgresql://localhost/foodmart; JdbcUser=postgres; JdbcPassword=postgres; JdbcDrivers=org.postgresql.Driver; Catalog=/WEB-INF/queries/FoodMa
rt.xml</DataSourceInfo -->
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:postgresql://localhost/foodmart;JdbcUser=postgres;JdbcPassword=postgres;JdbcDrivers=org.postgresql.Driver</DataSourceInfo>
<Definition>/WEB-INF/queries/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
######### /var/lib/tomcat6/webapps/mondrian/WEB-INF/datasources.xml FINE ################
8.04)
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/mondrian.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/fourhier.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/colors.js
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/arrows.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/testrole.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
9.10)
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/mondrian.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/fourhier.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/colors.js
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/arrows.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/testrole.jsp
<jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost/foodmart?user=postgres&password=postgres" catalogUri="/WEB-INF/queries/FoodMart.xml">
8.04)
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/xmla.jsp
<%@ page session="true" pageEncoding="UTF-8" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<!--
* Change uri attribute to your deployment of this webapp.
* The dataSource attribute is necessary for Mondrian's XMLA.
-->
<jp:xmlaQuery id="query01"
uri="http://localhost:8180/mondrian/xmla"
dataSource="Provider=Mondrian;DataSource=MondrianFoodMart;"
catalog="FoodMart">
select
{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,
{([Promotion Media].[All Media], [Product].[All Products])} ON rows
from Sales
where ([Time].[1997])
</jp:xmlaQuery>
<c:set var="title01" scope="session">Accessing Mondrian By XMLA</c:set>
9.10) N.N.
8.04)
vim /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/queries/mondrianXMLA.jsp
<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<jp:xmlaQuery id="query01"
uri="http://localhost:8180/mondrian/xmla"
dataSource="Provider=Mondrian;DataSource=MondrianFoodMart;"
catalog="FoodMart">
select
{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,
{([Promotion Media].[All Media], [Product].[All Products])} ON rows
from Sales
where ([Time].[1997])
</jp:xmlaQuery>
<c:set var="title01" scope="session">Mondrian OLAP via XML/A</c:set>
9.10)
vim /var/lib/tomcat6/webapps/mondrian/WEB-INF/queries/mondrianXMLA.jsp
<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<jp:xmlaQuery id="query01"
uri="http://localhost:8080/mondrian/xmla"
dataSource="Provider=Mondrian;DataSource=MondrianFoodMart;"
catalog="FoodMart">
select
{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,
{([Promotion Media].[All Media], [Product].[All Products])} ON rows
from Sales
where ([Time].[1997])
</jp:xmlaQuery>
<c:set var="title01" scope="session">Mondrian OLAP via XML/A</c:set>
8.04)
mkdir -p /var/lib/tomcat5.5/common/endorsed
cp /mondrian/lib/postgresql-8.3-605.jdbc4.jar /var/lib/tomcat5.5/common/endorsed/
cp /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/xalan.jar /var/lib/tomcat5.5/common/endorsed/
cp /usr/share/java/axis.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/axis.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/jaxrpc.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/wsdl4j.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/commons-discovery.jar /var/lib/tomcat5.5/webapps/mondrian/WEB-INF/lib/
9.10)
mkdir -p /var/lib/tomcat6/common/endorsed
cp /mondrian/lib/postgresql-8.4-701.jdbc4.jar /var/lib/tomcat6/common/endorsed/
cp /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/xalan.jar /var/lib/tomcat6/common/endorsed/
cp /usr/share/java/axis.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/axis.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/jaxrpc.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/wsdl4j.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/
cp /usr/share/java/commons-discovery.jar /var/lib/tomcat6/webapps/mondrian/WEB-INF/lib/
########## MONDRIAN SETUP ######################
for mysql subsitute
jdbc:postgresql://localhost
with
jdbc:mysql://localhost
