postgis | idevit.nl

apt-get install php5-curl php5-pgsql postgresql postgis postgresql-9.1-postgis postgresql-contrib-9.1 tomcat7
apt-get install libcommons-collections3-java-doc libgeronimo-jta-1.1-spec-java ecj ant libecj-java-gcj uuid proj-bin oidentd postgresql-doc-9.1 libdbd-pg-perl tomcat7-docs tomcat7-admin tomcat7-examples tomcat7-user libtcnative-1
apt-get install openjdk-7-jre-headless

postgress

sudo su postgres
createuser --pwprompt --no-superuser --no-createdb --no-createrole DBUSER
createdb --encoding=UTF-8 --owner=DBUSER DBNAME
psql -d "DBNAME" -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -d "DBNAME" -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql
psql -d "DBNAME" -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
psql -d "DBNAME" -c 'grant all on geometry_columns to "DBUSER";'
psql -d "DBNAME" -c 'grant all on spatial_ref_sys to "DBUSER";'
exit

PostGIS 2.0 users should also grant access to geography_columns and raster_columns.
Next you need to download and install GeoServer. Versions 2.2.x and 2.3.x has been tested with Cartaro:

wget http://sourceforge.net/projects/geoserver/files/GeoServer/2.4.3/geoserver-2.4.3-war.zip
sudo unzip geoserver-2.4.3-war.zip geoserver.war -d /var/lib/tomcat7/webapps/

Now add the drupal extensions to geoserver

cd /var/lib/tomcat7/webapps/geoserver/WEB-INF/lib
wget http://dl.geops.de/geoserver-sec-drupal/geoserver-sec-drupal-7.x-1.1.jar
chown tomcat7:tomcat7 geoserver-sec-drupal-7.x-1.1.jar

add CLASSPATH to web-inf

nano /var/lib/tomcat7/webapps/geoserver/WEB-INF/web.xml
#add after last context-param tag:
<context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath*:/applicationContext.xml classpath*:/applicationSecurityContext.xml classpath*:/applicationSecurityContextOverride.xml</param-value>
</context-param>

restart geoserver and open up port 8080 to localhost and tunnel yourself in to reset master password for admin whom is geoserver http://cartaro.org/documentation/using-drupal-users-and-roles-geoserver Add a new role service of type Drupal (Security » Users, Groups, Roles » Role Services » Add new). It does not matter which name you set. Only one such service is sufficient for any number of bound Drupal instances. Finally make sure GeoServer does actually use the new service by selecting it in GeoServer's global security settings. then we need to set java opts

nano /etc/default/tomcat7
JAVA_OPTS="${JAVA_OPTS} -DENABLE_JSONP=true"

install gdal

sudo apt-get install php5-dev g++ libgdal1-dev
cd /home/usr/src/
git clone https://github.com/geops/php5-gdal.git
phpize
./configure
make
sudo make install

add gdal to php and restart it.

; configuration for the PHP GDAL extension
extension=gdal.so

install cartaro as usual