Difference between revisions of "RBE10K/Libreplan/Installation"

From MediaWiki
Jump to: navigation, search
(Created page with "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-gento...")
 
Line 3: Line 3:
 
== Install dependencies ==
 
== Install dependencies ==
 
<code>
 
<code>
emerge -a commons-dbcp commons-pool tomcat jdbc-postgresql postgresql-server
+
emerge -a commons-dbcp commons-pool tomcat jdbc-postgresql postgresql-server
 
</code>
 
</code>
  
 
== Create Tomcat instance ==
 
== Create Tomcat instance ==
 
<code>
 
<code>
/usr/share/tomcat-7/gentoo/tomcat-instance-manager.bash --create
+
/usr/share/tomcat-7/gentoo/tomcat-instance-manager.bash --create
 
</code>
 
</code>
  
Line 15: Line 15:
 
== Add necessary jars ==
 
== Add necessary jars ==
 
<code>
 
<code>
ln -s /usr/share/jdbc-postgresql/lib/jdbc-postgresql.jar /usr/share/tomcat-7/lib/
+
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-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/
+
ln -s /usr/share/commons-pool/lib/commons-pool.jar /usr/share/tomcat-7/lib/
 
</code>
 
</code>
  
 
== Create the database ==
 
== Create the database ==
 
<code>
 
<code>
su postgres -c psql
+
su postgres -c psql
CREATE DATABASE libreplan;
+
CREATE DATABASE libreplan;
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;
 
</code>
 
</code>
  
Line 33: Line 33:
 
== Install the database ==
 
== Install the database ==
 
<code>
 
<code>
psql -h localhost -U libreplan -W libreplan < install.sql
+
psql -h localhost -U libreplan -W libreplan < install.sql
 
</code>
 
</code>
  
 
== Install the web application ==
 
== Install the web application ==
 
<code>
 
<code>
cp libreplan.war /var/lib/tomcat-7/webapps/
+
cp libreplan.war /var/lib/tomcat-7/webapps/
 
</code>
 
</code>
  
Line 45: Line 45:
  
 
<code>
 
<code>
<?xml version="1.0" encoding="UTF-8"?>
+
<?xml version="1.0" encoding="UTF-8"?>
 
+
<Context antiJARLocking="true" path="">
+
<Context antiJARLocking="true" path="">
 
     <Resource name="jdbc/libreplan-ds" auth="Container"
 
     <Resource name="jdbc/libreplan-ds" auth="Container"
 
         type="javax.sql.DataSource"
 
         type="javax.sql.DataSource"
Line 55: Line 55:
 
         driverClassName="org.postgresql.Driver"
 
         driverClassName="org.postgresql.Driver"
 
         url="jdbc:postgresql://localhost/libreplan" />
 
         url="jdbc:postgresql://localhost/libreplan" />
</Context>
+
</Context>
</code>
+
</code>
  
 
'''''NOTE THE LINE THAT HAS TO BE PRESENT''''': ''factory="org.apache.commons.dbcp.BasicDataSourceFactory"''
 
'''''NOTE THE LINE THAT HAS TO BE PRESENT''''': ''factory="org.apache.commons.dbcp.BasicDataSourceFactory"''
Line 62: Line 62:
 
== Start the application ==
 
== Start the application ==
 
<code>
 
<code>
/etc/init.d/tomcat-7 start
+
/etc/init.d/tomcat-7 start
 
</code>
 
</code>

Revision as of 19:44, 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

Install dependencies

emerge -a commons-dbcp commons-pool tomcat jdbc-postgresql postgresql-server

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.

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/

Create the database

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

Fetch Libreplan files from its website

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

Install the database

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

Install the web application

cp libreplan.war /var/lib/tomcat-7/webapps/

Configure Libreplan

Edit /etc/tomcat-7-libreplan/Catalina/localhost/libreplan.xml and paste this in it:

<?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"

Start the application

/etc/init.d/tomcat-7 start

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox