Set up GPSphoto server on CentOS

• Install a bare web server
• Add the Epel repository

  yum install epel-release
  

• In order for GPSphoto to work you also need the following packages:

  yum install mod_wsgi python-webob python-pillow python2-boto python-dateutil pytz
  

• To make sure exif data is kept with the images install piexif (attached) Does not seem to be needed

  yum install piexif-1.0.7-1.noarch.rpm
  

• For KML export functionality install simplekml (attached)

  yum install python-lxml simplekml-1.3.0-1.noarch.rpm
  

• For geojson support install

  yum install python-geojson
  

• For cookie management in WSGI install the following:

  yum install python2-cookies
  

• To use Google openid authentication install:

  yum install mod_auth_openidc
  

PostgresQL / PostGIS

If you chose postgis as your DB back-end, continue with this section. If you prefer sqlite, which is more lightweight, but also does not scale that well continue at the next section.

Get the latest postgres / postgis by install the Yum repo from ​https://yum.postgresql.org/repopackages.php and install the following packages:

yum install postgresql96-server postgresql96 postgresql96-contrib postgis2_96 postgis2_96-utils\
 postgis2_96-client python-psycopg2 python-psycopg2-doc ogr_fdw96 pgrouting_96

Edit /etc/sysconfig/pgsql/postgresql-9.6 to contain the following content:

PGPORT=5440

Initialize the database and start and enable it:

/usr/pgsql-9.6/bin/postgresql96-setup initdb
systemctl enable postgresql-9.6.service 
systemctl start postgresql-9.6

Make sure the path is updated by creating /var/lib/pgsql/.pgsql_profile with the content:

export PATH=/usr/pgsql-9.5/bin:$PATH

Create the DB schema:

su -i postgres
createdb mapserver
createuser mapserver
psql mapserver
> alter user mapserver with password <password>
> CREATE EXTENSION postgis;
> CREATE EXTENSION postgis_topology;
> CREATE EXTENSION ogr_fdw;

To verify the install do:

SELECT postgis_full_version();

Load the gpsphoto table

psql -f gpsphoto/table.sql -d mapserver

update postgresql configuration

Add the following line to /var/lib/pgsql/9.6/data/postgresql.conf

listen_addresses = '*'

Comment all original lines in pg_hba.conf and put the following at the bottom:

local   all             all                                     md5
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

Add the following line to pg_ident.conf:

gpsphoto        apache                  mapserver

Selinux for Postgres / Apache

Allow httpd to connect to postgres:

setsebool -P httpd_can_network_connect_db 1

Spatialite

• install spatiallite if you chose SQLite as the backend DB from the epel repository:

  yum install libspatialite
  

Also install pyspatialite (attached on this page) and if you want to be able to create and modify the spatialite db having spatialite-tools (also attached) is advised:

yum install spatialite-tools-4.1.1-13.el7.centos.x86_64.rpm pyspatialite-2.6.2_spatialite.2.4.0_4-1.x86_64.rpm

QGIS Server

http://gpsphoto.fritz.box/qgis/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities&map=/var/www/wms/project.qgs

Useful tools and commands

print detailed exif information of image:

identify -verbose P1100818.JPG