Difference between revisions of "Nominatim for Traffic Accident Database"
From stgo
(→Setup of Nominatim VM) |
|||
| Line 13: | Line 13: | ||
=== Setup of Nominatim VM === | === Setup of Nominatim VM === | ||
# copying basicubunutu1404.vdi file and renaming to nominatim.vdi | # copying basicubunutu1404.vdi file and renaming to nominatim.vdi | ||
| + | # creating the elgg VM on CedeusDB (ip.18): | ||
| + | #* <code>VBoxManage createvm --name elgg --ostype Ubuntu_64 --register</code> | ||
| + | #* <code>VBoxManage modifyvm elgg --memory 4096</code> | ||
| + | #* <code>VBoxManage modifyvm elgg --cpus 4</code> | ||
| + | #* <code>VBoxManage modifyvm elgg --nic1 nat</code> | ||
| + | #* <code>VBoxManage storagectl elgg --name "SATA Controller" --add sata --controller IntelAhci</code> | ||
| + | #* assign the (old) disk image a new uuid | ||
| + | #*: <code>VBoxManage internalcommands sethduuid elgg.vdi</code> | ||
| + | #* attach the (old) disk image: | ||
| + | #*: <code> VBoxManage storageattach "elgg" --storagectl "SATA Controller" --port 0 --device 0 --type hdd --medium elgg.vdi</code> | ||
| + | #* <code> VBoxManage storagectl elgg --name "IDE Controller" --add ide --controller PIIX4</code> | ||
| + | #* set the nat rules (ports): | ||
| + | #*: <code> VBoxManage modifyvm elgg --natpf1 "ssh,tcp,,15022,,22"</code> | ||
| + | #*: <code> VBoxManage modifyvm elgg --natpf1 "apache,tcp,,15080,,80"</code> | ||
| + | # optional - set VRDE port: | ||
| + | #* <code>VBoxManage modifyvm elgg --vrdeport 7765</code> (Note: 3389 is the default port anyway) | ||
| + | # start the VM | ||
| + | #: <code>VBoxHeadless -s elgg --vrde on &</code> | ||
| + | #: the VM will listen on port 7765 | ||
| + | # 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 | ||
| + | # change the computers name in ''/etc/hosts'' and ''/etc/hostname'' | ||
| + | # 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 | ||
Revision as of 16:03, 2 March 2015
>> 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
- copying basicubunutu1404.vdi file and renaming to nominatim.vdi
- 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"
-
-
- optional - set VRDE port:
-
VBoxManage modifyvm elgg --vrdeport 7765(Note: 3389 is the default port anyway)
-
- start the VM
-
VBoxHeadless -s elgg --vrde on & - the VM will listen on port 7765
-
- 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
- change the computers name in /etc/hosts and /etc/hostname
- 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
