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 elgg VM on CedeusDB (ip.18):
   • VBoxManage createvm --name elgg --ostype Ubuntu_64 --register
   • VBoxManage modifyvm elgg --memory 4096
   • VBoxManage modifyvm elgg --cpus 4
   • VBoxManage modifyvm elgg --nic1 nat
   • VBoxManage storagectl elgg --name "SATA Controller" --add sata --controller IntelAhci
   • assign the (old) disk image a new uuid

     VBoxManage internalcommands sethduuid elgg.vdi

   • attach the (old) disk image:

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

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

     VBoxManage modifyvm elgg --natpf1 "ssh,tcp,,15022,,22"

     VBoxManage modifyvm elgg --natpf1 "apache,tcp,,15080,,80"

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

   VBoxHeadless -s elgg --vrde on &

   the VM will listen on port 7765

5. The following step do not seem to be necessary with Ubuntu 14.04 and new VirtualBox - however, are necesary for 12.04. But if so: connect with VRD and adjust network card settings (remember the existing VM have an old password)
   • open /etc/udev/rules.d/70-persistent-net.rules and comment out existing network adapters
   • reboot
   • check if ssh connection works
6. change the computers name in /etc/hosts and /etc/hostname
7. 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