Pages

Tuesday, 30 May 2023

项目计划管理Web系统 LibrePlan



LibrePlan 是一个基于 Web 的开源项目计划和管理系统,支持多国语言(包括中文),多用户,是计划、监控和控制项目的各个阶段的有力协作工具。适合用于多个项目和各种资源交汇的项目场景。包含甘特图,图标报告等丰富的功能。

-------------------------------------------------

LibrePlan - Open Web Planning

www.libreplan.dev

LibrePlan

Description

LibrePlan is a free software web application for project management, monitoring and control.

LibrePlan is a collaborative tool to plan, monitor and control projects and has a rich web interface which provides a desktop alike user experience. All the team members can take part in the planning and this makes possible to have a real-time planning.

It was designed thinking on a scenario where multiple projects and resources interact to carry out the work inside a company. Besides, it makes possible the communication with other company tools providing a wide set of web services to import and export data.

from https://github.com/LibrePlan/libreplan

-------------------------------------------------

LibrePlan manual installation

Debian/Ubuntu

  • Install requirements:

    # apt-get install openjdk-8-jre postgresql postgresql-client tomcat8 libpg-java cutycapt xvfb
    
  • Connect to database:

    # su postgres -c psql
    
  • Use SQL sentences to create database:

    CREATE DATABASE libreplan;
    CREATE USER libreplan WITH PASSWORD 'libreplan';
    GRANT ALL PRIVILEGES ON DATABASE libreplan TO libreplan;
    
  • Download database installation script:

    $ wget -O install.sql http://downloads.sourceforge.net/project/libreplan/LibrePlan/install_1.4.0.sql
    

    Warning

    The 1.4.1.sql file is specific for a MySQL install.

  • Create database structure:

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

    Warning

    It is very important to execute the previous command specifiying libreplan user (as you can see in the -U option). Otherwise your LibrePlan installation is not going to start properly and you could find in your log files something like that:

    JDBCExceptionReporter  - ERROR: permission denied for relation entity_sequence
    
  • Download .war file from SourceForge.net:

    $ wget -O libreplan.war http://downloads.sourceforge.net/project/libreplan/LibrePlan/libreplan_1.4.1.war
    
  • Create a new file /etc/tomcat8/Catalina/localhost/libreplan.xml (file name has to match with .war name) with database configuration for Tomcat 8:

    <?xml version="1.0" encoding="UTF-8"?>
    
    <Context antiJARLocking="true" path="">
        <Resource name="jdbc/libreplan-ds" auth="Container"
            type="javax.sql.DataSource"
            maxActive="100" maxIdle="30" maxWait="10000"
            username="libreplan" password="libreplan"
            driverClassName="org.postgresql.Driver"
            url="jdbc:postgresql://localhost/libreplan" />
    </Context>
    
  • Add next lines to Tomcat 8 policy file /etc/tomcat8/catalina.policy or /var/lib/tomcat8/conf or /etc/tomcat8/policy.d/03catalina.policy with the following content:

    grant codeBase "file:/var/lib/tomcat8/webapps/libreplan/-" {
       permission java.security.AllPermission;
    };
    grant codeBase "file:/var/lib/tomcat8/webapps/libreplan.war" {
       permission java.security.AllPermission;
    };
    
  • Also add next lines to Tomcat 8 policy file:

    grant codeBase "file:${catalina.home}/bin/tomcat-juli.jar" {
      ...
      // begin:libreplan
      permission java.io.FilePermission "${catalina.base}${file.separator}webapps${file.separator}libreplan${file.separator}WEB-INF${file.separator}classes${file.separator}logging.properties", "read";
      // end:libreplan
      ...
    };
    
  • Add link to Java JDBC driver for PostgreSQL in Tomcat8 libraries directory:

    # ln -s /usr/share/java/postgresql-jdbc4.jar /usr/share/tomcat8/lib/
    
  • Copy war to Tomcat 8 web applications directory:

    # cp libreplan.war /var/lib/tomcat8/webapps/
    
  • Restart Tomcat 8:

    # /etc/init.d/tomcat8 restart
    
  • Go to http://localhost:8080/libreplan/

Warning

If you have problems with printing support review the last section Fix printing in Debian Squeeze.

from https://github.com/LibrePlan/libreplan/blob/master/INSTALL.rst 

(https://www.libreplan.dev/,

https://demo.libreplan.dev/)

 

 

 

 

 

 

No comments:

Post a Comment