QUICKSTART & PASSWORDS

Version - 20160528

Written by Ricardo Pinho

(ricardo.pinho@gisvm.com)

This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License

INDEX

What’s inside

Passwords

First time run

How to use it

Open QGIS sample project to view the included Natural Earth data

Add a new PostGIS layer from GISVM to your QGIS project

Upload a new PostGIS layer to GISVM using QGIS

Upload a new PostGIS layer to GISVM using SHP2PGSQL

How to manage it

Using phpPgAdmin to manage the PostgreSQL server

Using pgAdmin III to manage the PostgreSQL server

Using Webmin to manage the Ubuntu operating system

Use the local site to get more information on using GISVM

REMEMBER, USE GISVM AT YOUR OWN RISK.


What’s inside

maxresdefault.jpg

Ubuntu 14.04.4 LTS Server 32bit

  • Private (NAT) & Local (Bridge) networks
  • Apache2 Web server & PHP5
  • Samba - windows network
  • OpenSSH
  • Webmin 1.801
  • Shellinabox

Postgis_1.png

PostgreSQL 9.5.3

  • PostGIS 2.2.2
  • phpPgAdmin 5.1
  • postgis sample database
  • natural earth 2 sample data

Passwords

LOGIN

PASSWORD

URL

Ubuntu shell (&sudo)

gisvm

gisvm

http://gisvm:4200
(shellinabox)

Local site (Apache2)

gisvm

gisvm

http://gisvm

PostgreSQL

(Database: postgis)

postgres

gisvm

http://gisvm/phppgadmin/

Webmin

gisvm

gisvm

http://gisvm:10000

Samba share

(/home/gisvm/gisdata)

(/samba/gisdata)

(Windows Shortcut)

\\gisvm\gisdata


First time run

Three simple steps: Download, unzip and run

  1. Download

GIS Virtual Machine is a complete and independent computer on a file.

It is optimized to use less than 2 GB of space on your disk at start.

You can download and get it in a compacted 7z file that is less than 200 MB.

 

  1. Unzip

After download it you must uncompress the 7z file.

You must have a uncompress program installed or install 7z available as free software:

http://www.7-zip.org/download.html 

  1. Run

To run it you must have a Virtual Machine Player installed or install a free available:

- Install VirtualBox, available as free software:

https://www.virtualbox.org/wiki/Downloads 

gisvm-download-vb.png

- Or install VMware Player, available for free:

https://www.vmware.com/go/downloadplayer 

gisvm-download-vmw.png


Virtualbox_logo.png Run on VirtualBox:

import-gisvm.png     import2-gisvm.png

start-gisvm.png    gisvm-running-vb.png

vmware_player.png Run on VMware Player:

gisvm-vmware-open.png

gisvm-vmware-poweron.png       gisvm-vmware-running.png

Or just double click the file “gisvm.vmxfound inside the gisvm unpacked folder.


How to use it

  1. Open QGIS sample project to view the included Natural Earth data

Use the QGIS installed on your computer or on any other computer at your network, to open the included QGIS sample project file: “gisvm qgis example.qgs” found in the qgis subfolder inside the gisvm unpacked folder.

Note: If you don’t have QGIS installed, just download it from the official site and install it, it’s free software: http://www.qgis.org/ 

 

gisvm-open-qgis-prj.png

When you open the project all the data is store on the gisvm virtual machine, inside the “postgis” database, using several tables from the “ne” schema.

gisvm-open-qgis-prj2a.png

  1. Add a new PostGIS layer from GISVM to your QGIS project

To create a new PostGIS connection on QGIS, simply type: Name = gisvm ; Host = gisvm ; Database = postgis ; Username = postgres ; Password = gisvm

You can also activate: Save Username & Save Password so you don’t have to type in each type you use the connection.

gisvm-open-qgis-newconnection.png

After creating the connection just select it (gisvm) and click on Connect to display all tables (layers) available to add to your project.

gisvm-open-qgis-newconnection_add.png

  1. Upload a new PostGIS layer to GISVM using QGIS

Add any layer to your QGIS project, for example, the roads shapefile (ne_10m_roads.zip) from Natural Earth dataset: http://www.naturalearthdata.com/downloads/10m-cultural-vectors/ 

gisvm-add-qgis-new.png

Use the DB Manager tool, in the Database menu, to import a PostGIS vector layer to GISVM

gisvm-open-qgis-connection5.png

The ne_10m_roads layer (table) is now available to be used from PostGIS on GISVM, and you can add it to your QGIS project, just like on the previous example:

gisvm-open-qgis-connection7.png

  1. Upload a new PostGIS layer to GISVM using SHP2PGSQL

Add any shapefile layer PostGIS database with the included command line tool: shp2pgsql, for example, the airports shapefile (ne_10m_airports.zip) from Natural Earth dataset: http://www.naturalearthdata.com/downloads/10m-cultural-vectors/ 

Just download, extract and copy it inside GISVM, into ”gisdata” shared folder: \\gisvm\gisdata

gisvm-shp2pgsql-1.png

Go into gisvm terminal in Virtualbox or VMware player window and login as gisvm, password = gisvm. You can also use your browser with shellinabox: http://gisvm:4200 

After login, change directory to where you saved the shp file (cd gisdata/ne_10_airports)

gisvm-shp2pgsql-2.png

To upload the shp file into the postgis database, inside the ne schema, to the ne_10m_airtports table, type or copy&paste the following command line:

shp2pgsql -s 4326 -D -I -W "latin1" ne_10m_airports.shp ne.ne_10m_airports | psql -h localhost -d postgis -U postgres

When it asks for the postgres password, type: gisvm

gisvm-shp2pgsql-3.png

You can then add it to your QGIS project:

gisvm-shp2pgsql-4.png

How to manage it

GISVM comes installed with two great full feature administration tools that can be used to manage it completely: phpPgAdmin and Webmin 

  1. Using phpPgAdmin to manage the PostgreSQL server

To manage the PostgreSQL running inside the GISVM you can use the included web application phpPgAdmin: http://gisvm/phppgadmin, login with postgres, password = gisvm

gisvm-phppgadmin-1.png

After login just navigate through postgis database, ne schema and ne_10m_airports table.

It allows the execution of all kinds of PostgreSQL operations, like browse and edit the data, add a new column or DROP (delete) the table.  

gisvm-phppgadmin-2.png

  1. Using pgAdmin III to manage the PostgreSQL server

If you have installed the pgAdmin III on your computer you can also use it to manage the PostgreSQL server running on GISVM. If you don’t, you can install it for free from:

http://www.postgresql.org/ftp/pgadmin3/release/v1.22.0/ 

Run pgAdmin and create a new Server Registration with: Name: gisvm , Host: gisvm , Username: postgres , Password: gisvm

gisvm-pgadmin-0.png

Then use that connection to access the PostgreSQL server running in GISVM:

gisvm-pgadmin-1.png

  1. Using Webmin to manage the Ubuntu operating system

To manage the ubuntu operating system in GISVM just use the included web application Webmin inside your browser: http://gisvm:10000 

Login with: gisvm and password: gisvm

gisvm-webmin-1.png

After login you can completely manage the GISVM virtual machine, make updates, create new users, restart running services, configure network, server applications like SAMBA:

gisvm-webmin-2.png

  1. Use the local site to get more information on using GISVM

GISVM comes with a simple internal site with more information and several other links to help you start using it: http://gisvm 

gisvm-site.png

REMEMBER, USE GISVM AT YOUR OWN RISK.

THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.

THIS INFORMATION IS BEING GIVEN TO YOU GRATUITOUSLY AND THERE IS NO AGREEMENT OR UNDERSTANDING BETWEEN YOU AND THE GISVM PROJET OR ME (RICARDO PINHO) REGARDING YOUR USE OR MODIFICATION OF THIS INFORMATION BEYOND THE CREATIVE COMMONS ATTRIBUTION-SHAREALIKE 3.0 UNPORTED LICENSE (CC BY-SA)

Please visit the GISVM project site regularly

to get updates and help us make it better!

http://gisvm.com 

Thank you for using it.

THAT’S IT, HAVE FUN !!!!!!!!!

GISVM 14.04 POSTGIS - QUICKSTART & PASSWORDS by Ricardo Pinho - ricardo.pinho@gisvm.com 

This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License