Nominatim for Traffic Accident Database

>> return Cedeus_IDE

---

Objective

Develop a script for automated geo-referencing of Chiles transit accident database.

Tools:

• loading an MS Access DB in OpenOffice/LibreOffice: http://askubuntu.com/questions/187389/is-it-possible-to-open-an-access-2010-database-file-without-using-wine-or-virtua/519571#519571

Installing Nominatim

• Nominatim installation manual: https://wiki.openstreetmap.org/wiki/Nominatim/Installation

Setup of Nominatim VM

1. copying basicubunutu1404.vdi file and renaming to nominatim.vdi
2. creating the nominatim VM on CedeusDB (ip.18):
   • VBoxManage createvm --name nominatim --ostype Ubuntu_64 --register
   • VBoxManage modifyvm nominatim --memory 4096
   • VBoxManage modifyvm nominatim --cpus 4
   • VBoxManage modifyvm nominatim --nic1 nat
   • VBoxManage storagectl nominatim --name "SATA Controller" --add sata --controller IntelAhci
   • assign the (old) disk image a new uuid

     VBoxManage internalcommands sethduuid nominatim.vdi

   • attach the (old) disk image:

     VBoxManage storageattach "nominatim" --storagectl "SATA Controller" --port 0 --device 0 --type hdd --medium nominatim.vdi

   • VBoxManage storagectl nominatim --name "IDE Controller" --add ide --controller PIIX4
   • set the nat rules (ports):

     VBoxManage modifyvm nominatim --natpf1 "ssh,tcp,,20022,,22"

     VBoxManage modifyvm nominatim --natpf1 "apache,tcp,,20080,,80"

3. optional - set VRDE port:
   • VBoxManage modifyvm nominatim --vrdeport 7761 (Note: 3389 is the default port anyway)
4. start the VM

   VBoxHeadless -s nominatim --vrde on &

   the VM will listen on port 7761 - connect with GTKvncViewer to check

   • check if ssh connection works
5. change the computers name in /etc/hosts and /etc/hostname
6. restarting Apache gives the error message: "apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 ..."

=> solve this by adding ServerName elgg as the last line in /etc/apache2/apache2.conf file