Difference between revisions of "RBE10K/Libreplan/Installation"

From MediaWiki
Jump to: navigation, search
(Create the database)
m (Create the database)
 
Line 27: Line 27:
 
  CREATE USER libreplan WITH PASSWORD 'libreplan';
 
  CREATE USER libreplan WITH PASSWORD 'libreplan';
 
  GRANT ALL PRIVILEGES ON DATABASE libreplan TO libreplan;
 
  GRANT ALL PRIVILEGES ON DATABASE libreplan TO libreplan;
\q
+
\q
 
</code>
 
</code>
  

Latest revision as of 20:29, 18 May 2013

The installation instructions for Libreplan on Gentoo/Tomcat-7 are the following, based on the instructions found here: http://ask.libreplan.org/questions/564/install-on-gentoo-or-sabayon

Contents

[edit] Install dependencies

echo "x11-base/xorg-server xvfb" >> /etc/portage/package.use 
emerge -a virtual/jdk commons-dbcp commons-pool tomcat jdbc-postgresql postgresql-server cutycapt

[edit] Create Tomcat instance

/usr/share/tomcat-7/gentoo/tomcat-instance-manager.bash --create

Optionally add --suffix libreplan at the end of the previous statement to create an independent Tomcat-7 installation specific for use with Libreplan. In that case replace any following /var/lib/tomcat-7 with /var/lib/tomcat-7-libreplan.

[edit] Add necessary jars

ln -s /usr/share/jdbc-postgresql/lib/jdbc-postgresql.jar /usr/share/tomcat-7/lib/
ln -s /usr/share/commons-dbcp/lib/commons-dbcp.jar /usr/share/tomcat-7/lib/
ln -s /usr/share/commons-pool/lib/commons-pool.jar /usr/share/tomcat-7/lib/

[edit] Create the database

su postgres -c psql
CREATE DATABASE libreplan;
CREATE USER libreplan WITH PASSWORD 'libreplan';
GRANT ALL PRIVILEGES ON DATABASE libreplan TO libreplan;
\q

[edit] Fetch Libreplan files from its website

Now download the latest libreplan.war and install.sql and rename them to libreplan.war and install.sql.

[edit] Install the database

psql -h localhost -U libreplan -W libreplan < install.sql

[edit] Install the web application as ROOT

mv /var/lib/tomcat-7/webapps/ROOT /var/lib/tomcat-7/original-webapps-ROOT
cp libreplan.war /var/lib/tomcat-7/webapps/ROOT.war

[edit] Configure Libreplan

Create a file /etc/tomcat-7-libreplan/Catalina/localhost/ROOT.xml with the following contents:

<?xml version="1.0" encoding="UTF-8"?>

<Context antiJARLocking="true" path="">
   <Resource name="jdbc/libreplan-ds" auth="Container"
       type="javax.sql.DataSource"
       factory="org.apache.commons.dbcp.BasicDataSourceFactory"
       maxActive="100" maxIdle="30" maxWait="10000"
       username="libreplan" password="libreplan"
       driverClassName="org.postgresql.Driver"
       url="jdbc:postgresql://localhost/libreplan" />
</Context>

NOTE THE LINE THAT HAS TO BE PRESENT: factory="org.apache.commons.dbcp.BasicDataSourceFactory"

[edit] Start the application

/etc/init.d/tomcat-7 start
rc-update add tomcat-7 default

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox