Environement setup for Linux

For those who want to go quickly, we provide (as is and without any warranty of any kind) some Docker or installation script

For those who want to be guided, step by step, do the following instructions :

Before install and launch Gisgraphy, you must setup Java, Postgres, and Postgis. It is not, properly speaking, the installation of Gisgraphy, and if you already have Postgresql, Postgis and java installed (you needs JVM >= 1.5), you can go install Gisgraphy

Install and configure java / JVM

Install Java

Open a shell and type :

Valid screen (tab + OK) :

Accept the license (TAB to select 'yes' + OK) :

java version "1.6.0_06"
Java(TM) SE Runtime Environment (build 1.6.0_06-b02)
Java HotSpot(TM) 64-Bit Server VM (build 10.0-b22, mixed mode)

We will now configure the Java.

Configure Java

Open a shell and type :

You may have this message if you are on a 64 bits machine : Impossible de find alternative « /usr/lib/jvm/java-7-oracle/jre/jre/plugin/i386/ns7/libjavaplugin_oji.so ". thats not important. that's because there is no applet in 64 bits.

We now need to add a JAVA_HOME environement variable :

• add this line to .bashrc in your home directoy
export JAVA_HOME=/usr/lib/jvm/java-7-oracle/


• execute "source ~/.bashrc" in a shell to take the changes into account.

Type "echo $JAVA_HOME" to check it is well set : /usr/lib/jvm/java-6-sun-1.6.0.06/

The JVM is now well installed

Install postgresql and postgis

Install the package

This documentation is a documentation for ubuntu / debian, it is just a start point, but you can install Postgres and Postgis for other distributions. You will find some tutorials for a lot of linux distribution or even Windows on this Openstreetmap wiki page

Open a shell and type :

Configure Postgis

Here are the command to install a Database and init the Gisgraphy database

# create the database
psql -U YOURUSER  -h YOURIP -c  "CREATE DATABASE gisgraphy ENCODING = 'UTF8';"

#create language
createlang -U YOURUSER -h YOURIP plpgsql gisgraphy 

#create postgis function
psql -U YOURUSER -h YOURIP -d gisgraphy -f -f /usr/share/postgresql/YOURPOSTGRESVERSION/contrib/postgis-1.5/postgis.sql
psql -U YOURUSER -h YOURIP -d gisgraphy -f psql -U postgres  -h 127.0.0.1 -d gisgraphy -f /usr/share/postgresql/YOURPOSTGRESVERSION/contrib/postgis-1.5/spatial_ref_sys.sql

#or for postgis 2 :

psql -U YOURUSER  -h YOURIP -d gisgraphy -f /usr/share/postgresql/9.3/contrib/postgis-2.1/postgis.sql
psql -U YOURUSER  -h YOURIP -d gisgraphy -f /usr/share/postgresql/9.3/contrib/postgis-2.1/spatial_ref_sys.sql 

Configure the postgres user / password

By default the postgres user can connect to postgres with the same password as the Unix one, but we'd like that postgres ask for a password and not use the UNIX one

• Change postgres (unix) user :
sudo passwd postgres
• Log to Unix with user 'postgres' :
su - postgres

and give the new password you've just type




• Check postgresql conf :
vim /etc/postgresql/9.1/main/pg_hba.conf

and edit it in order to have (at least) those 2 lines (at the beginning of the file) :

local  all     all                                        ident sameuser
host   all     all    127.0.0.1         255.255.255.255   ident sameuser

• Define the postgres (postgresql) user's password

Connect to postgres to change the postgresql password :

psql -d template1 -c "alter user postgres with password 'YOURPASSWORD'"

Where 'YOURPASSWORD' is the password you wish to use for the user postgres

Now you've changed the password for your postgresql user, we have to tell postgresql to use this password



• Update postgres conf

Open a shell and Type :

vim /etc/postgresql/9.1/main/pg_hba.conf

And edit in order to have (at least) those two lines :

local  all     all                                        password
host   all     all    127.0.0.1         255.255.255.255   password

• Restart postgres

We must restart postresql to take our changes into account :
Close your postgres 's Linux session, type :

exit

Restart postgres :

sudo service postgresql restart

Define Linux settings

sudo ulimit -n6000

* hard nofile 20000
* soft nofile 20000