Resource Menu


by Pascal Molli - (no comment)
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
  1. IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust host all all 127.0.0.1 255.255.255.255 md5
  1. 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 127.0.0.1 255.255.255.255 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
  1. note: increasing max_connections costs about 500 bytes of shared
  2. memory per connection slot, in addition to costs from shared_buffers
  3. and max_locks_per_transaction.
#superuser_reserved_connections = 2 port = 5432
  • 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


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