ubuntu+xplanner-plus

Debian Lenny

This installation was tested on Debian Lenny with Tomcat using the internal http-server and MYSQL. HSQLDB and Jetty were not tested yet.

install packages

regard that the installation does not work if you install sun-java after the tomcat packages. There seems to be this[1] issue.

java已经不支持apt-get下载了，请前去java网站下载，笔者使用的版本是jre-6u45-linux-x64.bin

 sudo apt-get install xinit gdm ubuntu-desktop mysql-server tomcat6 tomcat6-admin
 chmod +x ~/Downloads/jre-6u45-linux-x64.bin
 ~/Downloads/jre-6u45-linux-x64.bin

configure mysql

mysql -u root -p 
 create database xplanner character set utf8;
 grant all privileges on xplanner.* to xplanner@localhost identified by 'xp';

configure Tomcat

Edit /etc/tomcat6/tomcat-users.xml and add the role manager and a new user with that role. Your tomcat-users.xml should look similar to this now:

add user/role

 <?xml version='1.0' encoding='utf-8'?>
 <tomcat-users>
 <role rolename="tomcat"/>
 <role rolename="manager"/>
 <role rolename="manager-gui"/>
 <user username="tomcat" password="tomcat" roles="tomcat,manager,manager-gui"/>
 <user username="mangr" password="mangr" roles="manager,manager-gui"/>
 </tomcat-users>

configure policy

Edit file /etc/tomcat6/policy.d/04webapps.policy and add following permissions

permission javax.security.auth.AuthPermission "modifyPrincipals";
 permission java.net.SocketPermission "127.0.0.1:3306","connect, resolve";
 permission java.net.SocketPermission "localhost:9090","connect,resolve";
 permission java.lang.RuntimePermission "getProtectionDomain";
 permission java.lang.RuntimePermission "shutdownHooks";
 permission java.lang.RuntimePermission "accessClassInPackage.org.apache.jasper.el";
 permission java.lang.RuntimePermission "accessClassInPackage.org.apache.coyote";
 permission java.lang.RuntimePermission "accessClassInPackage.javax.el";
 permission java.lang.reflect.ReflectPermission "suppressAccessChecks";
 permission java.lang.RuntimePermission "accessDeclaredMembers";
 permission java.io.FilePermission "/var/lib/tomcat6/webapps/xplanner-plus/xplanner-plus-activity.log", "read,write";
 permission java.io.FilePermission "*","read";
 permission java.io.FilePermission "/usr/share/tomcat6/common/-","read";
 permission java.io.FilePermission "/usr/share/tomcat6/bin/bootstrap.jar", "read";
 permission java.io.FilePermission "/usr/share/java/commons-daemon.jar", "read";
 permission java.io.FilePermission "/var/lib/tomcat6/webapps/xplanner-plus/WEB-INF/classes/logging.properties","read";
 permission java.util.PropertyPermission "*","read,write";
 permission java.net.SocketPermission "jakarta.apache.org:80","connect,resolve";

install xplanner

Open your tomcat manager. The address should look similar to this http://yourserver:8180/manager/html Under "WAR file to deploy" select the Xplanner+ file you downloaded first and press upload. Alternatively you can manually put the war-file into /var/lib/tomcat6/webapps, it will be automatically be deployed.

configuration

XPlanner+ works out of the box if you use the default configuration. The default configuration can be found in:

/var/lib/tomcat6/webapps/xplanner-plus/WEB-INF/classes/xplanner-custom.properties

Default means to use HSQLDB, if you are using MYSQL or use other user/passwords you need to edit this file.

uncomment properties for MYSQL, and you should have the following;

 ## XPlanner hibernate configuration
 hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
 hibernate.connection.driver_class=com.mysql.jdbc.Driver
 hibernate.connection.dbname=xplanner
 hibernate.connection.url=jdbc:mysql://localhost/xplanner?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
 hibernate.connection.username=xplanner
 hibernate.connection.password=xp
 hibernate.show_sql=false
 xplanner.migration.databasetype=mysql

and comment properties for HSQLDB;

# Hibernate HSQLDB Configuration - embedded persistent HSQLDB
#hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
#hibernate.connection.url=jdbc:hsqldb:file:hsqldb/xplanner
#hibernate.connection.driver_class=org.hsqldb.jdbcDriver
#hibernate.connection.username=sa
#hibernate.connection.password=
#  TODO(PATCH) Find a way not to repeat these migrations for all databases but work on a global database mode that select Dialect, migration database type, patch path...
#xplanner.migration.databasetype=hsqldb
#xplanner.migration.patchpath=patches/hsqldb:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install

In this example there is no email-configuration and no security configuration!

login

the login-link should be something like http://localhost:8080/xplanner-plus log in with sysadmin/admin

problems with the installation

Errors can be found in /var/log/syslog or catalina.YYYY-MM-DD.log