This section explains how to set up LibrePlan in openSUSE after installing the package.
It assumes that PostgreSQL is already running and configured to use md5
as
the authentication method.
If this is not the case, go to section "Configuring PostgreSQL to use md5
authentication method", at the end of this document.
# psql -h localhost -U postgres < /usr/share/libreplan/pgsql/create_db.sql
# psql -h localhost -U postgres < /usr/share/libreplan/pgsql/create_user_postgresql.sql
# psql -h localhost -U libreplan -W libreplan < /usr/share/libreplan/pgsql/install.sql
# ln -s /usr/share/libreplan/conf/libreplan.xml /etc/tomcat6/Catalina/localhost/
# wget http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc3.jar -O /usr/share/java/postgresql-jdbc3.jar
# ln -s /usr/share/java/postgresql-jdbc3.jar /usr/share/tomcat6/lib/
# ln -s /usr/share/libreplan/webapps/libreplan.war /usr/share/tomcat6/webapps/
# service tomcat6 restart
LibrePlan should be running at http://localhost:8080/libreplan
Review INSTALL file for more information.
This section explains how to upgrade LibrePlan from version a.b.c to version x.y.z.
# psql -h localhost -U libreplan -W libreplan < /usr/share/libreplan/pgsql/upgrade_x.y.z.sql
VERY IMPORTANT: If there are other versions between a.b.c and x.y.z, we need to execute those scripts in order, so the upgrade is done correctly.
WARNING: If you are using PostgreSQL version 8 you will have to execute the next command over LibrePlan database in order to use the upgrade script for version 1.3.0:
# su postgres -c "createlang -d libreplan plpgsql"
# service tomcat6 stop
# rm -rf /usr/share/tomcat6/webapps/
# service tomcat6 start
LibrePlan should be running at http://localhost:8080/libreplan
We assume that PostgreSQL is using md5
as the authentication method, instead of default ident
.
These are the steps to change it.
# su postgres -c psql
postgres=# ALTER USER postgres WITH PASSWORD 'postgres'; postgres=# q
# sed -i "/^host/s/ident/md5/g" /var/lib/pgsql/data/pg_hba.conf
# service postgresql restart