-
Notifications
You must be signed in to change notification settings - Fork 0
/
Vagrantfile
executable file
·132 lines (122 loc) · 6.69 KB
/
Vagrantfile
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
# -*- mode: ruby -*-
# vi: set ft=ruby :
# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure("2") do |config|
# The most common configuration options are documented and commented below.
# For a complete reference, please see the online documentation at
# https://docs.vagrantup.com.
# Every Vagrant development environment requires a box. You can search for
# boxes at https://atlas.hashicorp.com/search.
config.vm.box = "bento/ubuntu-18.04"
# Disable automatic box update checking. If you disable this, then
# boxes will only be checked for updates when the user runs
# `vagrant box outdated`. This is not recommended.
# config.vm.box_check_update = false
config.vm.hostname = "oereb-iconizer"
config.ssh.forward_agent = true
config.ssh.forward_x11 = true
# Create a forwarded port mapping which allows access to a specific port
# within the machine from a port on the host machine. In the example below,
# accessing "localhost:8080" will access port 80 on the guest machine.
# config.vm.network "forwarded_port", guest: 80, host: 8080
config.vm.network "forwarded_port", guest: 22, host: 2028, id: 'ssh'
# Create a private network, which allows host-only access to the machine
# using a specific IP.
# config.vm.network "private_network", ip: "192.168.33.10"
config.vm.network "private_network", ip: "192.168.50.8"
# Create a editlic network, which generally matched to bridged network.
# Bridged networks make the machine appear as another physical device on
# your network.
# config.vm.network "editlic_network"
# Share an additional folder to the guest VM. The first argument is
# the path on the host to the actual folder. The second argument is
# the path on the guest to mount the folder. And the optional third
# argument is a set of non-required options.
# config.vm.synced_folder "../data", "/vagrant_data"
# Provider-specific configuration so you can fine-tune various
# backing providers for Vagrant. These expose provider-specific options.
# Example for VirtualBox:
#
config.vm.provider "virtualbox" do |vb|
# # Display the VirtualBox GUI when booting the machine
# vb.gui = true
#
# Customize the amount of memory on the VM:
vb.memory = "4096"
vb.cpus = 2
vb.customize ["modifyvm", :id, "--cableconnected1", "on"]
end
#
# View the documentation for the provider you are using for more
# information on available options.
# Define a Vagrant Push strategy for pushing to Atlas. Other push strategies
# such as FTP and Heroku are also available. See the documentation at
# https://docs.vagrantup.com/v2/push/atlas.html for more information.
# config.push.define "atlas" do |push|
# push.app = "YOUR_ATLAS_USERNAME/YOUR_APPLICATION_NAME"
# end
# Enable provisioning with a shell script. Additional provisioners such as
# Puppet, Chef, Ansible, Salt, and Docker are also available. Please see the
# documentation for more information about their specific syntax and use.
config.vm.provision "shell", inline: <<-SHELL
locale-gen de_CH.utf8
echo "Europe/Zurich" | tee /etc/timezone
dpkg-reconfigure --frontend noninteractive tzdata
echo 'deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main' >> /etc/apt/sources.list.d/pgdg.list
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -
apt-get update
apt-get install -y postgresql-11
apt-get install -y postgresql-client-11
apt-get install -y postgresql-11-postgis-2.5
apt-get install -y postgresql-11-postgis-2.5-scripts
apt-get install -y postgis
sudo -u postgres psql -d postgres -c "UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';"
sudo -u postgres psql -d postgres -c "DROP DATABASE template1;"
sudo -u postgres psql -d postgres -c "CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING='UNICODE' LC_COLLATE='en_US.UTF8' LC_CTYPE='en_US.UTF8';"
sudo -u postgres psql -d postgres -c "UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';"
sudo -u postgres psql -d postgres -c "UPDATE pg_database SET datallowconn = FALSE WHERE datname = 'template1';"
sudo -u postgres psql -d postgres -c "CREATE ROLE ddluser LOGIN PASSWORD 'ddluser';"
sudo -u postgres psql -d postgres -c "CREATE ROLE dmluser LOGIN PASSWORD 'dmluser';"
sudo -u postgres psql -d postgres -c "CREATE DATABASE oereb WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' OWNER ddluser;"
sudo -u postgres psql -d oereb -c 'CREATE EXTENSION postgis;'
sudo -u postgres psql -d oereb -c 'CREATE EXTENSION "uuid-ossp";'
sudo -u postgres psql -d oereb -c 'GRANT SELECT ON geometry_columns TO dmluser;'
sudo -u postgres psql -d oereb -c 'GRANT SELECT ON spatial_ref_sys TO dmluser;'
sudo -u postgres psql -d oereb -c 'GRANT SELECT ON geography_columns TO dmluser;'
sudo -u postgres psql -d oereb -c 'GRANT SELECT ON raster_columns TO dmluser;'
sudo -u postgres psql -d oereb -c "ALTER DATABASE oereb SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';"
sudo -u postgres psql -d postgres -c 'ALTER USER ddluser WITH SUPERUSER;'
systemctl stop postgresql
rm /etc/postgresql/11/main/postgresql.conf
rm /etc/postgresql/11/main/pg_hba.conf
cp /vagrant/vagrant/postgresql.conf /etc/postgresql/11/main
cp /vagrant/vagrant/pg_hba.conf /etc/postgresql/11/main
sudo -u root chown postgres:postgres /etc/postgresql/11/main/postgresql.conf
sudo -u root chown postgres:postgres /etc/postgresql/11/main/pg_hba.conf
service postgresql start
echo 'deb http://qgis.org/debian-ltr bionic main' >> /etc/apt/sources.list.d/qgis.org-debian.list
apt-key adv --keyserver keyserver.ubuntu.com --recv-key CAEB3DC3BDF7FB45
apt-get update
apt-get install -y apache2 libapache2-mod-fcgid
apt-get install -y qgis-server python-qgis
mkdir /var/log/qgis
chown www-data:www-data /var/log/qgis
mkdir /var/lib/qgis
chown www-data:www-data /var/lib/qgis
#cp /vagrant/vagrant/qgis-server.conf /etc/apache2/sites-enabled/qgis-server.conf
#rm /etc/apache2/sites-enabled/000-default.conf
cp /vagrant/vagrant/000-default.conf /etc/apache2/sites-available/000-default.conf
cp /vagrant/vagrant/fcgid.conf /etc/apache2/mods-available/fcgid.conf
a2enmod rewrite
a2enmod cgid
a2enmod headers
service apache2 restart
apt-get install -y gdal-bin python-gdal
apt-get install -y xauth zip unzip
apt-get install -y ifupdown
apt-get install -y fonts-liberation
SHELL
end