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.4Once 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
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.
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all ident sameuser # 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 # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5
- 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.xThe 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 = '127.0.0.1, 192.168.1.1' -- 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:
You can watch our installation demo to see the installer in action demo
java -jar LibreSource-Community-1.5-Installer.jar