Resource Menu

by Stéphane Bagnier - initial
In order to use the Libresource installer you have to install a jdk (>1.4) and postgres (>7.4).

I did the installation on my Ubuntu as following:

I used synaptic to install postres 7.4

Once postgres installed, you have to:

  • edit the /etc/postgresql/7.4/main/pg_hba.conf. Libresource connects to postgres with the postgres JDBC driver. This driver uses tcp/ip connection. So postgres
must be configured to accept tcpip connection.

Here is my pg_hba.conf:

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
local   all         all                                             ident sameuser
# IPv4-style local connections:
host    all         all   trust
host    all         all   md5
# IPv6-style local connections:
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        md5

I just added the line "host all all trust". It tells postgres to accept tcpip connection coming from localhost.

  • edit /etc/postgresql/7.4/main/postgresql.conf. Set "tcpip_socket =yes".
# - Connection Settings -
tcpip_socket = yes
max_connections = 100
#superuser_reserved_connections = 2
port = 5432

Notes Regarding PostgreSQL 8.x

The postgres.conf file has changed and tcpip_sockets is no longer valid. Instead use listen_addresses = ' ' with the addresses between the single quotes. To allow all addresses, use listen_addresses = '*' The listen_addresses = defaults to loopback only.

You can comma delimit multiple addresses like this:

listen_addressess = ',' -- Thanks Laurent ;)

  • restart postgres :
% sudo /etc/init.d/postgresql-7.4 restart
  • Create the Libresource user and Libresource database
% sudo su postgres
% createuser -d -a molli
% exit
% creatdb libresource
  • Postgres is now ready. You can run the Libresource installer:
java -jar LibreSource-Community-1.5-Installer.jar

You can watch our installation demo to see the installer in action demo

Last edited by null at - Edit content - View history - View source